Kaniguan1969
08-14-2014, 11:07 PM
Hi,
I have a worksheet with autofilter column that i would like to replace or change the string value "Not yet" with "IN TRANSIT". May I ask your help guys on how to do in vba maco. thanks.
below is the macro code.
'replace value string "Not yet" with "IN TRANSIT"
Dim dat As Variant
Dim a As Range
Dim i As Long, FilterRow As Long
With wsWork
lrow = .Range("A" & .Rows.count).End(xlUp).Row
Set FilterRng = .Range("A1:J" & lrow)
FilterRng.AutoFilter 6, "Not yet"
FilterRow = .Range("A" & .Rows.count).End(xlUp).Row
'?replace all string "Not yet" in column F with "IN TRANSIT"
End With
I have a worksheet with autofilter column that i would like to replace or change the string value "Not yet" with "IN TRANSIT". May I ask your help guys on how to do in vba maco. thanks.
below is the macro code.
'replace value string "Not yet" with "IN TRANSIT"
Dim dat As Variant
Dim a As Range
Dim i As Long, FilterRow As Long
With wsWork
lrow = .Range("A" & .Rows.count).End(xlUp).Row
Set FilterRng = .Range("A1:J" & lrow)
FilterRng.AutoFilter 6, "Not yet"
FilterRow = .Range("A" & .Rows.count).End(xlUp).Row
'?replace all string "Not yet" in column F with "IN TRANSIT"
End With