+ Reply to Thread
Results 1 to 8 of 8

Offset entire row help

  1. #1
    Registered User
    Join Date
    06-28-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    89

    Exclamation 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.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,222

    Re: Offset entire row help

    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.

  3. #3
    Registered User
    Join Date
    06-28-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    89

    Re: Offset entire row help

    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

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,222

    Re: Offset entire row help

    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.

  5. #5
    Registered User
    Join Date
    06-28-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    89

    Question 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.

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,222

    Re: Offset entire row help

    You are still using Set. Delete it.

    You are still using .Value. Delete it.

  7. #7
    Registered User
    Join Date
    06-28-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    89

    Re: Offset entire row help

    *Face Palm Emoji*

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

    Thank you so much for the help it worked!

  8. #8
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,222

    Re: Offset entire row help

    Glad it worked! Come back next time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 11-13-2018, 04:54 AM
  2. Replies: 3
    Last Post: 06-01-2014, 10:26 AM
  3. Offset function not capturing entire range
    By shawnvon in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-09-2014, 03:09 AM
  4. function similar to offset to offset the offset
    By Jerseynjphillypa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2012, 03:07 PM
  5. Replies: 0
    Last Post: 02-14-2012, 12:34 PM
  6. Reformatting - insert formula with offset, then offset to next cell
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2011, 05:41 AM
  7. Offset Entire Row
    By mattydalton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2008, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1