columncount

Hello, I'm trying to sort the columns in a range of data based on a selected row. I found this code to start with but haven't the knowledge to modify and would appreciate help from someone in the community please. Here's the code; <code style="margin: 0px; padding: 0px; font-style: inherit...

Hi, I have a sheet where the headers i want to sort start in row 4 and the data is below. The first column with data is column B. Depending on the sheet there are different numbers of columns and a different number of rows. I read that it is possible to sort data by double clicking on the...

Hi all, I've got the code below from the microsoft support website https://support.microsoft.com/en-us/help/291296/procedure-to-export-a-text-file-with-both-comma-and-quote-delimiters-i The problem is it's working a little too well. I only need the First Row of the columns (basically the table...

I want to have the formatting (green highlighted rolls and bold font) STOP when it reaches the last column that has any formatting (using columncount) instead of having the green highlight continue on out past the last column. But I cant figure out what VBA to use to accomplish this. When I...

I have a macro that i have successfully run several times in the past. I have it linked to a button on my quick access toolbar. I have a dataset on "sheet1" with row 1 being the column headers and column 1 being a unique identifier. The data fields are numbers and the macro simply creates a...