i need to pass to a Sub a parameter TargetRange As Range
i want my macro to pick up the target range location from a cell on on
of the sheets.
for example:
in cell a1 i have the value "B10"
i need to pass the value in a1 as a Range to my Sub.
i tried
Dim TR
TR
Range(Worksheets("DataFeeds1").Range(Worksheets("D ataFeeds1").Range("A1")).Value)
Sub mysub (Target As Range)
.....
end sub
But inside mySub Target is A1!!
Admittedly i'm somewhat new to this.
Your Help is sincerely appreciated
--
Message posted from
http://www.ExcelForum.com