Help: Macro to to sum across selected visible worksheets

  • Thread starter Thread starter maimai
  • Start date Start date
M

maimai

Hi there!

Can anybody help me design a macro that would sum across VISIBLE
worksheets, that starts from, say 3rd worksheet up to the last visible
one?

thanks!
 
You can test visible sheets for the .Visible property = xlSheetVisible.

Is this enough to get you going or do you need more?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Display selected cell at bottom of screen 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to change add-in object from within worksheet module. 3
Need Macro... 8
Loop within worksheet array 5
If/Then Macro For Each Visible Worksheet 3
Error message when I open any other excel file 2
Command Button Click Help 8

Back
Top