Offset entire row help

Hi,

I am trying to export each range of an excel document to txt.

The information in column "A" is the title and column "B-D" is the information.

Right now I can only get cell B to export with "Offset( , 1)"

I tired using the & function to populate columns C and D but I am getting an object error.

Any suggestions?

Please Login or Register  to view this content.

rDisclaimer is a range, and you are using Set to set it to a String. That won't work. Instead, make Disclaimer a string. See corrected code below in red.

Please Login or Register  to view this content.

Hi Jeff,

I updated the code but still am getting an "Object Required" error on the ".Offset"

Please Login or Register  to view this content.

End Sub

You did not change the code the way I showed. Use the exact same code that I posted. Make sure all the red code is an exact match.

You are still using Set. Delete it.

You are still using .Value. Delete it.

*Face Palm Emoji*

I am so sorry, I definitely missed that part of it.

Thank you so much for the help it worked!

Glad it worked! Come back next time.