View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Userforms, switching sheets

....this will make it a lot easy/better

with worksheets("sheet1")
.range("A1") = "foo"
.cells(2,1) = .range("A1")
end with

Especially after I asign them variable name like you said so I can easily
change the name down the road...
thanks again!