Can you use a table in VBA rather than a specific range?
at the moment I'm using this:
.Range("B7:B23")
but I'd like to use a table so it could be added to by the user.
Is this possible and if so, what is the syntax please?
Thanks!
at the moment I'm using this:
.Range("B7:B23")
but I'd like to use a table so it could be added to by the user.
Is this possible and if so, what is the syntax please?
Thanks!