dynamic range autofill in Excel

qwertyjjj

Registered User.
Local time
Today, 14:37
Joined
Aug 8, 2006
Messages
262
Hi
I'm trying to program Excel from Access.

I need to get a variable into the range bit here:
.Range("B" & iCount + 7).AutoFill Destination:=Range("B12:Z12"), Type:=xlFillDefault

I'm trying to replace B12 with "B" & iCount + 7 but can't get it to work because of the semicolon in the range bit.
ANy ideas?
 

Users who are viewing this thread

Back
Top Bottom