• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Refer to current Sheet within a macro

    I've been Ninja'd again, I think I got it. Thanks, Aldo
  2. A

    Refer to current Sheet within a macro

    Hello, I just recorded this macro: ActiveSheet.Shapes.AddChart.Select ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = "=RawData_1!$A$2:$E$1500" ActiveChart.SeriesCollection(1).Values =...
  3. A

    Using the cell function within other functions

    That helps a lot, just wanted to make sure I was following why CELL wouldn't work when nested...it changes the format to a string. Thanks, Aldo
  4. A

    Using the cell function within other functions

    You are a Ninja indeed...both of these functions work very well. Can you elaborate on the difference between an address and a reference in Excel? For instance: =INDEX(F17:F90,MATCH(.001,E17:E90,1)) returns 4.138029 in this sheet, how does CELL use this number and output E31 using "address"...
  5. A

    Using the cell function within other functions

    Thats the problem, using the cell function wont work. In this sheet the slope is found by manually entering the start and stop. https://www.dropbox.com/s/ck9lvzn1ly2kej1/Sample%20Slope%20File.xlsx Aldo
  6. A

    Using the cell function within other functions

    Sorry, that chart should look like this: ____D______E_____F__ 3__________X_____Y__ 4_Start__$E$31_$F$31 5_Finish_$E$82_$F$82 Aldo
  7. A

    Using the cell function within other functions

    Hello, I am new to the forum and using Excel for data analysis in general, thanks for the help in advance. I am working with some data and trying to find a slope in a linear region the data. I have been trying to use the SLOPE function and specifying a range in X and its accompanying Y data...
Back
Top