Svgmassive
Board Regular
- Joined
- Nov 2, 2010
- Messages
- 113
i am running a function(vba) then checks for numbers in a range
when the rng.Address is $F$5:$F$11 then function returns the correct rows $F$5:$F$8,$F$10:$F$11
but if i clear the sheet and start entering values in f5 the results are listed below.This affects other formulars on t he sheet.how do i correct this? thanks
?rng.Address
$F$5
?rng.SpecialCells(xlCellTypeConstants, xlNumbers).Address
$A$5:$D$5,$F$5:$G$5,$I$5,$N$6:$O$6
when the rng.Address is $F$5:$F$11 then function returns the correct rows $F$5:$F$8,$F$10:$F$11
but if i clear the sheet and start entering values in f5 the results are listed below.This affects other formulars on t he sheet.how do i correct this? thanks
?rng.Address
$F$5
?rng.SpecialCells(xlCellTypeConstants, xlNumbers).Address
$A$5:$D$5,$F$5:$G$5,$I$5,$N$6:$O$6
