Results 1 to 9 of 9

How to make a macro cell independent

Threaded View

Ads. How to make a macro cell... 10-17-2011, 07:11 AM
quekbc Re: How to make a macro cell... 10-17-2011, 07:13 AM
royUK Re: How to make a macro cell... 10-17-2011, 07:59 AM
royUK Re: How to make a macro cell... 10-17-2011, 08:00 AM
Ads. Re: How to make a macro cell... 10-17-2011, 08:18 AM
romperstomper Re: How to make a macro cell... 10-17-2011, 08:21 AM
Ads. Re: How to make a macro cell... 10-17-2011, 08:29 AM
Ads. Re: How to make a macro cell... 10-17-2011, 08:38 AM
romperstomper Re: How to make a macro cell... 10-17-2011, 08:43 AM
  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    7

    How to make a macro cell independent

    Hi,

    I am new to macro recording and VBA. How do I make a macro cell independent? For example, I currently have:

    Range("K4").Value = Range("K4").Value - 1
    i.e. minus 1 from the current value in the cell K4.

    Say then I move the content of K4 to some new location, e.g. I've added a new row above so K4 has now been shifted to K5. How do I program it so that the macro automatically performs the original operation in the new arbitary location?

    Thanks for any help
    Last edited by Ads.; 10-17-2011 at 09:10 AM.

Thread Information

Users Browsing this Thread

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

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