apparently

Some built-in controls (eg, idMso="FileSaveAs") allows customization of the screentip and supertip properties. Others, such as idMso="CellFillColorPicker" apparently do not. Is there a way to override these properties? TIA John

Hello folks, I am trying to use the below formula but it's too large, apparently. Can anyone tell me what I need to do to shorten it? Thank you so much...

I have a large file with numerous “VLOOKUP” functions that I would like to change to “INDEX/MATCH” for efficiency. To do so, the INDEX/MATCH equation apparently must ignore blank rows in the data. Can this be done? Here is my initial attempt which only works on the first item (row 4 (HRL))...

This is driving me crazy because I have instructions to do this, but no matter what i do to try and resolve it nothing is working. I've googled this issue and apparently others have had the same issue, but was never really able to get help. I know somebody from community will have experienced...

Hey Guys, I have puled up an old sheet and need to make some changes and additions, but i have done something i cannot remember how to undo. to the right of the last column of cells i was working in and below the last row of cells I removed the additional cells. I hit shift+ctrl+ arrow key...

Hello all, I have several excel files that are macro enabled with some code in them. However, I would like to save some code free copies for back up. I thought this would be as simple as saving it to a .xlsx file but that apparently doesn't completely wipe out the vba project. Is there an...