Greetings my friends,
Is it possible to send data to the first blank cell of a Named Range and then continue filling down? There will be 3-5 named ranges.
Example:
Named Range "MyRange" has 10 cells. A1 To A10. I need to send data to the first cell "A1" and fill down until "A10" if needed. I am using a search Macro to grab the data..And it works fine except I need to send data to 3 or more Named Ranges on the same sheet.
Example 2:
My Macro looks for a Name in say Column D. If the name is found it looks for a singe letter in the same row Column B. Then it copies that name into a named range and fills it down.
I hope this makes sense to someone