LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to use Indirect function?

Does anyone have any suggestions on how to use Indirect function?

Under column AC, INDIRECT("AC"&591+1) in cell AC593.
When I copy this cell to the right under column AD, does anyone have any
suggestions on keeping the "AC" changing based on located column?
This is what I want under column AD, INDIRECT("AD"&591+1) in cell AC593.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Indirect Function Jim May Excel Worksheet Functions 10 November 12th 06 07:29 PM
using the INDIRECT function hot dogs Excel Discussion (Misc queries) 1 November 1st 06 12:01 PM
INDIRECT function inside AND function Biff Excel Worksheet Functions 3 September 23rd 06 07:20 PM
Need help on Indirect function Naveen Excel Discussion (Misc queries) 3 August 11th 06 06:45 PM
Help with Indirect function ? Richard Buttrey Excel Worksheet Functions 4 May 24th 06 11:27 PM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"