TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Programming Archive
‹
Page 30
Archive
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
view full version:
back to formated view
10151:
2008->2003 incompatibility
10152:
EMPLOYEE WEEKLY SCHEDULE
10153:
zoom in &zoom out in VBA User Form
10154:
Select an empty cell
10155:
print each row in the list in the combo bos
10156:
Disabling the "Design Mode"
10157:
PasteSpecial issue
10158:
Code to get Max Value in a perticular cell in ALL Sheets
10159:
Userform problem
10160:
Tools/Customize question - toggle Show/Hide Comments without a macro
10161:
Excel 2007 retreive text from text file
10162:
Shade cell if No value in offset cell
10163:
Please Help Help$$ modifying the recorded (VBA) Macro with Excel
10164:
hiding rows with merged cells using macros
10165:
Using formula in a macro?
10166:
change event
10167:
using rowsource to fill a combobox
10168:
Day of Week
10169:
Control Number - A better way
10170:
Cell Update on Paste
10171:
Shortcut Key Assigned to Imported Macro (i.e. in personal.xls) Does Not Work
10172:
Should TD be HTMLTableCell?
10173:
getting the entire range before be filtered
10174:
Loop through table of columns and rows
10175:
additem removeitem
10176:
Macro to schedule downloads
10177:
Help me to first row matching First date and last row matching last
10178:
Excel workbook save behavior using VB6 very confusing
10179:
Delete Specific Sheets
10180:
How to Place a Drawing Object on a Worksheet as a Control?
10181:
Macro Copy Excel Chart Sheet to PowePoint - Mod of Jon Peltier code
10182:
DialogActiveCellFont
10183:
Need to paste/update info to correct row.
10184:
Return Control to Userform
10185:
List Box Highlight Selection from Sheet
10186:
How to populate web page forms from Excel or DB? Is this possible?
10187:
Match function not wokring on 2D array
10188:
automatically create list of the worksheets
10189:
Issue with marco for entire workbook
10190:
find error
10191:
How to install missing DBNamespace 1.0 Type Library
10192:
Find first empty row in a range
10193:
automating (alt & f11)
10194:
Automatic Toolbar
10195:
writing a text file in the same folder as my program
10196:
Stripping HTML tags from excel
10197:
Set message subject here ...
10198:
Tip # 14 To color all sheets in the workbook
10199:
Excel has encountered a problem and needs...
10200:
macro to return value of worksheets
10201:
referencing to external name range that would update automatically
10202:
Sorting problem
10203:
Linked file Excel 2007
10204:
Excel file linking
10205:
Excel tables vs. system tables
10206:
Running macro in one workbook that refers to variable in another
10207:
Delete Row Select Case
10208:
I have the slowness problem also
10209:
match function - date and time
10210:
Subroutine Summing and Outlining
10211:
Getting a range using row & col numbers?
10212:
Retrieve selected data from Network file
10213:
Error Handling Help
10214:
alt & f11 via macro
10215:
too much space
10216:
User Form
10217:
Cannot hide columns/rows
10218:
combobox dropdown
10219:
how to identify a shape as a picture in excel from VB
10220:
error 70 permission denied in excel
10221:
prefix in text box
10222:
E-Mailing macro font options
10223:
Formula for day of the week to relate to corresponding date cell
10224:
Checking Web Queries
10225:
add total from 6 textboxes and put in label
10226:
last cell as label caption
10227:
show userform/hide workbook
10228:
Naming Ranges with code
10229:
Displaying programatically worksheet errors messages in a cell
10230:
Insert Row & format as per other rows, above/below
10231:
manipulating Query data 'on the fly'Question
10232:
lastcell
10233:
"Toggle Switch" help needed
10234:
force text/numbers in text box
10235:
range value as label caption
10236:
Addins - number of columns & rows in running version of Excel
10237:
Triggering macro
10238:
Select a series of cells
10239:
Searching for a value for and then replacing when found.
10240:
Concert number to time
10241:
Ok what's the trick to do this?
10242:
How to extract aggregate values from PivotTable
10243:
Conditional formatting
10244:
Cancel Button on file save
10245:
Problem in automating using a button created by recording a macro
10246:
test
10247:
recently used file
10248:
Saving multiple worksheets to a master file
10249:
Excel Macro: Selecting items from another worksheet without
10250:
loop help
10251:
Loop help
10252:
Sort Data auto on cell range when updated
10253:
Add dimesion to Array already populated
10254:
Copy & Paste Dynamic Named Range
10255:
Help with code
10256:
Help! Refrence a userform element from a textbox?
10257:
Help! Refrence a userform element from a textbox?
10258:
Create VBA function that returns many values
10259:
Shell Command Fails (sometimes)
10260:
Atofill Questions
10261:
Passing result of multiple split function results to 1 Array
10262:
sheets
10263:
How to copy from each sheet and paste to a summary sheet
10264:
Prevent a Worksheet from being deleted
10265:
Get Save Prompt when closing workbook immediately after saving
10266:
how to save a file and overwrite existing file
10267:
Date and Time
10268:
MS Excel 2007. ActiveChart.ApplyCustomType
10269:
Restore "Delete..." and "Insert..." shortcuts
10270:
Using Excel Interop via VS.NET 2005 to create and save a new Excel
10271:
"Call" Commandbutton1()
10272:
Excel 2007 VB function call return value syntax question
10273:
Office 2007 VBA Compatibility??
10274:
Filter and count hidden cells problem
10275:
Set position of non frooze rows when panes are frooze
10276:
Multipage Tab vs Regular Userform
10277:
Extracting Text between 2nd and 3rddelimiter
10278:
how would i wrtie this formula
10279:
VBA for Exporting to Text file
10280:
Opening workbook in same directory
10281:
passing an argument
10282:
Show Time Stamp in Cell when Command Button Clicked
10283:
dynamic source range change in pivot table
10284:
Copying across values based on criteria
10285:
every fifth line
10286:
Macro triggered by date
10287:
error
10288:
Connection problem using DAO
10289:
Using Outlook Express for this Newsgroup
10290:
Delete Row if value <>
10291:
Delete a workbook...
10292:
Excel Addin Install via Registry
10293:
Leading Zero in .csv format
10294:
copy cell until data doesnt exitst anymore
10295:
can I copy "2" different Ranges from closed workbook (VBA)
10296:
Open, print, close multiple pdf's from macro
10297:
Userform Programming
10298:
If JobNumber = Val(field(7)) Then Query
10299:
hyperlink to sheet with name in cell
10300:
Change event for several Textboxes on UserForm
10301:
Advanced Filter Error 1004
10302:
Search a column to match textbox value from a form
10303:
Macro to merge text and delete rows
10304:
Combobox drops down blank row
10305:
Zero values in Pivot Tables
10306:
PivotTable Show Properties in Report - stange behaviour
10307:
Macro for export
10308:
Updating workbook from protected workbooks...
10309:
Input box
10310:
ListBox
10311:
Force CAPITAL LETTERS
10312:
Problems printing Webbrowser Control with a worksheet.
10313:
Print To WorkSheet
10314:
retrieve text from a text file
10315:
Excel Macros sending attachments to multiple e-mail addresses
10316:
Automating excel though outlook
10317:
re : Copying a range from WB01 and pasting to WB02
10318:
How do I create a Graphical Report from Survey responses in Excel
10319:
Send parameters in worksheet button > 255 characters
10320:
date and time
10321:
UDF that returns a date
10322:
How to create .HLP for my VBA project
10323:
How do I GetCurrentDirectory in Excel?
10324:
Worksheet Change from Add-In
10325:
Count Sum Problem
10326:
cell is merged and contains "something"
10327:
how to add
10328:
Microsoft Office 2003 Web Services Toolkit 2.01
10329:
Excel Macros: Sort which is not Worksheet Specific
10330:
format cells so they do not resize
10331:
default fill color
10332:
Rows & Columns Disaggregation Help
10333:
Making code global in workbook
10334:
Excel file open in memory?
10335:
How come VBA if clause fails?
10336:
New user and need help
10337:
Linking rows on multiple worksheets
10338:
consolidating workbooks(not sheets)
10339:
Check column for a value and if not there execute series of functi
10340:
Pasting while in edit mode
10341:
Is Active Cell in a Range?
10342:
Protection on a sheet type thats new to me!
10343:
UDF and dynamic range
10344:
select and delete all pictures in a given range
10345:
Skipping empty cells for a Range object?
10346:
Indirect.ext Function Isn't Working for me
10347:
How to create msg box if a cell contains value < 0
10348:
Run procedure from worksheet change event
10349:
Can a For statement work in reverse (from 40 to 1)
10350:
multiple if then statements
10351:
Analysis of 2 groups?
10352:
Digital Certificate Question - Help
10353:
Automation of report, daily, monthly then yearly as per need
10354:
Running total of Found Substrings in MainString in Big Loop
10355:
Copy data from Microsoft Word form into Excel
10356:
cell data
10357:
Make sense out of right-click class module
10358:
Can't save any more in Excel 2007 Compatibility Mode
10359:
VBA code executes fine, but compiler throws error. Huh?
10360:
perform the same calculation in several spreadsheets
10361:
Comment Automargins property
10362:
User form
10363:
Print causes crash
10364:
F9 not working with SumByColor
10365:
Run Time Error '91'
10366:
Newbie floundering in the VBA code
10367:
Another runtime 1004 error
10368:
InserPictureInRange method for excel VBA
10369:
Blatt-Schutz und Zellen formatieren
10370:
find a string in one cells
10371:
events
10372:
DAO Syntax Problem
10373:
VBA to delete leading space
10374:
Disappearing Userform Label
10375:
Help with VBA runtime error
10376:
Activate an variable located workbook and copy 2 ranges?
10377:
GETPIVOTDATA with date in referenced cell
10378:
Email .From
10379:
ComboBox search for variable...
10380:
Logical functions AND,OR in array formulas work ?
10381:
Creating Outlook Task from Excel
10382:
Executing a macro
10383:
how to display cell value in formula
10384:
searching for shapes
10385:
On Cell click, start macro
10386:
On Cell click, start macro
10387:
.NET and Python Programming with Resolver One Spreadsheet
10388:
VLookup if criteria matched
10389:
How to concatenate in macro across sheets
10390:
Pivot Table Deconstruction
10391:
Protect part of Insert comment
10392:
Pay Reconciliation
10393:
ask user to select a target sheet as an input for a macro
10394:
vlookup - table array in cell
10395:
'Moving cells'
10396:
Scroll function in VBA
10397:
Retain focus of IE using DocumentComplete
10398:
Is there a fancy way to open a workbook in a minimized window stat
10399:
trouble loading a range into a comboBox
10400:
Reading data from PPT and purge data to Excel and image
10401:
still get runtime error 424
10402:
Is Pivot table the way to go?
10403:
Access Fields in Lotus Notes DB Forms
10404:
Dumb newbie Q re. passing cell addresses to a UDF.
10405:
run time error 424 object required - how to load control on Userfo
10406:
Open "Insert Hyperlink" popup window with VBA?
10407:
Prevent rows from being selected
10408:
Delete Rows based on cell value
10409:
Excel spread sheets do not close from vb.net
10410:
Pivot tables - how to hide the total row?
10411:
multidimensional array
10412:
Excel Macro Help for Charts
10413:
Fill down a row
10414:
Excel Macro for Charts
10415:
getting Runtime Error 1004
10416:
Cell Content
10417:
How can I see assembly code for VBA routine?
10418:
Custom Cell Format Question
10419:
Simple Code but slow
10420:
Looping through a range
10421:
Using Case and referencing a cell instead of a value
10422:
Covert Columns to rows Macro
10423:
Unwanted recalculation of UDF while running a Replace-statement
10424:
Conditional Formatting in a For Each Worksheet Loop
10425:
DAO connection problem
10426:
Dynsmic Charts
10427:
SQL Not In Query Problem
10428:
Macro Help - ASAP - Please!
10429:
How do I change Date Format ??
10430:
Autoformat screws up with FormatConditions?
10431:
VBA to create button on sheet after copy and to change the caption
10432:
is blank
10433:
VBA code to find macros associated with command buttons in an s/s
10434:
conditional formatting
10435:
Combo box help
10436:
Track Changes Data
10437:
copy a dynamic column range in macro?
10438:
Lookup in numerous sheets
10439:
Find end of number and copy/paste 5 columns
10440:
Coping Range from another Excel file
10441:
Excel automation on server
10442:
Macro codes automatically opens when opening a excel file
10443:
assign value to cell on different sheet
10444:
Help with the following code...from EntireRow to set width
10445:
VBA and PDF files
10446:
Range values not being copied with same number of significant digits
10447:
Excel spreadsheeet
10448:
Auto Mail
10449:
VBA Module Function???
10450:
Linking Worksheets
10451:
Excel Sorting - Finding Duplicate Entries
10452:
Tracking changes in sheets
10453:
NG and Word
10454:
Microsoft Excel Triggers Microsoft Word
10455:
Complex macro issue
10456:
Source Code control vba
10457:
cell change
10458:
Formatting UserForm Text Field as Numeric
10459:
Assign cell to checkbox
10460:
Spin button
10461:
Worksheet event to change formatting when date expires.
10462:
Getting Chart Cursor information in Excel 2003
10463:
Locking Cells
10464:
Getting Chart "Cursor" information in Excel 2003
10465:
Formula to ask what Time/Date it is.
10466:
Property in lowercase
10467:
Getting Chart "Cursor" information j
10468:
SUBTOTAL SUM AND AVERAGE
10469:
Extreme calculations
10470:
Macro not running in Protect Sheet
10471:
Macro not running in Protect Sheet
10472:
How to write VBA code to make backup copy in another folder
10473:
Drawing a Flow Chart / Schematic / (tree diagram?)
10474:
Macro doesnt work from another sheet
10475:
VBScript Event Sink Not Firing
10476:
Dropd Down (validation: list) on the fly with a code - a problem
10477:
Macro / vb query
10478:
VBA time and date?
10479:
Determining number of columns of 2 different ranges
10480:
Appending multiple columns into a new worksheet
10481:
Slow Macro...Takes at least 1 Hour to Run
10482:
exporting to a server
10483:
odd vlookup solution required - can you rise to the challenge?!
10484:
How to change column size in VB6 and Excel 2002
10485:
ActiveWorkbook.SaveAs
10486:
Using MS Query to do a Jion for pivot table data
10487:
Excel List Box
10488:
Combining two ideas?
10489:
Converstion of Complex Word VBA macro to Excel Macro
10490:
"show office assistant" greyed out; code suspect
10491:
maximizing the size of a UserForm
10492:
Run Macro
10493:
Capture Events on programmatically generated Charts
10494:
Save from exe file to csv file
10495:
I just want to add a W!
10496:
visual basic Loop by rows in Excel
10497:
Deactivate / Reactivate the Paste Function in excel
10498:
Changing cell data with macro--HELP!!!!
10499:
Text format in "Concatenate" function
10500:
Excel automation issue---enter date into cell based on other cell