+ Reply to Thread
Results 1 to 4 of 4

want to go to particular column & sheet on the first empty row VBA

  1. #1
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    want to go to particular column & sheet on the first empty row VBA

    hi,

    On the first VBA formula has worked well (solved by HaHoBe)... after I try for the second case does not work ... please help me

    thanks in advance
    Attached Files Attached Files
    Last edited by herukuncahyono; 07-01-2013 at 03:22 AM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: want to go to particular column & sheet on the first empty row VBA

    But there is no sheet present in your attached file with the name B16


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: want to go to particular column & sheet on the first empty row VBA

    Hi, herukuncahyono,

    there is no problem getting over D16 to the first empty row in the wanted sheet but I wonder if that really is what you are looking for (code will only copy that value over):

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    Re: want to go to particular column & sheet on the first empty row VBA

    hi HaHoBe,

    exactly right what I need is just code to go to sheet name and the value in D 16...I learned a lot from you & thank you very much HaHoBe...
    Sorry for My "Indonesian" English

    Heru

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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