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...
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!
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
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.