-
Hi again This has been working well. However I have been asked to slightly change the columns that come into the spreadsheet. I thought this would be straight forward as I can just adjust this part -- here I have made changes to a couple This is the one i have changed -- all works EXCEPT the last column...
-
It may be better to post the code you have now and we can add somthing to open and paste into another worksheet in another book. Irrespective, I would have a couple of questions Do you want the 'other' workbook to be dynamic or is it the same location and name each time or is it a new workbook...
-
Hi All, I've been using VBA to play with text in a cell. Basically I needed to change individual characters to be uppercase, lowercase, subscripted etc. I think I have that sorted now but whilst playing around I tried using the StrConv vbUpperCase, vbLowerCase & vbProperCase functions, which...
-
Hi Nick I have recorded 2 macros. I am very very new at Macros and VBA and would appreciate help in working out how to make it prompt for File 1.Imports text file and gets rid of unnecessary columns Sub importtextfile() ' ' importtextfile Macro ' Macro recorded 10/06/2010 by Catherine '...
-
Is there anyway I can automate my sheet so it will print in PDF format and either save to my Shareware site or print to a drive and email to my Shareware site? I have tried recording a macro to see if I could find some code but no luck and I cannot find anything in the literature I have.
-
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...