View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default What data type for Variable?

Hi
dim StartPoint as range
dim myRange as range

Set StartPoint = Range("A1")
Set myRange = ActiveCell


--
Regards
Frank Kabel
Frankfurt, Germany


Jeff Armstrong wrote:
What would be the correct data type if I wanted to declare
and set the variable below?

dim StartPoint as ???
dim myRange as ???

Set StartPoint = Range("A1").Select
Set myRange = ActiveCell.Offset(rowindex:=0,
columnindex:=0).select
I know I can always use 'As Variant' but this uses the
most memory. Is there something else I should be using?

Jeff