applying modules to mulitple worksheet
Can you show us the changes macro please Violet?
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"violet" wrote in message
...
got another problem now...you c my code is for highlighting changes..now
prob
is that when one of the sheet that i declare in the array is empty..the
array
of worksheet seem like will not load as any sheet that is declare after
the
blank sheet, the macro "changes" will not work on those sheets.
eg.
For Each wks In wkb.Worksheets(Array("Korea", "China", "Malaysia",
"Brunei"))
call changes
next wks
if korea sheet has no data, "china" sheet and the rest will not execute
changes
"violet" wrote:
i have written a sub test_values in modules named Identifychages. I know
that
by runing the module it will perform the sub on the excel worksheet that
i am
opening. however, i wish to run this sub on mulitiple worksheets on the
same
workbook.how can i do it?anyone can give me advice? i still very new to
vba
coding in excel.
|