When trying to select only a few items off of a Pivot table's field selection list, I can deselect items from the list if all of the items have been selected with a 'Show All' manually. The VBA code I use is ".PivotItems(5).Visible = False".
However, if I try to select an item that is not...
Thanks, Mike. It seems to have worked but since I only have access to the latest version of Excel and had to save everything using it, I'm not sure what will happen next month when the users submit there workbooks saved in older versions. However, I'm going to update all the workbooks and the...
My original code was as follows:
Private Sub Workbook_Open()
Sheets("GIS Labor Supplier Spending").Select
End Sub
I tried rmikesmith's suggestion using 'ThisWorkbook.Sheets...' and it seems to have reduced the number of 1004 errors by over half.
Would having the Excel workbooks saved under...
I have a simple statement in my Workbook_Open macro "Sheets("GIS Labor Supplier Spending").Select" which works fine if I open a single work book or if I open a number of files with this macro from Windows Explorer.
However, if I open a number of files at the same time from the Excel Open...
Handling negative numbers also means that you have to decide whether rounding 'up' means 'close to' or 'farther from' zero. i.e.: does -142 become -140 (close to) or -145 (farther from)
Thanks, Genimuse, I wasn't trying to change the constant, just determine what the value should be for this session by using the IF or Select logic. OH Well. I'm going to try both of your suggestions to see how they work. I know one of them will.
Currently I set the ADO connect string for my site into a 'constant' that is used by all the asp pages on my site. This allows me to change the database that I connect to depending on whether I am in test mode or production mode.
I now want to test for which server the code is running on and...
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.