Editing a macro
Looking for information on how to edit a macro. Using a macro to enter data
into a spreadsheet. The number of entries is never the same. How do you
tell Excel to stop entering data after the last entry? I currently have to
enter a value such as Range("K4:K20000"), but I never have 20000 entries, it
will fill the remaining cells with #VALUE, I need the macro to stop after the
last entry. Any ideas?
|