View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tim Coddington Tim Coddington is offline
external usenet poster
 
Posts: 94
Default Macro to Delete Row

You are examining the same cell over-and-over.
You could put in an activecell.offset(1,0) to move to the next cell.
"Fredrik Wahlgren" wrote in message
...

"Tom Fortune" wrote in message
...
It acutally looks like it completes all steps of the macro, but no lines

are
deleted. I have tried stepping through the macro and it goes through

the
step but nothing happens and I do not get an error. It is as if the

For/Next
loop does not do anything!

What would be the code to display the current value of cRows during the

loop
so I can see if anything is actually happening?

Is the cRows= statement correct?

Thanks

"Fredrik Wahlgren" wrote:



I haven't examined your code. If it's a Sub, use MsgBox. You can also step
thru tehe code, the debugger should show the value of cRows.

/Fredrik

/Fredrik