TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Programming Archive
‹
Page 71
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
385
386
387
388
389
390
391
392
393
394
view full version:
back to formated view
24501:
VBA colorscale and color #
24502:
test
24503:
how to define a range
24504:
how to define a range
24505:
Mouse point
24506:
Transpose problem
24507:
how to define a range in VBA
24508:
how to define a range
24509:
Problems with MkDir
24510:
AutoFill question
24511:
Hope to stock data at every single update&all the sheets stocking synchronized
24512:
password problem
24513:
List folders but not sub folders
24514:
Create list of folders
24515:
AutoFit Looks Terrible
24516:
Hope to stock data at every single update&all the sheets stocking synchronized
24517:
Hope to stock data at every single update&all the sheets stocking synchronized
24518:
HOW CAN I UPDATE DATA OF SHEET1 TO SHEET2
24519:
Using custom properties
24520:
Import data from Outlook 2003 to Excel 2003
24521:
Current Time
24522:
Ignore formula
24523:
Empty/Delete Cells in a Column
24524:
apply Macro to all sheets in workbook - loop
24525:
How to Track Current Time of different GMT
24526:
Add subtotal formula to empty cells
24527:
Control search/replace dialog startup values
24528:
Tracking Time Zone
24529:
Getting VB List Box Selections to show in an excel spreadsheet cel
24530:
transpose skip 0's and blanks
24531:
How to get the path where a shortcut of an Excel sheet is located
24532:
Stupid Dancing Forms Controls
24533:
Help Importing using GetOpenFilename
24534:
while deleting rows it finds an error - error trapping
24535:
minimize workbook
24536:
How do I get solver to excute more than one time
24537:
only deletes first row with a blank cell in column "M" con't
24538:
minimize just opened workbook window
24539:
only deletes first row with a blank cell in column "M"
24540:
Pulling Data From PivotTable
24541:
Replacing Code with words using vlookup
24542:
Outlook/Excel return code to know if Sender pressed the SEND butto
24543:
script does not delete blank rows
24544:
conditional formatting
24545:
test
24546:
Naming Worksheets and Footers
24547:
Array with OR condition and multiple criteria tests
24548:
Sheet Tabs.
24549:
Pivot Table
24550:
I want to Protect VBA Code
24551:
How to conditionally determine Workbook save compatibility in VBA?
24552:
runtime 1004 error on deleting rows with blank cells
24553:
CAN ANYONE GIVE ME VB CODE TO REMOVE INITIALS FROM A NAME AND ATTACH IT TO THE END OF THE NAME??
24554:
VLOOKUP Woes
24555:
Autofill macro help!!
24556:
Listbox AddItem problem
24557:
Macro to autofill text help!
24558:
Data logging with a DDE link and VBA
24559:
Clear cell data using Combo Box
24560:
delete rows with null values in "M" column
24561:
Save As Part 2
24562:
macro print area
24563:
delete a cell with a null value in column n
24564:
replace method using ReplaceFormat .....
24565:
Sheet Tabs.
24566:
Determine qty charged per month
24567:
Help with Formula
24568:
Grab PivotField Data When Not in PivotTable
24569:
Formula Help
24570:
Changed Linked Cell
24571:
How to retrieve the activesheet of an Excel file using OleDbConnec
24572:
Getting the User Name
24573:
Statistical summary of bucketed data
24574:
Help setting PivotItems...
24575:
2-character limit on InputBox
24576:
VB Editor References
24577:
Creating a series from multiple columns and (multiple) files
24578:
UDF returning a 2 dimentional array
24579:
Corresponding Data From PivotTable Field List
24580:
slope function with matrix columns as arguments
24581:
UDF returning a 2 dimentional array
24582:
runtime error '1004' application or object defined error
24583:
Listbox
24584:
Error indexing worksheet
24585:
Deleting contents from merged cells from VBA
24586:
Flush Memory/Cache Clear:
24587:
Help with VBA
24588:
Help with VBA
24589:
Help with VBA
24590:
Double click item in Listbox to select item and close Listbox
24591:
getURL or open
24592:
a range of cells to UserVal...
24593:
Help with VBA
24594:
Visual Basic code
24595:
Activate a worksheet and paste / Import a code
24596:
Help with Drop-down control
24597:
Tough for me - Import 30 macros from one excel file to another in one step
24598:
Tough for me - Import 30 macros from one excel file to another in one step
24599:
2 questions: Macro Mapping & Active Chart
24600:
Read Lotus mail from excel
24601:
Go to a specific cell when selecting an entry in a validation list
24602:
Display 0 in the cells...
24603:
Display 0 in the cells...
24604:
Help creating a proper loop
24605:
Listen to "rename sheet" event in excel
24606:
TRANSPOSE WITHOUT ZEROES(0's)
24607:
Filling in Numbers on Forms
24608:
Need help with VB code to find certain values & select changing va
24609:
Summation of latest running 3 month total
24610:
Inserting Multiple Columns
24611:
How to call a soap web service in excel 2007
24612:
Problem with Web Query
24613:
VBA References
24614:
Hope to stock data at every single update&all the sheets stocking synchronized
24615:
Error message in Web Query written in VBA
24616:
refreshing web query
24617:
style propertie causing excel not being released
24618:
macro to check file open
24619:
Return Excel's current security setting
24620:
NEED VB CODE TO REMOVE INITIALS FROM A NAME AND ATTACH IT TO THE END OF THE NAME
24621:
Solution to your problems
24622:
Hope to stock data at every single update&all the sheets stocking synchronized
24623:
Hope to stock data at every single update&all the sheets stocking synchronized
24624:
userform textbox to variable
24625:
Fill function to next cells
24626:
How to convert philippine currency to english words
24627:
PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO THE END OF THE NAME
24628:
PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO THE END OF THE NAME
24629:
Create Sub Directories From Excel Column via Macro
24630:
Copy paste error
24631:
Display all items in outlook 2003 folder
24632:
pastespecial
24633:
force update/"refresh" of cell & workbook_open?
24634:
How to Disable Ctrl+Break?
24635:
Deleting Worksheets
24636:
From Office 2003 to Office 2007
24637:
Setting Windows Timers for a specific time
24638:
Cancel = True not turning edit feature off
24639:
Office Automation through C#.Net (with out save option, ctrl-s and mouse click disabled)
24640:
msgbox text vbyesno
24641:
Flush Memory/Cache Clear:
24642:
Spreadsheet getting corrupted
24643:
Moving Excel Chart to Powerpoint (getting runtime error 91)
24644:
copy sheet from Server URL
24645:
Click on a cell to get a check mark then...
24646:
Calculation based on entry into one of 2 cells
24647:
problems adding Rich Text Box control to a VBA form?
24648:
Flushing Memory/Cache Clear:
24649:
NEED VB TO REMOVE INITIALS FROM A NAME
24650:
NEED VB TO REMOVE INITIALS FROM A NAME
24651:
change contents of cell to another cell's value via macro or??
24652:
Macro to return averages within a column
24653:
Counta with VBA -
24654:
Changing Sheet Names
24655:
remove embedded images from a spreadsheet
24656:
Need Help with an Excel App to Submit information to a Webservice.
24657:
Web Query Without URL
24658:
create a macro to delete columns and then border remaining columns
24659:
Data validation on different sheets?
24660:
subscript out of range error in Excel 2007 at Vista
24661:
Reset Sheet name tracking number
24662:
refedit column
24663:
Refedits / Autotab
24664:
Userforms in Excel 2003
24665:
Userforms in Excel 2003
24666:
Compare sheets
24667:
Divide existing data in cell
24668:
Adjusting scale of an adjsuting chart
24669:
Before Save
24670:
Dynamic Ranges & Invisible Offset
24671:
Numeric TExt Into SQL Server
24672:
Flushing Memory/Cache Clear:
24673:
continous assessment help with vba
24674:
Selecting cells for a desired result
24675:
VBA help needed please
24676:
Error Handle: File is already open.
24677:
Concatenate question
24678:
Latest running 3 month total
24679:
DateAdd question
24680:
Errors 3705 and 3709...
24681:
How to listen to "rename sheet"
24682:
Best place to learn VB online
24683:
How to develop a "Shpping Cart"
24684:
Selecting ranges in macros
24685:
Editing Recorded Macros in Excel - VB
24686:
Grouping/Collapsing lines in VBA editor - xl2000
24687:
How to stop multiple refreshes on worksheet
24688:
Chart Titles - Thanks
24689:
Cell should show "0" as character....
24690:
VBA - Trying to insert records
24691:
Memory/Cache Clear:
24692:
Looking for Ideas - Page Breaks
24693:
Need help saving to multiple locations
24694:
Warning when saving in Excel 03 running on XP
24695:
VBA question: Condense cell contents to first character
24696:
e-mail macro
24697:
Syntax Problem
24698:
Linking custom toolbar to personal.xls
24699:
How2 automatic refresh advanced filter based on validation list?
24700:
A macro to change font size
24701:
Use a List to Generate Worksheets
24702:
jump into the loop
24703:
Macro fails to select pivotitems
24704:
Code snippets for custom menu
24705:
Macro keyboard shortcut problem
24706:
Macros stopped working
24707:
Pivot Table Columns force visible
24708:
error handling question
24709:
Custom Software Development
24710:
How to call out "other" open book
24711:
automatically change column references in formulas
24712:
Message box for overdue dates
24713:
Hide Sheets in the Work book....
24714:
Delete shapes, not buttons
24715:
Document Level Project in VSTO 2005 For Excel 2003
24716:
Open an excel-file from the web
24717:
Copy Data from Excel 2007 XLSM workbook to Excel 2003 XLS workbook using ADO
24718:
Embed image in excel
24719:
COUNT IF + using 2 sets of data
24720:
UserForm Pointers & Class Modules
24721:
PExcel AddIn hangs when trying to access data programatically
24722:
Escaping Quotes problem
24723:
Check current location
24724:
Excel Form data to closed workbook
24725:
Creating A Text File From Single Column Via Macro
24726:
xl2007 Application.FileSearch
24727:
create messagebox when a date is overdue
24728:
Do we have time for yet another Sort problem?
24729:
Big Idea lacking enough knowledge
24730:
Trend Analysis/coefficient of differentiation formula
24731:
Run a query with two tables connecting to two different ODBC
24732:
Delete break line between column A & B
24733:
Excel/VBA 2007 Problem
24734:
VBA to Copy Range
24735:
Scroll Bar/Chart links in Excel 2007
24736:
[Music Movies Soft] Free binaries search & download = www.GEGEREKA.com
24737:
How to intercept each pressed key
24738:
Summary Sheet
24739:
How to get the current path
24740:
How to transfer a ListBox to a function
24741:
Double Lookup Without Exact Match-Price Breaks
24742:
Sort order via excel userform combobox
24743:
put a procedure into comments with code
24744:
Custom Position UserForm
24745:
Transpose cells skipping blanks
24746:
Bottom border for each row code not working
24747:
Merged Cells ' Range height
24748:
name_range auto filter
24749:
Excel 2007 referencing other wb
24750:
Using Find and FindNext to Format Cell Text
24751:
Userform picture
24752:
RowSource as a row
24753:
a macro...for a virgin sheet
24754:
Marco Help
24755:
macro Help
24756:
Programing a code
24757:
Help with summing.
24758:
Excel: Using Look up to return multiple corresponding values
24759:
Search for value move to next column code not working
24760:
Countif with parameters from another range?
24761:
Excel bug
24762:
multiple workbooks
24763:
Convert number to nearest multiple of Five
24764:
Delete from the bottom up
24765:
Control Q
24766:
THE LORD OF DOWNLOADS: MP3,Movies,Soft = www.GEGEREKA.com
24767:
Pop Calendar Fixed
24768:
Array with unknown elements(apologies if reposted)
24769:
Macro to run based on drop down list
24770:
Unknown element array
24771:
Complex Copy/Paste HELP....
24772:
Excel, WordPad and DDE
24773:
Complex Copy/Paste help
24774:
Extract all non-table data from Word
24775:
Import MS Access data into MS Excel using VBA...
24776:
How do you insert wingdings symbols using VBA macro?
24777:
Subtotal Macro Help
24778:
Sorting a data list with a variable
24779:
How to get the index in VBA of the selected item in a ListBox
24780:
VBA Question: IF value in M >0, set O="Delete"
24781:
Free Software search and download = www.GEGEREKA.com
24782:
short message box
24783:
Complex Copy/Paste help
24784:
Calculate Sets and Subsets
24785:
Help or Information about Microsfot Excel Aplication Objet model
24786:
ADODB Create New Database from Excel
24787:
Excel does not execute a button's code when another macro simulates mouse movements & clicks
24788:
Copying Worksheets Question
24789:
ignore first 10 characters with find and replace
24790:
Formula Change
24791:
DisplayHeadings
24792:
Open WB
24793:
Is there a limit on the length of a PrintArea?
24794:
Lookup latest entry
24795:
MP3 MPEG AVI DIVX ; DLL EXE ZIP SOFT = www.GEGEREKA.com
24796:
GetOpenFilename in Windows Excel 97 bug?
24797:
Order of Add-Ins Loaded By Excel
24798:
Ideas for "linking" rows for printing.
24799:
Opening another workbook while current one is open
24800:
downloading query generated csv file
24801:
Copy and paste between sheets error
24802:
Create Pop Ups
24803:
Convert .CSV format to .XLS format in C#
24804:
microsoft map is no longer associated with microsoft excel
24805:
Writing code for Events in Class
24806:
String in a range
24807:
(auto)filter on row
24808:
Copy From One Column to Text File
24809:
NEED VB TO FILL A ROW WITH ABSOLUTE CELL REFERENCE
24810:
Visual basic code query
24811:
MP3 AVI DIVX MPEG SOFT = www.GEGEREKA.com
24812:
replace text string in cell automatically
24813:
URGENT: #REF! ERROR WHEN COPY AND PASTED
24814:
Better way than Nesting, or other solutions
24815:
"Getting Rid Of Save Prompt On Quit Command"
24816:
Edit Ribbon
24817:
clear defined named cells' contents
24818:
Merging data
24819:
VBA in Excel for Pivot Table Selection (want to use a variable)
24820:
Set Source two Worksheets
24821:
Error When using ActiveWorkBook.SaveAs and EnableEvents in same macro
24822:
Find and Format code doesn't work
24823:
Cross-sheet hyperlinking, data insert,lookup
24824:
#REF! ERROR IN EXCEL97 WHEN TRIED TO COPY AND PASTE A RANGE
24825:
Pop Up Excel Calendar VBA CODE
24826:
Macro Suggestion
24827:
Select Case syntax
24828:
Add text change row colour
24829:
copying hyperlinks to another sheet
24830:
Color
24831:
Color
24832:
Changed module names don't register in toolbar links
24833:
red "X" disable
24834:
workbook open event
24835:
Highlight Highest number
24836:
Extreme opening time of workbook (15 minutes)
24837:
How to disable cell entry ?
24838:
disable the red "x" @ top right coner
24839:
Select and Save as
24840:
Page break Page number
24841:
Open workbook with the same sheet every time
24842:
Help Required
24843:
pasting values only
24844:
file edit view insert etc disable
24845:
populate listbox as textbox changes question
24846:
Need help with recorded macro
24847:
Change pivot source w/o refresh? Can't change original/copied pivo
24848:
Maximized or minimize
24849:
Delete macros
24850:
Set bk = Workbooks(...)