Modify macro to be relative

**rileyp** · 03-25-2013, 07:48 AM

Hi Everyone.
I have with some help from the kind people on this forum managed to make a small macro that converts a column of timestamps that is not in a format excel can recognize as date time into a excel date time format. It works a treat and I am very happy with it.

Please Login or Register  to view this content.

http://www.excelforum.com/excel-gene...date-time.html
The next step for me now will be make the macro able to be used in different columns.
At the moment I can only use it with column A and the new date time is put in column C.
The data I import always contains 2 columns and I would like to put more than one lot of data onto a sheet.
Is it possible if each time with my mouse I highlight the top cell two right of the column where the imported timestamp is eg G3 when imported timestamps start at e3 and then run the macro from there.
Any tips much appreciated
cheers rileyp

**rileyp** · 03-25-2013, 07:55 AM

I think i just found it "use relative references" I'll do a recording using relative references and then look at the code and compare to code above and hopefully I can nut it out myself.

Edit... I need help.

**Richard Buttrey** · 03-25-2013, 08:14 AM

Hi,

This shortened macro is one way

Please Login or Register  to view this content.

You could also put it in the Sheet Double Click event so that double clicking a cell would automatically run the macro.

**rileyp** · 03-25-2013, 09:06 AM

Thanks Richard I really like the idea of double clicking but have no idea how to make it happen and what you posted above does work and how it does amazes me but it changes the data in the second column (eg a temperature or valve position etc) to a timestamp...This isnt supposed to happen.
Thanks for your help