Search results for query: *

Gotcha, Problem solved. Cheers for the time and help, Tom.

What I basically need to do is turn the contents of each worksheet into a set of CSV files. D'you think that creating a new workbook would be the best way to do it? Tom.

What's the best way to copy the usedrange of a worksheet to a new worksheet created for this temporary purpose? I've tried the Copy function, if this is correct I can't seem to get the syntax right.....any help appreciated. Also I try to save the worksheet as a CSV file and it saves the entire...

That's done the trick. Thanks a lot mate. Tom.

It's tellin' me that ISNUMBER isn't a function. I couldn't find the thing in the help file either. I was looking at 'Cint' as a conversion function, but I don't know if I can put that in an if statement, becuase it'll probably throw up an error..... In which case how would I deal with that...

An easy one for you pro's out there..... How do I go about checking for a 'numeric value only' in a cell, even if the cell is text based? Cheers, Tom.

Genius I tell, genius. Been using the stuff for about two weeks now, so the message was a great help to me. Sorted now. Cheers Pal.

Sorry, I don't think my first mail was too clear looking at it again! I'm trying to get rid of any null rows in the data, so I'm finding the null ones then deleting them. Trouble is, if there are two null rows together, it deletes one of them, the whole thing shifts up from that point and I'm...

When I delete an excel row in a for loop the row gets deleted but the row under it is then shifted up to compensate. This means that on the next loop around I'm looking at what is essentially two rows ahead originally..... What I need is something that lets me go back one in the loop to get the...