Excel VBA Stuff - Teh Forum

From:	Peter (BOUGHTONP)	14 Sep 2006 13:26
To:	Extrobe (ALDREDD)	2 of 9

30625.2 In reply to 30625.1
1) Why can't you do code: Rows(currentRow+1 & ":" & currentRow+1).Select ? `3.1415P265E589T932E846R64338`

0/0

Reply Quote

More

From:	Extrobe (ALDREDD)	14 Sep 2006 13:33
To:	Peter (BOUGHTONP)	3 of 9

30625.3 In reply to 30625.2

that does make sence :/

I've also managed to get it to only copy the cells which have a formula in it, and leave the other cells blank.

Just need to figure how to get the value of a prompt into the certain cell, but could be tricky, as the code now asks how many news rows a want to insert! :B

0/0

Reply Quote

More

From:	Extrobe (ALDREDD)	14 Sep 2006 13:36
To:	Peter (BOUGHTONP)	4 of 9

30625.4 In reply to 30625.2

do you know haw to make the worksheet not refresh (or prompt to refresh) external links on startup?

The sheet only needs refreshing once a week, and only by me, and dont want others being prompted to do so!

thanks

0/0

Reply Quote

More

From:	Peter (BOUGHTONP)	14 Sep 2006 13:39
To:	Extrobe (ALDREDD)	5 of 9

30625.5 In reply to 30625.4
I'm afraid I was just making a semi-educated guess - my knowledge of Excel VBA is miniscule. :( `3.1415P265E589T932E846R64338`

0/0

Reply Quote

More

From:	Extrobe (ALDREDD)	18 Sep 2006 16:55
To:	Mr (M00RL0CK)	8 of 9

30625.8 In reply to 30625.7
Another one for you, if I may? I've got a spreadsheet which pulls data from another workbook. What my boss wants is a few line below the report, to see an extract of the same report, but just 5 lines of it, being the top 5 results of a sort. I know that makes no sense at all, so I've attached an example of how it might look (I've pasted values on it). At the top is the main report - could be anywhere from 20 - 2000 lines - and mornally about 65 columns. this will always be sorted by Column L in this example. Below all of this are two extracts, one showing the highest cover lines, the other showing the lowest. This report is updated weekly, and the extract needs to reflect this. Can you think of any way of doing this? I've tried creating a Macro to do it, which mmics me copying into a new sheet, sorting & copying back, but this just doesn't give me the flexability I need. Is this even possable? Thanks!
Attachments: test.xls

0/0

Reply Quote

More