Move down next visible cell

Hi, janagan,

build a range based on the visible cells only and loop through that with a For Each ... Next loop:

Please Login or Register  to view this content.

No need to activate or select a cell.

Ciao,
Holger

Hi, janagan,

maybe we could just analyse the line of code that you insist to use (although it will never do what you expecz oit to do).

Please Login or Register  to view this content.

You go to Range("A1") and want to offset 1 Row and 0 Column which makes it A2 - why are you surprised that your code does what the code is supposed to do? Even if you put in SpecialcCells there you would end up with that cell selected.

Maybe you should ask yourself why you would need to drag the cursor around instead of working with objects which do what you want? I supplied a working code which loops through the visible cells only - still no need for any Select/Activate.

Ciao,
Holger

Hi, janagan,

Iīm still not convinced by using Select/Activate but maybe this comes in to what you expect - you would need to activate the cell prior to the one you want selected as the next one (not what I would call solid coding):

Please Login or Register  to view this content.

Ciao,
Holger

Hi, janagan,

So manual adjustment is very difficult for me. please give a solution

There are no hidden rows in your sample file which makes a solution simple (use Offset in your sample), and there still is no explanation why you would need to activate the next visible cell.

Ciao,
Holger

Hi, janagan,

I hope your functions will write to a different cell than they refer to - itīs the very same code I posted in my first answer except that it doesnīt display the Address of the cells but calls functions which you donīt show:

Please Login or Register  to view this content.

I have a slight problem understanding why the same range would be needed to call two different functions.

Ciao,
Holger