PDA

View Full Version : Solved: return missing value



sal21
05-28-2007, 01:31 PM
with a macro, please....
i want to insert in colum B the missing value in range from column A based a B1 to C1...
started from B2 insert value from 45000001 to 45000080, 45000082 to 45000107, 45000109 to 45000149... 45034946 to 450040000

naturally for test use only the first 8 digit of value in column A

rbrhodes
05-28-2007, 03:40 PM
Hi sal21


This help?

Cheers,

dr

sal21
05-28-2007, 11:09 PM
Hi sal21


This help?

Cheers,

dr

superb!
tks.
Only one.... but possible to no insert blank cell in column B during the copy of missing value?

sal21
05-28-2007, 11:26 PM
Hi sal21


This help?

Cheers,

dr
dont worry for last reply, solved...
tks for all...

Ahhhhhhhhhhhhh...
Tks again for good explain in code.
Good user not is only make code, but good user is who understand the code!