TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Programming Archive
‹
Page 37
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
view full version:
back to formated view
12601:
Check error cell in C#
12602:
Formatting with Macros
12603:
File size
12604:
Column Possible
12605:
TRIM Function gives Compiler Error!!!!
12606:
furmula to add hours
12607:
the value of a condition in a conditional format
12608:
VBA question
12609:
Same task for Multiple fields
12610:
AND/OR in Macro
12611:
Move to next cell
12612:
Excel Macro - Extract data from website
12613:
Changing a formula inside a textbox - Excel 2007
12614:
Calling AutoFit using macro in XLCALL.h
12615:
Extract rows to different sheets
12616:
Save several worksheets into one file
12617:
Merging
12618:
Error Number: 91 object variable or With block Variable not set
12619:
Running a macro from the spreadsheet
12620:
C++ Excel Automation
12621:
Run Macro from different files
12622:
how to set pivotitem.visible property to true
12623:
Selecting A Tab By Its Name
12624:
Command button
12625:
Consolidating Various Excel Files
12626:
Sort WorkSheetName unknown
12627:
Tip # 13 Make a style statement with worksheet tabs
12628:
Listboxes
12629:
excel+webcam
12630:
Conditional Formating
12631:
vb code to re-arrange data
12632:
2 line headers in excel 2003 spreadsheets
12633:
Convert NumberFormat to System.Type
12634:
Toolbars GONE!
12635:
Specifying Cells To Copy Across Workbooks Not Working!
12636:
Ribbon Image Size
12637:
Use Contents of a Cell to Create a Hyperlink
12638:
Missing relative reference icon
12639:
Function instead of "Text to Column"
12640:
auto start code when a sheet is looked at
12641:
Deleting CommandBar("").Controls
12642:
Page Header Macro?
12643:
Single Row Count
12644:
set print area to last occupied row
12645:
Another lookup question
12646:
set print area to last occupied row
12647:
Common Dialog Control Reference problem
12648:
Transposing/combining columns with 2 headers
12649:
Pasting and organizing information from one sheet to another
12650:
transpose address information for each customer number
12651:
Data Validation Pop-downs
12652:
Loop help Please
12653:
Excel General Ledger Template
12654:
html exported to excel when save as, defaults to web page
12655:
RANGE
12656:
how can i automate copying of tabs to a new workbook?
12657:
user form and radio buttons
12658:
Find and Replace Macro
12659:
Calling AutoFit using C API's
12660:
Last Real Cell
12661:
VBA ReadyState basics
12662:
ie Command to Wait for "File Download" and "Save As" windows
12663:
Merge problem
12664:
Updating Date Field in Pivot Table with VBA Help
12665:
IF and ISBlank for a selected range of cells
12666:
getting error message 3704 when running excel vba
12667:
Macro on Current Row
12668:
How to save a project independent of a spreadsheet
12669:
Using VBA: Conditional Formatting of Row Color
12670:
Displaying Line #'s
12671:
Formatting a worksheet
12672:
locad password protected MS Access table
12673:
Highlighting Rows and Columns with Macro and VB
12674:
Column List to Multiple Columns
12675:
Change sheets within a read and write function...
12676:
Slow tabstrip
12677:
Column AutoFit C API
12678:
Find next empty row & paste data
12679:
FitToPagesWide
12680:
ListView - ItemClick - How to know column number
12681:
Macro to Edit Contents of Cell
12682:
Time Calculation w/ Macro
12683:
Export records into a text file based on criteria
12684:
Creating a list box
12685:
Get numbers from cell
12686:
load list data
12687:
ByRef argument type mismatch when passing dictionary object
12688:
Vlookup to Return Cell Name Not Value?
12689:
do loop until empty cell
12690:
Overwrite conditional formatting
12691:
Problem with IE
12692:
Disable Ctrl- PAGEUP PAGEDWN
12693:
Find value in sheet 1 and copy matching row from sheet 2
12694:
Auto insert
12695:
Version Issues
12696:
Debugging Advice Wanted
12697:
How do you x-late GetTextExtentPoint32's units into the real world?
12698:
Can Search's default be changed to "By Columns"?
12699:
nested for each or something else??
12700:
Excel Add & Substract in One Cell
12701:
Check for incorrect characters
12702:
Extract Access records to new workbook using VBA in Excel
12703:
Extensive file damage.
12704:
Add data range to a specific tab based on "Sheet Name"
12705:
Tabstrip Tabs Width
12706:
Excel VBA functionality and SharePoint
12707:
Trust Access to Visual Basic Project - Access to Excel and back
12708:
Disabling SAVE AS Temporarily
12709:
Sub to delete only all damaged defined ranges in book
12710:
advanced lookup feature
12711:
vba structure
12712:
Conditionally format cells
12713:
How do you hide .....
12714:
Copy variable to clipboard
12715:
exception in excel while writting to it
12716:
reset a cell
12717:
Listbox help
12718:
finding UsedRange with sparse data
12719:
Outlook VB not working
12720:
I protect sheet - Macro will not run now
12721:
Excel 2007 ListBox missing last item
12722:
Userform - 100 checkbox (10X10)
12723:
Select Object Button
12724:
stock the header items of a .dbf file into a vector
12725:
Is 'IgnoreRemoteRequests' the same as....
12726:
Making a [semi] Dictator Application: Hiding Main Command Bar?
12727:
Sum variable ranges
12728:
VBA...No Subroutine Code
12729:
newbie - If a cell is blank
12730:
Printing worksheets
12731:
identifying multi-select items in a listbox
12732:
Dynamically Change Cell Contents From VB
12733:
Change Axis Title
12734:
AutoFit function
12735:
"next and "previous"button problem in vba
12736:
Automatic Calculating & Autofil in Various Tabs
12737:
loading another application from excel vba
12738:
Count positive value
12739:
import xml in excel workbok using VBA code
12740:
Spreadsheet Component
12741:
break apart pdf binder
12742:
Blank cells & formula cells
12743:
VBA to move and concatenate
12744:
VBA to Update Pivot Table
12745:
Importing Access to Excel
12746:
data entry
12747:
help with Run-time error '1004'
12748:
Target.Cells.Count
12749:
Target.
12750:
Need to know how data is grouped in PivotTables
12751:
Bypassing the Security Warning when opening Excel file
12752:
Font enlarge/reduce by 1 pt?
12753:
Trouble with code that is broken over multiple lines (space_)
12754:
Modify the IgnoreBlank property of the Validation object
12755:
Difference between two dates
12756:
Does a shape cover a cell ?
12757:
Macro to Paste Unformatted Text Into Excel
12758:
hard time with If InStr(1, ..
12759:
clear contents on linked sheet
12760:
Combo box the exludes blanks
12761:
working with images
12762:
How can i automate the response to a generated pop up?
12763:
Parameter Driven Query
12764:
Lots of similar buttons need to call a macro but need to find out
12765:
read xml and fill valuesin excel form combobox
12766:
Checking worksheet names
12767:
Creating different worksheets from a main worksheet
12768:
Clear entire rows below last row of data in col A except in 1st 3 sheets
12769:
Loop Till the end of used Cell
12770:
option button problem
12771:
Why doesn't the FindNext work inside a function ?
12772:
Forcing Move seelction to the right
12773:
Filldown top cell to last row with data in adjacent col
12774:
How can I see the Project Explorer and Code window together?
12775:
How to specify charset for queried data?
12776:
Get Lines Before and After Search Text
12777:
Returning column letter
12778:
excel multiple choice toggles
12779:
Password Protecting/Unprotecting Worksheets using VBA code?
12780:
Refreshing cell value
12781:
clear contents
12782:
variable not defined error
12783:
VBE Help: How to get list of all string functions?
12784:
text&formula coloring!
12785:
How to generate a text file from Excel using a macro or script?
12786:
How to generate a text file from Excel using a macro or script?
12787:
Synchronizing worksheets
12788:
How to validate path? --- bValidatePath ("") Then
12789:
Activate one Book then another Book
12790:
Problems adjusting column width
12791:
Tip # 12 Stretch out: Insert a line break in a cell
12792:
How to change the background colour on event?
12793:
Excel VBA : Find Method
12794:
Change rangre color with scroll bar
12795:
How do I select an option button using code
12796:
Rename active sheet
12797:
Read text into Excel
12798:
Repost of How to get Popup Text help to work
12799:
Hot to Get a Column Number from a column letter
12800:
hyperlink in Excel 2003
12801:
error running macro from Ribbon button
12802:
CONCATENATE preserving original formating
12803:
How can I list values in a combo box?
12804:
Series order vs Legend Order in Charts
12805:
I NEED AN EXCEL TEMPLATE FOR ANNUAL BUDGET CONTROL OF SMALL BUSIN
12806:
Worksheet Help
12807:
Custom View: hide/unhide does not work when worksheet is protected
12808:
Change UserForm font
12809:
Enable Auto Refresh Message Box
12810:
Turn AutoCalc before calc takes place
12811:
Adding help to a user defined function
12812:
read datas from XML to excel using VBAmacros
12813:
2008 federal payroll withholding tax
12814:
Choosing no when asked to overwrite an existing file?
12815:
incrementing a cell value
12816:
check box help!
12817:
creating hyperlink using the value of the cell
12818:
Make active cell a variable, return there later
12819:
CreateObject from Template
12820:
Formula for Finding Retail
12821:
Select first 5 visible rows
12822:
Can I find out if & where "Freeze Panes" is set
12823:
VBA function wont update in worksheet
12824:
Change Event
12825:
Select charts by "Chart Names"
12826:
ctrl-a
12827:
annunce: excelmailer 0.2
12828:
excel temp file
12829:
Exclude gray figures from sum
12830:
TextBox mismatch ..... calculation
12831:
Copy cell to empty cells below.
12832:
Protects running from VBA, but not from hot key
12833:
Hou would you optimize this code?
12834:
writing screens to enter data
12835:
How to find a matching row and Insert Data
12836:
Insert Multiple rows with data
12837:
About xml constructing
12838:
how do i create a macro that will print and save my file to sharep
12839:
How2 accept only numbers in userform textbox
12840:
HELP!!
12841:
2008 federal payroll withholding tax
12842:
Need user unable to unhide sheets
12843:
User Defined Record Compile Error
12844:
Disable auto-update
12845:
Date Range Macro
12846:
Populate Comment on the basis of Text Box Entry
12847:
2007 Ribbon dropdown
12848:
Duplicate items in ComboBox
12849:
merging cells using VB - Excel 2003
12850:
How do I Create a Macro to run VB Code in Excel?
12851:
Excel and Calendars
12852:
Change text in Textbox on Chart?
12853:
protected linked cell
12854:
Macro problems: Waiting for site to load and commanding Save to
12855:
Spread data and keep format
12856:
MACRO IS NOT COMPLETE
12857:
checkbox
12858:
Using VBA to send email to distribution list ... how to CC?
12859:
name box
12860:
programatically create new worksheet
12861:
Apply code to Icon
12862:
Find first blank cell
12863:
use a range variable in advanced filter
12864:
Last Empty Row in Range
12865:
"Move or Copy" sheet
12866:
Variable not Defined Compile error
12867:
Selecting multiple areas
12868:
Sheet Protection doesn't hold
12869:
Shapes!
12870:
Columns ranked by highest revenue
12871:
Repost: Copy Range from one wbk to another
12872:
Popup box appears based on cell value entered
12873:
Copy range from one workbook to another
12874:
Uninstall Add-ins when workbook closes
12875:
Unhide Worksheet with Login UserForm
12876:
Row Headings (cell number) on Rightside
12877:
VBA multiple events
12878:
Hide/Show Rows based on Cell Value with Data Validation
12879:
Activate woorkbook
12880:
reset pivot table name
12881:
First blank cell
12882:
Who last opened file?
12883:
Iteration Error
12884:
NEED ADDITION IN MACRO
12885:
VBA to save a chart as a GIF
12886:
Bug applying Borders to Range
12887:
Input Box code help
12888:
Help in vba
12889:
How I can get color (RGB value) from .ThemeColor + .TintAndShade?
12890:
Worksheet with some limits
12891:
How do I set a range to the currently selected cells?
12892:
Call function from other workbook.
12893:
label to display multi rows and colums on a userform
12894:
How to Refer to Another Excel Workbook
12895:
Protected VBA vs RibbonX question
12896:
How to get Popup Text help to work
12897:
min function trouble
12898:
How to enter a formula over 250 characters?
12899:
Trying to create dropdowns in excel using vb.net
12900:
What is the VBA function to return the greater of two integers?
12901:
Value transfered to cell differs from value in record set
12902:
Keep Losing VBAProject
12903:
Amend sub to re-hide comment when activecell change to another
12904:
Code not working since upgrade to 2007
12905:
Application Maximise event
12906:
HELP - Vlookup with referenced tab name
12907:
Help with an IF Formula
12908:
If B1=Level 1 then B2=10
12909:
If b1 = 1, then b2 = Yellow
12910:
Formlua Entry
12911:
Using ADO to import Access table
12912:
Conditional formatting cells with formulas = "DIV/0!"
12913:
using the calendar on a userform
12914:
Advanced transposing in Excel
12915:
countif formula
12916:
surpress leading and trail spaces
12917:
Finding max value
12918:
PT - list multiple page field selections
12919:
Loop Through Combo Boxes on Worksheet and in Workbook
12920:
exit sub if no data
12921:
Usage of StockQuote.MSNStockQuote in excel vba code
12922:
How to show zero values in conditional sums
12923:
Add code on the fly to existing userforms
12924:
PRINTING PAGES !
12925:
writing to a table in wrod from excel
12926:
Select or Enter into a TextBox on a UserForm
12927:
Date format text conversion
12928:
Linking to specific pages in a PDF
12929:
removing comma in data string
12930:
Error for loop
12931:
Help with code: Web query for security agreement
12932:
outlook and excel
12933:
exit for loop
12934:
copy access table in to cells comments
12935:
Linking from a Combo box to another excel file's specific workshee
12936:
userform
12937:
Get parameters to create existing chart
12938:
How do you do this?
12939:
Creating Lookup User Form
12940:
On Error GoTo .... error
12941:
command button code needed
12942:
Trouble changing Range destination
12943:
Print Range
12944:
Retrieving hyperlink from cell
12945:
macro for mail merge automation
12946:
ThisWorkbook.VBProject.References
12947:
Excel Help
12948:
Hover-over Function
12949:
AllowEditRanges
12950:
Attn: Barb Reinhardt