I'm writing my first macro, having no prior knowledge of VB...fun.
Basically, I need the macro to open an input text file of tabulate
data and create a chart with that data.

The problem is that the amount of input data will change frequently, s
the plotting range has to be dynamic. When I recorded the macro, i
inserted absolute R1C1 cell references for the range function. I nee
to replace those references (for example, R1C2:R4332C2) with dynami
references that will select the entire column.

I noticed that you could do this easily in the A1 reference style, b
simply using H:H or whatever the column name is. But I can't find an
information on doing it in the R1C1 style, and it seems I have to us
R1C1 when writing the macro.

Thanks in advance for any help you can offer

--
Message posted from http://www.ExcelForum.com