macro3

I am trying to call a simple macro based on a cell input. In this case i want macro3 to run anytime a number between 1 and 12 is entered at cell "Q1". in this case i am selecting the month number at "q1" and instead of assigning the macro to a button i just want it to run when the number is...

Hi guys, need a code to replicate what excel has on its own ribbon. i mean, need to asign a button in order to paint any cell i choose to , for example, yellow. Tried this: ( not the result i looking for of course) CAn you help me? Tks! Sub Macro3() ' ' Macro3 Macro ' '...

Hi Where you usually write the comment about the sub you are writting? I created macro by recording steps and under Descrition: I wrote testing to my surprise excel created this code Sub Macro3() ' ' Macro3 Macro ' testing ' ' End Sub I was expecting this ' Macro3 Macro ' testing Sub...

Hello All, Hope someone here will be able to tell me how to activate URL link in a range of cells using VBA. I tried to record the macro, but all it gives me is Sub Macro3()' ' Macro3 Macro ' ' Range("N10").Select ActiveCell.FormulaR1C1 = _...

Hi so what I am trying to do below is just add another tab, but I need to always add a tab and it to be second from first. I have 15 tabs so I always want to add a new one as second tab and name it Errors. I tried worksheets (2) but debug. Sub Macro3() ' Sheets.Add After:=ActiveSheet...

Hi all, I would like to change one line in my recorded macro: Sub Macro3() ' ' Macro3 Macro ' ' Range("K11").Select Selection.Copy Sheets("MANAGER 1").Select Application.Goto Reference:="R3C7" Sheets("Sheet1").Select Range("J12").Select Application.CutCopyMode =...

The following code takes an age! It does work but takes a very long time. :mad: Any help please :) Sub Copy_Paste_Filtered_Selections()' ' Macro3 Macro ' ' Sheets("Selections").Select Range("A26:AO124").Copy Sheets("Filtered Selections").Range("A10000").End(xlUp).Offset(2, 0)...