Results 1 to 2 of 2
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Find next column on Row (2003/SP2)

    I'm having a senior moment this morning. I am on row 8 and need to find the next available coumn to write into. I tried, <pre> NextCol = Sheets(PivSheet).Cells(L, 256).End(xlLeft).Column + 1</pre>

    but get stupid errors. Help?
    Alan

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Find next column on Row (2003/SP2)

    Try:
    <code>NextCol = Sheets(PivSheet).Cells(L, 256).End(xlToLeft).Column + 1</code>
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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