Programming
in [Excel]
|
Selecting a cell according to the cell value Hello All VB expert Need help with a Macro. I would like to be able to select a cell according to a variable in a cell. For example: Cell A1 “31/04/2010”. Cell A3 = 31/05/2010 Cell A4 = 30/06/2010 Cell A5 = 31/07/2010 Cell A6 = 31/04/2010 In this case when I run the Marco, it will select Cell A6 becau... 28 Apr 2010 02:52
NetDDE Hi Does anybody know how to transfer data from an Excel sheet on one PC to an other Excel sheet on an other PC? May be via NetDDE or any other way. Regards reklamo ... 28 Apr 2010 14:02
HOW: Click Formula Hyperlink To Trigger Macro I have a column (Column 6) where every row contains an IF() formula that results in a HYPERLINK() formula if the previous cells in that row each contain data. In other words, a hyperlink shows up if the row is filled out. If the hyperlink shows up, and the user clicks it, I want a macro to be triggered. I want t... 28 Apr 2010 08:22
moved macros to new book now they don't work This is my third attempt to post this problem. My apologies for any duplication. I moved some macros to a new workbook (Excel 2003), so they could be shared amongst multiple workbooks. In order to run the code in the new location, I changed the worksheet_activate sub in the originating sheet as follows: fro... 28 Apr 2010 03:58
modify formula sorry of the double post. last was a finger glitch. if one had a formula in AB151 and the formula was =BD355, how would you add 3 to the cell reference in the formula and place formula =BC358 in range AB152 regards FSt1 ... 27 Apr 2010 20:14
Autofit If I'm in an Excel spreadsheet I can click the button between column label A and row label 1 to select the entire worksheet. Then I can double click in between any column and all the columns will autofit to the best fit. How can achieve this affect using VBA code? ... 27 Apr 2010 20:14
Calling one UDF from another in a different module Do I need to do anything special to be able to call one UDF from another UDF in a different add-in module? For some reason, I keep getting "Compile Error: Sub or Function not defined". I have them declared as Public: Public Function MyUDF(p1,p2,...) ... 28 Apr 2010 14:02
How to find all UDF calls in all workbooks I've decided to make a few "improvements" to some of the UDFs in my personal add-in module. Now I need to find all of the calls to those UDFs in all of my workbooks, because the syntax has changed some. Is there an easy way to find them other than opening each one? ... 29 Apr 2010 13:33
declaration help please a third party added some code to one of my apps and didn't dim anything. i'm not sure how to dim these variables. can someone help? a couple examples in the code: DDEChannel = Application.DDEInitiate(app:="RSLinx", topic:="T09113") DDEItem = "Xfer_Sched_New" 'Tag in CompactLogix DDEChannel = App... 27 Apr 2010 23:33 |