Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Noted with thanks, Tom !
-- Rgds Max xl 97 ---------------------------------- Use xdemechanik <atyahoo<dotcom for email ----------------------------------------- "Tom Ogilvy" wrote in message ... this can be quite unreliable. -- Regards, Tom Ogilvy Max wrote in message ... Maybe one row after?, for the "next blank row": ActiveCell.SpecialCells(xlLastCell).offset(1,0).Se lect |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto format blank rows using code | Excel Discussion (Misc queries) | |||
VBA code to hide blank rows | Excel Worksheet Functions | |||
VBA Code- Copy & Paste in Blank Range | Excel Discussion (Misc queries) | |||
Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
Code works 1st time then Type Mismatch when checking for not blank cells | Excel Programming |