Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-14-2014, 08:06 AM
BobBridges's Avatar
BobBridges BobBridges is offline Locking A Cell Reference Regardless Windows 7 64bit Locking A Cell Reference Regardless Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Ah, of course. I used to use INDIRECT a lot, and then decided that for many situations I should use OFFSET instead. But for this case I think Peco's solution is better: It's more intuitively obvious to the eye.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking A Cell Reference Regardless Keeping an absolute reference in a cell bremen22 Excel 7 01-16-2014 11:06 AM
Locking A Cell Reference Regardless How to reference a cell value Jmoney2290 Excel 1 11-06-2013 09:39 PM
Locking A Cell Reference Regardless Reference number and cross reference for equation numbers to match the thesis format wmac Word 1 05-14-2013 08:54 PM
locking out word joe Word 0 11-19-2009 02:09 AM
How do I reference a merged cell in a multi column & row table in MS Word ('03')? jihanemo Word Tables 0 03-18-2009 08:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:03 AM.


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