Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difine a range with variable
I want to write macro that making a graph. I can't know the range so I writing a loop that would check the range. Could I define the range with variable that I get from the loop? thanks :) -- ditzafar ------------------------------------------------------------------------ ditzafar's Profile: http://www.excelforum.com/member.php...o&userid=29475 View this thread: http://www.excelforum.com/showthread...hreadid=497501 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difine a range with variable
Could I use excel function when I don't know the range and I need t define it with variable. If it possible, how I do it? thanks: -- ditzafa ----------------------------------------------------------------------- ditzafar's Profile: http://www.excelforum.com/member.php...fo&userid=2947 View this thread: http://www.excelforum.com/showthread.php?threadid=49750 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difine a range with variable
Assuming you know that there are nRows, you can use
Set rng = Range("A1:A" & nRows) or something similar -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ditzafar" wrote in message ... Could I use excel function when I don't know the range and I need to define it with variable. If it possible, how I do it? thanks:) -- ditzafar ------------------------------------------------------------------------ ditzafar's Profile: http://www.excelforum.com/member.php...o&userid=29475 View this thread: http://www.excelforum.com/showthread...hreadid=497501 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Range | Excel Worksheet Functions | |||
Macro to copy a specified range to a variable range | Excel Programming | |||
sum on a variable range | Excel Programming | |||
setting a range variable equal to the value of a string variable | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |