Remove unnecessary code in macro

**rileyp** · 03-28-2013, 10:54 AM

Hi
I'll start by saying I'm very new to all this and I'm learning a lots as I go.

I have multiple lots of data that is in two columns. The left with a timestamp that I need to convert to an excel format and the other just values relevant to the timestamp.

My macro was developed with help here
http://www.excelforum.com/excel-prog...-relative.html

It converts both columns to a date format. I'd like only the column that contains dates to do so.

Please Login or Register  to view this content.

I think I have fixed it though probably not in the most elegant of ways.
I modified the macro slightly and I thinks its much better now copying and putting the excel dates back on top of the original timestamps and fixing the value column. I'm not sure its the simplest and neatest it could be and I was wondering if there is any irrelevant code I could remove. Am I correct in saying the blue bit can go?

Please Login or Register  to view this content.

cheers rileyp

**Fotis1991** · 03-28-2013, 10:58 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title.

**rileyp** · 04-03-2013, 03:23 AM

Thanks Fotis1991 I have edited my post.

**Fotis1991** · 04-03-2013, 03:31 AM

Thanks for that. I believe that soon one of our members(as my VBA skills are not good) will be able to help you.

**arlu1201** · 04-03-2013, 06:11 AM

Yes the blue highlighted section can go.

Also, why are you using activecell? Will you be highlighting / selecting a cell and then running the macro?

**rileyp** · 04-03-2013, 11:19 PM

I am using active cell as that is what was suggested to me in my other post I linked to above. I suppose if the macro was smart enough it could probably search the whole spreadsheet for strings that look like this 2012-07-19T23:00:01.01+10 and then convert them into an excel date time . My original post is here http://www.excelforum.com/excel-gene...date-time.html
I have no idea how that would be done though.
cheers rileyp