Go to Precedents - different sheets - with VBA

galileogali

galileogali

Well-known Member
Joined
Oct 14, 2005
Messages
748
Using VBA.
How go to the cells of a cell precedents, and if some other stations are in different Sheets?
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Sort by date Sort by votes
Of cause you can.have a try:

Code: 
Sub Macro1()
Application.ScreenUpdating = False
Dim s As String
Sheet1.Select
[a1].Select
ActiveCell.ShowPrecedents
ActiveCell.NavigateArrow True, 0
s = "SHEET1!A1 Precedents:" & ActiveCell.Parent.Name & "!" & ActiveCell.Address & " Formula: " & ActiveCell.Formula
Sheet1.Select
[a1].Select
ActiveSheet.ClearArrows
Application.ScreenUpdating = True
MsgBox s
End Sub

Best Regards
Northwolves
 
Upvote 0
NorthWolves: Thank you very much.
I changed the parameter "0"
to 1 and to 2

ActiveCell.NavigateArrow True, 2
GALILEOGALI
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Add zeros preceding number so that number is a total of 6 characters
Replies
2
Views
129
Rick Rothstein
Rick Rothstein
B
  • Solved
Removing characters from the front of a text string
2
Replies
16
Views
436
awoohaw
awoohaw
R
  • Question
Subtracting all calendar days, but end date cannot fall on a weekend or holiday. If it does, the end date shifts to the preceding work day.
Replies
7
Views
200
Alex Blakenburg
A
A
  • Solved
exclude zero and precede it on userform when populate data in listbox
Replies
4
Views
313
abdelfattah
A
A
  • Solved
Differentiating overlapping strings using SUMIFS?
Replies
2
Views
162
JamesCanale
JamesCanale

Forum statistics

Threads
1,214,647
Messages
6,120,722
Members
448,987
Latest member
marion_davis

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top