EntireRow.Copy

[Metrazal]

What do I need to replace EntireRow (Marked in Red) with to copy only columns A:DL? Any help would be appreciated.

Please Login or Register  to view this content.

Thanks,

Met

[mehmetcik]

Please Login or Register  to view this content.

[Metrazal]

Mehmetcik, thanks for the response. However, I'm getting an object required error. Any ideas?

Thanks,

Met

[AB33]

Hi Met
Try

Please Login or Register  to view this content.

[mehmetcik]

can you post a spreadsheet so that I can see what you are doing?

I don't really understand what the

Please Login or Register  to view this content.

is doing in your scenario.

I suppose .offset(1) might mean activecell.offset(1) so that would be the last row offset 1

in which case myrng.Copy destination:= .Offset(1) might work

[Metrazal]

Thanks for the help. Both suggestions seem to work. I appreciate the help.

Met