Search results for query: *

I have a range of cells that are in $##,###.00 format. I need the cells to be in thousandths format, i.e., instead of $16,400.00, it should be $0.16 instead. I tried naming the range and creating a loop that loops through the range and divides each cell by 1000, but it doesn't work due to a...

I know how to test if activesheet.autofiltermode = true. Can I do something similar to test if there are any hidden columns in a worksheet? If true, I want to unhide them. If false, do nothing. The following didn't work: first select worksheet, then If Selection.EntireColumn.Hidden = True...

I have 30 or so pages of VBA code that is stepping through one to four separate excel files that contain raw data. The VBA code opens, saves, and closes the other excel files, and manipulates the raw data (extracts, imports, and plots/reports the revised data). The VBA code is accessed by...

How do I get around the limit that excel has on the number of cells that can be included in the concatenation function? Seems to max out at 15 columns. I need to concatenate 20 columns, one to 10 characters each, mix of strings and numbers. I tried using VBA to do a concatenation upon...

I am trying to get one column of numbers to determine the text in another column. If column 1 = 0, then I want the same row in column 2 = "none" and it should be formatted with green as background pattern color. I have named ranges for each column and I tried to use a...