| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Last Row
HI.
I am running a fill down macro and am needing some assistance.... How do I word the macro so that it goes down to a particular row? (instead of searching a range or column). I.e. - I need one of these to say the last row is always 500. Set LastRow = Sheet1.Range("a65536").End(xlUp) or LastRow = Range("a65536:hc65536").End(xlUp).Row Thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setting default filter setting | Charts and Charting in Excel | |||
| PrintQuality setting - is -3 a valid setting? | Excel Programming | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
| VBA Setting .Value to a date does not respect local system setting | Excel Programming | |||
| Sending email via macro- setting the importance setting. | Excel Programming | |||
Threaded Mode
