hidden columns vba code

Hello, My employees work on multiple projects, they use excel to record their hours. We currently have 10+ projects but an employee may only be working on any 5 of those. Each employee has their own excel spreadsheet (stored on sharepoint- online 365) I would like to be able to...

Hello, I am after an upgrade to my simple paste special code. I want to allow the code to ignore hidden columns but I have no idea how to begin other than presuming that the code will be probably using an If statement and entirecolumn.hidden = true/false statement? But I get lost from there...

Hi, I have a macro that is 90% perfect for what I need but I am just struggling coding the macro ignore hidden columns. This is my code that I have so far: Sub Update_Selected_Cells_With_Inputbox() Dim r As Range Dim c As Range Dim name As Variant Set r = Selection.Cells name =...

Hi guys , I am sure there is a better way of hiding columns than the code below that i am using. Basically I need to hide the columns based on the cell value of column and whatever row I am currently on and ignore the pervious cell value in column 20 value if that make sense. The spreadsheet...

I have a worksheet that I have created that unhides columns based on what is selected in a dropdown. My problem is that when those hidden columns appear and I select a value from the drop down in that previously hidden column all the columns that I want to stay hidden appear. I have tried...

Hello, I'm intermediate with Excel formula but not very experienced with VBA. Any guidance on the below would be much appreciated! I've built a spreadsheet that will help my colleagues add/remove product codes that are used by a client. I need this because there is a specific set of product...

Hi, I have the following code to hide columns, however if someone inserts a column before D, I want the hidden columns to shift as well, i.e Hide columns E:BA if one row was inserted. Columns("D:AZ").Hidden = True