+ Reply to Thread
Results 1 to 4 of 4

Two Macro's on one sheet

  1. 04-22-2019, 11:12 PM #1
    Josebug
    Josebug is offline
    Registered User
    Join Date
    04-22-2019
    Location
    Australia
    MS-Off Ver
    Windows 7 enterpirse
    Posts
    8

    Two Macro's on one sheet

    Hi,
    I have the following which works a treat in range "h:h", but I want it to do the same thing for m:m and p:p
    Any ideas?

    Please Login or Register  to view this content.
    Last edited by Josebug; 04-22-2019 at 11:59 PM.
    Reply With QuoteRegister To Reply
  2. 04-22-2019, 11:14 PM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Two Macro's on one sheet 

    Please Login or Register  to view this content.
    Last edited by humdingaling; 04-22-2019 at 11:19 PM. Reason: remove rule as OP complied
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 04-22-2019, 11:21 PM #3
    Josebug
    Josebug is offline
    Registered User
    Join Date
    04-22-2019
    Location
    Australia
    MS-Off Ver
    Windows 7 enterpirse
    Posts
    8

    Re: Two Macro's on one sheet

    Unfortunately that did not work. Error message pops up and code no longer functions.
    Reply With QuoteRegister To Reply
  4. 04-22-2019, 11:59 PM #4
    Josebug
    Josebug is offline
    Registered User
    Join Date
    04-22-2019
    Location
    Australia
    MS-Off Ver
    Windows 7 enterpirse
    Posts
    8

    Re: Two Macro's on one sheet

    Quote Originally Posted by humdingaling View Post 
    Please Login or Register  to view this content.
    Managed to get it working with the following changes:
    Set WorkRng = Intersect(Application.ActiveSheet.Range("H:H,M:M,P:P"), Target)
    Thanks for your help, much appreciated.
    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 updating after selecting another sheet and back to Macro enabled sheet?
    By Imran Magsi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-29-2016, 04:38 AM
  2. [SOLVED] Macro to copy data from a master sheet to separate sheet as per date using a macro
    By tmaster81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2014, 08:05 AM
  3. Macro to gnereate new sheet which includes the macro to generate a new sheet
    By jocanon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-27-2013, 05:15 PM
  4. [SOLVED] Macro running on active sheet instead of sheet defined in macro
    By davegscott in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2013, 02:04 PM
  5. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  6. Macro to add new sheet and then fill formula in a totals sheet to refernce this sheet
    By Sophs5 in forum Excel General
    Replies: 1
    Last Post: 07-30-2012, 02:35 PM
  7. [SOLVED] When sheet is activated, execute macro in other sheet and return to sheet
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2012, 10:50 AM

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