macro2

i have a code which was written by a freelancer on a dummy file. when i tried to copy the code into my original file, i ran into some error. i understand that the code contains a lot of .select and was advised to rewrite the code. can anyone help me with that? Sub Macro2()'' Macro2 Macro '...

I am trying to figure out how to take a macro I have made for Row A. Then if i were to select another row, it would run the same as it did for Row A. My example macro: Sub Macro2() ' ' Macro2 Macro ' ' Range("D1").Select Selection.Copy Range("A1").Select ActiveSheet.Paste...

Hi, having trouble figuring this out, i have the following sheet code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("Z2:Z50")) Is Nothing Then If Target.Offset(0, 1).Value = Target.Offset(0, 2).Value Then 'do...

VBA to run macro1 when cell (A1) value = 14 and run macro2 when cell (A2) value =14.

I am receiving an error at the Sub Macro2 script for the line of code: "Workbooks.Open Range("N12"). Value where it tells me that it is N12 empty. How can I reactivate the sheet to pull the file name variable in the file I wrote code in N10, N12, and N14. N10 works as the sheet is activated...

Can someone let me know why this is giving an error at .Axes(xlValue).CrossesAt = 0? Sub Macro2() ActiveSheet.ChartObjects("Chart 1").Activate With ActiveChart .Axes(xlValue).CrossesAt = 0 .Axes(xlCategory).CrossesAt = 0 End With End Sub Thanks

Hi All, Everytime I record a Macro for some reason the first action is Delete. = even though i did not press delete while recording macro. This is is causing issues when I try to re run the macro. Can someone please why this happens? Sub Macro2() ' ' Macro2 Macro ' ' Delete. = "Hello"...

Currently have a macro to instruct for the print the workbook sheets as follows, but I am lokk9imng for a code that would prompt to select which printer to print, can anyone help? Sub Macro2() ' ' Macro2 Macro ' ' Keyboard Shortcut: Ctrl+Shift+P ' Sheets("Charge Sheet").Activate...

I created a combobox with a list of customers. From the value selected, which is transfered to another cell automatically, I want to filter my PivotTable. I recorded a macro to help me start but i'm completely lost. Can anyone help? Here is the macro I created Sub Macro2() ' ' Macro2 Macro '...

So I have multiple macros to keep things clean. It may be extra macros but it help in case files change etc. I have a master 'CallMacros' macro assigned to a button Clicking this button, calls 11 macros, let's call them Macro1, Macro2, Macro3, etc. Each macro is: Workbooks.open (a...

I am trying to create a macro to change value of the visible cells in column Y from zCSS to zContractAdmin based on the value of column K. This is the macro I have tried to use but it's giving me error on Formula. Any help is greatly appreciated. Sub Macro2() Application.CutCopyMode =...

Hi,. I have this and it fails at the paste for "Subscript out of range". It would seem I am not properly selecting my destination. Is it my method? Sub Macro2() ' ' Macro2 Macro Dim wb1 As Excel.Workbook 'Open PSSLA workbook first Set wb1 = ThisWorkbook Dim wb2 As String 'Open Raw Data...

Hello, I have recorded this VBA, but I need it to apply to a different Name. Sub Macro2() ' ' Macro2 Macro ' ' Sheets("Pivot").Select Range("C21").Select ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh...