creating an offset based on a range variable

[dcwan]

Hello, I created a range variable for later use, so I can take advantage of the inbuilt .OFFSET function. However, after utilizing the

However, it keeps getting stuck in the line 'Sheets("Temp").pasteRange.Offset(, 1).Formula = 2". The error "Object doesn't support this property or method." How would I go about fixing it to make it work as intended?

Please Login or Register  to view this content.

Thank you for your help

[AlphaFrog]

Qualify the Sheet when you set the range variable. Not when you use it. The Sheet is part of the range variable. If you do not qualify a sheet when you set the range variable, it defaults to the sheet that was active when you set it.

Please Login or Register  to view this content.