Search:

Type: Posts; User: arjay13; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    392

    RetiredGeek Thanks for the code. It took me...

    RetiredGeek
    Thanks for the code. It took me awhile to determine the best way to implement it in my macro. Once done, it works like a charm. The main problem was that I had to abandon using cell...
  2. Replies
    2
    Views
    392

    Locate chart below last row of data

    Hi
    I have a macro that creats a chart at a specific location on my spreadsheet.

    ActiveSheet.Shapes.AddChart(xlXYScatter, Left:=Range("C52").Left, Top:=Range("c52").Top,...
  3. Replies
    8
    Views
    1,533

    Steve Yes, I usually use linest for the bulk of...

    Steve
    Yes, I usually use linest for the bulk of my work but I occasionally find it more convenient to just grab the regression equation from the chart for a quick check.
    Arjay
  4. Replies
    8
    Views
    1,533

    Retiredgeek Thanks for the additional...

    Retiredgeek
    Thanks for the additional suggestion. A nice elegant addition.
    Arjay
  5. Replies
    8
    Views
    1,533

    Sdckapr Many thanks for the prompt reply as...

    Sdckapr
    Many thanks for the prompt reply as well as the tidy code. It works better and cleaner than what I had ginned up. I discovered that if I copy the entire trendline equation including the "="...
  6. Replies
    8
    Views
    1,533

    Parsing trendline equation

    Hi
    I have written a macro to parse a trendline equation (peak area vs concentration) so I can use it to calculate chemical concentrations from area data. What I have written does the job for a...
  7. I ended up having to Dim the variables as...

    I ended up having to Dim the variables as variant. i also forced the trendline through the origin. It works quite nicely. Thank you so much!
    Sub chart()
    '
    Dim cubiccoeff As Variant
    Dim...
  8. sdckapr Interesting approach. As a newbie, I am...

    sdckapr
    Interesting approach. As a newbie, I am still somewhat less than fluent in VBA. I understand what you did with the named ranges. It also occured to me as I was driving home that I may have...
  9. Trying to calculate polynomial trendline coefficients

    Hi
    I am trying to use a formula to calculate the coefficients from a third order polynomial regression. I am using a formula published by John Wlkanbach which I have seen several places on the...
  10. Wow! I knew it was something goofy but had no...

    Wow! I knew it was something goofy but had no clue as to what the issue was. I see that there is a listing of "Thanks". How about Thank you, Thank you, Thank you! Three times in one post. I started...
  11. 28100 RG Interestingly, when I started with a...

    28100
    RG
    Interestingly, when I started with a new spreadsheet and manually entered the headers, the macro worked like a charm. However, it doesnt work on my data files for no discernible reason to...
  12. Just want to insert a column after "Area" cell

    Hi All
    I have a spreadsheet with a header row that goes - "time, Area, time, Area" etc. All I want to do is insert a column to the right of each cell that contains "Area". My code sucessfully cycles...
  13. Thanks sdckapr! That works perfectly. I am new to...

    Thanks sdckapr! That works perfectly. I am new to VBA and don't have an extensive knowledge of the syntax yet. I never would have come up with that solution. I will study it so I can get a little bit...
  14. I'd like the macro to continue as if nothing...

    I'd like the macro to continue as if nothing happened. In other words, if I click on "no" or "cancel" I don't want the code to do anything- just proceed as if nothing happened.
  15. This is a portion of my macro. The runtime error...

    This is a portion of my macro. The runtime error is generated on the last line when there is an existing file with the same name I am using to save the current workbook.

    Private Sub Ok_Click()
    ...
  16. Sorry - I get: Run-time error '1004': Method...

    Sorry - I get:
    Run-time error '1004':
    Method 'Save as' of 'object_workbook' failed
  17. Problem with responding to "Save As" dialog box

    Hi
    In VBA, I am saving a CSV file as an xls file before I process the data in it. After processing, I re-save the file to capture the changes. Now I get the "Save As" dialog box asking me if I want...
  18. geof The only reason stopping me is I am...

    geof
    The only reason stopping me is I am learning a new programming language - so i start with simple steps. In this case, S and s would signify the same thing to me, so they actually sould be in...
  19. sdckapr as a newbie to VBA programming, I did...

    sdckapr
    as a newbie to VBA programming, I did not fully appreciate all the nuances of the code. I just started reading books last week. Thank you!
  20. Copy certain rows of data to new spreadsheet problem

    I have a spreadsheet with rows of data where I want to copy only the rows where the sample name begins with S or s. The following code does this but copies each "S" or "s" row on top of the...
  21. Replies
    4
    Views
    6,232

    Ah Yes. In the back of my tiny mind, I was...

    Ah Yes. In the back of my tiny mind, I was thinking about an Else...nicely done
  22. Replies
    4
    Views
    6,232

    Thanks for the help

    Sub DeleteRows()
    Jim
    Thanks so much for the help. The code you sent works fine as long as there are not consecutive "Blank" rows. In that case it deletes the first row and skips the second row. I...
  23. Replies
    4
    Views
    6,232

    deleting rows using excel macro - repost

    Hi
    I have a set of data, where I want to scroll through the rows, and delete the ones that have the word "BlanK" in column C. I would also like to stop when a cell in column C is empty.The data are...
  24. Replies
    1
    Views
    1,255

    deleting rows using excel macro

    Hi
    I have a set of data, where I want to scroll through the rows, and delete the ones that have the word "BlanK" in column C. I would also like to stop when a cell in column C is empty.The data are...
  25. Replies
    6
    Views
    3,557

    Excellent! Thanks guys!

    Excellent! Thanks guys!
Results 1 to 25 of 27
Page 1 of 2 1 2