Hello, I am new to macros, and to recording them. I created a webquery with
a parameter that it edits a part of the query based on a cell I select. I
now have to run this web query 800+ times. So I recorded myself doing it
with the Use relative references checked. But it always puts the
sorry, On Red Bold i mean ActiveCell.Offset(1,1)
On 31-08-2013 0:56, De Premor wrote:
Try to using Offset
Ex: Before you run your code, active / selected cell was on C3, then
try to run this code
Sub Tes()
ActiveCell.Offset(1,0).Select'Move 1 Cell Down
Stop'See Your Current
Try to using Offset
Ex: Before you run your code, active / selected cell was on C3, then try
to run this code
Sub Tes()
ActiveCell.Offset(1,0).Select'Move 1 Cell Down
Stop'See Your Current Selected Cell Now, then back here and
press F8
ActiveCell.Offset(0,1).Select