Dummy Excel
Well-known Member
- Joined
- Sep 21, 2005
- Messages
- 1,004
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
Hi
i need to range some cells, but I cant work out the code so that it just autofill to the first blank cell
my code is:
selection.autofill destination:=("a2:a145")
I cant have hard coded cells as the number of rows change each week
your help is appreciated
Samuel
i need to range some cells, but I cant work out the code so that it just autofill to the first blank cell
my code is:
selection.autofill destination:=("a2:a145")
I cant have hard coded cells as the number of rows change each week
your help is appreciated
Samuel