Reach end of worksheet, continue on a new one

[omgeokid]

Hey guys,
I have a file that uses every column in a worksheet and fills it with data. How could I make my macro simply continue this on a new worksheet? I feel like I'm making it a lot harder than it needs to be. Basically, I need this portion of my code to work until it fills a sheet, then have it create a new one and keep recording there, including the correct dates and headings.

Please Login or Register  to view this content.

[omgeokid]

bump? mods, sorry for the double post, just really need help.

[stnkynts]

You got quite a lot going on there. It is hard to see what is happening but in response to your question would it be possible to use a For/Next loop outside whichever section is actually putting the data on the sheets? Something like:

Please Login or Register  to view this content.

Not sure if this is gonna help you any but who knows, it might.

[omgeokid]

I thought of that, but that's the problem. I feel like anything that is going to be done has to be within this for each loop. I know it has a lot going on, and its most likely very sloppy code because I'm learning as I'm writing (thanks to this forum) but I've been trying things left and right that just don't want to work.

[jwright650]

Can you code it using some conditional formatting so that it sees when column IV is not blank and immediately fires a macro to create a new worksheet and copy all of your column headings over to the new sheet?

[omgeokid]

Can you code it using some conditional formatting so that it sees when column IV is not blank and immediately fires a macro to create a new worksheet and copy all of your column headings over to the new sheet?

thats an awesome idea.I'll try it and let you know how it works. The only thing flawed about it is, the headings are all different, I'm continuing to count device names and putting them in every 2 headers. I think I can work something out with the conditional formatting though.

[jwright650]

I think that I mis-spoke about using conditional formatting....maybe use the "ISBLANK" function and

IF it returns "FALSE", then
fire the macro.......

ElesIf it returns "TRUE",
then "Exit Sub"
End IF

[Domski]

Might better to use a COUNTA worksheet function in your code. ISBLANK can only check one cell I think.

Dom