+ Reply to Thread
Results 1 to 2 of 2

Cells(row,column) error

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    1

    Cells(row,column) error

    Guys,

    I have written the following function in VBA, but having trouble.

    Please Login or Register  to view this content.
    When used the function tells me an error in value "#VALUE". The problem line is where I try to assign the difference to the cell on the right (ie. Cells(ActiveCell.Row, ActiveCell.Column + 1) = ...)

    Can you please help me??? Thanks

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Your code looks right ... you can test it by transforming your function in a standard sub macro ...
    A function can modify only those cells, into which it is entered... but not other cells ...
    HTH
    Carim


    Top Excel Links

+ Reply to Thread

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