PDA

View Full Version : macros code help !



KK1966
10-17-2013, 10:03 PM
Hi, experts I’m annoying as I have spreadsheet with macros run for daily summary which contents too many date / time to calculations, one of that don’t know why now error’s come up! I find that was caused from columns “S” which is a time value format (00:00:00) what was error encountered? Is even cells are empty but also counts that an even else value caused.How to avoid that if empty cell?What I discovered on it is empty cell but a space 2 tap are there. Does it mains caused? Code’s like that If cells(I,19) = “” then goto Nnext ( I, have tried if len(trim(cells(I,19) = 0 ) then !! also nothing) If cells(I,19) > timeserial(13,0,0) and cells(I,19) < timeserial (14,0,0) then AM13 = AM 13+1 End if

Aussiebear
10-17-2013, 10:57 PM
Please think about a better descriptive title for your post. You have been a participating member of this forum for a while now, and you should know what's required.