Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro aid please
I have the following macro doing a filldown and it works perfectly.
Dim a As Long a = Range("B" & Rows.Count).End(xlUp).row Range("C6:BQ" & a).FillDown End Sub I then have a second sheet I would like to at the same time, autofill down the exact number of lines the first sheet pulls down, am hoping to have one macro pull both pages down, based on the above macro. How would I do this, if its possibel or do i need 2 macros to do this? Ryk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |