VBA and Excell

Comments

  • This is what I see: All of your data should be of the same format so your algorithm will work the same everytime. From your post, I assume everything is a date.

    Is everything in one row or column?

    Dim cur As Date

    for x=1 to number_of_rows
    for y=1 to number_of_cols
    cur=cells(x,y)
    cells(x,y)=Right("0" + LTrim(Str(Day(cur))), 2) + "-MA-" + LTrim(Str(Year(cur)))
    next y
    next x
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion