Search results

Bilbo I didn't explain myself very well so I have attached a file that I am hoping will explain things better. Having said that your response has shown me other ways to consider. From the attacment you will probably notice that my enquiry has grown. Its a bit of a project that I am trying to...

I have "Sheet1" that contains a range "W14" I have "Sheet2" that contains a range "A:A". Within Range "A:A" is sequential numbering with the last one being the most up to date and always being added to. I need "Sheet1" Range "W14" to be populated with the with the last entry at the bottom of...

Out of interest. Why is it considered bad practice to select cells before doing anything with them in VBA. Is it a pure selection issue as Chergh's response does not state select or does it? From experience I know the answer is going to be very obvious but if I don't ask, I'll never know...

Thank you Some answers can make you feel a right plum. Regards, Matt

I have the following formula that was created using the auto sum, so I don't understand why I am receiving an error message. Cell (B2) contains a postive value Range (B3:B7) contains positive values Cell (B8) needs to subtract the value of Range (B3:B7) from Cell (B2) The auto sum helps...

That was it. Unsure how that was changed but at least its fixed now. Thank you.

I have been using the same worksheet for months. All of a sudden the values of formulas do not update when an associated range value is changed. I can F2 the cell and the cell value changes accordingly but there are a lot of formulas. Can anyone tell me:- 01 - Why this may have happened (to...

Your a clever bunch. Thank you guys. Regards, Matt

Guys I have just checked and the first string is not always the same length. Can you please tell me how to use the first space as in the:- Data=>Text to columns=>Fixed width etc. mentioned. Thanks, Matt

I have a range of cells (A1:A77) that each contain a value such as:- N002 Lift Lobby N003 Corridor N006 Shower etc etc What I would like Is to extract this information from each cell to the adjacent cells so that Range B1:B77 contains N002 N003 N006 etc etc Range C1:C77 conatins Lift Lobby...

Thank you. Couldn't have been much simpler could it. I was trying too hard making it more complicated than it really was. Thank you.

UserForm1 contains 3 x TextBox. TextBox1 the user inputs a number TextBox2 the user inputs a number The User then clicks a ComandButton What I would like when the ComandButton is clicked is the result of this simple calculation to appear in TextBox3. TextBox2/TextBox1 Can this be done...

It is. Thank you

I have a ComandButton1 on Sheet6. How can I still keep it visible when in use but when Sheet6 is printed and or saved as, ComandButton1 does not print, and/or saved as. The user may save the workbook as another filename (Save As) or print the worksheet at anytime. I would only like...

Thank you. So that I can learn something other than just parroting the wisdom that other provide in this forum. I sort of understand the:- Private Sub Workbook_SheetSelectionChange... (I understand that this proceddure will run when something changes within the worksheet) is this correct...

Thank you I will give that a try. Regards, Matt

I have a Macro that starts when Ctrl+Shift+C is pressed. I would also like this macro to start when the user clicks Range("S18") on ("Sheet1") Can you please advise me. Regards, Matt

I have a UserForm1 with a MultiPage1 containing Page1, Page2, Page3, Page4, Page5, Page6. Pages 3 - 6 (inc) Enabled = False. When UserForm1.OptionButton10.Value = True I need Page3 from the MultiPage Enabled = True. What I cannot seem to do is reference the Page3. I have got this far but...

Has anyone got a workbook that if you give the following information. Loan amount Interest rate Duration of loan Monthly payment and whatever else would be needed. That a table would be produced that would produce the following information on a month-by-month basis. Total Amount Oustanding...

I would be grateful if someone could explain what Debug.Print ............. is used for and where. I can see it in code but cannot work out what it is used for. Regards, Matt