Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cell in VBA from a different worksheet
Hello,
I originally wrote this code for data that was on one sheet, but now I want to look at data that is on Sheet 1 and if it fits the criteria that I have listed on Sheet 2, then I will go through the j loop and copy it. I don't know how to reference the cells in the 1st "if" statement when they are on different sheets. Can someone please help me? Sub trial() For k = 2 To 9 If Cells(k, 12) = Cells(17, 4) And Cells(k, 5) = Cells(17, 2) And Cells(k, 5) <= Cells(17, 3) Then For j = 1 To 26 Cells(k + 16, j) = Cells(k, j) Next j End If Next k End Sub Thanks, Stephen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing a cell in another worksheet | Excel Discussion (Misc queries) | |||
Referencing a cell from another worksheet | Excel Discussion (Misc queries) | |||
Referencing a cell to another worksheet | Excel Discussion (Misc queries) | |||
Referencing a worksheet name to a cell... | Excel Worksheet Functions | |||
Referencing another worksheet via a cell | Excel Worksheet Functions |