# Search:

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

Page 1 of 6 1

1. ## Thread: Extract all values (from list) that lie within a range

by palaeontology
Replies
4
Views
169

### Re: Extract all values (from list) that lie within a range

Thankyou, so much, that worked brilliantly.

Now, all I need to do is dissect your formula to see why it works.

Again, thankyou, so much.

Kind regards,

Chris
2. ## Thread: Extract all values (from list) that lie within a range

by palaeontology
Replies
4
Views
169

### Extract all values (from list) that lie within a range

Is there a way to extract all numbers from a list that lie within a range ?

For example, I have a list of ascending numbers in the range B3:N3 and two numbers in P3 and R3 .. the number in P3 is...
3. ## Thread: first number (in a list) larger than a certain value

by palaeontology
Replies
6
Views
265

### Re: first number (in a list) larger than a certain value

Thankyou, so much, to both of you, they both worked brilliantly.

I've gone with Tetra's formula, but am happy to switch if my next query requires me to ...

I still have that list range in...
4. ## Thread: first number (in a list) larger than a certain value

by palaeontology
Replies
6
Views
265

### first number (in a list) larger than a certain value

I have a list in the range ... CM37:CW37

I have a value in ... BY37

I'd like to find the first number in the list range that is larger than the value in BY37.

eg: List Range in CM37:CW37...
5. ## Thread: convert row list to table

by palaeontology
Replies
2
Views
219

### convert row list to table

I have a list of values in the column range C32 to C800.

I have a formula I use to convert a the column list to a table just 10 columns wide starting in cell L32 ...
...
6. ## Thread: countif within range

by palaeontology
Replies
4
Views
212

### Re: countif within range

Thanks Michael,

i just suddenly realised i probably should be using countifs, not countif.

Very kind regards,

Chris
7. ## Thread: countif within range

by palaeontology
Replies
4
Views
212

### countif within range

I have a row of data in the range L5:BI5

In CA5 I have a number

In BX5 I have another number

I'd like to count how many values in the initial range L5:BI5 exist between the lower value found...
8. ## Thread: Excel Chart query

by palaeontology
Replies
2
Views
157

### Excel Chart query

I have a 'Line with Markers' chart plotting the data range ... 'View Individual Student Profile'!\$D\$56:\$E\$68

I've removed the line, so all I have is thick, black dot markers for each of the 13...
9. ## Thread: force PDF save to be at top of page ???

by palaeontology
Replies
0
Views
146

### force PDF save to be at top of page ???

I'm using the following code to save any worksheet (named with a 5-digit code) as a PDF in a given location ..

Dim wPath As String, r1 As String, r2 As String, r3 As String
wPath =...
10. ## Thread: Dim ws As Worksheet issue

by palaeontology
Replies
2
Views
184

### Re: Dim ws As Worksheet issue

Hi Alan,

I've just figured out my issue ... was a very simple fix.

Ta for looking into it.

Kind regards,

Chris
11. ## Thread: Dim ws As Worksheet issue

by palaeontology
Replies
2
Views
184

### Dim ws As Worksheet issue

I'm receiving an error message ... (Compile error: Duplicate declaration in current scope) ... when I run some code that has 13 components, but I believe it's the following two components that...
12. ## Thread: Save certain worksheets as PDFs in a fluid location

by palaeontology
Replies
3
Views
163

### Re: Save certain worksheets as PDFs in a fluid location

Strike that ... everything you wrote works perfectly. I was doing something wrong at my end.

Thankyou again so much for doing that.

It is very much appreciated.

Very kind regards,

Chris
13. ## Thread: Save certain worksheets as PDFs in a fluid location

by palaeontology
Replies
3
Views
163

### Save certain worksheets as PDFs in a fluid location

I currently use the following code to print all worksheets named with a 5-digit name (eg: 34716)

For Each ws In ThisWorkbook.Worksheets If ws.Name Like "#####" Then
...
14. ## Thread: code to save sheets as separate word files

by palaeontology
Replies
8
Views
205

### Re: code to save sheets as separate word files

I can no longer see my thread in the posts ... have you removed my thread from public view ?

Kind regards,

Chris
15. ## Thread: code to save sheets as separate word files

by palaeontology
Replies
8
Views
205

### Re: code to save sheets as separate word files

If you look back through my history, in both this username, and the one I used many years ago (closer to 2002) you will find that I...
16. ## Thread: code to save sheets as separate word files

by palaeontology
Replies
8
Views
205

### Re: code to save sheets as separate word files

Hi Macropod, as I mentioned, I've inherited this spreadsheet, and am unfamiliar with vba coding.

Kind regards,

Chris
17. ## Thread: code to save sheets as separate word files

by palaeontology
Replies
8
Views
205

### Re: code to save sheets as separate word files

if it's simple to go to PDF, can we code it that way please ?

I appreciate any assistance at all,

very kind regards,

Chris
18. ## Thread: code to save sheets as separate word files

by palaeontology
Replies
8
Views
205

### code to save sheets as separate word files

I have inherited a spreadsheet which has a number of userforms that have some reasonable coding in behind them.

One userform allows the user to click on which teacher they are, and the userform...
19. ## Thread: first 6 unique numbers in row

by palaeontology
Replies
2
Views
150

### Re: first 6 unique numbers in row

of course, embarrassed i missed it.

Thankyou for solving that,

Kind regards,

Chris
20. ## Thread: first 6 unique numbers in row

by palaeontology
Replies
2
Views
150

### first 6 unique numbers in row

Hi,

I have the following numbers in range AS133:BD133 ...
<tbody>
10
23
2
2
23
97
21. ## Thread: vba to screen-shot a given range on every worksheet in file

by palaeontology
Replies
18
Views
1,138

### Re: vba to screen-shot a given range on every worksheet in file

Hi again Kenneth, I ran your #6 post and it works brilliantly, I am so thankful to you.

However, since writing my initial post, I've increased the size of what I need imaged from the range...
22. ## Thread: vba to screen-shot a given range on every worksheet in file

by palaeontology
Replies
18
Views
1,138

### Re: vba to screen-shot a given range on every worksheet in file

Thanks Kenneth, I'll definitely try them out.

Thankyou, so much, again, for all your work.

Very kind regards,

Chris
23. ## Thread: vba to screen-shot a given range on every worksheet in file

by palaeontology
Replies
18
Views
1,138

### Re: vba to screen-shot a given range on every worksheet in file

Thankyou all for your contribution to this ... I have to say I didn't understand a single word of any of it.

I'll have my IT guys at work run their eyes over what you've all said, but I suspect...
24. ## Thread: vba to screen-shot a given range on every worksheet in file

by palaeontology
Replies
18
Views
1,138

### vba to screen-shot a given range on every worksheet in file

Is it possible to have code that takes a screen-shot of all sheets named with a 5-digit student ID number (eg: 69213) and save that image as a jpeg (named with the same 5-digit code as the sheet the...
25. ## Thread: create new sheets based on list of student ID numbers

by palaeontology
Replies
13
Views
713

### Re: create new sheets based on list of student ID numbers

that worked perfectly ... thankyou to everyone who helped me,

kind regards,

Chris
Results 1 to 25 of 150
Page 1 of 6 1