|
Posted to microsoft.public.excel.programming
|
|
|
need to copy row above but different thoughtout data
Don Guillett wrote:
[b]something like this (untested)
for i = cells(rows.count,"a").end(xlup).row to 2 step -1
if application.countif(range(cells(i,"b"),cells(i,"I" ))=0 then
rows(i-1).copy rows(i)
end if
next i
Don,
On this one i'm getting an Invalid number of arguments. I did notic
a typo right after 'cells(i,"I"))' I had to add another ) I hope i
was the right spot.
Tom,
Don't know if I was missing something on yours but when it got t
this point in the script it did nothing. I'm new at this so could no
see where I could come up with anything to spark it.
Awaiting more food *smile* thanks for the help.
Michae
--
Message posted from http://www.ExcelForum.com
|