Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update Cell in Multiple Sheets - Macro
My apologies if I have done this incorrectly.
After closing off a previous post I added to this question. Is there someway to select and update Multiple Worksheets in a Macro, I have tried a couple of ways below I have included my latest code. Sheets(Array("Regional Freight-QNRFA", "Int Retail-QNIMR", "Int Wholesale-QNIMW", _ "Passenger-PS", "Network-NW", "Infrastructure-IS", "Workshop-WS", "COMB IS & WS")).Select Dim d As Date d = InputBox("Enter the desired date.") Range("C1").Value = d This will only update the first sheet Thanking you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update Cell in Multiple Sheets - Macro
Sub Makro1()
Range("C1").Select Dim d As Date d = InputBox("Enter the desired date.") Sheets(Array("Regional Freight-QNRFA", "Int Retail-QNIMR", "Int Wholesale-QNIMW", "Passenger-PS", "Network-NW", "Infrastructure-IS", "Workshop-WS","COMB IS & WS")).Select Selection.FormulaR1C1 = d End Sub On 4 Mar, 03:07, enna49 wrote: My apologies if I have done this incorrectly. After closing off a previous post I added to this question. Is there someway to select and update Multiple Worksheets in a Macro, I have tried a couple of ways below I have included my latest code. *Sheets(Array("Regional Freight-QNRFA", "Int Retail-QNIMR", "Int Wholesale-QNIMW", _ * * * * "Passenger-PS", "Network-NW", "Infrastructure-IS", "Workshop-WS", "COMB IS & WS")).Select * * Dim d As Date *d = InputBox("Enter the desired date.") *Range("C1").Value = d This will only update the first sheet Thanking you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update Cell in Multiple Sheets - Macro
Thank you, you guys are great.
Works perfectly "Jarek Kujawa" wrote: Sub Makro1() Range("C1").Select Dim d As Date d = InputBox("Enter the desired date.") Sheets(Array("Regional Freight-QNRFA", "Int Retail-QNIMR", "Int Wholesale-QNIMW", "Passenger-PS", "Network-NW", "Infrastructure-IS", "Workshop-WS","COMB IS & WS")).Select Selection.FormulaR1C1 = d End Sub On 4 Mar, 03:07, enna49 wrote: My apologies if I have done this incorrectly. After closing off a previous post I added to this question. Is there someway to select and update Multiple Worksheets in a Macro, I have tried a couple of ways below I have included my latest code. Sheets(Array("Regional Freight-QNRFA", "Int Retail-QNIMR", "Int Wholesale-QNIMW", _ "Passenger-PS", "Network-NW", "Infrastructure-IS", "Workshop-WS", "COMB IS & WS")).Select Dim d As Date d = InputBox("Enter the desired date.") Range("C1").Value = d This will only update the first sheet Thanking you . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to update hyperlinks through multiple sheets but can't | Excel Worksheet Functions | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
Update same charts in multiple sheets at once | Excel Worksheet Functions | |||
Update multiple sheets | Excel Worksheet Functions | |||
Update multiple sheets at once | Excel Discussion (Misc queries) |