Absolute addresses and ranges
 

Is it possible to make VB understand the standard way of naming range
as used when writing formulas in Excel? It is confusing to write row
first and columns second plus the odd concept of giving the column
number in stead of the letters that is written in the heading.

Below line ios an example:

ActiveChart.SeriesCollection(2).Values = "=Sheet1!R2C4:R1002C4"

but I would much prefer to write:

ActiveChart.SeriesCollection(2).Values = "=Sheet1!D2:D1002"

as this is what I see in the spreadsheet. Is this possible with th
correct amount of "Range" and double quotes and stuff?


Niel

--
ns
-----------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...fo&userid=2650
View this thread: http://www.excelforum.com/showthread.php?threadid=46818

Absolute addresses and ranges
 

Hi,
try Application.ConvertFormula

regards,
ste