User Profile

Collapse

Profile Sidebar

Collapse
babs1979
babs1979
Last Activity: Mar 27 '08, 10:15 PM
Joined: Nov 15 '07
Location: Boston
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • babs1979
    replied to Locking Excel Cells in a VBA Code
    in Visual Basic
    I already tried that but all it does is highlight the cells. I want like to have a procedure that locks them upon highlight and delete the values in the rest of the cells. Thank you though....
    See more | Go to post

      Leave a comment:

    • babs1979
      started a topic Locking Excel Cells in a VBA Code
      in Visual Basic

      Locking Excel Cells in a VBA Code

      I have a worksheet with a lot of formulas but would like to delete all the cells that are not associated with formulas. There are hundreds of them and it would take a lot of time to delete them. Is there anyway a VBA code can execute this by selecting the cells with formulas and locking them? Would appreciate help.

      Regards
      See more | Go to post
      No activity results to display
      Show More
      Working...