Excel Programming [Archive] - Page 173

excel 2002
Macro to move to next cell
References
Array
Re: Pasting a range of information from a foler on F Drive to another folder on same drive
Re: 2 buttonbar questions
Re: Do the Addins belong to a workbook, or are they global to all workbooks loaded?
How to obtain the shortest range that encloses all the non empty cells?
How to get the 'current row' from VBA
Re: Arrays: querying with two variables, why doesn't it work?
Re: VBA - import txt file using space separator
Help with the Find method
Particular cell in Range
Get data from one sheet to another
Formulas not data 0
testing for non-empty cells
Re: Input Password to Open Linked Files
Updating Excel imports
Data Validation is it proper to use it in this situation
textbox query
How to hide a loaded .xls...?
macro that cleans single the unblocked cell
Copy range between workbooks
Save protected file into unprotected file without password
Auto loading of a user form sometimes
checkbox
column widths
How could I do this? Email status...
Dim person, needs help
Auto_Open Check date and Close
Re: Sum only numbers in red font color
Re: Sum only numbers in red font color
Re: Sum only numbers in red font color
A pun on Google
Re: transpose matrices
Hide Columns before Print problem
programing book
Poor Worksheet Performance
PasteSpecial failed
Wildcard in conjunction with data comparison
Copyfromrecordset Bug ?
MSG Box triggered by move/copy
combo box web ability
Re: How can I discover the FULL list of vbConstants
Relative references to multiple selections
#div/0!
Re: Relative references to multiple selections
Re: Accessing properties of a series with no data
Using an ActiveXDll with Excel 2002 when the DLL uses a VB Form and VBA uses a Userform
Re: transpose matrices
The For Loop Worked, but need critique
Re: Workbook Open code
Re: Workbook Open code
"Headroom" on <Files=99> in config.sys
Mcdonalds -> McDonalds
Tallying columns
macros and screen updates
Auto Open Excel at Specific Sheet
How to Save on a Network Drive using UNC?
Default for Dates in User Form
HELP!! Excel 2000 Copy of worksheet class failed run time Error 1004
Pausing a VBA macro
Access a built-In command?
macros
Modifying an Access record in Excel
Debug/Compile: Compilng excel macros? What it generates?
Re: My workbook doesn't works on no other PC exept mine....
Re: Conditions
FileSearch Problem
call dll's from Excel asynchronously ?
Which Path not found?
Re: Auto Save in Excel 2003 (XP)
delete upper triangular matrix ???
Re: FileCopy error
Re: Worksheet_Change Event Not Working
FileSystemObject question
Alternative to Indirect Function
More UDF problems; some won't update, some won't stop running!
INDEX
Re: Copy Data to a new sheet
Recordset Opening Excel File
Re: Need new idea for universal path
How to disable the Ctrl+Break ?
Re: reading cells from a spreadsheet using VB
Re: Copy Data to a new sheet
Get data from a CSV file
Easy Question - Opening a workbook
vlookup
Re: Auto Select a file not knowing its specific name
Re: transpose matrices
Re: Built In CommandBars
scan rows
Regional Options and Decimal symbol from VBA
Downloading drawings from a list in excel
Re: Update Links automatically using VBA ?
Update links using VBA
Re: Searching directories...
Re: Need new idea for universal path
Re: controlling another program from Excel
Problems clearing a cell
Re: OpenText bug ?
compare rows...
Textbox object does not update
Converting DataLabels to Numbers
Re: Saving a file(new) using the multiple cell contents as a file name
Re: Can't deploy my .xls to other PCs...
Re: Range object to Array object conversion
Re: Range object to Array object conversion
Re: Subtotal detail reference?
Limitations in UDF:s
Re: Range object to Array object conversion
Re: Searching directories...
Re: Regression
Moving Row Data
Re: mediaplayer
hyperlink breaks if space within hyperlink
Re: split cell content without using a specific character/sign
Copy of protected document was unprotected in 97 and protected in 2002
Can a macro be suspended during user input?
For Each...Dynamically formatting multiple worksheets
cell order
Placing the target cell after a hyperlink is executed
Re: Use a variable with Sendmail ?
MsgBox
Mortgage amortize, stop calculations at end of term
Re: Pivot table question
POSTGRESQL
excel link to access
Hide/Unhide worksheets help
Displayed Collumns and Rows
Re: Quad combinations
PDF files & Excel using VBA
Run userForm only when opened manually
preventing page breaks from control V
InputBox to get user hidden columns question
Re: select a different range each time
opening multiple .csv files from the web
Re: Apply macro to closed workbooks
external data access problem
sorting macro
Query source location - how do I change?
Using Application.quit is causing my macro to run and print twice...
Sort "database" = loose links from other worlsheets??
Re: Auto-install toolbar button with add-in
Re: Assign a data type to specific cells based on IF stmt...
How to get Timezone in VBA (for Excel)?
Cell Editing Macro
Excel 97 - Inconsistent Change Events
Retain if atleast 4 entries
Re: Looping through all workbooks
Excel and VB.Net
Duplex Printing from spearate worksheets
Moving active cell
save a excel sheet in vba
Re: template wizard
Re: Order worksheets by cell nunber
Enter Formula in a cell with VBA
Excel add-in set title?
Uncontrolled page tabs
Can I make time stamp function that "sticks"?
Conditional Formatting Drawing Objects
Help with Userforms and filters or autofilters
Previous Column
unprotect sheet in code and make sheet visible
Run Time Error '1004'
Re: Combo box feed
Can't access .xla functions from .xls doc...
GetOpenFilename and arrays
Does workbook contain code and links
select contents of entire worksheet
LDAP Query
Printing Only Select Columns
Excel Worksheets.Copy in VBS???
Re: Combo box feed
Re: Deleting sheets in a shared document
Setting default Tab Name
Determine Selected Cells
Calling an Excel Addin from VBA
Calling an Excel Addin from VBA
strange run time error
R1C!
Forms and Frames
Re: Text from multiple columns to one
Re: Text from multiple columns to one
Hide Unused Cols & Rows in a Range
Logging data from a web query
Built in Commandbars
Re: Run time error 9
Re: Formatting pivot table
Shapes in header
Advanced Filter from a Form
Re: macro to run automatically
Macro to insert numbers
Problem with VB running from a command button
Macro to add formulas to added worksheet
Paste doesn't work
Adding Checkboxes
Formatting problem with web query
How to insert data into microsoft excel sheet using ODBC API
sorting in a shared wkbk
Looping Through Chart Labels
Re: one doozie of a macro req'd please...
Chart into Userform Problem
Re: Excel 2000 Voice Alerts - Macro
Excel 2000-2002 compability
Re: Toolbar customization
Creating Userforms and textbox numbers
Re: COMPARE AND COPY
FUNCTION Problem, Please advise
Re: one doozie of a macro req'd please...
Re: macro to run automatically
Need some help with Resize. Thanks
Re: date list
Re: assigned macro taking the name of file creating it. Please help.
Character.Font Properties.
label caption
Converting Excel 97 macros to 2000
Basic Input Forms
Re: Run-time errors
Rapid SQL
Excluding sheet in loop
Sheetname = Cell content ........ is it possible?
ExcelXP 10 times slower than 2000 on web queries.
Popup a Msg to Prevent Code Interruption
Re: MultiPage Background Color
Trapping the movement of cells in XL VBA
What's causing file to increase in size and slow program?
Copy & Paste without the formulas
deleting sheets
Re: Macro Question
Pivot table selection
Input Password to Open Linked Files
Re: Quit Application
calling a macro from within a loop
Hiding Rows with Zero or Blank Values
adding animated *.gif's to a text box
Help With Worksheet Operations
displaying varying toolbars depending on workbook
Re: Hiding Rows with Zero or Blank Values
Hidden characters
Re: hide a textbox on a userform?
Page Breaks
Userform
Missing ActiveX Frame control in Excel 2000
verifying date
Move a column in one line of code
Excel Macro Code invoking InputBox.
Please HELP!
Macro Help
Protected worksheet VS. sorting data
User-defined function with a naming format of =ABC.XYZ.
microsofts' crm?
Re: Userform
Re: I make the leaf of report with a macro?
module-level variable lifetime
Macro for command button
Move a column
Re: Toolbar customization
CELL drop down menu
Re: edit query
Re: Dynamic Link to SQL
Re: calling a macro from within a loop
Re: NONE
Opening XLT file with Excel XP
Inserting row of data
Programming to put in dates
I dare you to help me! Somebody, anybody...
Re: Working with strings
Re: Making a TextBox look and feel like a Label in a userform
Re: Excel last modified date
How to create in a userform, select all/deselect all checkboxes
Calling VBA functions from a xll
overwrite Excel SaveAs function from File menu
help with dataform and sorting macros
Determining whether selected cell has value or formula?
Ignoring other Formulas
Using wildcard for checking whether files are open
programmatically insert multiple blank rows in worksheet
Re: Changing just one column
CSV to XLS
Re: Concatenation & formula results
duplicates
Macro assigned to a button question
Worksheet Change question
Conditional row delete
Re: Crerating a temporary menu button
Workbooks.Open / .Open Text - How do you stop the .xls addition?
Re: Emailing an Excel File with a Macro through Outlook
Import AutoCad Drawings into Excel
Toolbar with Macros
multi[le file operation
Set Default Directory
Re: Control code behavior with userform ?
Help! Turning off PivotTable Subtotals
Causing all calculated cells to refresh...
marking cells that do not have a formula?
Path Reference in cells
Passing properties to a procedure
Skipping empty rows when copying a formula down a column
How to eliminate "X"sign (= ALT+F4) on UserForm in my VBA project ?
Displaying the "Calculating Cells n%"
Open Filename + SendKeys
Office XP Excel Macro Security Problem
auto save as macro
collecting previous values
Macro to close workbook when file print is selected
Working with strings
Re: Crerating a temporary menu button
Re: Havig the replies sent to our address
Hyperlink to AutoCad file ??
Gettiiing Started in VBA
Re: SaveAs problem
dropdown problem
Add shortcut instead of file to Email with Macro
Deploy Excel 2002 add-in
select sheets by name - how?
delete custom toolbar
Sum of cells
Help Programming Macros
Add OptionButtons in Excel
ExcelReadWriteAdo
Setting up a variable print range
Re: xls2txt xls2pdf
Run-time error 429
Help
Re: Run-time error 13 between Win NT and Win 2000
Macro Passwords
Save calculation results
a moth before
Macro to e-mail hyperlink
To say "no" with vba
Open/manage newly created workbooks
Function to reduce date by 3 months
Excel and Picture
Re: visual basic macro reply to P Molloy
ActiveSheet
Please help with this formula
Installing Invoice sample
how to write dynamic link library for excel to use?
Re: Making a TextBox look and feel like a Label in a userform
Posting text typed inside a TexBox into the worksheet cell
Variable to formula.
File-Properties-comments
A MAJOR LEAGUE THANKS TO JOHN WILSON
Convert text to column using macro
Automated Email Messages from Excel w/VBA
form class
Re: Cannot Get Caption to show on custom toolbar button
Re: Structure of If...Else in VBA
Creating separate sheets from a list
Re: Automate File Naming Function in sequence
Re: Automate File Naming Function in sequence
Re: Making a TextBox look and feel like a Label in a userform
Show' Read Only' On A Form
CSV
Easy one: Using Search (Ctrl+F)
Re: Making a TextBox look and feel like a Label in a userform
How to prevent Reopening of target file ?
Re: Calculating Commissions Macro
Re: run tiem version
Re: Move cursor to columns to the right
REGISTER parameter
Last cell in column
Re: Last cell in column
Re: run tiem version
Re: Last cell in column
'And' / 'Or' statements
Macros created in Excel 97
Adding Formula's
Accesing a combobox control via it index propertie in VBA, Is itPossible?
Books
MultiPage Caption
TS1 Reuters Links in Excel
Re: Move cursor to columns to the right
Re: Move cursor to columns to the right
worksheet protection
How to paste variable value onto a Cell?
Excel Add-in
Randomization of Multiple Columns and Sequences
Macro for a single line mail merge?
Search Mutiple WorkSheets
Would Palm allow VBA Excel
UserForm Pops Up when in the wrong file.
pastespecial
Disabling toolbar customization
Select two consecutive rows
Re: Strange problem with a dynamically populated tabstrip on a worksheet
Trying to create a custom "clear worksheet" function (in a VBA module)
Re: Excel macro activation.
running all modules
worksheet protection
Userform Screen Location
Block Copy as opposed to EditCopy
need help with syntax of a Workbook Event
selection
Re: Data form Dates wrong when called from macro?
Sending Email using Lotus Notes
Application.caller
Move to displayed row of filtered list
VBA Cell row-column numbers to variable
Conditionally Hiding Rows
Re: What is the item "How Many"?
code needed
Double-click to open XLT in Excel 2002
set zoom
Can Excel write to an Access DB?
Capturing pointer locations
Re: Function returns a zero value
Adding a splash screen to an excel add-in causes double-clicking to not work
Excel macro activation.
Re: ActiveSheet
Help for User Defined Functions in Excel 2003 Beta
Help with macro to make it loop through coloums
Re: Slowing Macro
ActiveSheet
Re: Excel macro activation.
Excel macro activation.
Re: Application.Calculation exception
Re: Additional Controls
Excel Add-in prevents a workbook from opening when doubled clicked
custom dataform
Setting print range using VBA
Re: Change Control properties in VBE
Setting print range using VBA
OFFSET and UDF bug
Re: Setting print range using VBA
create graphic autmatically with VB
get rid of tabs strip
Copying Data from closed workbooks
Save to FTP site through a macro
Re: Looping through all workbooks
RE: Password Unprotect
Re: Status Bar
AutoFill KILL
Compiling a workbook...
Selecting cells
Re: Grouping in a Pivot Table
Macro To Email Distro List
Re: Grouping in a Pivot Table
Looping through all workbooks
select case help please
How does Excel determine the TEMP directory?
rounding to 5 cents
Cell formula, picking Text
Refer to Combo-box using a part + variable
Usermenu does sometimes not find subroutine
Setting a File name:
delete duplicate rows
Using wildcards with the "Like" command
Formula to equal Blank
insert macro in new workbook
HELP! Merge cells and borders....
Loading PDFs, Shell Function
Re: 'File not found'
code for saving
Adding Cell Values to Ranges
calling API's
correlation function in macro
Distributing sheets and local cubes
unlocking a project in VB(A)
find in 2000 and xp
Identifying a Control Type
multiple query
Is there a Sheet delete property?
Sort two columns at once
Highlighting a cell, and undo and redo buttons
Re: Text Function - Custom Format ( Re-posted from Misc still looking for answer )
Re: Text Function - Custom Format ( Re-posted from Misc still lookingfor answer )
Re: set zoom when file opened
How to skip MySQL ODBC Driver Promp-up window?
Can an Excel macro be converted into a VBdotnet Windows application?
Copy a comment to another cell - How?
4 short answer questions
Re: Getting list of files in a folder to excel
Text Function - Custom Format ( Re-posted from Misc still looking for answer )
Macro to select the print area
protection of the worksheet in Excel 97
Help!!! Code problem 1004
Problems Loading Analysis ToolPak when automating from Visual Basic
replacing multiple Chr(13)s
How to get Username written in logfile (.txt) through macro
Re: using MailEnvelope
Show msgbox only when....
HELP!! Range selection doesn't work
Too many different format cells
olemainthreadwndname:excel.exe - application error
Drop down box issue
Must be a way to force focus back to sheet instead of UserForm - isn't there?
Re: Change to Code
Printing Selections from four sheets
upload text and/or image files to a web server?
Add to finally successful dialog box
Grabbing a String between two delimiters
Re: VBA code to calculate the difference between rows
Why does text in posts re-format?
VBA CODE Question
automate the TAB inside a userform?
Dynamic Sort
Re: EXCEL USERFORM
Re: COM in VB Excel
runtime error 1004
Re: Accessing ActiveX Controls using VBA - can't use Control.Name to access.
Seperating Rows
Re: UserForm TextBox to ActiveSheet TextBox over 256 characters
comparing cells in different workbooks - open a certain sheet
Minimize workwook and then maximize UserForm
adding columns
macro to apply worksheet event to active worksheet
variable range
Send FORM by mail
DDERequest: Interesting Predicament
Remove items with no data from pivot
Email files using macro
change font color using arguments
Re: relative ref. macro
runtime error 1004 when opening excel file via VBA in a browser
Re: Find a cell then delete the row
Status Bar and the small panels on its right
Re: Find a cell then delete the row
Specify file location
shortcut for menu
Circular References
UserForm
UserForm
Toolbar icons./ FaceID Bitmaps.
Setting named range in VBA- how to set as formula/reference instead of text string?
How does one refreshes the screen?
AutoFill
Re: strange worksheet.codenames in XL97
Changing Font Color meeting an argument
deleting rows
correlation matrix
SaveAs problem, renames Worksheet too
Userform leaves traces
Calculating time zone differences
Dialog List Box
Printing selections from sheets to PDF
Excel 2000 ComboBox Code Change event
summing values according to name in defferent column
For Each Code Not Working
Re: summing values according to name in defferent column
default name for a new book
Re: load userform from other VBProject (Excel 2000)
deleting a variable number of columns
Re: Simple For Each Next code
select data based on user input
Re: Simple For Each Next code
No-numeric data
Column References
Dao.OpenDatabase gives me error when ...
Online workbook help needed...
MakeCompiledFile
Pivot Table using VB Script
Define the irownumber
System.Convert.FromBase64String
VBa, Password protected sheet fails to get unprotected with the same password
How to use a conversion function in a whole column
Locking column
Hyperlinks-Problem
.NET Add-in
Copying data to another worksheet gives "Type Mismatch" error
show the form as minimized window
Deleting a Sheet
Ensure sheet is saved password Protected
How to minimize a form using VB
How to output recordset data to sheet
write marco to put data from sheet to memory
how to write dynamic link library for excel to use?
Starting a userform upon starting the file
Re: VBA code to calculate the difference between rows
Automate Graph of Pivot table
Re: VBA code to calculate the difference between rows
how do i loop in a access search
Accessing file extensions
Can someone tell me what i am doeing wrong?
An easy one !!! How to get the clipboard Size . Thanks
Printing a WorkSheet with an embedded command button
Pull info from SQL server to Excel
Libraries In Excel VB Editor
XLL - VS .Net2003 - init problem - const char strings - /Gf option??
VBA calling DLL function: how can I make it re-entry?
Send a Userform by email
Can the AND operator be of use here?
Re: XLL - VS .Net2003 - init problem - const char strings - /Gf option??
Range as varable
SQL for EMPTY records
Inconsistent Behavior on Web vs. Local Disk
combobox
How to to catch embeded worksheet events in a host program (Access in my case) ?
R1C1 Notation
books for learning vba- excel
Parsing help
Password - Protect, UnProtect
Commandbar button running macro
Re: Calculating Commissions Macro
ActiveSheet.Name?
Any way to set the Default Filename for a new document?
Is there a way to know when a worksheet has been clicked?
finding and replacing a cell
help with Excel bowling score sheet
delete part of a sheet
Userform Textbox in Password Validation
Range.BorderAround(xlLineStyleNone)
Re-Post Anyone know how to do this?
GetOpenFilename
Target Offset?
IndicatorColorIndex Property
variable 'open' command
finding and reporting in column A, where a series of column reaches zero
Digital Signatures
Naming Modules
Active workbook
Code - if T changed, change date in W to date it is changed
use standard icon in image control
saveas calling a variable
how to? running average from a variable length list
Ignore this.......Reposted to excel.links......
5.0 Not Compatable
Live Stock Data in Excel
gantt chart
Re: control button numbers (ID=???)
Form control names
lottery- excel formula required
NEW free code: digital signatures, embed binary data..
Apologies
My (old) function that I wrote doesn't work anymore!
Managing Addins in Excel
Copy and pastespecial without formulas
Subtotal formats
sum products...
problem with an iif() function in a formula
Sum of products
MS EXCEL as list Manager
Macro link to an Access table
Passing range to subprocedure - maybe?
Re: Failed Web Query ... sometimes
Detecting workbook activation
Delte blank rows between different sections of data
Incompatible Code
Macro run much slower under VBA than in Excel
serial port mscomm32.ocx in excel
NumberFormat strings for Excel Cells
Clear row contents code
Separating code from data
Cases/Set object to take coordinates of Print Range
Re: Subject: Not showing "info on clipboard" message
re:form popup
Emailing in VBA
Canceling a Macro that Has Been Scheduled
Re: prohibit printing based on input
VBA Code Signing
insert page breaks every 43 lines
Rounding numbers then doing a sum of those numbers produces incorrect result.
Re: Macro skipping even rows
Re: How to pass variable value between macros
custom toolbar button that visually toggles in and out
Comparing two arrays/ranges
automating Excel 2002 Task Pane
passing a variable as an argument to a function
Changing the File Save Properties
Get data from another program to Excel
Save Filename+Date+Time?
Help with Syntax UserForm TextBox
adding sheets based on input
Excel 2000 VBA Form Combobox value
Hyper Links
Keeping Excel Hyperlinks From Launching More Than One Browser Window
Convert Text String to Cells
Customize the File Open Window
Function or a Sub?
Moving a row based on content of a cell to a diff worksheet
Take data from one worksheet to populate another
Macro-Text from word doc paste to excel empty row
Re: open range (within workbook) as ado recordset - excel vba
A simple question
Copying shts from one wbk to another
A simple question
Re: A simple question
Re: A simple question
Code to insert a Page Break
Counting Unique Values in A column
Macro too slow...how to optimize
help delete blank rows
Vertical stacking of letters DURING edit mode
Custom Button
Re: Scroll Area for Data
Print Selection in Code
creating workbooks and worksheets automatically from existing ss
Need Live data in web Excel chart
Re: extracting text from within a cell - 'text to rows@ equivalent of 'text to columns'
ComboBox Name array
Re: Macro not working when Sheet protected
File with too Bytes?
Revised btnprint1_click()
saving *.xls files but troubles with opening with MS Excel
OPENING A FILE LOCATED IN A DIRECTORY DIFFERENT FROM CURRENT DIRECTORS
Listboxes get unchecked on save-as
Need way to protect cell after data entry
excluding duplicates from list box
Re: Worksheet Change Method
sql
Need Translation
Passing a variable to a range statement
Re: Find Code
sending outlook mail
Combobox control problems in a grouped cell
re:Category Names runtime error 1004
Re: ActiveSheet.Paste error
Userform help
RE: Form Popup
Re: What is the connection string ?
Run a macro when a workbook is opened
Run a macro when a workbook is opened
combo boxes
Dynamic Spreadsheet Link error Excel '97
Worksheet Change Method
Operator definitions
Opening many files sequentially
Disable Save As just for opened workbook
Re: Table from labels
vlookup
Convert If..Else to Select Case Statement.
advanced average function
How to create User Defined Function
Programming dates
Re: Excel :: Creating Entry Forms that auto load a workbook
Re: retaining font formatting after a text= merge
Re: Formula error when saving
Re: end of data in column
Customize Subtotals
make sure macro be loaded without user intervention
Passing an argument to a quote
Simply was to repeat a macro N times
Re: Microsoft software
Help w/ IPMT differences
Moving Array formulas from spreadsheet to VBA
Re: Consuming excel events in C#
showing a rounded number without rounding it
Sorting and Moving Rows in Multiple "stencil " worksheets
Defining Names
vba yahoo! finance
Passing an argument to a quote
Trapping the mouse
Re: pulldown boxes
Not showing "info on clipboard" message
Re: pulldown boxes
Re: pulldown boxes
My First User Form - How to Select Range(s) and Print
Re: Frustrated with Factorials
Re: Can excel calculate?
What commands do you use to name a workbook, save a workbook,open a workbook
Finding Totals...Continued with Some Data
Run-time error '5':Invalid Procedure call or argument
Visual Basic
Grouping and Listing Projected Projects By Inclusive Dates
check if sheet exists
Finding Totals...Continued
How to create a ListBox with 'hyperlink'-like items in VBA ?
Calling macro in add-in.
Searching
Seriously Impressed!
Re: how to identify cells containing formulas
how to change default file name in "save as" or "save"
Re: Excel and Dot Net
Order of events
Directory search screen
Re: Importing Multiple Data Files
List or Array
prevent user from saving file to a folder but allow my code to save from behind.
Using Index and Match functions to lookup data in another worksheet
How to make the Today() function static
Macro to paste error
Macro to paste error
Can we code this?
Minimizing a Form
Saving Cell value as filename
run two or more macros simultaneously ??
Color Tabs
VBA adjustment for beginner
Re: Setting Print range
Currency conversions
Re: formula doesn't work until cell is re-entered
Re: Worksheet Change Method
Macro Virus Protection
Entering data while procedure is on
Is ByVal always better if ByRef isn't necessary
Re: quit excel with macro
Coding problem: Runtime 1004
Special cmdbar button activating Enable Macro dialog
NESTED IF's too many
VBA code for looping through open workbooks and worksheets
Adding Arrays
Excel 2003 Beta Problems
disable save query definition in VBA sorry repost
Finding the "Size" of Each Sheet in a Workbook
disabling a template wizard
prevent user from saving excel file to a folder
If .. Then
Looping through sheets
Macro shortcut keys
HELP! Macro stuck-"Invalid Object"
Re: Excel Startup
lost password in a macro
How to create a ListBox with 'hyperlink'-like items in VBA ?
Printing Cell Formulas
selecting ranges
Re: search & copy with loop
Disable Protection Messages
disable ctrl+s
Re: copying ranges from different workbook
Write Once Function
Common Dialog Boxes
Suspend viewing of macros
xlLocationAsObject
Calculate Tax and Insert into table
Re: Solver error with Excel 2000?
Changing macro source
Handling Excel Apps?
Excel window with more than one pane
Re: ODBC driver file path
Re: Can excel calculate?
Entering a formula via VBscript
Counting Cells
Problems designing userforms
How to check a zipcode
How to find out what the user selected?
ComoBox Resluts
Date maniputation question
How can I change an image based on cell value
password problem with protect worksheet
Can excel calculate?
Blank Row
Can excel calculate?
frequency of characters within a string
Re: Dynamically populating and formatting cells with Essbase members
Excel VBA
How to keep window + form activate together
Evaluate - Sumproduct GRRR
Commandline Arguments
Adding a new excel file type
freeze panes
retaining superscript after a cell merge using =text
Formatting & colours
Formatting & colours
Formatting & colours
Excel 97 Tutorials for VBA Newbie
please give an example of a class module.
Colours
Re: Problems with Excel Web Query for Post Method URL
formatting before concatenation
Display a busy window while processing
probably 2 basic
Re: Defining a formula
Re: Manipulating Excel pie charts with VB
inserting the name of the current workbook into a cell
Re: Manipulating Excel pie charts with VB
Combine ranges from 2 sheet into 3rd
Re: My macros are slowing down.
clear data in a macro
HPageBreak
My macros are slowing down.
Re: Run Macro on many files at once
User Form Apology
Opening an Excel Pivot table sheet with right information
Macro to delete last charcter in a text string
Re: Get User Input
Assign data to chart series, using array
Using Excel Interfaces
Re: Copy/pasting between 2 workbooks...
Re: tried to execute application from VBA
NETWORKDAYS
Re: Timer function
Re: Calling Excel FUNCTION MACROS Programmatically from VB
Re: Copy/pasting between 2 workbooks...
Even Better
Stopping "Link Worksheets?" message box (using automation)
Running a macro to concatenate
collapsing columns base on criteria
Can't find informations on TrendLines
KERNEL32.DLL error after running EXCEL Macro
Re: Help with borders
Re: Inefficient VBA Code - Worksheets Property
date question
Help with version control
Array Questions
Re: Manipulating Excel pie charts with VB
Coping Values - Not the cell
BeforeRightClick() and Cell menu
looping to create multiple files
Re: Assigning Multiple Macros to One ComboBox Control
Should I use Excel for this software project--or something else?
Re: Asking user to set a printarea when none is defined
Cell in Range Testing Function
Populating Active X Controls
Re: Assigning Multiple Macros to One ComboBox Control
XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select
Disabling the Update links message
Strange (forms) ListBox behavior
Formatting with IF Statement
Saving an Excel file as a CSV using a Macro
picking up real time updates from bloomberg
Finding the first few characters in a cell
Get User Input
Inserting Hyperlink from a Query
Use numeric data from a textbox on an userform
Error in formula will saving
Print Range
Copy one spreadsheet into another without activating second spreadsheet's user form
Re: Change Sheet By Macro
Re: protecting macro code
Re: additem to listbox built on the fly
Password to hide and unhide sheets
Password to hide and unhide sheets
Saving a new file with a macro
Re: Date Format - Unchangeable
ADO newbie help please
Hllapi Call to Extra!
Is there a way to remove numbers w/o remove formulas
Last Active
Please explain why following code doesn't work....
On Event Macro's?
Re: tried to execute application from VBA
Form Popup
Re: accessing CheckBox on Worksheet
Missing Word 10 Object Error References
Re: dialog raise event?
Re: tried to execute application from VBA
Variable TextBox
colour and value transfer
Which formula should I use relative to a date.
Mask an entry using InputBox function
What's wrong with this line of code?
Disable read only
determining last column
Code to Change Chart Type
sorting using VBA
why don't buttons work?
Automatic coping on 2 column
Looping thru custom controls
data validation in excel 2000
Reverting to open workbook in excel
sum & VLOOKUP
Deleting Shared Files???!!!
dynamic range without using OFFSET()
How many entries can you have in List Data Validation
Problem with saving REAL type to txt file
Place Subform data into specific cells
visual basic macro in excel
Microsoft Excel cannot find the data...
Place Subform data onto specific cells
visual basic macro in excel
Add submenu to custom menu
Repeat importing text
Cell Lost Focus
running macro while in the edit mode
Cannot run macro from toolbar in a file on another pc
Code page for data in Excel spreadsheets
Find links with code; change from G drive to C drive
How do I disable the Margins button in Print Preview Window
Re: Object Arrays
Re: Object Arrays
Userform and passing date values
Re: Object Arrays
Re: split data in many workbook
Toggle State on Custom Menu
Ever see a link with these symptoms?
Re: Using VB to find next cell in range
Re: Using VB to find next cell in range
Re: MsgBox
Re: Record Worksheet Content as Macro and Execute from another Worksheet
Hidding columns
Unwanted MS Acccess Query in Excel spreadsheet
Preventing print when cells are blank
Option buttons - disabling
Re: Ignore MsgBox if run by automation
Re: Ignore MsgBox if run by automation
move this rectangle to hide the unused cells
Text paragraphs and image
Re: Paste Clipboard from Word to last row in excel
Highlight Cell on Focus
Re: Other applications
macro to clear rows
Saving excel spreadsheet in a cell
Need UDF help; cycling through various sheets using VBA name property
Excel macro to VB executable
Re: Macros run slow in XP
Date/Time data source refreshed function
Using Outlook with Excel to Input Names into Email
Using Dialogs Save
Combobox
Updating database table from Excel?
Print all data from list on seperate form
Passing parameter from Excel to stored procedure?
windoes system directoty?
Modifying the right-click popup menu of a shape
reurning currently opened file name
Embedded Word Document not painted until I click on it and activate it with the mouse
Images will not display
disable pop up when overwrithing saved files
naming multiple public variables generated by single function