Hi,
I am sure this is a simple quesiton, but I am not sure how to word it correctly to get it to show up in a Google search.
I am trying to refer to a portion of named range via VBA. So for example, I'll have a column named "MyColumn" and I only want to select rows 8-41, how would I write this correctly:
Thanks!
I am sure this is a simple quesiton, but I am not sure how to word it correctly to get it to show up in a Google search.
I am trying to refer to a portion of named range via VBA. So for example, I'll have a column named "MyColumn" and I only want to select rows 8-41, how would I write this correctly:
Code:
range("MyColumn").Cells(8,1):Cells(41:,1)
Thanks!