Excel Programming - Page 398

Rating Thread / Thread Starter	Last Post	Replies	Views
Checking for [Ctrl] + [Pause/Break] Conan Kelly	by Conan Kelly	3	163
What is wrong with this? Conan Kelly	by Tom Ogilvy	4	216
How can I prevent this from happening? Conan Kelly	by Dave Peterson	3	183
Overridding the "already exists" message with the SaveAs method Conan Kelly	by Bob Phillips[_6_]	4	195
Can I call a sub procedure from another file? Conan Kelly	by Dave Peterson	1	192
Showing Toolbar Buttons as Pressed... Conan Kelly	by Jim Thomlinson[_5_]	1	151
Setting Shortcut Keys Conan Kelly	by Conan Kelly	2	173
Keyboard Shortcuts Conan Kelly	by Conan Kelly	5	233
Looping through each element of an array Conan Kelly	by unavailable	3	328
"in the language of the macro/user" Conan Kelly	by Mark Lincoln	1	201
AutoFilter on one sheet filters same on other sheets? Conan Kelly	by Tom Ogilvy	3	199
Using Analysis ToolPak funcions in VBA Conan Kelly	by Conan Kelly	5	242
Replacing "NULL" Conan Kelly	by Conan Kelly	2	207
Using IsBlank in VBA Conan Kelly	by Zack Barresse[_3_]	5	360
Testing for Named Ranges Conan Kelly	by Mike Fogleman	2	178
Please check my code for conditional formatting Conan Kelly	by Peter T	2	324
Range variables and Freeze Panes Conan Kelly	by Conan Kelly	3	174
How do I return the progress Conan Kelly	by Conan Kelly	2	129
Still trying to return the progress Conan Kelly	by Conan Kelly	0	135
"Method 'Selection' of object '_Global' failed" error Conan Kelly	by Conan Kelly	0	197
Testing an object varible for Nothing Conan Kelly	by Conan Kelly	5	249
Help with Error Handlers!!! Conan Kelly	by Bob Phillips	6	219
Error handler will not work correctly after [Ctrl] + [Break] Conan Kelly	by MSweetG222	3	201
When does the Workbook_Open event occur? Conan Kelly	by Conan Kelly	2	252
Can I use VBA to play a WAV file? Conan Kelly	by Bob Phillips	2	227
Testing for and ungrouping grouped sheets Conan Kelly	by Conan Kelly	4	221
XL2003 VBA: Debuging...can not break or run in break/step mode. Conan Kelly	by Joel	1	531
Move/reset to the beginning of a TextStream Conan Kelly	by Joel	1	281
Changing properties of a file with VBA Conan Kelly	by Norm Cook	4	389
ChDir and ChDrive Conan Kelly	by Dave Peterson	2	394
XL 2003: How do I get every possible combination? Conan Kelly	by Dana DeLouis[_3_]	14	426
XL2007 (or 2003): Triggering SelectionChange event Conan Kelly	by ozgrid.com	1	174
I need to remove passwords from a list of files. Conan Kelly	by Conan Kelly	4	208
Selecting a group of sheet tabs Conan Kelly	by Tom Ogilvy	1	412
Assigning cell address components to variables Conan Kelly	by Arvi Laanemets	1	210
Setting a Constant when creating a new file from a template? Conan Kelly	by Nigel	1	183
Seting a Constant (via code) when creating a new file based on a template Conan Kelly	by Conan Kelly	1	252
Code equivelent to a key combination? Conan Kelly	by peterDavey	6	200
How do I determine if it is a new file or an existing file? Conan Kelly	by ben	2	231
Advancing to the next cell Conan Kelly	by Bernie Deitrick	1	222
Moving files via code Conan Kelly	by Bob Phillips[_6_]	1	223
Button on toolbar for AutoCalc Conan Kelly	by Conan Kelly	2	230
Looping through a range of cells Conan Kelly	by Bob Phillips[_6_]	2	207
Storing column references in a variable Conan Kelly[_2_]	by Conan Kelly[_2_]	3	172
Accessing Windows clipboard during runtime Conan Kelly[_2_]	by Conan Kelly[_2_]	2	212
Change a date in text format xx.xx.20xx to a recognised date format concatenator	by Trevor Shuttleworth	1	1,801
Create a "key" concatenator[_2_]	by concatenator[_2_]	0	206
Excel 2K Com Addin DLL in Excel 97? Conceptor	by Conceptor	0	223
VBA Excel 2000 - one shot multiple cells modification Conceptor	by Dan E[_2_]	1	329
Write a function call into an Excel cell from VBA Conceptor	by Conceptor	2	278
Macro shortcut from XLA Conceptor[_2_]	by Jos Vens	1	540
Replace sheet formulas with value Conceptor[_2_]	by Conceptor[_2_]	3	207
piggyback cell from formula function Conceptor[_2_]	by Conceptor[_2_]	6	378
Detect workbook events from .XLA Conceptor[_2_]	by David Hager[_2_]	2	291
Link .xls cell formula to .xla function Conceptor[_2_]	by Conceptor[_2_]	4	330
Detect macro's parent workbook or worksheet Conceptor[_2_]	by Frank Kabel	1	222
.xls file keeps referenced addin(.xla) filepath? Conceptor[_2_]	by Nikos Yannacopoulos[_5_]	1	320
application.volatile activation Conceptor[_3_]	by Dick Kusleika[_3_]	5	302
Formula appears as =RC[-3]+RC[-1] Whats this? Concrete Guy	by Bob Phillips	1	516
I want to run a macro when i press return Concrete Hippo	by Concrete Hippo	2	210
command button Conditional Formatting	by Conditional Formatting	0	147
conditional formatting Condoodle	by Bob Phillips[_6_]	1	137
Outlook messages generated from Excel macro Condor	by Condor	2	279
Change Cell Value when autofiltered [email protected]	by Roger Govier	2	219
Import text file problem [email protected]	by [email protected]	0	155
Delete last row from range [email protected]	by Barb Reinhardt	3	228
2007 Ribbon dropdown [email protected]	by [email protected]	0	221
Custom ribbon dropdown [email protected]	by [email protected]	0	288
What should my calculation settings be? CondtllyFrmttd	by CondtllyFrmttd	2	182
IF Statement not Displaying FILLDOWN results Automatically CondtllyFrmttd	by sebastienm	3	225
Only a genius can help with this 7 Nested If that doesn't fill down CondtllyFrmttd	by CondtllyFrmttd	5	187
Export To Excel From ASPNET Coneection OLAP	by Coneection OLAP	0	190
How do I stop VB Editor window from opening when I run my macro Confucius	by Edwin Tam[_7_]	2	347
Excel crashes with long file names Confuscious	by NickHK[_3_]	3	251
Need help with loop code confused	by confused	0	202