Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: juslearning
- Content: Threads
- Order by date
-
Slow PPR Report
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...- juslearning
- Thread
- Replies: 0
- Forum: Cognos solutions
-
Runtime error 1004 replace with msgbox
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...- juslearning
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Date formatting
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...- juslearning
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
