View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andreas Winter Andreas Winter is offline
external usenet poster
 
Posts: 1
Default Save "Range-Value" to variable?

Hi,

I need to extract the Range of an excel sheet into a variable.
I want to get the "A1:C10" value as a string or as a list, if there
are multiple selections. I have looked into the VBA manual of
WinXP-Excel but I can't found this topic.

VarRange = Worksheet("Sheet1").Range won't work.

If somebody knows an answer, please give me a reply.

sincerely
A. Winter