Results 1 to 5 of 5

Remove hardcoded Cell Reference and replace with ROW Function - How

Threaded View

  1. 04-17-2023, 01:45 PM #1
    Badvgood
    Badvgood is offline
    Forum Contributor
    Join Date
    02-09-2007
    Location
    UK
    MS-Off Ver
    2019 & 365
    Posts
    304

    Remove hardcoded Cell Reference and replace with ROW Function - How

    Hello all,

    I have several thousand formulas to correct, and after researching, I think the ROW function added to an INDIRECT Formula is the way to go. But I can't get it to work!

    =INDIRECT(A$1&"!A9")

    I have to copy this across and down, and where the A9 is hard coded, that means adjusting thousands of formulas by hand...

    How do I replace the A9 with the ROW function to start at A9?

    Very small sample data is attached.

    I really appreciate any help you can provide.

    BVG
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Multiple function macro with hardcode value being subtracted in hardcoded cell
    By ryguy111 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-23-2020, 11:32 AM
  2. Macro: Search and replace: Replace using a cell reference
    By kalyan46 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2019, 07:11 PM
  3. [SOLVED] Replace an absolute cell reference in an If function when met.
    By markDuffy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2018, 09:19 AM
  4. [SOLVED] How to replace or substitute function formulas but left the cell reference intact?
    By Franky alta in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-02-2016, 12:48 AM
  5. replace hardcoded value with a formula plus a growth calc
    By Vaslo in forum Excel General
    Replies: 8
    Last Post: 10-16-2014, 05:33 PM
  6. [SOLVED] Replace absolute cell reference with Indirect cell reference in formula
    By Roothy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2013, 04:46 AM
  7. Replace ability to select folder with a hardcoded directory
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2010, 04:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1