Hello All...
Having a little trouble here
I have the following codes:
Dim Lst As Long
And
and it's not working...
If I use:
It does work, however I wish the formula to go to the last row and not only to Row 20...
What am I doing wrong?
Thanks
PS what I'm trying to accomplish, is in column M, to only display what is in column E that only has a mixture of Text and Numbers like: LB667
Having a little trouble here
I have the following codes:
Dim Lst As Long
VBA Code:
Lst = Range("A:A").Cells.Find("*", _
SearchOrder:=xlByRows, searchdirection:=xlPrevious).Row
And
VBA Code:
Range("M2").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-8]=""No Tag Found-"","""",RC[-8])"
Selection.AutoFill Destination:=Range("M2" & Lst), Type:=xlFillDefault
Range("M2" & Lst).Select
Range("A1").Select
and it's not working...
If I use:
VBA Code:
Range("M2").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-8]=""No Tag Found-"","""",RC[-8])"
Selection.AutoFill Destination:=Range("M2:M20"), Type:=xlFillDefault
Range("M2:M20").Select
Range("A1").Select
What am I doing wrong?
Thanks
PS what I'm trying to accomplish, is in column M, to only display what is in column E that only has a mixture of Text and Numbers like: LB667