G
Guest
I have used Range(Cells(a,b),cells(c,d)).Copy in Excel VBA code successfully
before but currently am working on a macro where I use the following
instuction:
wsFrom.Range(Cells(intFRowNum, 1), Cells(intFRowNum, FPMCOL)).Copy
and get an error that reads "Run-tim error '1004'; Application-defined or
object-defined error."
If I substitute the following instruction it works fine (i.e. no error):
wsFrom.Range("A" & intFRowNum & ":" & Chr(64 + FPMCOL) & intFRowNum).Copy
Any idea what's going on?
Will
before but currently am working on a macro where I use the following
instuction:
wsFrom.Range(Cells(intFRowNum, 1), Cells(intFRowNum, FPMCOL)).Copy
and get an error that reads "Run-tim error '1004'; Application-defined or
object-defined error."
If I substitute the following instruction it works fine (i.e. no error):
wsFrom.Range("A" & intFRowNum & ":" & Chr(64 + FPMCOL) & intFRowNum).Copy
Any idea what's going on?
Will