Referencing a cell using a cell from a different sheet

[kwaring]

The cells I am trying to reference are in a sheet called interface. In this example, i am trying to use values in cells E37 and E39 to reference Ax and Hy where x and y are the respective values of cells E37 and E39 in sheet "Interface"... Why doesn't this work or how can i make it work?

Range("A" & [Interface!$E$37] & ":" & "H" & [Interface!$E$39]).Select

Thanks!

 

[kwaring]

'Copies format down
Sheets("Data").Select
Range("A" & Sheet1.[E37] & ":" & "H" & Sheet1.[E39]).Select
Selection.AutoFill Destination:=Range("A" & Sheet1.[E37] & ":" & "H" & Sheet1.[E40]), Type:=xlFillDefault
Range("A" & Sheet1.[E37] & ":" & "H" & Sheet1.[E40]).Select
ActiveWindow.SmallScroll Down:=-9
'Pastes information
Range("I" & Sheet1.[E37]).Select
ActiveSheet.Paste
'Resets to Interface Sheet
Sheets("Interface").Select
Trying to copy down the formatting (like dragging the bottom right hand corner of a selection down the sheet) and then paste a value into it

 

[kwaring]

oh, one more thing the error occurs at the first line starting with "Range"

 

[Tom Urtis]

Well, here is your code, revised and error free when I tested it.

This looks like only part of your entire code, but nevertheless, this portion had no errors.