using Names in a macro

[tab1]

Hi - I have written a simple macro that takes a column of data & creates 3 temperature columns of data tempK, tempC, tempF. These are actually Names that I create.
When I run the macro on a new file, it doesn't seem to re-define tempK (for instance) as a cell range, and instead tries to use the original tempK cell range defined when I had created the macro...

How can I modify my macro so that the tempK Name is re-defined anew every time the macro is invoked ?

Please Login or Register  to view this content.

Thanks !

ak

[StephenR]

You could try deleting the name first before defining it again. If you post a sample workbook, we could probably also shorten your code.

[tab1]

I'm not sure what you mean...

I open a new file. There are no Names defined at this point. Then I run the macro.
the tempK Name appears (but of course it points to some older data). So I am forced to manually re-define the tempK range.

Is this what you suggest ?

I'm hoping there are ways to create macros using Names that would work for any random xls file I open.

ak