Hi I am trying to alter a column which is formatted in "General" I.e Just Numbers (1, 2, 1.5 etc) I am trying to get the values to read as HH:MM format so 1.5 becomes 01:30, 2 becomes 02:00 etc. The code I have used in the past is as follows: Please Login or Register to view this content. For some reason on this occassion it is coming up with an error on the line Cell.Value = Cell.Value / 24 and I really can't see why. I have used this piece of code countless times before with no problems but on this occassion it simply won't work. Has anybody got any ideas? Thanks In Advance Mark
Please Login or Register to view this content.
Think it's because of this line Please Login or Register to view this content. If it's not formatted as General you will get a error VBA Nobo
_________________________________________ Credo Elvem ipsum etian vivere _________________________________________ A message for cross posters Please remember to wrap code. Forum Rules Please add to your signature if you found this link helpful. Excel links !!!
The thing is it is formatted as general (well, when I right click on it and go in to Format Cells it shows as General under the Number Tab). Any ideas? I really can't see where it is going wrong.
See if this helps Please Login or Register to view this content. VBA Noob
That seems to work fine. So was the problem caused by the fact that the first cell (i.e the heading) wasn't numeric? Something so simple?? How annoying! Thanks (again!) for your help, really appreciate it. I'm going home to have a cry now!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks