View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JasonSelf[_4_] JasonSelf[_4_] is offline
external usenet poster
 
Posts: 1
Default RefreshAll Data with VBA

Well, this should be my last question for a little while. I need t
create a button that refreshes all data on a specific sheet (we wil
call it sheet1) I found this Worksheets(2).RefreshAll that is suppose
to do just that. I just don't understand exactly how I specify m
worksheet. The 2 is not the name of any of my sheets but doing
little searching I found that it may be the Index property....I do no
understand how I can determine the index property if that is indeed th
case.

Thanks for your help as always, any input would be greatl
appreciated.

Jason Sel

--
Message posted from http://www.ExcelForum.com