Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2023, 09:19 PM
soroush.kalantari soroush.kalantari is offline How to go to Nth precedents of active cell? Windows 10 How to go to Nth precedents of active cell? Office 2016
Competent Performer
How to go to Nth precedents of active cell?
 
Join Date: Jun 2021
Posts: 124
soroush.kalantari is on a distinguished road
Default


@ p45cal. I have a follow up question. Is there a way to make this code do the job, when the precedence is a relative defined name? (See the excel attachment. I have defined a relative name (“inflation”) and when in cell “E1”and enter 1 in the input box, I expect to go “E2”.)
Attached Files
File Type: xlsm direct.precenedts for relativenames.xlsm (18.6 KB, 3 views)
Reply With Quote
Reply

Tags
prcedent



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to go to Nth precedents of active cell? 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
How to go to Nth precedents of active cell? 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
How to go to Nth precedents of active cell? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft