macro1

Hey, guys, I'm using a macro do to some basic tasks. However, it keeps ignoring some of the worksheets. Any idea why? Sub Macro1() Dim w as worksheet Application.ScreenUpdating = False For Each w In Worksheets ActiveWindow.DisplayGridlines = False ActiveWindow.Zoom = 85...

Hi all, I'm trying to put the below code to VBA and send it to cell A2 but it won't work. I had a look on Google that its over 255 characters so tried to split the code into two variables but would still not work. =IFERROR(INDEX('https://wels.sharepoint.com/sites/GroupSites7/blue/Talent/Shared...

Hi I hope someone can help me out with VBA for slicers. I have two slicers ("A" and "B") and I want both slicers to work when clicking on each of them. So when I click on a sliceritem (or multiple) in slicer "A" I want to clear the fitler on slicer "B", also working the other way around. I...

Code from the macro recorder is inset like this : Sub Macro1() Range("A2").Select End Sub Is it possible to have no inset when using the recorder? Like this : Sub Macro1() Range("A1").Select End Sub

Hi For some reason, the below code don't work. It shows the error message even when all my filtered rows =base Thank you Option Explicit Sub Macro1() ' ' Macro1 Macro ' ' Dim base As Integer Dim c As Range base = InputBox("State base")...

I need to create lots of pie charts for a dashboard and was hoping to record a macro that I could run once I have selected the data. However the macro fails here: Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+z ' ActiveSheet.Shapes.AddChart.Select ActiveChart.ChartType =...

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 want to add in a variable from pivot table using VBA. Please kindly advise me. Your help will be very much appreciated. Thanks you. Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+v ' cdcd = Worksheets("sheet8").Range("AQ2") With...

Hi, I have a Macro (Macro1) which is created using the Macro recorder. Macro1 is used to do similar functions in each worksheet. I can actually go to each worksheet and run Macro1 but I have altogether 500 worksheets, which means I have to do 500 times. I'm thinking of creating another Macro...

Im trying to run some VBA and getting a Compile error stating Else without If My code is listed below Cant seem for the life of me what is wrong ... probably staring me in the face Range("C4").Select If Range("C4").Value > 0 Then Range("B4:G4").Select Call Macro1...

Hi, I use code tags to post code in threads aka Sub Macro1() 'Some code End Sub Usually, I write the code in the VBE to test, then copy and paste to the thread inside the code tags. Unfortunately, it seems to add extra "lines" in between the code, usually after Sub, which means I then edit...