Quote:
Originally Posted by music_al
Is there a simple was that (from the Word VBA module) of...
- Counting the number of rows used on a particular worksheet
- Returning a value from a particular cell
I'm sure I could work out what I'm trying to do from that
|
Sure, you could simplify the code I posted - by deleting the error-checking, for example - but then you'd risk it falling over. A considerable portion of the code goes into checking whether Excel is already running and whether the workbook exists and whether someone else has it open (which might mean the data are changing).