keep 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 =...

The module successfully copies all rows from the source sheet to the destination sheet that have 'Fletcher Bone' in row B. How can I edit my code to copy the values from the source, yet keep the formatting in the destination? Any help you can provide is greatly appreciated! Set wsSource =...

Hello there, I have a folder containing 3 files : my Excel file (with my macro), Book1 and Book2. I would like to create a macro to import automatically my two ".xlsx" files (Book1 and Book2) in my Excel file. Data from Book1.xlsx would be placed in Sheet1 and Book2.xlsx in Sheet2. I also want...

Hi! I am am looking for some much needed help but please bear with me as I am a complete novice and only joined Mrexcel today! Using windows 7 with Excel 2013 but would like this to run on previous versions also. The following is what I would ideally like: I have a workbook with 2 worksheets...

Hi This is my first post and am new to using code in excel sheets. I have a spread sheet that is keeping track of requested report from 3rd parties. This sheet will need to be password protected as multiple users will have access, so i am trying to sort out a macro that will allow some one to...

Hi This is my first post and am new to using code in excel sheets. I have a spread sheet that is keeping track of requested report from 3rd parties. This sheet will need to be password protected as multiple users will have access, so i am trying to sort out a macro that will allow some one to...

Hiho, how you doin? I've been working in this code these days and can't get it working. Excel keeps showing this message: Run-time error '-2147188160 (80048240)': Method 'PasteSpecial' of objects 'Shapes' failed Here it goes the code i've been working so far: Sub CopyToPPT() Dim PPApp As...

I need some assistance in combining multiple cells into one and keeping the formatting the same. I currently have code that will combine the columns but it losses the leading zero on numbers less than 10. For instance I gave some examples of the current output. CURRENT <tbody> Hour Min Sec...

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I know that it sounds like an old problem but I still haven’t found anything….<o:p></o:p> <o:p> </o:p> I have four cells in different sheets each having text in different color. I want to...