Mavericks334
Active Member
- Joined
- Jan 26, 2011
- Messages
- 280
Hi.
I have a macor that filters and search's for a data accroding to the criteria. And then select the entire rows from where the data is starting. I need to select the blank cell active. Below is the part for the code.
Windows("FTS_HC").Activate
Sheets("OR").Select
Range("A1").Select
' Data is filtered
Range("A1").AutoFilter Field:=25, Criteria1:= _
"IO"
' Rows activated from where the data reflects could be any row number
Rows("2:2").Select
' To make blank cell
With ActiveCell
Cells(.Row+1, .Column).Select
End With
I have a macor that filters and search's for a data accroding to the criteria. And then select the entire rows from where the data is starting. I need to select the blank cell active. Below is the part for the code.
Windows("FTS_HC").Activate
Sheets("OR").Select
Range("A1").Select
' Data is filtered
Range("A1").AutoFilter Field:=25, Criteria1:= _
"IO"
' Rows activated from where the data reflects could be any row number
Rows("2:2").Select
' To make blank cell
With ActiveCell
Cells(.Row+1, .Column).Select
End With