Macros in Excel Spread sheets?

Question

I want to write a macro where I can insert a line below the current line, format the cells to merge, bring the text to the top, and wrap the text.  I know how to write the macro, however, how do I get the macro to work on any line in the workbook, not just the line I created it on?

Anonymous · Accepted Answer

Don't use absolute cell addresses.  (Record a macro while you do what you want, and look at the code that gets saved.)

Something like this may help you:

Dim i
    For i = 147 To 1 Step -2
        Rows(i).Select
        Selection.Insert <whatever>
    Next i

If you just want it to work on one row, select the row first, then run the macro, written to have its effect on the selection.

Anonymous · Answer

You don't even need a macro. Format the cells as custom and then you can have three different formats, e.g. #,##0.00;[Red]-#,##0.00; This tells it to format with 2 decimal places for all values, negative values in red, and zeroes left blank.

Macros in Excel Spread sheets?

Related Questions

Trending Questions