vb - help

I am try to get a code to hide cell range or Columns but I can not get it to work in Office 365. and trying to tide it to a button Sub DoIfNotEmpty() Dim ra As Range, re As Range With ThisWorkbook.Worksheets("Sheet1") Set ra = .Range("D4:F40") For Each re In ra...

In this table should be to add items (Category and Sub-Category) so I need when I choose the category and the sub Category will filter the table depending on the sub-category and give me the last number txtCode for code comDepartment for category comSubCategory SubCategory Private...

Hi all, I'm struggling with this, I need to split this document so I get a CSV for each unique site formatted as per below.. Users will be in multiple sites Current Export Data Username Site Name Current Perm New Group site_exampleSite_SiteManager exampleUser exampleSite siteManager...

Hello, I am trying to extract a reference number from a database using FIFO method. Have tried numerous ways, while i could get to write some code with google ref., i couldn't really achieve the full result. Please help me. I am sharing the details along with codes i had worked. To assist, i...

Hello, I need a VB code that clears contents of cells of a selected column in an Excel sheet when the number of characters exceeds 12 Thank you,

I have two worksheets. The following are the conditions based on which Values from Sheet 2 need to be copied over to Sheet 1. In Sheet 2: We have Column A, Column N, Column R Sheet 2 has multiple values for each instance of a Pipe A is the primary value(InstanceID), along with Columns N or R...

Hello, I have a spreadsheet with 4 columns and 100's of records. Column 3 contains sequential numbers. Every so many records (unknown number) column 3 skips up to 4 records, in other words it might go 1,2,3,5,6,7,11,12, etc. How can I add an extra row to account for the missing records...