+ Reply to Thread
Results 1 to 5 of 5

VBA Locking in Formulas based on two conditions

  1. 02-25-2014, 12:55 PM #1
    aworfolk
    aworfolk is offline
    Forum Contributor
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2016
    Posts
    120

    VBA Locking in Formulas based on two conditions

    I am trying to lock a set of cells values using VBA but only if the last cell in the block is a formula and a date. So in the file i attached it would be cell BH4 and the cells that need to be lock would be all of Rows 4,5,6,7,8. But i need it to find amoung all cell in the BH coloumn. The actual file goes all the way to BH1978. Thank you in advace. Also the sheet I attached has had some informtion deleted so that personal infromation would be removed. 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by aworfolk; 02-25-2014 at 05:12 PM. Reason: added code been working on
    Reply With QuoteRegister To Reply
  2. 03-12-2014, 02:05 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: VBA Locking in Formulas based on two conditions

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 03-12-2014, 07:58 AM #3
    aworfolk
    aworfolk is offline
    Forum Contributor
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2016
    Posts
    120

    Re: VBA Locking in Formulas based on two conditions

    I didnt solve it persce i just took the basic formula and coped it about 200 times changing which line it looks at
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-12-2014, 09:18 AM #4
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: VBA Locking in Formulas based on two conditions

    No, this wont be an efficient method. There are better ways of doing this.

    By lock i know you mean to paste special values. Can you explain which cells and how do we arrive at these cells which need to be locked?
    Reply With QuoteRegister To Reply
  5. 03-12-2014, 11:59 AM #5
    aworfolk
    aworfolk is offline
    Forum Contributor
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2016
    Posts
    120

    Re: VBA Locking in Formulas based on two conditions

    In the BH Coloumn starting at BH4 then cells there is a cell that populates a date when that populates then this macro will lock the values in for the cell in rows 4-8 and Cell A3. Then this contenuies every 7 cells. So It would then need to look at BH11 and lock Rows 11-15 and Cell A10.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Dynamic Count and Sum Array Formulas Based on Multiple Conditions
    By 5150 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-27-2014, 04:35 PM
  2. Conditions/criteria based on arrays with different formulas?
    By nikojago in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-16-2013, 12:11 PM
  3. Locking Formulas
    By Thadar in forum Excel General
    Replies: 3
    Last Post: 12-16-2005, 10:25 PM
  4. [SOLVED] Re: locking formulas??
    By diane in forum Excel General
    Replies: 0
    Last Post: 12-12-2005, 05:55 PM
  5. locking formulas
    By speary in forum Excel General
    Replies: 6
    Last Post: 07-21-2005, 02:05 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