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.
Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
Please read the rules
If someone helped you, click on the star icon at the bottom of their post
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
Hi Jeff,
I updated the code but still am getting an "Object Required" error on the ".Offset"
End SubPlease Login or Register to view this content.
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.
Re: Offset entire row help
Yes, I did. I made Disclaimer as string and changed it in the other spots as well.
Please Login or Register to view this content.
Last edited by Rachel5694; 06-18-2019 at 06:33 PM.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks