Recent content by ADE6

Hi, I have the following code,created using the Excel macro recorder. Is it possible to change the parts that refer to "HELP" so that it refers to cell H25, so that when I change the text within cell H25 and run the macro again it will create a new Hyperlink,called whatever text is displayed...

Hi, I have a macro called "TRIAL" shown at the bottom of this post, the macro executes the section of code shown below THREE times when running(SHOWN IN RED) Dim strSheet As String strSheet = Sheets("CONTROL PANEL"). Range("A1").Value Sheets(strSheet).Select 'Sheets("BRENT CRUDE").Select...

I seem to have sorted it out. By removing "SolverSolve" it seems to work

Hi, Does anybody know how to stop the Solver Results Dialog Box appearing ? I want to accept the solver results and carry on with the rest of my macro. Really appreciate the help Ade Sub METASTOCKSOLVER() Sheets("CALC").Select SolverOk SetCell:="$F$21", MaxMinVal:=1...

Thanks PH, I really appreciate your help. That seems to do exactly what I want. Ade

Hi PHV, I have highlighted in red the three times during my macro that I need the code to refer to whatever sheet name appears in cell C2 of the worksheet named LIST. Thanks for the ideas Ade Sub METASTOCK2() Sheets("BRENT CRUDE").Select Range("AZ3:BA660").Select Selection.Copy...

Hi, I have a Data Validation list in cell A1 of a worksheet called LIST. I would like to modify the macro that I have recorded, the macro uses data from various worksheets. I would like to sort out some code so that at certain points in the macro it will select the worksheet that is shown in...

Hi, I have a workbook that contains a worksheet called CALC , in column A of this worksheet I have a list of other worksheets that I would like to run a macro on. Would it be possible to set up some code that would select the worksheet at the top of the list, perform a macro then select the...

Hi , I am aware of the Application On Time method of running a macro at a set time of day. Excel receives realtime data around the clock from another program via DDE links,about 10 seconds after every half hour I would like to run my macro. Example times: ("21:30:10") ("22:00:10")...

Hi , I am aware of the Application On Time method of running a macro at a set time of day. Excel receives realtime data around the clock from another program via DDE links,about 10 seconds after every half hour I would like to run my macro. Example times: ("21:30:10") ("22:00:10")...

Hi , I am aware of the Application On Time method of running a macro at a set time of day. Excel receives realtime data around the clock from another program via DDE links,about 10 seconds after every half hour I would like to run my macro. Example times: ("21:30:10") ("22:00:10")...

Thanks for the help Ken Ade

Hi, I have imported realtime currency prices into a spreadsheet using DDE links, if I have 5 rows showing the last 5 days prices the data is displayed with the most recent days record at the bottom of the table however I would like the most recent records to be displayed at the top. ACTUAL...

Hi, I am new to Pivot Tables so I would really appreciate any ideas. Below I have some data showing closing levels of The Ftse 100 share index, only trading days are shown in then left hand column. I want to sort my data by time periods such as weeks,months,years etc, which I have managed...

Dirk's solution appears to have done the trick, thank you. All I need to do now is modify it to produce the same data tables for monthly and yearly time frames.[thumbsup2]