I'd like to use the following code
but I want the "E"s to be the value of "counter". How do I code this?Cells(1, Counter).AutoFill Destination:=Range("E1:E" & lastrow)
Thanks.
I'd like to use the following code
but I want the "E"s to be the value of "counter". How do I code this?Cells(1, Counter).AutoFill Destination:=Range("E1:E" & lastrow)
Thanks.
Last edited by bd528; 09-13-2010 at 10:29 AM.
It's not clear what you're doing with the first cell before hand (ie if you need to use AutoFill) but
With Cells(1,Counter) .AutoFill .Resize(lastrow) End With
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Perfect, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks