InputBox VBA all worksheet, specific cell(s)

P

Preschool Mike

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.
 
J

john

this should do what you want

For Each sh In ActiveWorkbook.Sheets
sh.Range("A1, U5, W10") = Name
Next sh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array with many cells from a row but not in order or together 11
Naming non-contigent cells with vba 5
Arrays and scattered cell values or another way? 16
Find value of active cell in other visible worksheets 8
Code to format cells on several worksheets 2
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
Worksheet Sharing VBA 3
Using VBA to Copy Ranges to a PreSet Dim formula AND Cell Propertys. 0

Top