COPYING A FORMULA IN CELL - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: COPYING A FORMULA IN CELL

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi Derek,
    Thanks a lot that works great.
    -Ajay

  2. #12
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    One more question? It works when the coulumns have numeric values but when i change the values to Text and then try to concatenate rc(-2), and rc(-1) it does not work

  3. #13
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Ajay
    I have rechecked it and tested it with your change and both text and numbers work perfectly on my maching. I am using Excel 2000 on Windows 98SE.
    When you say it doesn't work, does it display anything at all, do you get a runtime error or what?
    regards
    Derek

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com