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
|