hi, i have a sheet that links to data in another sheet. the links go to many more rows than there is data. i want to get to the bottom of the data but not to where the formula ends, just to where the data ends. the Selection.End(xlDown).Select goes to the end of the formulas. how can i go to the end of just the data and not to where the formula ends?
in the sample below if i use the selection.end code above i'll go to the last zero since that's where the last link to another sheet is, but i just want to get to the row that shows link_item3.
link_item1 (these rows link to another sheet)
link_item2
link_item3
0
0
0
0
Bookmarks