1:
Count funtion
2:
Pivot table - Unique values
3:
in excel 2003 what is the replacement for the old extract formul?
4:
Excel Solver in VB
5:
Data from Access
6:
Updating Data
7:
Vlookup, several tables, one sheet
8:
printing of linked picture includes buttons not included in area
9:
obscure array sort
10:
Data Validation for % input in userfom
11:
batch editing a document
12:
Copy chart to clipboard
13:
Determining if a cell/range is in error?
14:
External Data refreshment
15:
Enable Macro - default //
16:
Date vs Date$
17:
Finding Characters in a String
18:
Referencing mso enumerations (e.g., msoLineSolid)
19:
All Pivot table include different pivot field to save as individual
20:
HELPPPPP Please - Comparing Data
21:
Insert characters into String
22:
Time format in userform textbox
23:
[GetMacroRegId}
24:
Text - Blink //
25:
textbox font style
26:
Macros and data analysis
27:
Form Objects in an array?
28:
short key to invoke command button in userform
29:
number of types
30:
Want to learn macros in excel
31:
formula
32:
VBA question: How to extract cell values in different languages
33:
Excel Services Chart Generation for SharePoint Dashboard Display
34:
Div/0 error
35:
Any macro programming sample for accessing database through Excel?
36:
"Method 'Add' of object 'INodes' failed" in TreeView.
37:
Macros: Strategies For Where They Live?
38:
Series of custom dialog boxes
39:
"Breaklink Problem"
40:
SUM columns based on 2 pieces of logic
41:
How to replace the image on the Office Button in Excel 2007?
42:
Drag and Drop
43:
need VBA to clear dependent data validation lists in several rows
44:
Using a variable in a formula
45:
Listbox
46:
compare 2columes of name
47:
Do not execute Double Click Event when UserForm is Showing
48:
Macro to Insert Object with browsing ability
49:
Change Excel query with a inputbox
50:
VBA and Pivot Table Query for Text values
51:
Conditional Formating
52:
Converting Excel Equation into VBA
53:
Is there a test for an empty string that returns a boolean?
54:
Macro - How do i....?
55:
=sum doesn't work properly
56:
Function Call to check Workbooks.Open
57:
Calculating Cells
58:
Open to today's date
59:
need help tweaking Debra Dalgleish macro
60:
Checkboxes and Arrays
61:
Formula for selecting highlighted cells only
62:
currency formatting of cells with code
63:
Record Macro Window.
64:
worksheet menu bar
65:
Any sample to connect a remoted database through Excel?
66:
VBA formula too long?
67:
Getting folder size information into cell???
68:
Merge muliple sheets in multiple workbook below each other.
69:
workbook / worksheet change event
70:
Pulling data from 3000 files
71:
My code enters break mode but there are no breakpoints
72:
Macro to show/hide rows
73:
Variable Input
74:
Macro Error Help!!
75:
Count function?
76:
Appending Contents Of Multiple Spreadsheets Into One
77:
What's the API call to kill the KB buffer?
78:
ListBox Displaying With Some Items Already Selected In 2007
79:
Checking if a cell contains a string that is not case sensitive
80:
TreeView's pos on UserForm changes by itself.
81:
updating pivot table data via external xls file which is replaced
82:
Numeric data
83:
Cell references and merged cells
84:
Excel 2007 SP1 VBA Help
85:
Help to speed up this macro
86:
How do you collapse a TreeView?
87:
WM_SETREDRAW doesn't work unless...what?
88:
Confrimation of copy paste operation
89:
Capture paste from Office Clipboard
90:
Modeless Form help please
91:
Can i link various text in a cell to a picture
92:
Thanks to Stephen Bullen for fixing VBA's miserable UserForm.
93:
Excel 2007 - How do I ...
94:
UserForm ShowModal Problem
95:
code to extract data from a website runs of XP but not Vista
96:
Automanipulating IE drop-down list in VBA/Excel
97:
Create a Macro with a List
98:
I am not sure
99:
How to execute macro based on a users computer settings
100:
How best to break up code
101:
VBA Additional controls
102:
Controlling how a second excel file opens
103:
Checkbox
104:
Running Macros Remotely (.tcl file)
105:
Combo Box and smart key selection
106:
Working with Arrays
107:
Selfcert no longer working correctly
108:
Check access right to folder
109:
Save Date
110:
Userform: what happen to the sub who launched it?
111:
Excel VBA Query Across Databases
112:
Copy rows from multiple workbook into a different workbook (sheet)
113:
Staff resource query
114:
Follow Hyperlink in Cell
115:
Comparing 2 sheets
116:
Text Box - Initial Content
117:
Application.Run
118:
VB/Excel query
119:
Compile Error in Hidden Module: Module 1
120:
Variable length named ranges
121:
ms excel 2007 Filesearch
122:
Math Operation: Set Subtraction
123:
Select Column based on Sheet Name
124:
Help with Grabbing Cell Value from Range
125:
Sheet Protection Question
126:
Tracing where spreadsheet is opened from
127:
Retrieving the values of Excel check boxes in .NET
128:
Userform Initialize Problem !
129:
worksheet SaveAs WK4 in background
130:
Please help!
131:
Setting up Sum ranges inside a macro.
132:
Checkboxes with the same Group Name not Responding
133:
Identify shape in cell
134:
Iterate rows of spreadsheet(s}\Get values
135:
Help with match function, i need to tally
136:
ADO help: Only get first 255 characters of field...
137:
distributing a spreadsheet with macro buttons
138:
Easy Worksheet Function help
139:
UDF Function to calculate mean moving range (control charts)
140:
Trying to create Macro to delete duplicate Rows
141:
Optimising Code
142:
Multiple checkbox selection
143:
Excel2000: Avoiding loop in Worksheet_Change event
144:
Automation add-in - UDF to multi cells...
145:
List of email addresses
146:
Open several files and copy the contents
147:
One Workbook to Several Workbooks
148:
How do I exit from a macro when a condition is not met
149:
Userform coding problem
150:
Upgrade PivotTable drop-down selection box
151:
Grab all filtered rows for some action
152:
Macro defining dynamic named ranges
153:
Drop-Down Arrow in AutoFilter
154:
Running code.
155:
Automatically Change Row Height Based on Cell Contents?
156:
Adding a divider to an add-in using vba in excel 2007
157:
Problem in excel - possible MACRO solution ?
158:
Counting and adding values int two different columns
159:
Adding items in one row if criteria in another column is met.
160:
Warning message while macro runs
161:
Option Button FaceID in a custom commandbar
162:
Sum Column Y at first blank-bottom cell.
163:
dual zero conditional row deletion
164:
stuffing japanese text into a variable
165:
Pivot table not recognizing same field values
166:
Find & Copy Files Listed in Excel Worksheet ?
167:
Find and Replace Question
168:
Runs once and only once
169:
Entering a formula
170:
Copy past function on cell containing selective formula
171:
closing a variable file name with macros
172:
I need a way to pull a list based on criteria a user inputs.
173:
Refer to Column with a variable
174:
select a list, then sort #2
175:
tabs by dates
176:
Range to array excluding null values
177:
locating excel file
178:
If sh.Name <> Sheet1 Then
179:
Macro to insert repeat comments
180:
Remove On Activate Sheet Event
181:
open Workbook path
182:
Change Save Dir in IE (VBA)
183:
Programmatically call a menu item from a menu from a Add-in
184:
Analysis Toolpak Loaded or Not
185:
Advanced Filter problems using VBA in XL2007
186:
if then formula
187:
Scrolling columns in lockstep
188:
Cell should display, login name.
189:
Conditional Drop Down List
190:
Copying Worksheet Formatting (Rows to Repeat at Top)
191:
Triple Filter? Ron de Bruin Code.
192:
How to: IF FALSE in 2 Cells, Then Obtain Value From 3rd Cell?
193:
How to call a workbook Event..
194:
Hyperlink within formula
195:
number seperation
196:
With Application; Me.Top = ...
197:
Range.Group Method - group rows, not columns
198:
Excel CDO
199:
Is there any way to solve this problem ?
200:
match and offset
201:
Minimize Ribbon
202:
Object Required Error
203:
Spreadsheet or Table Control for Form
204:
passing ComboBox to subroutine
205:
Get From Clipboard
206:
Macro to Refresh child pivot table
207:
Automation
208:
List Table or Spreadsheet Object for Form
209:
Selecting rows using defined reference as end row
210:
Return list of file names from specific directory
211:
Selecting cells using a defined reference
212:
Icon Sets in Conditional Formatting
213:
find textbox insertion point
214:
I need help with macro
215:
caps in cells
216:
Embed HTML in generated email body
217:
Importing excel data into vector graphics programs
218:
Getting the position of an item in a pivot table
219:
"Freezing" Conditional Formatting
220:
Circular scripting between sheets in the same workbook
221:
Using ranges with Visual Basic, stuck...
222:
Excel 2003 stripping out line feeds
223:
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE
224:
Copy multiple charts to an array?
225:
Trigger CAPS LOCK ON When Wk Bk is Opened?
226:
organising staff rosters with 3 teams
227:
Use event to catch the running of a macro from an add-in
228:
Pivot Table Issue...
229:
Floating Command Button
230:
Need Macro to print curent page only
231:
Need a Macro to Scroll to the left
232:
How do I set up a column to automatically number the next row
233:
Compare 2 excel workbooks
234:
Data Validation problem still remaining
235:
Linked Workbook Files
236:
.OnEntry Macro does not fire when pasting
237:
Vlookup Question
238:
Woksheet spliting
239:
Data Validation List Problem
240:
Autofilter Range
241:
Random number generation
242:
VBA to VBS Translation - References
243:
lookup folmula i/e n/a
244:
list box dialogue msgbox
245:
Microsoft Map is no longer supported with Microsoft Office Excel
246:
Same page setup across multiple sheets (Excel 2000)
247:
Problem sorting file dates in an array
248:
Bitmaps on forms
249:
Solver Macro
250:
Solver Macro
251:
Connecting to an Access database
252:
Setting conditional colours for cells
253:
Naming Ranges
254:
random sampling TEXT
255:
Debugging Code
256:
Set group of wksheets to top of page
257:
Batch Processing Macro
258:
UserForm is missing the most basic Win controls. WHAT the?
259:
Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_
260:
Macro Halting During Execution
261:
Unable to assign FormulaR1C1 correctly
262:
Auto-increment file name
263:
extracting embedded or Ole Object data
264:
Reference active worksheet from macro in personal.xls
265:
"Subscript Out of Range" Error Question
266:
Notify users by email of document update
267:
Worksheet protection VBA
268:
Select Range and Find Values ***Maybe Loop?***
269:
Formula for CF
270:
Built-in Dialog box for folders?
271:
Auto Filter Problem
272:
Changing the Colour of a Line with VBA?
273:
Windows XP Office 2003 Run-time error '9'
274:
Sum using Variable
275:
Macro Help
276:
Custom toolbar - how to save in file and show on demand?
277:
Run Macro on all WS in active workbook..
278:
hiding columns in excel based on formula result
279:
Improve code that checks a range of names - currently using Activate
280:
How can I increase the capacity of a listbox?
281:
Predict based on range or series
282:
Changing Series Colour with VBA??
283:
Confirm Empty Cells in a Range
284:
=IF Formula to find both < and >
285:
Letting buttons depend on the sheet?
286:
Custom Angle and Alignment with VBA
287:
Compare 2 files and show deltas
288:
Need Macro to take me to a different tab to specific cell
289:
LIKE won't work in VBA/ADO app
290:
duplicate a row with a macro
291:
How to get number with in order
292:
linking excel data into Word
293:
Web query
294:
Excel 2003 to 2007 Migration Question
295:
Programmatically determine if Workbook contains Macros in Excel 20
296:
Place formula in cells
297:
date format in CSV
298:
Dialer.exe - I am actually trying to get dialer.exe to dial Excel cell phone numbers. I am using Excel 97 on a XP Box.
299:
XP Problems with SendKeys - dialing a number in an Excel cell
300:
Automatic, conditional chart creation from separate files [Excel
301:
Macro that adds up the sheets of similar workbooks
302:
Ignorance is not bliss
303:
Resourcing and counting staff
304:
Unprotect the sheet
305:
Personal
306:
if cell contains this AND that - like operator?
307:
ComboBox question
308:
Need VBA to remove command buttons
309:
AppActivate / Minimized Windows / GetWindowPlacement
310:
Query & IE7
311:
Offset vs. Range references
312:
RowHeight and AutoFit wit Merged Cells
313:
Need macro to copy active sheet to a new workbook
314:
How to disable TreeView screen update?
315:
Changing value of Node.Parent destroys .Bold property of entire
316:
How to return to worksheet where macro started?
317:
Advice on correctness of using subs
318:
Userforms in Excel
319:
Custom ribbon dropdown
320:
Open PDF File Using Reader 8
321:
ActiveX control button hint
322:
Macro to Break Links Before Saving Sheet
323:
Resize comments with only picture.
324:
Move Control with Scroll
325:
Userform Text Box Formatting
326:
Call a Private Sub using a variable
327:
Dialog Box and Save As Location
328:
HOW TO PUT MSGBOX CODE IN MACRO
329:
Please can anyone help me? Big problem with date format.
330:
Arrays and Loops
331:
How: Marco on Pivot Table to save as file up to 300 files
332:
Activate data according to the value key in in other cell.
333:
Help Command Button
334:
Import query from access into excel via vba, but will not refresh
335:
reset all pivot field properties
336:
Copy formulas between workbooks without copying links
337:
Activating a BAT file from a HTA
338:
Backup to multiple locations
339:
Call sub from worksheet_change
340:
Managing 70 checkboxes in financial graphing application
341:
Are the Windows.Arrange ArrangeStyle:=xlHorizontal settings persistent?
342:
commandbuttons won't trigger code.
343:
datacontrol grid problem
344:
Reload from DDE
345:
Getting duplicate names
346:
and, or in vbe
347:
Allow macro to work for a group of cells but not the other cells
348:
Date sorter
349:
Formual/Macro Help
350:
macro help