Search results for query: *

wicked that was really good help Thanks:)

hey i want my program in excel to do various things before the program starts up but for some reason it is not working . Can someone tell me what i need to to make this piece of coding work or why it doesnt work? 'Routine to start the application, set up screen defaults, set up 'custom menuus...

Im creating an Accounts program using Excel/VB, i was wondering whether it was possible to have two parts of your program that need 2 different passwords to access them, so that only certain people have access to certain parts of the system?

thanks alot that sorted it!

Any answers?

I keep on getting the error out of range. Can somone please tell me what needs to be changed in order to make this code work? Sub InsertBaldata3() Dim myRowCount As Integer Dim myRng As Range Set myRng = Sheets("insert balance data (2)").Range("1:1") myRowCount =...

Any ideas on the last thought of the thread?

Sweet that did the trick one final question though: what added code is needed to remove the value that you are transferring to another sheet, from the original sheet? Thanks for your help

yes acron thats great that works qutie well. two other questions though. im using the following code: Dim myRowCount As Integer Dim myRng As Range Set myRng = Sheets("insert balance data").Range("1:1") myRowCount = Application.CountA(myRng) With Sheets("company...

if i want to transfer 3 values from a sheet called ' insert balance sheet' to another sheet called 'company balance sheet, what needs to be changed in this coding as it says the Me function is invalid. Dim myRowCount As Integer Dim myRng As Range Set myRng = Sheets("insert balance...

Say if you have got a form where you enter data for the Following deatils: Name , Age and address, how can you transfer this data to another sheet using a macro in excel?What coding is needed? Thanks alot for your help

Say if you have got a form where you enter data for the Following deatils: Name , Age and address, how can you transfer this data to another sheet using a macro?What coding is needed?