I love Excel and the flexiblity of the forms - I was hoping there was a
way I could create simple html pages after completing an Excel form.
Is it feasible :confused: or am I barking up the wrong tree?
I know Excel probably isn't ideal but most of the HTML would be already

Why won't this sort the range below row 3, or in other words,
the first 3 rows have data, so the sort will start in row 4 and go
down.
Columns("A:J").Select

If a cell contains a value such as 4.13, but in a formula I want to use the
rounded value which would be 4, how do I do that?

Is it possible to se how many lines of code that I have written
in design mode ?

I am having trouble maximising my workbook.  In the top right hand
corner, there is the minimise, maximise and close.  For some reason on
this on this particular workbook it is missing.  Would anyone know the
reason why?

I tried to record a macro to read the cell value of the active cell.
The macro recorded the actual value of the cell I had selected at the
time.  So if I select a different cell and run the macro it still reads
the same constant value as when I recorded it the first time.  Example:

I have thousands of rows of parsed text in single rows. What I have
been asked to do is now take part of each row (starting at column F)
and data in each of the next cells (the number of cells varies from row
to row) and copy if down into inserrted rows.

Through a command button in a user form, I want to ask a user to select
a group of cells(range).  The user selects the cells.  I would like to
retrieve the address of that range and place it in a variable.
Mary

How do I get cells to display in feet and inches using the x'x" format? For
instance, instead of 16", display 1'4" . or, instead of 2.5', display 2'6"
I've tried to write my own custom number format to no avail, since I can't
figure out how to get a custom format to perform ...

Im trying to write a simple macro with a checkbox, so when i click a
checkbox a number is added to another number. So for example when i select a
checkbox i want the number 5 to be added to a number in another cell on my
spreadsheet.

In an excel macro, I  need to list all the drives available to a user and if
the drive is a network drive, then I need to list its mapping string eg
\\finance\restructre
Please can some one help, thanks in advance

I found VBA code that would place a cell's contents into the footer:
    With wkSht.PageSetup
        .CenterFooter = wkSht.Range("F1").Value
    End With

I'm looking for the API Calls for the excel window to be hidden however I
still want the userforms to come up on the screen. If anybody can help me
that would be greatly appreciatly.
Jason

I am wondering if anyone knows a visual basic method to update the
values of two cells in visual basic so one is equal to the other if it
changes.
For example, if I change A1 to be "5" I want C1 to be updated to "5"

Hey all,
I have a table (duh, excel!). I have created a small script: If you
right click any cell of that table, an entry "Insert Comment" in the
context menu appears. I want the action of that entry to create a