Results 1 to 3 of 3

Thread: [RESOLVED] [EXCEL] Changing the Modulus Range Using CONCATENATE()

Threaded View

  1. Jun 6th, 2008, 05:02 PM #1
    Vanquish2888
    Vanquish2888 is offline

    Thread Starter
    Lively Member Vanquish2888's Avatar
    Join Date
    Sep 2007
    Posts
    104

    Resolved [RESOLVED] [EXCEL] Changing the Modulus Range Using CONCATENATE()

    Hey Everybody!!

    Its been awhile since I've posted and I have come across an interesting question...

    I want to save the user some time AFTER the macro has finished running. The modulus range (the range selected in the SeriesCollection) of the graph is determined by the user once the macro has finished running, then they must change a place on the macro to same range in cells that use the SLOPE() & INTERCEPT() functions. It is rather time consuming & frustrating to change the range inside the cell. I want the user just to change the LOWER cell & UPPER cell of the range in a specified cell and have the others adjust based on this. I was thinking of using the CONCATENATE() function, however I have had no success. I have attached a picture below.

    Thank you in advance, please ask questions if I am not making myself clear.

    ~AJ
    Attached Images Attached Images  
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width