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

wsFrom.Range(wsFrom.Cells(intFRowNum, 1), wsFrom.Cells(intFRowNum,
FPMCOL)).Copy

--
regards,
Tom Ogilvy



"roadkill" wrote:

> 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

Thank you (don't I feel silly)

"Tom Ogilvy" wrote:

> wsFrom.Range(wsFrom.Cells(intFRowNum, 1), wsFrom.Cells(intFRowNum,
> FPMCOL)).Copy
>
> --
> regards,
> Tom Ogilvy
>
>
>
> "roadkill" wrote:
>
> > 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