how to return a range

N

NDBC

I need to return a range to send it to a function. This is what I am using

Set ranger = Range(Cells(TRow, 14), Cells(TRow, TCol + 3)).Address

It doesn't seem to work. All the variables are correct in debugger but the
ranger (dim as range) is "nothing".

Thanks again
 
R

Rick Rothstein

Try removing the .Address property call from the end of the Range (Address
returns a String value... you need an object to be assigned to the ranger
range).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

clearing array variables and using an array to determine min value 7
Using Do Loops to copy data 7
Macro to grap certain cells and copy..... 4
Loop code, capture exceptions, and display pop-up 3
Problem Passing Arguments 4
Convert code to lookup three criteria return fourth 15
HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE 2
Passing a Range to a Function Problem 4

Top