Search results for query: *

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]

The ultimate aim of this exercise is to manipulate the Daily data that comes in, as in the table in the above post to chrurn out data tables with the fields DAte, Open High ,Low ,Close for not just the weekly time frame but also for the monthly and yearly time frames. Another priority is to...

Hi, Firstly, I would just like to thank both Dirk and MunkyGod for their efforts,I really appreciate it. Yes, I am using Excel and unfortunately my knowledge is limited. The Daily data table below is actual data for the Ftse 100. The more I think about this the more complex it becomes...

Hi, Below I have a table showing various prices reached during the trading day of the Ftse 100 share index.A new row will be added to the DAILY table at 10pm after the end of each days trading and not before. I would like to convert the daily data into a weekly time frame, showing the same...

Hi, I have data for the Dow Jones Stock Index, a sample of which is below and my data goes back over 20 years in total. In column A, I have the high price achieved each month. What I would like to do would be to calculate the high price achieved for each completed year. So the last completed...

Hi I am importing Financial Market data into Excel,this seems to work ok,i would like the updates to take place at a specific time of day. I have looked at the External Data Range Properties box(refresh control)this allows three options,none of which are what i really need. I would like to...