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?
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?