Fill down during macro
Hello All
Hopefully someone can help with this issue.
I have a large spreadsheet that runs from A:AN there are a number of columns hidden.
I am wanting to run a macro each day that will take formulas that are in AI:AN (AE is the column visible before AI as rest are hidden) and fill down to the last record (num of records will increase daily) current number of rows is 136129.
Any more info needed to help me I with this let me know.
Cheers
K
Hi,
This should do what you need....
Range("AI1:AN1").AutoFill Destination:=Range("AI1:AN" & ActiveSheet.UsedRange.Rows.Count), Type:=xlFillDefault
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
look at the Excel VBA help files for FillDown
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks