Excel Programming - Page 52

Rating Thread / Thread Starter	Last Post	Replies	Views
Dim MyArray vs. Dim MyArray() Alan Beban[_2_]	by Alan Beban[_2_]	12	403
Dynamic Arrays Alan Beban[_2_]	by Peter T	12	468
Lifetime of VBA variables Alan Beban[_2_]	by Peter T	4	208
5461 element limit Alan Beban[_2_]	by Dave Peterson[_5_]	5	188
Object Arrays Alan Beban[_3_]	by Alan Beban[_3_]	0	244
CountIf Alan Beban[_3_]	by Alan Beban[_3_]	0	439
rng(1,1) syntax doesn't work for set rng = arange.columns(1) Alan Beban[_3_]	by Jake Marx[_3_]	2	287
counting entities with the same values Alan Beban[_3_]	by Alan Beban[_3_]	0	185
Deleting blank lines in a range Alan Beban[_3_]	by Alan Beban[_3_]	2	202
Check if a String is inside an Array Alan Beban[_3_]	by Alan Beban[_3_]	0	204
Loading 3 Dimensional Array Alan Beban[_3_]	by Alan Beban[_3_]	0	256
Why the.. does this not work??? Alan Beban[_3_]	by Wild Bill[_2_]	1	162
VLOOKUP in VBA Alan Beban[_3_]	by Alan Beban[_3_]	0	176
sum (column 2 of namedrange) Alan Beban[_3_]	by Carl Brehm	2	233
VBA code to calculate the difference between rows Alan Beban[_3_]	by Alan Beban[_3_]	0	241
transpose matrices Alan Beban[_3_]	by Alex@JPCS	1	205
VBA Syntax for VLOOKUP to return array of return values Alan Beban[_3_]	by Charles Williams	7	997
Declare Multidimensional Arrays Alan Beban[_3_]	by Alan Beban[_3_]	0	291
Range object to Array object conversion Alan Beban[_3_]	by Alan Beban[_3_]	0	365
Newsreader settings Alan Beban[_3_]	by Alan Beban[_3_]	0	167
locate max value in variable range Alan Beban[_3_]	by Alan Beban[_3_]	0	270
Macro to filter sheet and copy to another Alan Beban[_3_]	by Alan Beban[_3_]	0	252
Search for a value in a column Alan Beban[_3_]	by Alan Beban[_3_]	0	175
Next cell in a range, by row not column? Alan Beban[_3_]	by Alan Beban[_3_]	0	220
Array functions Alan Beban[_3_]	by Alan Beban[_3_]	0	218
Named Range Alan Beban[_3_]	by MarkM[_3_]	1	202
Declare Multidimensional Arrays Alan Beban[_3_]	by Brent McIntyre	3	331
Running external programs Alan Beban[_4_]	by Dave Peterson[_3_]	4	290
Type mismatch Alan Beban[_4_]	by Alan Beban[_4_]	0	256
Array Functions Alan Beban[_4_]	by Alan Beban[_4_]	0	239
Can I reset an array to myarray() Alan Beban[_4_]	by dan	1	269
Help: Can't write to the right sheet Alan Burns	by Alan Burns	4	208
Macro to delete a macro Alan B[_2_]	by papou[_2_]	5	174
Excel - adding control programmatically. Alan B[_3_]	by Alan B[_3_]	3	272
Code to trap data entry outside of range Alan Campbell	by Alan Campbell	3	222
Code problem emailing range as html in Outlook body Alan Campbell	by Alan Campbell	3	231
Custom Functions in Personal.XLS Alan Cannon	by Alan Cannon	2	237
Userform Listbox highlights wrong line. Alan Carpenter	by Alan Carpenter	0	671
setting address in "mail as attachment" macro Alan D.	by Alan D.	5	415
dynamically assigning QueryTables.Add.TextFileColumnDataTypes Alan D. Ayers	by Alan D. Ayers	0	288
Determining a combo box by code Alan Davis	by Dave Peterson[_5_]	3	181
PRINTING PAGES ! alan dinno	by alan dinno	0	141
Creating Name for a Command Button Alan Douglas	by Peter T	3	187
1st attempt vba-how do i whatnext in this sub ALAN EMERY	by Tom Ogilvy	1	257
autofill column data ALAN EMERY	by ALAN EMERY	2	197
Create and print simple maths problem sheets for kids. Alan Forsyth	by Alan Forsyth	2	180
Displaying Text on a Forms 2 Form Alan Forsyth	by Alan Forsyth	2	226
Centralized Macro Alan Glaister	by Alan Glaister[_2_]	3	343
Viewing a worksheet while a UserForm is active Alan Glaister[_2_]	by Bob R.	2	590
VB Editor complains of undefined variable for VBE Alan Glaister[_2_]	by Alan Glaister[_2_]	3	251
Altering UI Programatically Alan Greenwood	by Alan Greenwood	2	268
How To Hide Code? Alan Greenwood	by Auric__	2	214
How Many Simultaneous Users Can Be Safely Handled? Alan Greenwood[_2_]	by Jon Peltier[_8_]	2	234
Delay Visible Updates?? Alan Greenwood[_2_]	by Markus Scheible[_2_]	1	159
Programatically retrieve a list of public functions. Alan Howells	by Alan Howells	4	476
Reference styles and local/non-local formulae - international problems. Alan Howells[_2_]	by Alan Howells[_2_]	2	343
Undo stack Alan Hutchins	by Norman Jones	1	253
E-mail using Lotus Notes Alan Hutchins	by Andy Wiggins[_3_]	1	310
Excel in English run on PC with Excel in French Alan Hutchins	by keepITcool	2	202
Excel 2002 - 2 problems Alan Hutchins	by Norman Jones	1	181
Excel object model Alan Hutchins	by Alan Hutchins	0	303
Prevent users from running macros Alan Hutchins	by George Nicholson[_2_]	7	471
Out of Memory Alan Hutchins	by Alan Hutchins	0	221
Conditional Formatting Alan Hutchins[_2_]	by Alan Hutchins[_2_]	0	183
Write value to an Excel VBA variable by reading Access DB? Alan Ibbotson	by Dave Patrick[_2_]	1	208
How to Offset string variable? Alan Ibbotson	by Greg Wilson[_4_]	2	266
Return the value of fields in Outlook Contacts Alan Ibbotson	by Jim Thomlinson[_4_]	2	174
Copying template to workbook but user form does not copy? Alan Ibbotson	by Alan Ibbotson	0	183
Trying to return cell formatting? Alan Ibbotson	by JE McGimpsey	1	164
shape object on a userform? Alan Ibbotson	by Vasant Nanavati	5	285
print PDF file from Excel - NOT print Excel to PDF? Alan Ibbotson[_2_]	by [email protected]	1	175
my VBA procedures stopped calling other procedures in excel 2007. Alan in Toronto	by Alex Garcia	2	223
How do I get dates automaticaly inserted when editing excell Alan Johnson[_2_]	by Bernie Deitrick	1	186
auto filter based on color Alan Ku	by Nigel[_2_]	1	147
For loop... Alan L. Wagoner	by Trevor Shuttleworth	1	174