Search results for query: *

Hi, I have a situation where I have created a report with nested dimensions. This report is running very slow and sometimes returning an error. Does anyone have any ideas on what could be the cause for this slow running, as all the other reports run fine and within 1-3 minutes. I intially...

thanks for that, have put that into my code and the runtime error does not display now, however the macro runs through and does the rest. how can i stop it there and make it display the userform again. here is the code that makes the error message go away and displays my msgbox(test) and is...

Hi guys and gals, Am attempting to write a macro to create sheets automatically, have done the major bit and all works well but want to replace the runtime error 1004 'cannot rename sheet etc' when I accidently enter the same name of an existing sheet. I would like to replace it with my own...

thanks a bunch all who replied, got there in the end, saves me loads of time each week. Just want to say what a cool site, hopefully will be more technical in my questions next time. Thanks again.

wow, thanks guys it works like a treat, one more thing with one of the values I need to subtract one month after the formatting has occurred.

HI, thanks for the response, sorry but am new to this whole programming thing, here is the code i have Dim myvalue1 As String Dim myvalue2 As String Dim myvalue3 As String Dim myvalue5 As String Dim myvalue6 As String myvalue1 = UserForm1.textbox3.Text =...

Hi, At the moment I have a userform with several textboxes into which a date is inserted by clicking on a calendar. However I would like to only have to insert one date and then have code to format it several times so it can be used in the formula i have in the macro Any pointers? thanks in...