macro - display

I have a macro written that will unhide the rows I want to be displayed on another sheet, but I cannot get it so that they will remain hidden when the checkbox is not clicked. Any help would be appreciated! I have it written two ways - can you tell me where I'm going wrong?! Sub...

I have a spreadsheet that hides other sheets depending on the value of one of my data validations, however I can't work out how to adjust my code currently written to keep the costing sheet from hiding every time I adjust the data validation (other than naming it with all the possible outcomes...

So I have three sheets "Yard", "Available spaces", and "Yard configurations" If cells in Column K of "Yard configurations" equals Yes, and Cells in column B in "Yard configurations" equals ParkingLocation then use text in Column C of "Yard configurations" to find the same text in column A of...

Hi. I make userforms and I want when I click on button on userform 1 , it unloads and then show other userforms. Then I write This Code For Userform1: Option Explicit Private Declare Function GetForegroundWindow Lib "user32.dll" () As Long Private Declare Function GetWindowLong Lib...

Hi Team, Can any one help me with the Macro code for the below situation: I have the data validation in B1,B2,B3 where the user will select. I have a filter in row5 where I exclude blanks below row5. Example below after filter it will not show row 8 & 11 as its blank. Supplier # and Address...

Have recorded the following macro but it is asking me to debug it & I cant understand what is going wrong.. pls help Sheets("Pivot").Visible = True Application.Goto Reference:="'RPA Readiness'!R1C1" Application.Goto Reference:="Pivot!R1C1"...

Hi all, good afternoon! Had a look in the search bar, however didn't find any thread similar to what I'm looking for. Basically; I have the following: <tbody> A B C D E F G 1 Change reason? Dropdown 2 Nb of Changes? Dropdown (max 5) 3 Name Name Name Name Name 4...

I am wanting to format 3 columns of data in the comma style like I would if I used the Alt+H+K shortcut would format. Instead I cannot find any method that works. I have used "#,###.##" & "Comma" and still the values do not look at all like they would if I used the comma icon on the Home ribbon...

Hello, everybody! I would like to know if there's a way to unhide cells depending on the choices from drop down lists (well, I know there is). Let me explain it better. Lets us suppose I chose one answer from my first drop down list (the only one on screen yet). Then I want to unhide a range...

I need a macro code to divide select numbers on a worksheet by 640 and then go back and multiply them by 640. I need it to be with a button somehow that gives me the option to click it to do one and click the other option (or unclick) the button to multiply the numbers (which will be referenced...

Hello I am new to the site and macros but would like to know if anyone can help. Basically I am learning macros and would like to know if it is possible to have a macro display a range from another sheet Sheet 1 has names (A13:A40) with IDs (B13:B40) and a 2015 calendar in range of M9:AI43...