Search results for query: *

sorry, think you may have to put the focus on the worksheet first, try: Application.ScreenUpdating = False UserForm1.Hide Worksheets("Sheet1").Activate Worksheets("Sheet1").PrintOut UserForm1.Show Application.ScreenUpdating = True works ok for me, let me know how you go Adrian

worksheets("Sheet1").Printout, as you get to the fullstop VB will give you the options you can use with the "Object". Adrian

Hi again, still think you can do this without VBA but if you do then maybe "SELECT CASE" is the route you should be going down and use "TARGET" to activate this. All seems a bit complicated when it can (probably) be done within worksheet functions. It would be possible to...

Hi Westma, I have recently had to do something similar for work, having several departments, and plotting each ones' work processed over a period of time.Using data validation, you choose a department and their work processed is plotted. I used the If(And) formula, ie: A B C...

Hi Bishman, Tony is bang on as usual,but unless it is absolutely required to use code, have a look at DBase formulas such as sumproduct, I was pointed in that direction on an earlier thread and they work a treat....

Hi Everyone, I have several UDFs, and would like to be able to add help to them as you get with usual Excel functions, anybody got any ideas??? Cheers Adrian

thanks Tony, thought it may be a big ask, if u guys can't do it, nobody can....thanks for taking the time on it though.. Adrian

I don't know if this is even possible but there might be a work round. Does anyone know if it is possible to change the row and column headers in Excel, for instance col A would read "bookings" instead of 'A'...... cheers Adrian

Spot on XLBO, star for that one, waynerenauld could also just add the counts though couldn't he?(although I much prefer your UDF) COUNTIF(Sheet1!D:D,A1)+COUNTIF(Sheet2!D:D,A1)+COUNTIF(Sheet3!D:D,A1)etc...

Many thanks (once again) XLBO (and you other guys)thanks for pointing me in the right direction

Many thanks Calculas, you have confirmed what I thought, but any ideas on "shrinking" Excel a little in case I can't get my point across... I have tended to remove some of the formula I have (and pasting values) which seems to do the trick, but each file has a kind of summary sheet...

Hi PCFred, I have a spreadsheet with over 300 hyperlinks, and have never come across anything like this. Do you have any more info that may shed a bit more light on this..ie is there any other code running in this/these workbooks (are you hyperlinking to other workbooks?) and are you using...

Hello people, I have a question, which is not strictly a VBA question, but I figure one of you will be able to answer. I have a very large excel file, which deals with deliveries to my employers and exceeds 12000 rows (by about 15 columns). As I have to interrogate this information to review...

Thanks for your reply Calculas 97 has a preset minimum of 5 mins, what you are saying sounds interesting, but as a reletive newbie, could you give me a few lines of code or something? Many thanks again Adrian (Shaggi)

I have set up a series of shared workbooks for more than one person to input details into at the same time. However to try to cut down conflicts etc, I would like them to update pretty much as soon as data is input. I am using Excel 97, but cannot find a way in excel or VB to get the update time...

xlbo, you are absolutely right, but what is all this man yoo stuff, r u from up here (manc)???

hi, there is also: application.username

Hi, don't know if you have already been answered but here goes.....say you have the following table: a b c 1 novels bob 2 2 romance jenny 5 3 romance jenny 2 4 sci fi frank 1 if you need the quantity of romance...

Hi Vbasha try recording a macro of yourself protecting worksheets, then print out the resulting code, I think this may help, as I often record macros to find the code behind them........ cheers Shaggi

Hi Jim, in Excel you can make pretty much any key do what you want with: Application.OnKey "{insert key here(i.e ESC)}","insert module name here", but as I am not a big user of Word I am not sure if the same applies.It is important to switch the key back to its' normal usage...