gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
I have a table that can start in a different row each time the user is working in the workbook.
Is there a way to find what cell the header "Index" is in? It will always be in column B but the row will change from time to time.
I need to use this location in order to find the Intersect (so I would also need to determine the last Row of column B)
here is what I need to adjust:
If Intersect(ActiveCell, Range("B16:E" & LR)) Is Nothing Then
MsgBox "You must select a cell within the applicable Proposal Row. Select a valid Cell"
Exit Sub
End If
Thanks
Is there a way to find what cell the header "Index" is in? It will always be in column B but the row will change from time to time.
I need to use this location in order to find the Intersect (so I would also need to determine the last Row of column B)
here is what I need to adjust:
If Intersect(ActiveCell, Range("B16:E" & LR)) Is Nothing Then
MsgBox "You must select a cell within the applicable Proposal Row. Select a valid Cell"
Exit Sub
End If
Thanks