preserve formatting

Hi there, I'm trying to figure out a way to clear cells without clearing the applied Conditional Formatting rules from those cells. Here's my code: Sub WipeSheet() ' ' WipeSheet Macro ' Wipes all entries in the sheet besides formulas ' ' Keyboard Shortcut: Ctrl+Shift+W ' PopupPrompt =...

I found this thread in my search Trim Column in VBA and was able to convert Rick Rothstein's code to loop through all of the columns in a worksheet. Code will be listed below. Trouble is We have columns that have data with leading zero's, and, this code see to convert each column to general...

First tab: 9.17.19 Second tab: Next Download I'm using index/match to pull whatever is in $O$2:$U$300 in the first tab based on if $A2 matches $A:$A in the first tab. So, in cell O2 of the second tab, IFERROR((INDEX('9.17.19'!O:O,MATCH($A2,'9.17.19'!$A:$A,0)))&"","") I use a similar formula for...

I've been coding VBA for many years but this one is a real head-scratcher. The task is simple - Copy data from a table from Microsoft Word to Microsoft Excel. The challenge: Maintain the formatting of the data from Word, which includes bulleted lists and multiple paragraphs. More...

Hello, I am using the following code (which works great) to export the sheets named "Labor BOE xxxx" after my spreadsheet creates multiple copies of a template worksheet, inserts summary tables, and populates the summary tables. The one issue that I haven't been able to figure out is... after...

I found this code on the interwebs and it works great for splitting my worksheets to separate workbooks. However, I am wondering if someone can help me tweak it so it preserves the password protection and unchecks "display gridlines" when it separates. I am more concerned with the password...