Paul Morris
Board Regular
- Joined
- Sep 27, 2004
- Messages
- 64
Hi!
Don't know VB particularly well (if at all!). Spreadsheet has 2 sheets, trying to run a macro that will copy the cell contents of 'Sheet1'; cell A4 into an autofilter in 'Sheet2' (where the autofilter selection is 'equals'); except when recording the macro, it only sees the original value being pasted (not the cell contents, which will change frequently)
Here's the VB code:
Selection.AutoFilter Field:=1, Criteria1:="=010400901000370076", Operator _
:=xlAnd
It's the 0104 bit - instead of this value, I want it returning the contents of Sheet1; cell A4.
Appreciate any help on this.
Thanks
Paul
Don't know VB particularly well (if at all!). Spreadsheet has 2 sheets, trying to run a macro that will copy the cell contents of 'Sheet1'; cell A4 into an autofilter in 'Sheet2' (where the autofilter selection is 'equals'); except when recording the macro, it only sees the original value being pasted (not the cell contents, which will change frequently)
Here's the VB code:
Selection.AutoFilter Field:=1, Criteria1:="=010400901000370076", Operator _
:=xlAnd
It's the 0104 bit - instead of this value, I want it returning the contents of Sheet1; cell A4.
Appreciate any help on this.
Thanks
Paul