Search results for query: *

thanks for all your help ppl

Spot on Skip, thanks.......

Thanks for that, I have already named a cell group refence, this cell contains a variable string which I want to pick up and drop in cell A600. I could do copy/paste but I would like to use this method. any ideas?

Hello, I want to pick up a peace of text from a named range "Group_Reference", then drop it in another cell. Instead the below code is reporting Group_Reference as text instead of the text entered in Group_Reference, any ideas. Sub group_Reference() Dim group_Reference As Range...

Hello, What I'm trying to do is when a workbook is opened a check will be performed and if it fails the workbook will close without saving. It's the closing without saving I'm struggling with...? Thanks

Hi, I have a small issue I want a spreadsheet to clear certain ranges when a button in pressed - how ever the sheet that needs clearing is password locked and when you run the macro it asks for the password. I dont want the password box to open, is there a way around this apart from the obvioud...

Cheers Ken, 1st class............

OK here is some code I came up with, but why am I getting a message box whatever "Input_Check_1" is....ggrrrr Sub IS1_Next() Rem Swithces pages after checking input Application.ScreenUpdating = False If Input_Check_1 < 10 Then MsgBox ("Please check your selection!") Else...

Hello all, here's the problem: I have a named cell "Input_Check_1" and I want to run a Macro from a click event to check that the named cell is equal or greater than 10. If it is 9 or lees i want a messange box to pop up.... If it is 10 or greater I have the code already to pop in the IF...

Hi, Does anyone know what the legal licence situation is if you sell a product made in Excel/VBA, obviously I have a registered copy and so will the clients I sell my products to... thanks!

Thats very cool, how about disbaleing the scroll function on a mouse wheel?

Yes it is, put the following in C3 =if(a1=b1,"Matched","Unmatched") then copy down, it will give you one column (C) with the words macthed or unmatched acording to the A and B values. Hope this helps

There are many ways you could deal with this, I would be tempted to use an IF statement, if the layout we as below: a b c 1 1000 1000 Matched 2 2000 3000 Unmatched 3 Place the the cell you want...

Hi all, 1.I have a slight problem, is it possible to fix the size of the excel file windows when opened, this is so i can design a standard form and make sure it fits on the page regardless of screen res. 2.can i hid the scroll bars & function? thanks

as east as that, thanks peep's - was just about to go for a fag in frustration!

Hello, Perhaps you can help me 1.I want a form to appear when the spreadsheet is opened. on this form is a box to enter data and a button. 2.Whats the coded needed to copy the text entered in to cell a1 of sheet1 when the button is hit, i know it goes under the click event on the button but i...

OK, Anyone know the bit of code I need to hide a Tab/unhide a tab...??? cheers

Hello, anyone know how once a marco is activated you can hide the activity, I dont want to the marco jumping around across tabs and flashing, is there some code to just allow the marco without all the flashing etc... cheers

I have written some scrpits within Excel that I dont want anyone to be able to see or access, how can i do this?? cheers