Expression to Create a Range Name

G

Gerry

Can I use an expression to create a Range Name. If I have
a sheet with 10 rows which can sometimes vary, with cols
from A to C always. All rows will always have information
(i.e no blanks) can I create a range name in a Macro like
Range("B:COUNTA(B:B)")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top