Quote:
|
Originally Posted by Stuart W
ROTFLMAO!
It's not as easy as that mate!
You will need to construct an array, which will involve typing in the VB code manualy & realy knowing what you are doing.
I *could* just do it for you, but this would not help you at all as you won't know how to do it in future or how any of it works.
My best advice would be to either grab yourself a comprehensive guide to VBA or just do your project in MS Access which is a database, rather than MS Excel which is a spreadsheet.
|
I didn't know if it was that complicated
Surely there must be a simpler way for it just to check that the line is empty. Or how about recording a macro so that it inserts a new blank line and writes on that.
I can't do it in Access - the college have stipulated that it must be done in Excel. And anyway I have no clue as to how to do it in Access.
<rant>
Although they have taught Excel, they haven't really *taught* us how to use it as such. How the hell do they expect us to know such things?
<end rant>