TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Programming Archive
‹
Page 77
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
26601:
darn these quotes.. please help
26602:
Referencing Worksheet code name in the following code
26603:
UNDO and REDO buttons are inactive
26604:
Triggering Change_Events after Form Initialization
26605:
Data analysis: Detection and removal of outliers
26606:
How to create menu/toolbar item with picture?
26607:
e-mails not recorded in Sent messages
26608:
Help - can't understand why this doesn't work
26609:
Need help to convert date from dd/mm/yyyy to mm/dd/yyyy
26610:
GetOpenFilename
26611:
inputting American dates into an English workbook
26612:
running Excel VBA macro from SQL Server
26613:
Worksheet macro to copy formats and formula from discrete ranges
26614:
QUERY FOR TODAY RECORDS
26615:
Difficult Question about averages... Possibly Nested loops...
26616:
Macro that moves data "From Akash"
26617:
How to Debug User Defined Functions
26618:
Error in Code
26619:
Autosize bug workarounds in Excel 2007 shape textframes
26620:
Match numerical data using excel VBA
26621:
Statement not to update the file while opening through Macro
26622:
Advice on including Help files for UDFs in a Add-In
26623:
Excel VBA Reference to Forms Object Library (to be unchecked)
26624:
REname Pivot table columns
26625:
Autosize bug in Excel 2007 shape textframes
26626:
Double Space in Text Box or Excel Cell
26627:
Excel 2007: deleting macro from personal.xlsb
26628:
Specify which rows to NOT hide, and have excel hide the rest
26629:
Excel data numeric type read problem
26630:
Excel data numeric type read problem
26631:
Multi select with doubleclick event
26632:
shading cells trouble
26633:
Using a macro to hide columns
26634:
Copy/Paste problem in Excel 2007
26635:
Active X combo box help
26636:
Excel Format Cells Numeric Currency VBA
26637:
Excel Format Cells Numeric Currency VBA
26638:
Printing Excel Sheet
26639:
Access Excel Solver from a C# Add-in
26640:
VBA code to read formular from another cell
26641:
Populating cells based on a combobox OnChange Event
26642:
ComboBox Problems
26643:
"Stair-Stepped" Commissions Question.
26644:
How to enumerate controls on a worksheet in Excel 2003
26645:
Calling an Object using variables (What am I doing wrong????)
26646:
Active X combo box help
26647:
setting a variable equal to a value from a pivot table
26648:
What's wrong with my code? Thanks
26649:
MACROS 2
26650:
Populate A Userform ComboBox
26651:
QueryTable Lookup
26652:
another array approach question
26653:
Alternatives to Excel VBA (Query Tables returning more than a million rows)
26654:
MACROS
26655:
Sumproduct
26656:
Using Excel as a scheduling program.
26657:
Chartspace
26658:
find and update
26659:
IE Integration
26660:
Autoheight adjustment for merged cells not changing
26661:
what does target.offset(0,-1).select mean here?
26662:
beforedoubleclick and selectionchange
26663:
Clear Office Clipboard from VBA?
26664:
array from range question
26665:
Problem with Auto Filter and Macro
26666:
Delete all files except...
26667:
Executing a VBA macro from within Excel 97 script
26668:
PrintPreview in 2007 (for what it's worth...)
26669:
IE integration
26670:
getpivoitdata and assign to a variable
26671:
Command Button to email worksheets
26672:
Consolidate Rows?
26673:
Compare 2 series of columns (Combinations)
26674:
pulling data from a pivot table and assigning it to a vairable
26675:
Better looking command buttons on a worksheet
26676:
Macro to select a list of values greater than or equal to a value
26677:
If Conditional formatting
26678:
conditional formatting to print
26679:
Adding a Custom menu / sub menu
26680:
Save as filename
26681:
hide column
26682:
Pivot Tables and percentages
26683:
How would one merge this into 1 cell
26684:
Excel VBA - Sending email
26685:
Custom Button and End Users
26686:
hidden character in string
26687:
Digital certificate in outlook
26688:
Macro cannot be found in Read only modus
26689:
crash on close
26690:
Sorting chart by name
26691:
password recovery
26692:
VLOOKUP Trouble
26693:
Calendar Control - Years
26694:
Stopping copying and emailing of a Excel File
26695:
Break Links Macro help...
26696:
Using OE to post and read newsgroups
26697:
E - Mail when sheet updates - hyperlinking !
26698:
Sorting by chart name
26699:
Moving a worksheet to a new workbook when you do not know the name of worksheet
26700:
List of pivotitem visible
26701:
Extracting Specific dimensions/values from multidimensional array
26702:
Control box/Command buttons
26703:
Select Range Name Q
26704:
Pivot Query
26705:
Setting Variables
26706:
Using COUNTIF with an AND? Or is it something different?
26707:
Object Required Error
26708:
how to autofill a consecutive cells in a column?
26709:
command which returns the position of cell
26710:
How do I get this to look at a date and loop down all the info?
26711:
ranging the filter cells when doing auto filter
26712:
Excel2007 to DBASE4
26713:
help! Why my code can't work in excel 97
26714:
AutoFilter Criteria in VBA
26715:
2B or not 2B? - Go to cell Bx, depending on what row is selected
26716:
Cell format reverts to a custom date after change to General
26717:
Alert 'Micosoft Forms' when Closing application
26718:
User Date Picker rather than Input Box
26719:
Show worksheet from cmd button on userform
26720:
How do I assign a value cell in a column that has a dynamic row va
26721:
How to capitilize automatically?
26722:
relating 2 sheets
26723:
Create email from cells in Excel?
26724:
Excel web querying stock and mutual fund info?
26725:
running some VBA code in response to data entered in a cell
26726:
VBA to Fix Dates
26727:
Macro security bypass for one application
26728:
Is there a code?
26729:
auto set time(now) if criteria=true with no later change
26730:
High Security setting
26731:
Setting RGB colors for a set of cells.
26732:
Excel Prints the Page as a Tiny Little Square
26733:
Insert a comment on ComboBox double click
26734:
Macro step wasn't recorded
26735:
Copy from Word into Excel pastes wrong picture
26736:
MS query criteria - referencing a cell on a spreadsheet
26737:
Locking a TextBox in a userform
26738:
Test for Disable / Enable Macros
26739:
SELECTING TABLES & PATHS
26740:
not calling
26741:
Autofilling INPUTBOX
26742:
put inputbox input into a cell
26743:
Multiple column find
26744:
Help with userform labels
26745:
How to programmatically create range for solver?
26746:
My 3rd Msgbox is popping up in wrong position
26747:
PrintPreview problem
26748:
Use A Command Button more than one time
26749:
Prompting user to enter number of cells to be used
26750:
Size Matters - minimizing file size
26751:
email forms
26752:
Odd macro behavior
26753:
BeforeSave, Cancel and ReadOnly
26754:
Find data in other worksheet
26755:
Comparing two dates using between.
26756:
Selecting an array of worksheets for printing
26757:
Totalling Formulas
26758:
Formatting a TextBox on a UserForm
26759:
SQL Syntax Error
26760:
Displaying part of a worksheet in another worksheet
26761:
Loop & Accumilate e-mail addresses to send to
26762:
Attach Macro to single worksheet
26763:
code cleaner
26764:
ChangeLink with Worksheet Named Ranges as Arguments
26765:
Sort Macro
26766:
Column Autofit
26767:
How do i set the value "TRUE" as "YES" in excel
26768:
Dumb as a rock concerning VBA/Macros
26769:
Primary Programming Language for Excel 2007
26770:
Data Connection
26771:
macro to copy and paste
26772:
how to remove linebreaks in cells with VBA
26773:
find replace within sheet or workbook
26774:
Borders
26775:
Simple addition problem
26776:
How do i create a list of files per directory?
26777:
Sending task to Outlook from Excel
26778:
Excel
26779:
create chart in worksheet but hide the data from user
26780:
Excel crashes when I try to save workbook
26781:
Help with code (delete range)
26782:
new worksheet with 4 columns only
26783:
Using Solver with Excel 2007 VBA
26784:
Find 1st empty cell within each row
26785:
Returning a value forom a Module to a Userform
26786:
AutoFill Row Numbers & Print Area
26787:
Required Fields for many Text boxes on a userform
26788:
REPEAT NTH ROWS
26789:
Getting data for pivot table from another spreadsheet
26790:
parsing a string
26791:
Re: Changing cell text color based on cell number
26792:
Re: Changing cell text color based on cell number
26793:
Numeric or null value
26794:
Excel formula not displaying a number
26795:
Obtain Cell Formatting in Cell Referencing?
26796:
Cut time from string ?
26797:
Connection from Excel to SQL
26798:
stop application {on keys}
26799:
for Tom Ogilvy Please
26800:
Excel solver newbie question
26801:
Dynamic Userform Controls not Displaying
26802:
Passing table to web service
26803:
No Dir in Spreadsheet Referencing of Cells
26804:
Updating original data from vlookup screen (macro?)
26805:
Removing selection and maintaining formatting
26806:
Error 91: Object Variable Not Set
26807:
error 91: Object Variable not set
26808:
text trigger
26809:
faster way to save/restore a worksheet in MS Access
26810:
Remove validation
26811:
Calculating Commissions
26812:
Copy Merged Cells to Single Cells ??
26813:
Code for Select a file and save it in a different location
26814:
Worksheet events
26815:
Date format in an XML export
26816:
CAN I ADD CONTROLX BUTTON TO CUSTOMISED TOOLBARS
26817:
OK I admit that I can not make a Command Button work
26818:
How do i hide the main title bar in excel 2007
26819:
NOVICE with text and list box queries
26820:
I am so close....if null add new problem
26821:
Finding a Minimum Number other than Zero within a Range
26822:
Offset from end of a selection
26823:
Excel cursor
26824:
Check available pagesize
26825:
please help!
26826:
column copy
26827:
Selecting last pasted object
26828:
problem with code
26829:
Column lookups of specified numbers
26830:
Userform Position exactly adjacent to Cell A 46
26831:
Create a copy - Worksheet
26832:
Parsing Data String from text file line
26833:
Find and Replace Row
26834:
automatically deleting a worksheet (without warning prompt)
26835:
removing links between workbooks
26836:
View panel
26837:
how can add a wordin the same sheet
26838:
ActiveCell
26839:
Close workbook without alerts
26840:
HELP
26841:
Capture cell address in UDF
26842:
Check if a workbook has an "open password"
26843:
IfError Help
26844:
Bitwise comparison question
26845:
Macro's
26846:
Active Cell Filling
26847:
Exporting code modules
26848:
Group a range - closing the group does not hide the controls....
26849:
macro v active x control
26850:
Dynamic chart
26851:
UserInterfaceOnly question.
26852:
confine text to cell
26853:
Looping through a specific column
26854:
Resizing Userform
26855:
Preventing Duplicates...
26856:
Multiselect on Listbox and Click Event
26857:
Turn off highlight on Listbox after click_event
26858:
Remove Trailing Comma
26859:
top values within subtotals
26860:
Insert page break & merge text in 2 rows
26861:
Pop-up calendar with protected sheet
26862:
Using Cell Data in Multiple Places
26863:
Control Hierarchies in Userforms
26864:
Exporting XML data (encoding question)
26865:
Selecting an entire column
26866:
Advanced Filtering on an inactive sheet
26867:
FormulaR1C1 problem
26868:
Having problems w/ Solver code
26869:
Loan calculator- Payment
26870:
.Find and With stmts
26871:
Activate previous Workbook
26872:
Adding text to Formula result in VBA?
26873:
How to calculate Number of rows in Excel ?
26874:
Getting reference to an OLEObject from another cell?
26875:
Validation Drop Downs within a List
26876:
Validation based on digits in the middle of a string
26877:
range.offset(0,1) is OK but range.offset(0,2) not
26878:
addnew
26879:
DoneEx Removal
26880:
Listing
26881:
Needing Help
26882:
Tooltip for Shape/Picture?
26883:
Predictions with Excell
26884:
Copy chart to clipboard - VBA
26885:
1 Dynamic Userform vs Multiple Userforms
26886:
Help with a "delete rows" Macro
26887:
Vlookup "contains"
26888:
Protecting VB Code
26889:
A Sheet by any other name.....
26890:
Excel Stored Dates
26891:
Spinner and Date What the heck is happening?
26892:
delete macro from vbs
26893:
webquery URL with brackets
26894:
How do I find cells with invalid data and true conditional formatt
26895:
Projects accumulate in Project Explorer
26896:
Adding two characters in front plus three in back
26897:
Is there a way to do this?
26898:
Sending information from a cell in excel to a task in outlook
26899:
application run - macros within macros
26900:
Calling sub from CommandButton knowing which sheet is active
26901:
Command Button Tooltips
26902:
Biggie for me
26903:
Excel macro that deletes all rows which doesn't contain the character "|"
26904:
Yet Another Macro Question
26905:
determine if Pivot Table field item is hidden
26906:
Copy values (loop) from TXT file to excel
26907:
Running code from form button
26908:
addnew
26909:
Strange Formular for OLE
26910:
Excel Macro, slow performance on terminal server...
26911:
Excel 2007 Ribbon Check custom buttons
26912:
Check Box Control
26913:
Propogate information based on cell contents
26914:
Problem with Vlookup
26915:
Command button
26916:
Search Folder for Files
26917:
starting Solver with VBA
26918:
script to send data from worksheet to multiple workbooks
26919:
Random Numbers
26920:
Need help with checkbox to select recipients of an E Maiil via Lotus Notes
26921:
How unprotech .XLS if we dont't have password?
26922:
Selecting the one with the bigest amount
26923:
PivotTable CommandTimeout
26924:
Unload a Userform created in VB6
26925:
open all workbooks in a folder
26926:
Another Stock Macro Question
26927:
BRAND NEW USER -: PROBLEMS WITH LIST AND TEXT BOX INPUT
26928:
Publish as Web Page with Password
26929:
Adapt sheet Protection
26930:
calification analisys
26931:
If cell is changed clear all cells to the right in that row
26932:
Help with copy and pasting
26933:
ComboBox1 is DELETED(!?) when Me.Pictures(1).Delete runs in my macro
26934:
MailEnvelope
26935:
Trigger Email with Excel File Closed
26936:
toggle button in excel
26937:
How to locate Cell in which control resides
26938:
Create characters
26939:
Windows.RangeFromPoint method is not working properly
26940:
Pivot table showing #Num! error - SSAS2005 SP2
26941:
Shift + F2 problem
26942:
detect shape overlap?
26943:
automatic sorting selected data into acsending order
26944:
Re: can someone help me with these 8 lines of code
26945:
Excel training from Rockhurst University Continuing Ed. for free
26946:
updating Excel.FormatCondition
26947:
Double clicking a Cell Programatically
26948:
can someone help me with these 8 lines of code
26949:
Help Please !!!
26950:
For-Each loop, I think.