# Search:

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

Page 1 of 2 1

1. ## Thread: Locate chart below last row of data

by arjay13
Replies
2
Views
495

### 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. ## Thread: Locate chart below last row of data

by arjay13
Replies
2
Views
495

### Locate chart below last row of data

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

3. ## Thread: Parsing trendline equation

by arjay13
Replies
8
Views
2,091

### 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

by arjay13
Replies
8
Views
2,091

Retiredgeek
Arjay
5. ## Thread: Parsing trendline equation

by arjay13
Replies
8
Views
2,091

### 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. ## Thread: Parsing trendline equation

by arjay13
Replies
8
Views
2,091

### 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. ## Thread: Trying to calculate polynomial trendline coefficients

by arjay13
Replies
6
Views
3,548

### 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. ## Thread: Trying to calculate polynomial trendline coefficients

by arjay13
Replies
6
Views
3,548

### 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. ## Thread: Trying to calculate polynomial trendline coefficients

by arjay13
Replies
6
Views
3,548

### 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. ## Thread: Just want to insert a column after "Area" cell

by arjay13
Replies
6
Views
2,925

### 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. ## Thread: Just want to insert a column after "Area" cell

by arjay13
Replies
6
Views
2,925

### 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. ## Thread: Just want to insert a column after "Area" cell

by arjay13
Replies
6
Views
2,925

### 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. ## Thread: Problem with responding to "Save As" dialog box

by arjay13
Replies
9
Views
2,877

### 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. ## Thread: Problem with responding to "Save As" dialog box

by arjay13
Replies
9
Views
2,877

### 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. ## Thread: Problem with responding to "Save As" dialog box

by arjay13
Replies
9
Views
2,877

### 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. ## Thread: Problem with responding to "Save As" dialog box

by arjay13
Replies
9
Views
2,877

### Sorry - I get: Run-time error '1004': Method...

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

by arjay13
Replies
9
Views
2,877

### 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. ## Thread: Copy certain rows of data to new spreadsheet problem

by arjay13
Replies
4
Views
1,787

### 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. ## Thread: Copy certain rows of data to new spreadsheet problem

by arjay13
Replies
4
Views
1,787

### 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. ## Thread: Copy certain rows of data to new spreadsheet problem

by arjay13
Replies
4
Views
1,787

### 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. ## Thread: deleting rows using excel macro - repost

by arjay13
Replies
4
Views
7,200

### 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. ## Thread: deleting rows using excel macro - repost

by arjay13
Replies
4
Views
7,200

### 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. ## Thread: deleting rows using excel macro - repost

by arjay13
Replies
4
Views
7,200

### 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. ## Thread: deleting rows using excel macro

by arjay13
Replies
1
Views
1,385

### 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. ## Thread: Need tutorial for Visual Basic for Excel

by arjay13
Replies
6
Views
3,926

### Excellent! Thanks guys!

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