View Single Post
  #1   Report Post  
camerons
 
Posts: n/a
Default Referencing Variable Name Worksheets

I'm updating a formatted worksheet every day. I have a macro that
processes, lets the user augment, and then saves that days data into a new
worksheet with that days date. I need to reference that worksheet the next
business day to error check. I cannot :
PREVIOUS DATE IS IN CELL A1

s = range("a1").value
worksheets(s).select

Thank you for any help/suggestions

Chris Cameron