How to go to Nth precedents of active cell?

p45cal · #2 07-13-2023, 04:04 AM

This should do it (no need for the other lines):

Code:

Sub gotopresedence()
Application.Goto Reference:=ActiveCell.DirectPrecedents.Areas(InputBox("what precedence"))
End Sub

It's the Areas part that was missing.

re:

Quote:

Originally Posted by soroush.kalantari

As far as I know, there is no way to write a code that does this job for precedents which are out of the sheet the active cell lies

Have an explore of the likes of:

Code:

With ActiveCell
  .ShowPrecedents
  .NavigateArrow TowardPrecedent:=True, ArrowNumber:=1, LinkNumber:=1
  .Parent.ClearArrows
End With

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
access active cell in word vba	littlepeaks	Word VBA	5	08-24-2022 09:14 PM
Move active cell down	Marcia	Excel Programming	2	06-22-2022 04:10 PM
Change active cell after running macro in active cell via selection change	Peterson	Excel Programming	3	03-07-2021 12:19 PM
Cell equal value new value of active cell which is a drop down	hassanmoukadem	Excel Programming	1	04-13-2020 07:54 PM
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM