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...
Maybe knowledge base article Q199219 on the microsoft website will help. I ran across it in search of help with another problem, and it looks like it is related to your problem. The article describes problems using the With statement.
-Larissalle
Thanks for the tips. I tried both and both worked. I ended up using the second one, columns.hidden = false, after I saw that it took no longer to just unhide all rather than first test if there were any hidden before unhiding.
Thanks!
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 had a similar problem. It was caused by .emf files being generated in the temp directory each time a VBA button was clicked. emf stands for enhanced meta file and is generated when a graphics object is activated, i.e., a button. Check your temp folder. If you have thousands upon thousands...
No response received on this thread. But, I did figure out some of the problem, in case anyone is interested. It had to do with a bug in Excel 2000 where .emf files were not being deleted automatically. We had tens of thousands of .emf files in the temp directory created each time a button in...
Jonathan,
Re: "...creating several largish excel workbooks in this way causes the app to slow down and eventually grind to a complete halt."
Not sure if this applies to Excel running on Win 95, but I found that Excel2000 running on Win NT 2000 Professional, comes to a grinding halt...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.