Object Defined Error

[SBF12345]

With Workbooks(COMBINED).Worksheets(NameVar)

    .Range("A6", Range("A6").End(xlToRight).Offset(-1, 0)).Copy

I have an "application or object defined error" on the lower defined line of code. How is the correct way to write this? I would like to be able to copy a range from "A6: some column value and 5".

 

[Domenic]

It looks like you forgot the dot operator for your second range reference...

.Range("A6", [COLOR=#ff0000].[/COLOR]Range("A6").End(xlToRight).Offset(-1, 0)).Copy

Without it, the range will refer to the active sheet, not Workbooks(COMBINED).Worksheets(NameVar).

Hope this helps!

 

[SBF12345]

Thanks!