Hi,
Below is the macro code for entering a code into a cell (H3) and finding this code value in another sheet. I can only do this as a constant. Would anyone know how i could take the value in as a variable meaning and find the value based on the number entered
ActiveCell.FormulaR1C1 = ""
Sheets("Sep").Select
Range("H3").Select
Selection.Copy
Sheets("SCHEDULE2").Select
Columns("A:A").Select
Selection.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Rows("344:344").Select
Below is the macro code for entering a code into a cell (H3) and finding this code value in another sheet. I can only do this as a constant. Would anyone know how i could take the value in as a variable meaning and find the value based on the number entered
ActiveCell.FormulaR1C1 = ""
Sheets("Sep").Select
Range("H3").Select
Selection.Copy
Sheets("SCHEDULE2").Select
Columns("A:A").Select
Selection.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Rows("344:344").Select