How can I insert variables in a range statement. For instance: I
have looked down column j for a particular value and have found it in
row m. If I copy everything from the top (A1) up thru row m I can use:

Sheets("Sheet1").Range("a1:j" & m).Copy ActiveSheet.Range("A4")

where I can append the row range m to 'j'. But in general, how can
I use variables for the arguements in the Range statement.
thanks
chuck