mymacro

Hello, I have an issue with my auto-save macro on every 2minutes. It was working ok for couple of days, but now it is behaving odd. Macro is as follows (in Module1): Public dTime As DateSub MyMacro() Dim fPath As String Application.DisplayAlerts = False dTime = Now + TimeValue("00:02:00")...

Hi. I'm trying to call a macro using a Worksheet_Change Event but everytime I run it nothing happens. The event itself works great and recognized that the macro doesn't exist after I tried deleting it. I've also tried testing my macro using the Immediate Window feature and everything worked as...

hi all i created a button, created with Custom UI Editor. but heere create the button for the Actual Book. i want so so do this: 1) click on button, open a File and execute myMacro. how to do this? thanks..

Hello, I am looking to modify the below code in a way that when the user selects "Yes" in the drop down in cell A1, macro should just Exit sub. And when user selects "No" in the drop down the code should trigger "MyMacro". Private Sub Worksheet_Change (ByVal Target As Range) If Intersect...

Was hoping you could help this VB beginner. Keep getting '9' Subscript Out of Range error. Debug brings me to this: lastrow = Sheets("DB").Range("A356000").End(xlUp).Row + 1 The Range is dynamic and I am think my line code is off since I am trying to set some sort of range. Help please...

HI, This runs a macro every 5 minutes in order to .SaveCopyAs. The master file conducts a power query from web every 1 minute. I .SaveCopyAs to another file name/location every 5 minutes. Obviously, it saves an actual copy of the master file, including the webconnection (which is set to run...

This code works fine when I double click on Cat1 through Cat8; But I get R/T 91 - ERROR ONLY when I double-click on Cat9 (Only). What could be my problem? TIA, Jim Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim MyMacro Cancel = True MyMacro =...