InputBox VBA all worksheet, specific cell(s)
how about using a loop?
for ws = 1 to 30 Range("'Sheet" & ws & "'!, A1, U5, W10") = Name next "Preschool Mike" wrote in message ... 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. |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com