Hi Can someone please explain to me in simple terms the differents between using these two commands to set a cells value
Sheets("weeklyreport").Range("b" & y).Value = XXXXX
Worksheets("weeklyreport").Range("b" & zz + 7).Value = XXXXX
Also is there an equivalent that lets me update a cell in a sheet in a workbook different to the one currently active?
Thanks
JD
Sheets("weeklyreport").Range("b" & y).Value = XXXXX
Worksheets("weeklyreport").Range("b" & zz + 7).Value = XXXXX
Also is there an equivalent that lets me update a cell in a sheet in a workbook different to the one currently active?
Thanks
JD