Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: [Solved] VBA: Absolute Cell reference in macro

  1. #1
    Join Date
    15th May 2003
    Posts
    25
    Hello everyone, with the following lines of code I'm trying to get the value of cell F:9 multiplied by -1 and returned in the next empty cell. However, it wants to calculate the number of rows up (i.e. "=R[-10]C*-1") rather than using the cell reference F:9. I've tried a couple of things but haven't gotten it yet.

    Range("f65536").End(xlUp).Offset(1, 0).Select
    ActiveWindow.SmallScroll Down:=-1
    ActiveCell.FormulaR1C1 = "=R[-10]C*-1"

    I know this is probably simple. Thanks for the help.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    21st March 2003
    Location
    London, UK
    Posts
    41
    Try

    Range("f65536").end(xlup).offset(1,0).formula = "=F9*-1"

    instead

    HTH, Dzinja

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    15th May 2003
    Posts
    25
    Thanks, that worked great!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Absolute Cell Reference
    By mikeyc in forum EXCEL HELP
    Replies: 4
    Last Post: May 18th, 2007, 05:20
  2. Replies: 1
    Last Post: August 3rd, 2006, 22:17
  3. Making cell reference absolute in Macros
    By jimmya3556 in forum EXCEL HELP
    Replies: 5
    Last Post: February 11th, 2006, 00:09
  4. Changing Cell Addresing To Absolute Using Macro
    By Renegade Snail in forum EXCEL HELP
    Replies: 8
    Last Post: January 17th, 2006, 11:30

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
  •  
porno