Excel Programming - Page 101

Rating Thread / Thread Starter	Last Post	Replies	Views
Copy and paste Rob	by Bernie Deitrick	1	273
ActiveWorkbook.PivotCaches.Create in Excel 2007 Joe[_51_]	by Joe[_51_]	0	769
GetObjects chokes on apostrophe. Ross	by Ross	0	233
Run time error adding controls to form programatically ROBW	by ROBW	0	1,234
Data Validation circle cell position Rodels	by Jan Karel Pieterse	3	342
Pull data (sumif?) from an external workbook Simon	by teylyn[_8_]	2	325
DIR Paul W Smith	by Paul W Smith	4	287
Transpose paste with space Chance224	by Hans	8	317
How to set time within macro? Eric	by Jacob Skaria	1	250
Matching Data between 2 Tabs on Same Workbook - then calculating dbl7	by dbl7[_2_]	2	272
Create a list of pre-named tabs darsh	by Per Jessen[_2_]	2	295
How to set time for processing the code? Eric	by FSt1	4	301
question using SUMPRODUCT Bradly	by Joe User[_2_]	1	285
Create Range of Visible Rows only Humphrey	by JLGWhiz[_2_]	2	262
Checking specific text string in excel files stored in a folder AG[_3_]	by AG[_3_]	4	335
Calculating calendar days and completion dates. primed	by primed	4	556
List of Displayed Pivot Items mark	by mark	1	347
Automatic filling of data Andy	by Andy	3	259
Set certain cells to print and others not to print xp	by Project Mangler	2	101
Allow only one value in range. Michael[_4_]	by OssieMac	4	327
Using CodeName when Selecting Multi-Tabs Dean	by Peter T	5	353
delete rows which have a one in them kyle	by Jef Gorbach[_2_]	7	417
What's wrong with this? sarndt	by witek	4	293
Copy row when value NOT found? No Name	by No Name	3	294
save as - location or default John[_22_]	by John[_22_]	2	274
How do I code the cloning of an object in vba? sarndt	by Ryan H	1	327
Declaring variables for use in a Module Ayo	by Ryan H	1	287
VBA access to a series, after it was assigned to an empty range Werner Rohrmoser	by Werner Rohrmoser	0	249
.pdf file not working in UserForm Phil H[_2_]	by Phil H[_2_]	4	417
Automatically start a macro after data refresh Kurt Barr	by Kurt Barr	2	568
format on change event joemeshuggah	by Gord Dibben	4	375
Need Help with a cell? vpmedia	by Kurt Barr	1	283
move row to next sheet joemeshuggah	by joemeshuggah	4	280
List Listbox data in column K[_2_]	by Gary Brown[_5_]	1	296
Excel Open window customization Desaivres Alain	by Desaivres Alain	0	241
Problem using Match on columns of numbers with leading zeroesformatted as text ??? u473	by u473	4	299
.Text .Formula .Value to replace copy_paste values? Rikkart	by Dave Peterson	3	309
Getting output from the TREND function using VBA stanleykorn	by Peter T	3	331
Self Signed Digital Certificates. IdiotZ42	by Gord Dibben	1	270
How to simulate a click into a textbox (shapes) Alex St-Pierre	by Peter T	1	398
referencing a workbook using string var = error9 PBcorn	by Muscoby	1	280
Cloning an object which contains a collection deltaquattro	by deltaquattro	0	307
Filling right header/footer with barcode Pastor Del	by Pastor Del	0	271
Date dependent macro - run once only Wes_A[_2_]	by Dennis Tucker	3	423
Start a macro from a change in a cell value made by a formula? Geejay	by Geejay	7	465
Password To Open Spreadsheet Used as Variable in VB Code or Macro DogLover	by DogLover	2	259
Excel automation fails from PowerShell when PIa are installed. Shiv	by Shiv	0	409
Simplifying an If(OR(…)) statement xl@lf	by Zoltan	6	306
Stumped - Problem with Macro Security settings? Elkar	by Martin Brown	10	559
Combo Box Paul W Smith	by Paul W Smith	1	253
Chart Print Footer :: Excel 2007 QB	by Gary Brown[_5_]	3	511
Looping code Rob	by OssieMac	3	285
Clearing used range? jodleren	by jodleren	2	421
Missing Control In Addin SteveB	by Peter T	6	350
Determine the Empty row and/or column Subodh	by Mike H	1	310
Select contiguous cells by ActiveCell.Interior.ColorIndex and applyborders nofam	by nofam	13	778
VBE freezes after running macros [email protected]	by dvyg725	4	382
Configure macro to run on all sheets Excel 2k7 kevlarmcc	by JLatham	9	362
Is there a work-a-round i can use for making a datagrid.... Mr. GetRight[_2_]	by Mr. GetRight[_2_]	3	300
Copy subset of Range Simon	by FSt1	4	404
using excel formulas in VB coding Matthew Dyer	by Dave Peterson	4	287
How well does MS Office 2003 run on Windows Server 2008, IN PRACTICE? ship	by Tony Toews [MVP]	5	299
Recall a file oldjay	by Dennis Tucker	3	304
format a formula to general (not text) Emma Aumack	by Joe User[_2_]	4	317
Setting column width on different computers Gleam	by Gord Dibben	4	299
Open Workbooks Paul W Smith	by Paul W Smith	7	313
Minimum row height SteveZmyname	by Gord Dibben	8	1,043
2 Dim Array Sort, on any columns, ascend or descend. Guidance des Neal Zimm	by Neal Zimm	0	257
Convert Pivot Table to Values in Macro Buck	by Buck	0	346
Remove Focus from Form BillCPA	by Chip Pearson	1	328
VBA Conditional Formating Using Logical Expression 599R	by 599R	4	400
Autofill Formulas Mike Archer	by Gord Dibben	1	492
Place a cell value on Charts Moises	by Moises	2	287
Open hyperlink - how can I check the page has finished loading AltaEgo	by AltaEgo	0	296
Using data from cells in a Query to a MS Access Database DGreco	by DGreco	2	256