TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Programming Archive
‹
Page 32
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
view full version:
back to formated view
10851:
user form and radio buttons
10852:
Find and Replace Macro
10853:
Calling AutoFit using C API's
10854:
Last Real Cell
10855:
VBA ReadyState basics
10856:
ie Command to Wait for "File Download" and "Save As" windows
10857:
Merge problem
10858:
Updating Date Field in Pivot Table with VBA Help
10859:
IF and ISBlank for a selected range of cells
10860:
getting error message 3704 when running excel vba
10861:
Macro on Current Row
10862:
How to save a project independent of a spreadsheet
10863:
Using VBA: Conditional Formatting of Row Color
10864:
Displaying Line #'s
10865:
Formatting a worksheet
10866:
locad password protected MS Access table
10867:
Highlighting Rows and Columns with Macro and VB
10868:
Column List to Multiple Columns
10869:
Change sheets within a read and write function...
10870:
Slow tabstrip
10871:
Column AutoFit C API
10872:
Find next empty row & paste data
10873:
FitToPagesWide
10874:
ListView - ItemClick - How to know column number
10875:
Macro to Edit Contents of Cell
10876:
Time Calculation w/ Macro
10877:
Export records into a text file based on criteria
10878:
Creating a list box
10879:
Get numbers from cell
10880:
load list data
10881:
ByRef argument type mismatch when passing dictionary object
10882:
Vlookup to Return Cell Name Not Value?
10883:
do loop until empty cell
10884:
Overwrite conditional formatting
10885:
Problem with IE
10886:
Disable Ctrl- PAGEUP PAGEDWN
10887:
Find value in sheet 1 and copy matching row from sheet 2
10888:
Auto insert
10889:
Version Issues
10890:
Debugging Advice Wanted
10891:
How do you x-late GetTextExtentPoint32's units into the real world?
10892:
Can Search's default be changed to "By Columns"?
10893:
nested for each or something else??
10894:
Excel Add & Substract in One Cell
10895:
Check for incorrect characters
10896:
Extract Access records to new workbook using VBA in Excel
10897:
Extensive file damage.
10898:
Add data range to a specific tab based on "Sheet Name"
10899:
Tabstrip Tabs Width
10900:
Excel VBA functionality and SharePoint
10901:
Trust Access to Visual Basic Project - Access to Excel and back
10902:
Disabling SAVE AS Temporarily
10903:
Sub to delete only all damaged defined ranges in book
10904:
advanced lookup feature
10905:
vba structure
10906:
Conditionally format cells
10907:
How do you hide .....
10908:
Copy variable to clipboard
10909:
exception in excel while writting to it
10910:
reset a cell
10911:
Listbox help
10912:
finding UsedRange with sparse data
10913:
Outlook VB not working
10914:
I protect sheet - Macro will not run now
10915:
Excel 2007 ListBox missing last item
10916:
Userform - 100 checkbox (10X10)
10917:
Select Object Button
10918:
stock the header items of a .dbf file into a vector
10919:
Is 'IgnoreRemoteRequests' the same as....
10920:
Making a [semi] Dictator Application: Hiding Main Command Bar?
10921:
Sum variable ranges
10922:
VBA...No Subroutine Code
10923:
newbie - If a cell is blank
10924:
Printing worksheets
10925:
identifying multi-select items in a listbox
10926:
Dynamically Change Cell Contents From VB
10927:
Change Axis Title
10928:
AutoFit function
10929:
"next and "previous"button problem in vba
10930:
Automatic Calculating & Autofil in Various Tabs
10931:
loading another application from excel vba
10932:
Count positive value
10933:
import xml in excel workbok using VBA code
10934:
Spreadsheet Component
10935:
break apart pdf binder
10936:
Blank cells & formula cells
10937:
VBA to move and concatenate
10938:
VBA to Update Pivot Table
10939:
Importing Access to Excel
10940:
data entry
10941:
help with Run-time error '1004'
10942:
Target.Cells.Count
10943:
Target.
10944:
Need to know how data is grouped in PivotTables
10945:
Bypassing the Security Warning when opening Excel file
10946:
Font enlarge/reduce by 1 pt?
10947:
Trouble with code that is broken over multiple lines (space_)
10948:
Modify the IgnoreBlank property of the Validation object
10949:
Difference between two dates
10950:
Does a shape cover a cell ?
10951:
Macro to Paste Unformatted Text Into Excel
10952:
hard time with If InStr(1, ..
10953:
clear contents on linked sheet
10954:
Combo box the exludes blanks
10955:
working with images
10956:
How can i automate the response to a generated pop up?
10957:
Parameter Driven Query
10958:
Lots of similar buttons need to call a macro but need to find out
10959:
read xml and fill valuesin excel form combobox
10960:
Checking worksheet names
10961:
Creating different worksheets from a main worksheet
10962:
Clear entire rows below last row of data in col A except in 1st 3 sheets
10963:
Loop Till the end of used Cell
10964:
option button problem
10965:
Why doesn't the FindNext work inside a function ?
10966:
Forcing Move seelction to the right
10967:
Filldown top cell to last row with data in adjacent col
10968:
How can I see the Project Explorer and Code window together?
10969:
How to specify charset for queried data?
10970:
Get Lines Before and After Search Text
10971:
Returning column letter
10972:
excel multiple choice toggles
10973:
Password Protecting/Unprotecting Worksheets using VBA code?
10974:
Refreshing cell value
10975:
clear contents
10976:
variable not defined error
10977:
VBE Help: How to get list of all string functions?
10978:
text&formula coloring!
10979:
How to generate a text file from Excel using a macro or script?
10980:
How to generate a text file from Excel using a macro or script?
10981:
Synchronizing worksheets
10982:
How to validate path? --- bValidatePath ("") Then
10983:
Activate one Book then another Book
10984:
Problems adjusting column width
10985:
Tip # 12 Stretch out: Insert a line break in a cell
10986:
How to change the background colour on event?
10987:
Excel VBA : Find Method
10988:
Change rangre color with scroll bar
10989:
How do I select an option button using code
10990:
Rename active sheet
10991:
Read text into Excel
10992:
Repost of How to get Popup Text help to work
10993:
Hot to Get a Column Number from a column letter
10994:
hyperlink in Excel 2003
10995:
error running macro from Ribbon button
10996:
CONCATENATE preserving original formating
10997:
How can I list values in a combo box?
10998:
Series order vs Legend Order in Charts
10999:
I NEED AN EXCEL TEMPLATE FOR ANNUAL BUDGET CONTROL OF SMALL BUSIN
11000:
Worksheet Help
11001:
Custom View: hide/unhide does not work when worksheet is protected
11002:
Change UserForm font
11003:
Enable Auto Refresh Message Box
11004:
Turn AutoCalc before calc takes place
11005:
Adding help to a user defined function
11006:
read datas from XML to excel using VBAmacros
11007:
2008 federal payroll withholding tax
11008:
Choosing no when asked to overwrite an existing file?
11009:
incrementing a cell value
11010:
check box help!
11011:
creating hyperlink using the value of the cell
11012:
Make active cell a variable, return there later
11013:
CreateObject from Template
11014:
Formula for Finding Retail
11015:
Select first 5 visible rows
11016:
Can I find out if & where "Freeze Panes" is set
11017:
VBA function wont update in worksheet
11018:
Change Event
11019:
Select charts by "Chart Names"
11020:
ctrl-a
11021:
annunce: excelmailer 0.2
11022:
excel temp file
11023:
Exclude gray figures from sum
11024:
TextBox mismatch ..... calculation
11025:
Copy cell to empty cells below.
11026:
Protects running from VBA, but not from hot key
11027:
Hou would you optimize this code?
11028:
writing screens to enter data
11029:
How to find a matching row and Insert Data
11030:
Insert Multiple rows with data
11031:
About xml constructing
11032:
how do i create a macro that will print and save my file to sharep
11033:
How2 accept only numbers in userform textbox
11034:
HELP!!
11035:
2008 federal payroll withholding tax
11036:
Need user unable to unhide sheets
11037:
User Defined Record Compile Error
11038:
Disable auto-update
11039:
Date Range Macro
11040:
Populate Comment on the basis of Text Box Entry
11041:
2007 Ribbon dropdown
11042:
Duplicate items in ComboBox
11043:
merging cells using VB - Excel 2003
11044:
How do I Create a Macro to run VB Code in Excel?
11045:
Excel and Calendars
11046:
Change text in Textbox on Chart?
11047:
protected linked cell
11048:
Macro problems: Waiting for site to load and commanding Save to
11049:
Spread data and keep format
11050:
MACRO IS NOT COMPLETE
11051:
checkbox
11052:
Using VBA to send email to distribution list ... how to CC?
11053:
name box
11054:
programatically create new worksheet
11055:
Apply code to Icon
11056:
Find first blank cell
11057:
use a range variable in advanced filter
11058:
Last Empty Row in Range
11059:
"Move or Copy" sheet
11060:
Variable not Defined Compile error
11061:
Selecting multiple areas
11062:
Sheet Protection doesn't hold
11063:
Shapes!
11064:
Columns ranked by highest revenue
11065:
Repost: Copy Range from one wbk to another
11066:
Popup box appears based on cell value entered
11067:
Copy range from one workbook to another
11068:
Uninstall Add-ins when workbook closes
11069:
Unhide Worksheet with Login UserForm
11070:
Row Headings (cell number) on Rightside
11071:
VBA multiple events
11072:
Hide/Show Rows based on Cell Value with Data Validation
11073:
Activate woorkbook
11074:
reset pivot table name
11075:
First blank cell
11076:
Who last opened file?
11077:
Iteration Error
11078:
NEED ADDITION IN MACRO
11079:
VBA to save a chart as a GIF
11080:
Bug applying Borders to Range
11081:
Input Box code help
11082:
Help in vba
11083:
How I can get color (RGB value) from .ThemeColor + .TintAndShade?
11084:
Worksheet with some limits
11085:
How do I set a range to the currently selected cells?
11086:
Call function from other workbook.
11087:
label to display multi rows and colums on a userform
11088:
How to Refer to Another Excel Workbook
11089:
Protected VBA vs RibbonX question
11090:
How to get Popup Text help to work
11091:
min function trouble
11092:
How to enter a formula over 250 characters?
11093:
Trying to create dropdowns in excel using vb.net
11094:
What is the VBA function to return the greater of two integers?
11095:
Value transfered to cell differs from value in record set
11096:
Keep Losing VBAProject
11097:
Amend sub to re-hide comment when activecell change to another
11098:
Code not working since upgrade to 2007
11099:
Application Maximise event
11100:
HELP - Vlookup with referenced tab name
11101:
Help with an IF Formula
11102:
If B1=Level 1 then B2=10
11103:
If b1 = 1, then b2 = Yellow
11104:
Formlua Entry
11105:
Using ADO to import Access table
11106:
Conditional formatting cells with formulas = "DIV/0!"
11107:
using the calendar on a userform
11108:
Advanced transposing in Excel
11109:
countif formula
11110:
surpress leading and trail spaces
11111:
Finding max value
11112:
PT - list multiple page field selections
11113:
Loop Through Combo Boxes on Worksheet and in Workbook
11114:
exit sub if no data
11115:
Usage of StockQuote.MSNStockQuote in excel vba code
11116:
How to show zero values in conditional sums
11117:
Add code on the fly to existing userforms
11118:
PRINTING PAGES !
11119:
writing to a table in wrod from excel
11120:
Select or Enter into a TextBox on a UserForm
11121:
Date format text conversion
11122:
Linking to specific pages in a PDF
11123:
removing comma in data string
11124:
Error for loop
11125:
Help with code: Web query for security agreement
11126:
outlook and excel
11127:
exit for loop
11128:
copy access table in to cells comments
11129:
Linking from a Combo box to another excel file's specific workshee
11130:
userform
11131:
Get parameters to create existing chart
11132:
How do you do this?
11133:
Creating Lookup User Form
11134:
On Error GoTo .... error
11135:
command button code needed
11136:
Trouble changing Range destination
11137:
Print Range
11138:
Retrieving hyperlink from cell
11139:
macro for mail merge automation
11140:
ThisWorkbook.VBProject.References
11141:
Excel Help
11142:
Hover-over Function
11143:
AllowEditRanges
11144:
Attn: Barb Reinhardt
11145:
VBA Tutorial problem
11146:
Build DateSeries (?)
11147:
ThisChart function similar to ThisWorkbook (XL2003)
11148:
Excel and COM
11149:
Updating tables in Access
11150:
Document Manager Toolbar
11151:
User Function Question: Collect Condition in Dialog Box - But How to
11152:
Formula problem
11153:
Excerise with Days Off
11154:
Please help...
11155:
=SUMPRODUCT but need to break out Jan 07 and Jan 08 results
11156:
ChangePivotCache
11157:
dynamic print ranges ...
11158:
Ping via VBA
11159:
script to increase last number in cell entry for hyperlink
11160:
Lookup variabel field in variabel sheet
11161:
Copy paste different columns (ranges) to word
11162:
Unable to disable macro
11163:
Scalar Multiplying VBA Array
11164:
userform and inputboxes
11165:
Sheet sub to centralize comment display on mouse over
11166:
Multi-threading in VBA
11167:
Displays numbers as $ on a form
11168:
auto filter based on color
11169:
hiding excel
11170:
Pivot Table Pivot Item Visible - Why so difficult
11171:
find the matching and supply the quantity
11172:
find the item and supply the required quantity
11173:
Apply a macro to only one sheet
11174:
cell list from access table
11175:
adv: Designing reports in Excel
11176:
Upon error close workbook
11177:
Changed variable value
11178:
multiple text files to multiple rows in excel
11179:
Finding exact date
11180:
using excel data to create multiple web pages
11181:
Basic combobox question re setting values
11182:
centering checkboxes vertical in cell
11183:
Macro Looping Problem
11184:
Loop or If then Question.
11185:
Highlight text in Textbox
11186:
Error data mismatch ??
11187:
Problem with Public Variable value being changed.
11188:
Vlookup Error
11189:
run access macro from excel pass parameter
11190:
Copy from 1 worksheet to multipule worksheets based upon worksheet
11191:
Total beginner
11192:
Pausing Code
11193:
Insert Matched Value
11194:
Extract string from cells
11195:
Data input and database record using macro's
11196:
how to hve input box on msgbox
11197:
copying formulae down a column
11198:
Programmatically Open Locked VBAProject
11199:
Area of freeform shapes
11200:
Problem with Userform