Search results for query: *

Never mind... I decided it would be easiest to simply record a macro where I click "all cells", then change the font to white. Sometimes I tend to overthink things. Thanks anyway:) Cheers, MackInMN

My worksheet has invisible gridlines. Now I would like to control the visibility property of all the cells in my worksheet. I want all the cell values and formulas to exist, but remain invisible to the user during certain tasks. I would prefer NOT to hide all the columns or rows because...

I guess I might have been willing to, but instead I ran across the solution I've been seeking. If you or anyone else is interested, I did it by placing a transparent autoshape rectangle onto the sheet and assigning to it a macro named AutoBreak with the following script: Sub AutoBreak() Set...

Maybe there is a better way of wording this, but I'm shooting from the hip so please bear with me. I have a very large .xls file that I wish to print. The sheet is sorted by the contents of column A. Whenever the fifth (5th) character of the string in column A changes, I want a page break to...

My subject line is asking two questions: A particular field value is output to a report. An example of this value might be "01124134C" (no quotes). I would like to truncate the first 5 characters and format the remaining 4 characters so the above example would now appear as...

I've got a comma-delimited text file. I wish to create a small app that will read the file and output the data on paper with a spreadsheet-like appearance -- including gridlines. I understand there are many ways to approach this, but I am interested in using as little code as possible. Any...