| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
InputBox VBA all worksheet, specific cell(s)
I've created an inputbox to gather user info. that I'd like to apply to all
my worksheets in specificied cells. (e.g., All worksheets - cells A1, U5, W10). I know how to do this individually (e.g,: Range("'Sheet1'!, A1, U5, W10") = Name Range("'Sheet2'!, A1, U5, W10") = Name This continues to Sheet31 ETC. Was wondering if there was a quicker method so I don't have to copy, paste and then make changes? Any help is appreciated Mike but was wondering if there is a shorter and quicker method. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
InputBox VBA all worksheet, specific cell(s)
this should do what you want
For Each sh In ActiveWorkbook.Sheets sh.Range("A1, U5, W10") = Name Next sh -- jb "Preschool Mike" wrote: I've created an inputbox to gather user info. that I'd like to apply to all my worksheets in specificied cells. (e.g., All worksheets - cells A1, U5, W10). I know how to do this individually (e.g,: Range("'Sheet1'!, A1, U5, W10") = Name Range("'Sheet2'!, A1, U5, W10") = Name This continues to Sheet31 ETC. Was wondering if there was a quicker method so I don't have to copy, paste and then make changes? Any help is appreciated Mike but was wondering if there is a shorter and quicker method. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| InputBox VBA all worksheet, specific cell(s) | Excel Programming | |||
| Deleting specific rows with a specific criteria using inputbox | Excel Programming | |||
| If in specific cell in any worksheet but worksheet one add to spec | Excel Worksheet Functions | |||
| Help for vba to control the PivotItem in specific Field in Pivot Table by choose in inputbox | Excel Programming | |||
| Navigate to specific cell on specific worksheet | Excel Programming | |||
Linear Mode
