Results 1 to 4 of 4

Insert Column to the left once value of Cell = Specific Cell using IF Reference

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2019
    Location
    Atlanta, Ga
    MS-Off Ver
    Version 1910
    Posts
    2

    Post Insert Column to the left once value of Cell = Specific Cell using IF Reference

    I'm attempting to insert a column to the left of a dynamic cell once the value reaches an amount that is = to a specified cell. I am creating a template for future loans of similiar structure. The reason for doing this is that it is a loan structured with two tier interest and once the value reaches a specified amount, the loan starts paying a differing interest rate. To reach this cutoff value, an additional payment is needed before the cutoff value is reached. I have named the range with the total loan amount "Values" I am receiving a run-time error '424' message that states "object required"

    Can anyone give me some adivce on how to do this?

    Sub Add_Column_if_reference()
    'Insert colum to the left when final draw balance reached'
    For Each cell In Range("Values")
    If cell.Value = Range("D13").Value Then
    Rng.Offset(0, -1).EntireColumn.Insert Shift:=xlRight      ----> RECEIVING ERROR HERE
    End If
    Next
    Application.ScreenUpdating = True
    End Sub
    Last edited by goterry; 11-20-2019 at 11:48 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 17
    Last Post: 01-01-2018, 07:29 AM
  2. Replies: 8
    Last Post: 10-28-2015, 10:22 AM
  3. Find cell with value from a column and insert formula in the cell to its left
    By konata in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2014, 05:11 AM
  4. Find 1st unique Value on Column and Insert certain Word on cell on left Column
    By Wldlife23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2013, 10:02 AM
  5. Insert Column before a cell with Specific value
    By Tryagainandagain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2012, 07:00 AM
  6. [SOLVED] Stop cell reference changing when insert column
    By freud1 in forum Excel General
    Replies: 3
    Last Post: 07-27-2012, 10:44 AM
  7. [SOLVED] Macro to insert a value in a cell when the same cell in a different column=specific value
    By sdtgilbert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 07:09 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1