vba formatting

Hi Expert, thank you for your outstanding support. I usually manually format some import workbooks data, but now have been increased to more than 12 workbooks in different format. I new with VBA, I wonder is there a solution with VBA to formatting, The code should be apply any active sheet...

Hello, As part of a larger macro, I'm trying to input a formula into a range of cells. This formula does an indirect lookup of a worksheet name as a tab name, and therefore requires single quotes. However, VBA keeps trying to interpret the first single quote as a comment, and therefore...

I have a worksheet, there is currently 14 columns with information in them, only 6 of the columns are important. There are currently 3,500 rows in the workbook. I have created a macro that loops through column E and highlights the range C:N for any value greater than 1. That value is in a summed...

I know this is an easy solution using conditional format, but rows can change daily in my spreadsheet, columns however will stay the same. If the word "yes" is in column "J" then I would like to format that cell plus the next 6 to right. Example: J6 contains yes, then J6:P6 will fill blue, white...

I have data in column A that I would like align right if =(LEFT($A10,4)=" ") is true. Is there a way with VBA to run through all of the rows in column A and apply the align right to all the cells that are true? Thanks for your help!

I'm trying to create a macro that will bold all text on a row if the text in column A starts with " [" then move down to the next row and repeat. Any suggestions? Example: Column A Column B Column C [501650 Dues] 123 456 Billboard...

Hey All, I'm running into difficulties producing an array that will produce two separate lists based on formatting: Red - Additions , Underline - Deletions. The number of mandates and processes vary from instance to instance. See below for a visual of my inquiry: <tbody> Process A Process...

So I am looking in column I for partial texts. For instance Column I can say: "Health Care, Doctor J" "Formula 1 Driver Ayrton Senna" "Dog Toys" My VBA is looking for a specific partial string in column I and then putting another specific text in Column L. So the one I have written here says...