macro to combine two cells date notation

[Gielekes]

I am having a problem with an excel sheet. I have a sheet which imports a csv file and some time values. but i need to add a specific value. Additionally I need to be able to change this value from 1 up to 12. Is there a way to do this. the data gets popped in Column A from A11.

Yes i can write a macro which adds the value to the whole column but not specific for the range in which the data is located.

[DarkF1ame]

Hello Gielekes,

You don't have to add just one value to the entire "A" column. This code would add something to only the cells that have something in them:

Please Login or Register  to view this content.

You could additionally set up some logic loops to split numbers of the populated cells in the "A" column. There are a few ways to tweak this code based on your specific needs but since you said you have times i figured a string-based solution was best. You could always make it number-based though.

Let me know if I can help further,

DarkF1ame

[Gielekes]

When I use the code, the data gets converted into numbers instead of a date.

[DarkF1ame]

Gielekes,

If you can upload a worksheet that will help. Without that you can play around with the datevalue operator:

Please Login or Register  to view this content.

The "d" in the DateAdd operator would add your integer to the day, "m" would be month, "y" for year.

[Gielekes]

Thanks this helps a lot