View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L.White L.White is offline
external usenet poster
 
Posts: 32
Default Simple assignment question

I have a cell that is populated from a drop down list.
I want to place the value in the cell into a portion of memory and I cannot
remember how to correctly word it.

I have tried:
myTitle = Range("B3").Value
myTitle = B3
myTitle = Range("B3")
myTitle = Worksheets("Current").Range("B3").value
And all of the above combinations with Set in front.

What am I doing wrong? I know this is something simple and I should see it
but just am not seeing it.

LWhite