View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JPCPA JPCPA is offline
external usenet poster
 
Posts: 5
Default cell value from different worksheet

I have a user form that, based on the option button selected, a value needs
to be returned from a different cell in a separate worksheet. I get an out
of range error when I try the following code:

Sheets("Sample Selection").Select
ActiveSheet.Unprotect
Cells(2, 5) = Worksheets("SampleCalc").Cells(3, 45)

What am I doing wrong?

--
JP