Programming
in [Excel]
|
Unlink chart from sheet How can I replace ranges in a chart's SERIES formula with their current values? I know how to do this in Excel, but how would I do this in VBA? Thanks ... 20 May 2010 12:48
Calling Excel shortcuts from VBA Hi, I am trying to automate the following two excel shortcuts using VBA. I know I can use commandbar and commandcontrol to call excel menus but I can not find the submenus these shortcuts belong to. 1. Ctrl + [ -- cursor goes to the precedent cell 2. F5 + Enter -- cur... 20 May 2010 09:28
Calling Excel shortcuts from VBA Hi, I am trying to automate the following two excel shortcuts using VBA. I know I can use commandbar and commandcontrol to call excel menus but I can not find the submenus these shortcuts belong to. 1. Ctrl + [ -- cursor goes to the precedent cell 2. F5 + Enter -- cursor goes to the original cell A... 20 May 2010 15:01
Autocomplete Custom Functions and functions arguments Hi, I have custom functions in VBA. I want Excel to show the Autocomplete options as the Microsoft Office Excel displays below the cell a dynamic drop-down list of valid functions, names, and text strings that match the letters or trigger. Also, I want to make the arguments be shown automatically For example, to ... 20 May 2010 21:36
Export Several Worksheet Groups (Values Only) Macro Hi All, I need some help please... I have a workbook (which due to many pivots and formulae is massive), I need a macro to export groups of sheets to new workbooks (each time it is run) then return to the workbook and export another group for example: I need Belgium & Netherlands to be exported (values onl... 20 May 2010 11:40
Cell colour format according to date If a cell value is equal to today I want the colour to change to red. I have entered =TODAY as a conditional formatting value but the cell colour does not change. The cell has been formatted as ddd dd mmm. Any ideas please. Thanks in advance for any help John ... 20 May 2010 05:09
Application.Visible=False Just toying with some ideas... 1) Any way to recover the application after the above command and then crashing? 2) Anyone got error handling code to show the application and also preserve the 'original' error message and ability to go to the offending line of code with 'Debug'? ... 20 May 2010 09:28
retrieve data into a spreadsheet from a copy of that spreadsheetw Hi Ryan, if I had formulas in my spreadsheet to retrieve data from a certain spreadsheet (which is not open), like this: =[7488.xls]Prod.ticket'!$AD$24" How do I change the number 7488 to the content of cell A16 e.g: 7265? So, I enter 7265 into cell A16 and I want the formulas to bring up the values which a... 20 May 2010 10:34
"Update" calendar on userform? Hi. Guys, Excel 2003 - I've got a calendar on a userform displaying January 2010 This is my code: Ualmanak.Caption = "Kies die besprekingsdatum." Ualmanak.Calendar1.Today '<------ This works fine and highlight today's date 'Ualmanak.Calendar1.nextyear '<------ this display the calendar as January 2011... 20 May 2010 10:34
Number of lines in the Immediate Window Is there any way to increase the number of lines that can be displayed in the Immediate Window? Thanks ... 20 May 2010 06:13 |