ing, I would like 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
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'
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
I will only need 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
75"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
Rows("17:168").Select
Selection.EntireRow.Hidden = False
Range("B2").Select
End Sub
any suggestions to speed it up appreciated.
Mel
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, sShtName
macro to print only rows with Data? 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], _
Sea
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:=&q
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 wrote:
> Hi Mel,
>
> Please find the updated file which can be use with E
It looks like this is what I need however, I have Excel version 2003
not 2007 so it does not conver over and work.
any chance you can re-save in 2003 version? thx
Mel
On Mar 14, 5:02 am, Deepak Rai wrote:
> Hi Mel,
>
> I have a sample macro which work like similar as you want. Please
tion.
thx
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=287
tion.
thx
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=287
ent
versions of Excel? Maybe 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
'
tain 'networkdays' to
'nb.jours.ouvres'. Not exactly sure how to search all formulas for
this but maybe an options.
thx
Mel
--~--~-~--~~~---~--~~
-
Some important
ent
versions of Excel? Maybe a statement 'if Excel ver=French, use
NB.JOURS.OUVRES, if English use Networkdays'?
Or, maybe a macro to change any formula in the spreadsheet (and other
tabs) from 'networkdays' t
15 matches
Mail list logo
