$$Excel-Macros$$ Macro to copy 6 tabs to new sheet and past as values.

to inlcude it into another macro that updated cells in multiple spreadsheets in a folder. l will then updated it so that I can run it on all sheets in a folder. ie. C:\Excel-Work\. Hope this is clear. thx Mel -- Join official Facebook page of this forum @ https

$$Excel-Macros$$ Need help to create VBA to copy 4 cells from one spreadsheet to over 200 spreadsheats in same folder

to run this process once to update all spreadsheets with the new info for these 4 cells.I tried a number of different VBA to loop through each spreadsheet but keep getting a number of error. Any help is appreciated. thx Mel -- Join official facebook page of this forum @ https

$$Excel-Macros$$ How to create VBA to copy 4 cells from one spreadsheet to over 200 spreadsheats in same folder

On Wednesday, October 31, 2012 12:49:45 PM UTC-4, Mel wrote: I have a master spreadsheet with 5 tabs. On my master sheet (called Master) - on the tab called 'Option Letter' I need to copy cells B131, B202, B319, B424 to the same tab (same name on each sheet 'Option Letter') on over 200

$$Excel-Macros$$ Re: Need help to create VBA to copy 4 cells from one spreadsheet to over 200 spreadsheats in same folder

fantastic Paul. yes, all workbooks in only one folder. worked like a charm. Many thanks. Mel On Wednesday, October 31, 2012 12:49:45 PM UTC-4, Mel wrote: I have a master spreadsheet with 5 tabs. On my master sheet (called Master) - on the tab called 'Option Letter' I need to copy

$$Excel-Macros$$ Macro to hide rows, print, unhide rows runs very slow - how to speed up?

, _ IgnorePrintAreas:=False Rows(17:168).Select Selection.EntireRow.Hidden = False Range(B2).Select End Sub any suggestions to speed it up appreciated. Mel -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ How to copy sheet to new book without sheet module code?

I copy specific sheets from one book into a new book but I don't want any VBA code in the new book. One sheet, however, has code in the sheet module. How can I copy it without the code or remove the code in the destination book? For the copy, I'm simply using... Sheets(Array(sShtName1,

$$Excel-Macros$$ macro to print only rows with date but exclude rows that have a formula

is set to look at info in column H, if there is something in H, show comment in I. thx Mel Sub SetUsedPrintArea() Dim LastRow As Long If WorksheetFunction.CountA(Cells) 0 Then 'Search for any entry, by searching backwards by Rows. LastRow = Cells.Find(What:=*, After:=[A1

Re: $$Excel-Macros$$ Macro to filter dates using Userform1 printing

not sure but how do I re-format or move fields around without causing the dates for the calendar to fail? I am also trying to format the table of values (A3 to E5000) but cannot. On Mar 16, 8:31 pm, Deepak Rai daksh1...@gmail.com wrote: Hi Mel, Please find the updated file which can be use

$$Excel-Macros$$ Macro to filter dates using Userform1 printing

Mel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3

$$Excel-Macros$$ Macro to filter dates using Userform1 printing

Mel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3

$$Excel-Macros$$ using Networkdays formula in French version of Excel options

a statement 'if Excel ver=French, use NB.JOURS.OUVRES, if English use Networkdays'? Or maybe a macro to change the formula from 'Networkdays' to 'NB.JOURS.OUVRES' on all tabs of the workbook. thx Mel