-
Hi all, firstly I am wanting to plot a non linear XY data set (essentially 2 sets of nearly linear data with different slopes). then I would like to start working from the end pair of XY point with a linear trendline adding a pair to the trendlne fit at a time, examining the r value (correlation coefficient...
-
Hi all With the data below :- how can I sum the last 10 cells in the row from 2-11 (row 1=32) and (row 2=25) Data is added to columns 12 to ? at a later time. Derek 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 1 5 0 1 4 1 7 2 4 7 3 5 2 2 2 2 3 2 3 2 2
-
Is it possible to use a formula or VBA to automatically change the name of a tab when I copy from another tab (I'm thinking of it referencing a cell in the sheet - eg. =month(a4) ?
-
I work on a excel workbook that has 31 worksheet for the days of the month. I need the combo boxex I created to calculate across work sheets So if day 1 it add up cells in there specific range and specific columns. That works fine. Its when I need day 2 to look at the cell that day 1 has populated and...
-
I use Excel 2003, but some of my workbooks are used by colleagues using Excel2007. One of my workbooks populates cells with photos. I start with a suitably sized grid, select a cell, insert the picture and resize it and adjust its position. The code that does this is as follows: Sub InsertPic(row, col...
-
I am trying develop an excel spread sheet that calculate across spreed sheets and cells. I Code: Private Sub Tradebox_GotFocus() Tradebox.AddItem "AW" Tradebox.AddItem "BM" Tradebox.AddItem "AM" Tradebox.AddItem "CF" Tradebox.AddItem "E" Tradebox.AddItem...
-
Global Const commonPath = "H:\Market Data\Curve Data\" Global Const commonPath1 = "H:\Market Data\FX Data\" 'Global Const bookName = "MasterCurve" Public dTime As Double Sub startSave() dTime = Now + TimeValue("00:00:30") Application.OnTime EarliestTime:=dTime...
-
Helen Seldom any need to select and activate stuff. (You could have used activesheet.paste), so you code can copy the active cell and 6 columns to the right and then paste to the Patients sheet by just using the 'Destination' parameter in the copy method, thus Sub copydata240709() ActiveSheet...
-
hmdm2009, A little Googling and you're there. The code below is modified from http://peltiertech.com/Excel/XL_PPT.html#chartwd Make sure you add a reference to the appropriate Microsoft Word Object Library before you try to run the code. Sub ExcelCopyWordPaste() Application.ThisWorkbook.Activate...
-
Omar, You can do it using the following code (adapted from Gizmo's original reply): Private Sub Worksheet_Change( ByVal Target As Range) Dim intRows As Integer If Target.Column = 11 Then 'Error check only fires if Column 11 (K) is edited, else exit sub For intRows = 1 To 47 'Error check only...