Excel Programming - Page 101

Rating Thread / Thread Starter	Last Post	Replies	Views
Deconstructing a table - How to take a table back to the begining Bythsx-Addagio[_2_]	by Bythsx-Addagio[_2_]	0	662
deleting rows automatically using a maco or vba outrigger	by outrigger	4	233
Copy question ram	by ram	2	161
Object doesn't support this property or metheod ERROR Ayo	by Dave Peterson	7	167
Ribbon Customisation Howard31	by Howard31[_4_]	2	160
Triming trailing spaces before using Match on columns of numbers withleading zeroes formatted as text u473	by JLGWhiz[_2_]	1	180
Advantages and Disadvantages of Referencing An Add-In Workbook Ryan H	by Ryan H	0	326
Select all rows till last row with value in Column A and CopyPaste PVANS	by Mike H	7	225
How can I make this formula work? FriÃ°rik BjÃ¶rgvinsson	by Jacob Skaria	2	155
prioritized assembly data B2Wash	by B2Wash	0	150
XML Suppress Keytip Auto-Assignment in Custom Ribbon Tab XLjedi	by XLjedi	0	214
Prevent edit on combo box? Robert Crandal	by Gary Brown[_6_]	1	152
Cdate does not help jodleren	by Ron Rosenfeld	2	175
Bug with the function Round ! Tschuß	by Monarch[_2_]	8	193
create email when the cell value changes KevinM[_3_]	by joel[_811_]	1	149
Re Post Please help: Listboxes question K[_2_]	by K[_2_]	4	135
How can I use a collection inside a class? deltaquattro	by Hakyab	7	221
problem with conditional formatting and VBA (excel 2007) delium	by delium	0	197
Can I freeze columns in a listbox Paul	by Paul	0	246
How to get notified when user inserts cells, rows, or columns in W sbo	by sbo	4	268
Urgent Help needed!!!! deadknight89	by Jacob Skaria	3	145
Is there something wrong with the random generator in Excel? JasonK[_3_]	by Joe User[_2_]	14	727
Best Method Dennis Tucker	by Dana DeLouis[_3_]	9	333
Listbox scretch Jean	by Skiffle	2	148
Create Hyperlink in VBA PPL	by Dave Peterson	7	610
Is there a way to test if a control exists on a userform? Ryan H	by Gary Keramidas[_4_]	4	195
Simple IF give me nothing? John	by John	2	180
Closing workbook open as CSV S Shipley	by Dave Peterson	3	285
Auto Populate a Template Gringarlow	by Gord Dibben	5	236
Auto copy and insert a defined number of rows as defined in a cell Billy	by Project Mangler	1	241
presenting a list to the users salgud	by salgud	3	182
cell to have comma-delimited values based on text Richard the Lion-Hearted[_2_]	by Richard the Lion-Hearted[_2_]	0	160
Loop through a range Open a file Thanks	by Chip Pearson	7	334
Opened applications Patrick[_18_]	by Steve Yandl[_3_]	1	167
Calcutate SUM of column in first blank row PVANS	by Domenick	5	352
Determine number of rows with data Simon	by OssieMac	6	379
show download progress to user VBANovice	by John[_22_]	1	195
Macro Please 101 for me	by 101 for me	4	178
Excel 2007 David Lary	by Gary Brown[_6_]	1	153
update links - source file open KB	by Gary Brown[_6_]	1	210
Close Referenced Workbook if it's No Longer Referenced Ryan H	by Chip Pearson	4	253
Bubble Sort failure, Strcomp with binary compare Neal Zimm	by Neal Zimm	10	375
appXL = CreateObject("Excel.Application") Desaivres Alain	by Desaivres Alain	7	296
Referencing another field if result is N/A Brian	by Brian	2	164
need help writing a script Hiding a range when a cell with in is greater than 53.. EagerGit	by Don Guillett[_2_]	1	148
Programable Controls on a Chart jc	by Andy Pope	2	209
Problem copying named range IanC[_2_]	by Don Guillett[_2_]	3	217
VBA Excel Macro worked for 2-years now dosen't?? Canlink	by Canlink	11	483
Please assist. Extract Number from String Damil4real	by helene and gabor	9	265
Macro to delete rows JeffF	by JeffF	12	446
delete rows that have a duplicate id keeping the upper row Bruce Walker	by Bruce Walker[_2_]	6	273
help with dates in the past Bradly	by Bradly	5	326
Selecting from a randomized list bigjim	by Bernd P	7	207
Copying and pasting values to the last available column sanju[_2_]	by sanju[_2_]	2	226
Copy and paste Rob	by Bernie Deitrick	1	200
ActiveWorkbook.PivotCaches.Create in Excel 2007 Joe[_51_]	by Joe[_51_]	0	682
GetObjects chokes on apostrophe. Ross	by Ross	0	169
Run time error adding controls to form programatically ROBW	by ROBW	0	1,092
Data Validation circle cell position Rodels	by Jan Karel Pieterse	3	257
Pull data (sumif?) from an external workbook Simon	by teylyn[_8_]	2	237
DIR Paul W Smith	by Paul W Smith	4	209
Transpose paste with space Chance224	by Hans	8	230
How to set time within macro? Eric	by Jacob Skaria	1	178
Matching Data between 2 Tabs on Same Workbook - then calculating dbl7	by dbl7[_2_]	2	190
Create a list of pre-named tabs darsh	by Per Jessen[_2_]	2	206
How to set time for processing the code? Eric	by FSt1	4	221
question using SUMPRODUCT Bradly	by Joe User[_2_]	1	165
Create Range of Visible Rows only Humphrey	by JLGWhiz[_2_]	2	188
Checking specific text string in excel files stored in a folder AG[_3_]	by AG[_3_]	4	249
Calculating calendar days and completion dates. primed	by primed	4	475
List of Displayed Pivot Items mark	by mark	1	216
Automatic filling of data Andy	by Andy	3	178
Set certain cells to print and others not to print xp	by Project Mangler	2	100
Allow only one value in range. Michael[_4_]	by OssieMac	4	249
Using CodeName when Selecting Multi-Tabs Dean	by Peter T	5	269