| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook? | Excel Worksheet Functions | |||
| link a cell in the 'Master' worksheet list to a 'Detail' worksheet | Excel Programming | |||
| copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| selecting cell range in other worksheet without switching to worksheet | Excel Programming | |||
Threaded Mode
