| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
loop
"Wanna Learn" wrote: Thanks Dave I copied the macro, but it does not work . My last column that always has data is Q. I am overlooking something , sorry I just don't get it. Please clarify "Dave Peterson" wrote: Sometimes you don't need to loop. If you can pick out a column that always has data when the row is used, you can use that to find the last row. Dim LastRow as long With worksheets("Sheet1") lastrow = .cells(.rows.count,"X").end(xlup).row 'then format .rows(lastrow) end with Wanna Learn wrote: I created a macro and it works fine, however I want to add a loop. (Hope that is the term) I want to be able to go to the last row in the worksheet and highlight the row in grey and make the font bold . -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
| Loop gone crazy | Excel Discussion (Misc queries) | |||
| Do Loop | Excel Discussion (Misc queries) | |||
| Help with Do...Loop | Excel Discussion (Misc queries) | |||
| hysteresis loop | Charts and Charting in Excel | |||
Threaded Mode
