Programming
in [Excel]
|
extracting data from one workbook to another Hi, I tried this macro (below), but didn't work...Not sure what happened. Please let me clarify my need... I have Sheet1 open in WorkBook1 with data in the range A1:G200 I need a macro to select & copy the last 73 rows of data,in this case A128:G200 and paste it on Sheet1 of WorkbookB starting at B10. Note thi... 8 May 2010 14:31
Geometric progression in VBA Hello, I am looking use the PRODUCT function in an efficient way by working with range rather than cells (because the number of cells changes often). The code below is repetitive, do you see better way to perform this calculation? In our case, i goes from 1 to 256. Sub test() i = Sheets("Input").Range("... 11 May 2010 11:11
Workbook Macro Hi, How can I write this code to place in the workbook of the file, the macro changes the sheet tab name as per the individual sheet cell A1 which is changed from the first sheet Index of Stock, I am looking to do this so it changes instantly when the name is changed and do not need to calculate each sheet, ... 7 May 2010 18:58
Private Sub Workbook Hi, I was wondering how I can place the following macro into the workbook rather than having to inpu this code into over 100 individual sheets, the code changes the sheet tab name to that of cell A1 per every sheet, these are changed from the first sheet called Index of Stock, so when the name is changed in ... 7 May 2010 13:24
How to run a macro if I don't know the name in advance I am trying to create a macro on the fly using vb code from an existing file, and then run the Macro that was just created. Is there a way to find out the name of a Macro programmatically so that I can pass it to the Application.Run method? ... 7 May 2010 14:32
Adding a decimal place I have some sheets with various number formats, I want to be able to increase (and sometimes decrease) all of them by one or two decimal places. So... "0.0%" will become "0.00%" "#,##0_);[Red](#,##0)" will become "#,##0.0_);[Red](#,##0.0)" "�#,##0" will become "�#,##0.0" etc... Can I do this? Is there a... 8 May 2010 10:07
Speciefie table and not cells to sum Hi, I'm trying to make a summary in a specified tabell without have to specifie what start and end cell. So far I have done like this SUMMA.OMF(Januari!$C$4:$C$92;Januari!$A$4:$A$92;"=x") but I want something like this Summa.omf(Januari[#Allt] etc.... so that I can specifie column and tablename. ... 10 May 2010 03:22
Dynamically Create and ID OptionButtons, then insert Row; Loop This is a bit complex, so let me take a moment to explain. I'm trying to open a 'template' and connect the code to a button so a user can click it and put a '1' in cell Z16, then put an OptionButton in A16 and another OptionButton in B16, then assign an identifier to these OptionButtons (a name or a value to i... 7 May 2010 16:45
Array to copy columns Hi, I would like to copy from Sheet1 Columns B ,A, C in that order to Sheet 2 Columns A , B, C can this be done by array i.e myarray(B,A,C) Thanks in advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-programming/201005/1 ... 7 May 2010 12:16
ANSWERED Sorry! worked it out formyself! SaveAsUI! "Michelle" <mh_londonNOJUNK(a)hotmail.com> wrote in message news:C892CE59-1BCA-467F-A461-A1C318262DD6(a)microsoft.com... I want to be able to respond differently when the user has clicked 'Save As' - is there something that allows me to test what the user has done to ... 7 May 2010 06:44 |