+ Reply to Thread
Results 1 to 9 of 9

Go to specific row using Macro

  1. 03-28-2022, 12:56 AM #1
    Sultan1994
    Sultan1994 is offline
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Red face Go to specific row using Macro

    Hallo,

    I have several sheet in my workbook, but I want to go to specific row in all sheet (last filled data in Column "BA").
    Can you solve my problem?

    Please Login or Register  to view this content.
    This is work buat just in active sheet, the other run but nothing happen.
    thanks..

    Note: My workbook name is "BUKU BESAR.xlsm"
    Last edited by Sultan1994; 03-28-2022 at 01:00 AM.
    Reply With QuoteRegister To Reply
  2. 03-28-2022, 01:45 AM #2
    CheeseSandwich
    CheeseSandwich is offline
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,360

    Re: Go to specific row using Macro

    Maybe:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 03-28-2022, 02:16 AM #3
    Sultan1994
    Sultan1994 is offline
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Go to specific row using Macro

    Quote Originally Posted by CheeseSandwich View Post
    Maybe:
    Please Login or Register  to view this content.
    Is that any Option tu run all the sheet without write All the Sheet name on Array ("NB01", "NA05", "NB06", "NB07", "NA09").
    rather just write Allsheet for example
    Reply With QuoteRegister To Reply
  4. 03-28-2022, 02:20 AM #4
    CheeseSandwich
    CheeseSandwich is offline
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,360

    Re: Go to specific row using Macro 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 03-28-2022, 02:33 AM #5
    Sultan1994
    Sultan1994 is offline
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Go to specific row using Macro

    Quote Originally Posted by CheeseSandwich View Post 
    Please Login or Register  to view this content.
    error 1004 in
    HTML Code: 
    Reply With QuoteRegister To Reply
  6. 03-28-2022, 02:53 AM #6
    CheeseSandwich
    CheeseSandwich is offline
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,360

    Re: Go to specific row using Macro

    See attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 03-28-2022, 03:16 AM #7
    Sultan1994
    Sultan1994 is offline
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Go to specific row using Macro

    Ohh I see, If there is a hidden Sheet the code wouldn't run.

    Ok Thanks,

    But is that any solution for that? keep it running even there is a hiden sheet
    Reply With QuoteRegister To Reply
  8. 03-28-2022, 04:19 AM #8
    CheeseSandwich
    CheeseSandwich is offline
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,360

    Re: Go to specific row using Macro

    Do you want it to run on the hidden sheet?

    If not, then:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 03-28-2022, 04:25 AM #9
    Sultan1994
    Sultan1994 is offline
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Go to specific row using Macro

    Quote Originally Posted by CheeseSandwich View Post
    Do you want it to run on the hidden sheet?

    If not, then:
    Please Login or Register  to view this content.
    This perfectly work, Thanks mate..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] macro find and replace in a specific column specific words to an abreviation
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2018, 06:05 AM
  2. VBA MAcro to clear contents of specific cells if a specific cell contains text
    By muzzareilly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2017, 12:47 PM
  3. VBA Macro: Copy and Paste Specific Row Range based on the Specific Value in a Cell.
    By SolidSmoke in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-10-2016, 02:40 PM
  4. [SOLVED] Macro to copy specific data from one WB to specific cells in another WB based on specific
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 11:05 AM
  5. [SOLVED] Print Macro to email PDFs of specific pages of a workbook to specific recipients
    By mike_vr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2012, 12:34 PM
  6. Macro to extract data from multiple workbooks, specific sheet, specific cells
    By crissandraauree in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 03:54 PM
  7. Macro to copy specific data to specific columns from a pivot table
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2012, 07:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1