[RESOLVED] could someone help me with some code to increment a mac address please

[gerble1000]

i could do with a code that would increment a mac address by 1
example
dim mymac = "00:00:00:00:00:ff"

some code

msgbox(mymac) ' mymac = "00:00:00:00:01:00"

not sure where to start