Excel Programming [Archive] - Page 102

importing custom files?
Autofill Until
read multiple line
VBA - Solver use on arrays
second worksheet change
Connection String to SQL to run Stored Procedure
Dailog Box Q
highlighting rows when a value has been found
finding empty selection
Runtime Error "7": Out of Memory
VB 2005 Express and VBA DLL´s
error when sheet doesn't exist...
selecting a chart
Formula using a SUM of 3 code-defined cells
Recommendation for XML Macro language person trying to convert to
programming
Question on Application/Workbook
accessing .mpp file using excel VBA macros
Document merging
Request help
interior color of a cell
Compare rows to col
How to protect a code with password to avoid mishandling
How to find Watch window in Office X VB Editor (Mac OS X)
Rejected Safe Mode action : Microsoft Office Excel.
How can I do this with VBA?
Tab Names
Type Mismatch error in VBA code
Check - Similar Row contents - Different Sheets
Trouble with types...
Multipage control question
macro's run but spread sheet does not updata
I need a way to password protect a combobox?
Help with tidying up code please
userform memory
Type mismatch !
hide rows based on value
Need help with auto selecting cells
Insert Median Automatically
Data searching between sheets
Color cell text based on date
Copy and Paste Cell
RE: Copy and Paste Cell
Path/File access error (Error 75) using Name Statement
dget or dsum, that is the question
RE: Color cell text based on date
Path/File access error (Error 75) after using Name Statement
AddItems to a list box
RE: Color cell text based on date
RE: AddItems to a list box
programatically change the data source of Pivots
New guy with a tricky question
Which is unsupported?
Possible to reference column of named range in array formula?
Command Box jams macro
Help:loop on two workbooks
VBA & Excel: Concatenation problem
Macro to copy sheets from several files into a new workbook.
Querying an Access Database from Excel VBA
How To Q
Worksheet Change Event
ado connection with excel pivotcach-problem update/delete,etc database
Dynamic print area
Its so simple! Why won't it work!
Tom Ogilvy
Faulty Averaging Formula
formatting the target cell
Simple recorded macro crashes on playback. Why?
Macro entering an infinite loop
Pull drive information into worksheet
Modify a data query ??
ActiveSheet.QueryTables.Add
RE: ActiveSheet.QueryTables.Add
Extract a date for formula
End sub early if mismatch
Please, help with concatenation
Macro Button does not work on second click
How do I use the font as a filter
updating wbook from other...
Sum on Multipel sheets
Solver Add-In not installing...
Why must I click twice?
Code to view and Print several documents
last char of a string
Use variable as email reipient names
Command button and msgbox's
Excel Solver Programming Error
How do I set a price minimum in a spreadsheet?
Copy-Paste a Row via a cell reference
Copy File without opening
Code to get data from webpage into Excel
Progress Bar
How do I update a ODBC query in Excel using pivotTables in VBA?
Highlight Cells
can I get the printer options to display with the print icon
Pause Macro For Start Row While Parsing a Text File
Update Named Ranges
Function Help
Question
IF statement that looks at part of the contents of a cell.
VBA format function Win2000 and WinXP
If two lists don't match
Range Total
Deleting rows between
writing data to a tab delimited text file?
label effect
Compare and report differences.
Adding Cells in two different Workbooks
relative time
Fill the formulas at adjacent columns by VBA
Conditional Autofill
Open a protected XL file
macro security & digital certificate
Matching values in 2 columns
Macros disables under medium security
Textbox input control?
Binary sorting?
VBA to find account number that resides in one of several files
How do you hide macro names from showing in "Tools"?
Automatically Printing Autofilters
Opening password protected files
if duplicates then add quantities?
Cell value changing automatically
Last cell and first emty???!!!
Toolbox gone funny
Macro, how to protect sheet, but allow pivot?
how to create excel file when clicking on the button.
Tidy up of data within Excel Report
"save as" macro help
Delete a ROW in EXCEL
INDIRECT COUNTIF's??
Relationship between CHR alt Alt-XXX on the numeric keypad
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use:
without opening excel i want to save the excel in some specified location
Using excel in .NET
Wrapping cell contents in quotation marks
update wbook from vaiuos...
binary sort?
Lookup and store in array
from rows to columns
User Guided Button???
excel to word help
Hide Column - With text in cell
Obscure userform problem
clearing a selection
Macro Bombing out - Leith Ross
Automatically run a macro in time that user wants
help with code to paste from another workbook
question for Tom Ogilvi
conditoonal programing
Hide Column Condition
what is the code to delete row&column.
Make worksheets transparent
Rename Worksheets excluding Weekends and Holidays
how do I get my 2003 excel to recegnize my pocket excel worksheet?
scroll rows up or down
Userform Help
Percentage difference between numbers in 2 cells
Hiding rows based on cell content
Due date changes when new value is inputted in a different column
Specifying Range.Select in a loop
Schedule Print Excel Document
Change date with KeyDown
Custom function - Help please
beginner question
RGB values
FIND function not defined in macro
FIND function not defined in macro
Can't edit Excel worksheet with picture when automating Excel
create a form for search text in active sheet then got to selected
Anyone help please
asynchronous Procedure Calls
Need code for simple IF-Then
How to crop only numbers from a string?
Compare and update arrays
How do you "Find" on NonActive Page & Return Values?
Combo Boxes
formatting the target cell
Comparing two lists
Keeping VB Window on Screen
VB Help to Look at Next Row
Sendkey
how to subtract a range from another?
Using a Form in a Macro
Runtime Error 1004
convert excel data to 2-D array using macro
CreateObject("Notepad") ?
Quick and Easy from Checkboxes
how can I display memo data type in excel form?
Move some data to new workbook - my attempted macro is no good
Adding Cells
Not rounding numbers in VBA
VB Code To Conditional Format > 4 arguements
VB Code to Conditional Format a Cell Range
automatic import of .csv file into access database
macro to unhide row
Sort on Protected Fields
name a backup file
what is the best way to find a value in a sheet in VBA?
Programming Excel with VBA: How to make Selection Nothing
Align multiple MsgBox lines
Error when checking field for data
Header/Footer horizontal margins/text positioning
Conditional Formatting for True/False
Showing selected cell value
Trend funtion
Array <--> Range Error
Array problem?
Variable in more than one module
Userform input into a particular cell
Error messages: Program
CANT SAVE TOOLBAR CHANGES
Request code help, sorting array in memory
Range variable not being reset
Text Box in Chinese Under Excel 2003
Pasting with Dynamic Last Row
calculate number of business days between the 2 dates
Quickly Update Range
run macro only if condition is met
Can I program Excel to open a workbook to a default worksheet?
Chart disappears in Excel 2000
Run SQL Server stored procedure in Excel macro
Autoshape textbox
Catching max iterations Stop of Solver in VBA
cannot maximize or minimize
Excel - Access
Saving Reloading
how do I calculate difference between two dates and times
Anchoring a chart to a certain area
Please add a "sheet" function like "row" and "column" functions
difference application.quit & application.close
Remove Error
VBA macros to check a blank
Deleting Rows
putting a simple calculation in a field that may change rows
SendKeys - Right Click?
I need help -extracting specific data
Help with entering data
Column ROW CEL range vba
MailingAddressesToColumns
Can't get Find Box
identical macros run fast and slow
Appending special characters
Turning off alerts in VBA
Importing from multiple text files
For Each Next returns "Empty" when Data in Cell
What is function to select only not empty cells in a column (like SHIFT+END+ArrowDown or UP)
Am I in the right place?
looping a 'find and delete' code
filtering CSV data
Opening a .exe file from an excel hyperlink
Circular referance problem
How to color a row?
Password - 3 chances and **off
is there any sample of an excel dashboard ?
Convert XLS to PDF
Command bar diclaration
Adding total over two worksheets based on date values
Transpose and separating worksheet based on Input box name
Make a list from a table of elements ?
SaveAs with a pre-defined filename
Form, SetFocus and AfterUpdate issue
Refreshing a database query
Sheet protection altered when saving
XL2003: control button not visible
Moving between a column's cells
need some code help please
Changing the macor button color
Creating local cube using PivotTable
all the messages in the thread
Help with my user form
count number of "D"
relative sheet pt2
[Help]Excel mouse select region
Need Help Pls..... Urgent!!
Array problem: Key words-Variant Array, single-element, type mismatch error
LAddress of last cell in worksheet
Array problem: Key words-Variant Array, single-element, type mismatch error
How to show a progress bar in sheet calculation?
saving and reloading the contents of a userform
Just curious about Excel copying dates between workbooks???
Does Sheet exist? If True Use If False Create
comparing vertical list on one sheet to horizontal on another
And another puzzel
Msgbox not working
Copy formulas exact without references changing
Using Subtotals in VBA
Copying template to workbook but user form does not copy?
Closing Applications
Refreshing Charts inside a Macro
Hide & Unhide Charts
How do I set up a daily average of unit sales formula
Multiple For/Next
Excell macros(need help)
advanced filter macro to locate values via multiple criteria
preventin links from updating
Excel XP incompatible with Excel 2003
Looping statment
Macro to compare cell contents and make calculations
NETWORKDAYS problem
Which is the good PERSONAL folder in XP Pro
Using automation to add xy scatter chart
adding link to chart title using VB
Finding cell address...
% Change calculation
Addin Modified date/time
Checking if Workbook is Open
Sumproduct With Dates & Text In Same Column
Error Trapping when getting external Data
File Save, yes, no, cancel macro
big problem !!!
Flip Letters and Numbers
Problems with Combo Box
Invert Picture
link excel to paradox
easye compile question
Nesting Autofilter functions
paste values
Who can tell me where I go wrong?
question error handling
Getting Current Link Value
Logon Screen
relative sheet macro
VBA Lookup
validate lists
I want to count rows between the occurence of one word.
Running a procedure in a module on graph change
Macro to hide rows
open worksheet
place pictur underneath tabs on multipage
place picture
Programmatically check cell formatting
Range of Worksheet Function Max
Wierd Msgbox action - Can anyone see the fault?
why error in.... send xls
Excel, Microsoft Jet and OLE-DB
Using FIND in Visual Basic
What do I not see?
Can VBA Match?
Unlock cells in other open workbook
Top 50 Customers
Works using XL interface but not in VBA (err: 1004)
If option button not selected
error problem
Custom Menus in Chart Sheets
VB error, runtime error 13 (type mismatch)
Data Bound Controls in VBA??
Trust Access to Visual Basic Project
dynamic userform
Remove Formulas, Keep Values
excel hide and visible problem
combo box using input range
FileLen with very large files
UserForm Templates
autofiltered cells
udf to convert <any text> to range name
Import A Crystal Report into Excel
Building a Pivot Table where column headings will change
building code for an individual report
COMPARE 2 WORKBOOKS
Cluttering Clip Board - Excel XP
Select Merge Areas
Clearing what you have previously selected
HOW CAN I DEFINE A RANGE IN LOOP
changing row color
How to align entries in columns so other columns will follow ?
rename file
Worksheet Functions that Change Other Cells
ASP
Password and view of spreadsheet
Selecting sheets with unique names
How to use a combo box
concatination of cell contents
RE: Worksheet Functions that Change Other Cells
input box
generating passwords question
% variance calculation - amended
input check in cell question
% variance calculation
How to glance at other workbook while remaining in MyForm.Listbox?
Command bar diclaration
How to "visit" other forms properly?
Macro to copy and paste special values
Macro to copy and paste special values
Moving records from a sheet to another
How to change Macro security level very high to low...
Excel 2003 VBA: Detecting and removing toolbars
any variable size
Save As Dialog does not prompt for Web File Properties
using an input box to allow users type in the differnt fields name
Fill a cell in orange if the result is negative, help please.
Single Space in PRN
Simple problem
Re: print column labels with one row of data at a time.
Percentage Calculation using VBA
Data validation on form
Insert quotes around a lookup value
RE: Insert quotes around a lookup value
Macro error on MS Excel 10 for Mac Release 1
Protection within Macro
Forms
Possible to have a named array formula?
How to make excel to treat values in cell as a number?
Deleting a row based on a value in a column
String to number
How to get a sheets name or list.
Use CopyFromRecordSet to insert named range formulas? (Excel 2000)
clear format from RichTextBox
Maximum number of characters in a cell
Fill blank cells
Generate specific matrix
Custom Icon for an Excel File
Writing an array(2d) of user types to a worksheet
Re: How to calculate with years....?
Re: How to calculate with years....?
How to calculate with years....?
Argument help for UDF's
How to make scrollbar disappear after clearing textbox?
Urgent solutions needed to resolve vba coding
conditional formatting question
Userform with logo and without closebtn
Worksheet function Vlookup
Changing Values of a list
UserForm referring to another excel file
Script to increase font size of cells
Deleting Command Bars on close of a workbook
how can I use access forms in excel2003
Multiform Tab Colours
Fill two column combo box
Importing Web Data
How to run sub?
MSQuery settings? ConnectionString?
how to consolidate sheets
AfterUpdate Event not Running
Breaking a link.
VBA Question
Passing a Function name as a procedure argument
get cell of function
data from exel to visio for timeline
Lost the menus on right mouse click
Identifying the user's drive letter
where can I learn indepth how to use class modules in excel vba
Worksheet Question
Flip comment to left
Textbox Question
Position menubar
Macro to insert this formula automatically on start up
On Form Start Up
how do i build the macro i need?
easy vba question
Formatting Textbox, passing values to worksheet
trigger database query on cell data input
difficult function
Auto Userform Picture Change
Calculating hours between two points in time
Parsing Huge Files of Text
SpecialCells Method Question
Recognize first emtpy Cell in column
Code for reconizing a empty textbox
Year question
can someone help me with this formula
Excel VBA: calculating checksums
CurrentRegion less one Row
Popup opening a spreadsheet
How to reference a worksheet which name is specified in a cell
Specifying range relative to activecell in macro
Coping from existing spreadsheet
Using the value in the inputbox again
Turning off screen update while macro runs
adding formulas to blank cells
System Tray Notification/Alert
How do I publish an entire excel workbook on the internet
please help
combobox problem
Taking control of an existing instance of Excel
copy column
resizing excel window
Help with referencing variable range
Help with referencing variable range
Input data from file to Excel in Column Format
How to Put Conditional Sums in macros
Used Rows Range?
Import from another excel workbook on open
Macro timing might be the problem
quotation marks
multiselect remove
Maximum filename length. 218? 211?
More formula help
Sizing Autoshapes based on text length
OLEDB - INSERT INTO Excel FROM Stored Procedure
Reginal issue(Please help)
Create filepath if it's not available
Adding input to macro
WithEvents of MSForms.Textbox
Formula Problem
Advanced Filter stopped working. URGENT
text files
VSTO: ConditionalFormatting not working
following web link that are not hyperlinks
Treeview, avoid selecting node on keydown or up
Greying out the OK button
web, querytable &jpg
Use of SUMIF possible?
Problems with Auto_Close when opening spreadsheet from a macro
Creating an AVERAGE next to the top of a selection
Formula in VBA
Need MACRO to search for date
How to install MICROSOFT FORMS 2.0 OBJECT LIBRARY
Create an e-mail with recipient, subject and text
Macro not running when cell value is updated
Autofill until blank cell is reached
Using variable name as a value for inserting a row
How to evaluate string?
Transfer Data to Customer Database
Moving / sorting sheets in VBA
Validation List Box
Automatically Save and Route Code
Conditional Auto Fill in
many similar event procedures
Run A Macro Against a Table Until it gets to bottom
Filtering TIME/DATE
Form displays but no text
check if in list else quit application
Re: Button to email my spreadsheet
CSV separator in macro?
File protect via extern USB crypto modul?
Progress Bar
Pivot - limiting user access with VBA
How do I simulate a cursor down in Excel Macros
extracting a string from a cell
How to choose a folder
please help me with folder and subfolders
mbv vba-programma subfolders aanmaken
Replace C/R with @@@
Change - Status bar font
Setting spaces between text in a cell
Save "speed up"
mutlipage in the center of userform
create button in excel toolbar
Draw a cirle
User Defined Function Problem
don't forget to keep up with excel 12
How to select a specific file type
Select rows using a variable
VB Find String located after "/"
Quick Search Loop
change event procedure
Import emails from outlook folder as TXT
extract string
Run Macro if
sheet copy method fails...
runtime error 1004
determine if cell address is within a range of cells
Automate Autofilter Results - Copy to New Sheet
input box - I don't need the "cancel" button
VBA Hangs
ADODB Connection Problem
Sharing data
Open DialogBox in VBA
Label minimum value in Chart
Using CELLS function to define RANGE funcion
how to add text to a comment in VBA
Print selection in one page
Saving picture in clipboard into file
Deleting Columns Based upon Heading
Help - Problem with date precission
Copying a Variant Array to a worksheet
Need to disable a prompt in Excel when trying to programatically update links in a PPT Presentation that is linked to Excel
Getting Notepad.exe text in Excel including leading spaces
VB Sum n+1
Return key to "OK" a DialogBox
Finding equation between two sets of noncontiguous data
Defualt Formulas?
Nested Withs of Multiple Objects (Parent-Child)
Used Range of worksheet?
Arranging data
retrieving "Records Found"
Sorting with code
How do you link 2 drop-down menus?
VSTO PasteSpecial
Copy paste a formula in multiple cells
Macro - Selecting Next Available Cell
sendmail question
Re: PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic
Error trying to run a query in Access from macro in Excel
help with macros to protect different sheets
Reference problem
end with loop question
Disable Excel Program Messages
Copy paste a formula in multiple cells
Conditional Row Deletion
BeforeOpen Event and Data Validation annoyance.
Syntax To Link 2 Workbooks
Re: "tab" thru cells in a specific order
Protect/Unprotect Not Working
Hide row if column does"not" contain
Compressed folders
Range of Object Global failed
Error 1004 in search/copy
can I set up a sort command to happen by clicking on a table headi
If Cells.Find can't find anything
Running a macro
aligning textboxes on worksheet by cell reference?
Userform close button
Worksheet name
split?
Accessing Columns by name in a Row loop in VBA
Quick Copy
Button on toolbar for AutoCalc
Retrieving contents of wildcard match in search and Replace
Creating a pivot table automatically
For each workbook
Problem w/ Macro after move to Office 2003
Rounded-off number
Excel should let me fill down when I right-click
Code to copy formula to variable range
Splash Screen
Autofilter and Cell Count
Paste Special
Help With Formula To Calculate Commissions
Clear Columns Content
Find, Copy and change from row to column
Running Totals Formulas
Calling a macro on a change of Field Button in Pivot Chart
Selecting a single row range
Delete current month using AUTOFILTER
Cell Referencing
Find the user of an Excel file
No Blanks
Return value based on certain criteria in multiple columns
Stuck with script - Help Please
how to request Code-signing certificate
Margins control to VBA code
Help with code
Excel-created Word instance hanging on thru Outlook?
Code Execution Has Been Interrupted
How to open an external tool directly from an Hyperlink?
Call subroutine from another workbook
working with excel from visual studio 2005 express
Excel VBA/Listbox Query
How do I activate an facility from inside a macro?
Recording a filter which then doesn't work.
deleting all macro/codes from workbook
How do I move a macro from 'personal' to a specific excel doc?
Need to do a fancy string copy plus
Urgent Help needed with macro
Reflecting info between an excel file and a word one or two excel file.
Macro Sum of Cells
Refer to a hidden sheet using a macro.
Accessing word documents from Excel
macro to insert lines
detecting data in a range
Display AutoShape in UserForm
Finding a string in a cell
How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file?
Relative columns in range vs absolute columns
"Move Method of Worksheet Class failed"
Running Watch in Excel
Protection killed by sort button
Problem SelStart and SelLength
Help with For Next and Exit For
userform fullscreen
Selection.PasteSpecial with Office 2003
Problem with "#N/A" after vlookup
Truck loan spreadsheet
Autosize textframe
Filling down formula to cover complete range
Rename Sheets based on date range
How to change Macro security level very high to low...
executing an add in
import text file
pass cell value as string to function
dates in pivot not coming up with years
Updating Macro's in Multiple Workbooks
pivot date field range
Formula
Display Alert
How do I simplify a macro in excel?
Finding a row number
javascript causing web query problems
Concatenate a string when cells are not zero
Insert Literal in Access Table using JETSQL
Sorting number as text
initialize userform, using a sub
using text in an if function
VSTO 2.0 vs Excel VBA
Why Is This Crashing
sumproduct in VBA
Excel formatting should expand to other cells
Run a macro when a cell is changed by an outside source
How do I change color of cell or of character in a cell?
copy range and paste to new worksheet
Event priority
Auto save at intervals to new filename in excel
Activate code from another VBAProject
Select text from a field
Help with Date Reports
Cells.Find problem
Deleting data below last row in a determined range
Deleting data below last row in a determined range
outlook profiles
Create a collection of controls
Macro VBA, Drop down IF statement
Macro VBA, Drop down IF statement
Excel Data Merge
Append columns to existing worksheet?
Anyone know how to enter Info in a web page through VBA in Excel
Automate Opening Files
Hidding columns not working
SQL query
Excel and DDE CPS Plus serial data acquisition problem
Why this basic LOOP does not work!
How to: obtain the filename that a module exists in, via VBA?
VSTO column insert shift to right
"tab" thru cells in a specific order
New menu items
How to test if a range is with in another range?
set print area based on selection
set print area based on selection
(EXCEL) HOW TO PROGRAM CELL SO DATA WILL POP UP IN OTHER CELLS
Macro to paste in another workbook
Vlookup top to bottom & not left to right
Instert Rows Based on Cell Value
Instert Rows Based on Cell Value
Letters = Numbers
Letters = Numbers
Mirror/Flip Axis/Chart
Mirror/Flip Axis/Chart
Select paticular cells
finding cell value when formula
Automate Password log-on
Copy Contract Number to CenterFooter on multiple sheets
Comparing Absolute Column on multiple rows
Creating Pivot Tables with macro Problem
ChDrive error (server path)
Macro to Recognize Dates
How do I, in a marco VBA, code to take data from excel and append it to Access?
How do I Append excel data to a Access database table in a excel macro?
initializing multiple comboboxes
Using Date$ function in file name
Using Date$ function in file name
Find last populated cell in a row.
Creating Pivot Tables with Macros Problem
userform in a separate workbook?
How do I deal with several workbooks that are open in the ActiveWi
Vlookup to closed workbook ?
how to format a Docmd to pull in an Access file in Text format
how to format a Docmd to pull in an Access file in Text format
finding next empty row from bottom up!!
finding next empty row from bottom up!!
Problem with coding a msgbox
Problem with overflow
Macros--user choices
onMouseOver Highlight Rows
Error with macro-it worked now it doesn't
saving file name and location with excel macro
Filtered worksheet is frozen
IsDirty
problem with formatting text in every worksheet same workbook
VBA syntax
security for folder??
excel lookups
Pasting Tables from Excel to Word
First Business day of the month?
"grouped" footer changes
Estimating costs
Appending to Access table
Appending to Access table
Focusing on open workbooks
Focusing on open workbooks
Excel Spreadsheet troubleshooting
For Each Statement still not working
Help with Vlookup to several workbooks
How to control the user can or cannot select? Selection filter?
Unlock VBA project or Copy Sheets
VBA Insert Stement for SQLServer
SetFocus: conditional use of
SetFocus: conditional use of
Slecting worksheets one by one.....possible?
Evaluating files without opening
AutoFilter criteria
Why No Work?
For Each Statement not working as expected
How to program a code to die
How to program a code to die
Putting Formula in Cell
I want excel opening path.
I want excel opening path.
Close Internet connection
Accessing excel 2003 from visual studio express edition
Form.Show Problem in Excel 2003
Mark a range from activecell
Mark a range from activecell
Replace formula with IF(error(formula;"";formula)
highlight text in userform textbox
btnUpdate_Click() Question in VBA
error handling
Hiding columns
Prevent users from deleting the first row of a list
Can this be done? Type of lookup
data analysis toolpak
data analysis toolpak
Code for optimization, ReDim Preserve not handling it well, HELP please!
Learning Excel
mailing
mailing
double data
double data
Clarification on "Application.Worbooks.Count" proceedure
VBA Print set up very slooooooowww
Copying between Workbooks
Re: Split Function gives rn-time error
Lost Macro Control Characrters for Macros in Excel
Add Dynamic Array to List Box
Write Unique Values to New Worksheet
Add .LOG to .txt file on creation
Add .LOG to .txt file on creation
Split Function gives rn-time error
Split Function gives rn-time error
Reset menu wanted
quitting worksheet then excel if....
Copy paste manually
"tabbing" from one element to the other
"tabbing" from one element to the other
VBA: Object variable or With block variable not set (Error 91) - ???
What's the most efficient to check a file name is valid?
Copy last row with data to next empty row...
Copy last row with data to next empty row...
Setting EnableResize = False
Cells(i, "B") not working
Using my own dll to my excel code
Invisible the Customize item in Execl
Why am I getting a "Type mismatch" Error
Copy only some existing worksheets to a new workbook
Macro to change filename of the Hyperlink
Multiselect ListBox - Active/Inactive Items
Mtge calculation (Dly compound interest and multiple interest rate
how do I prevent a workbook from being saved?
using xlDialogChartSourceData
Auto_Open Workbook_Open
formula problem
HELP WITH WORK/EXCEL MACRO
type mismatch on saving excel calculation mode via VB app
Re: formatting columns with formula results
How to copy to cashe?
How to delete spreadsheet if wrong password entered?
Automate "Allow Users to Edit Ranges"
Hyperlink to an external program
XML Source Borders - Any known bugs?
Protect Excel VB macro
combo box multiple workbooks / sheets
Usage of SUMIF formula in the VBA code
Is there any way to switch among different sheets in a workbook while an inputbox is popped?
Sub Totals with multiple rows and columns
show form yes/no... if anything other than no, close appl.
only letters in text box
XLA add-in Abort load on Auto_Open
problem macro to show a warning sheet...
Stopping automatic macros
error in attempt to warn about macro security
Open / Run Application using VBA
Converting Dates Problem
Macro to copy excel and paste in word
api fileopen dialog - lpstrFile size limitation?
How do you turn a grid into columns?
Help with formula
Detecting if workbook running in IE or in Excel
How to force VBA to create an Excel.Application object of specified version of Excel?
Menu of sheet names
Create New Sheets from Filtered List using Template
Can Excel or Access activate a sound file based on a cell value?
Data Flipping - Approach with formula?
Close file automatically
start application / macro warning problem
How do I change the color of a cell depending on the result of the function in that cell
Shelling out to DOS
Data Flipping
selection.interior
Easy-Selecting "No" from message box
Count between Values
VBA: How to pass arrays in Function Calls?
Auto Select from list of values
blank filling remaining characters in a field.
Assignibg a value to a property from a cell
Resizing my range - End row
Help with looping
Delete Row based on cell contents
Buttons & Timers
Unusual excel behaivor causes crash... Magically linked worksheets?? Why?!
.dll error message help needed
Userform - Move to next textbox field by hitting enter instead of
Excel data to SQL Server
How to judge wheter an object is existing or not
how to cancel the right mouse button
VBA - Check for password protection
Wait time variable
Sorting and Filtering out data
'If' Statement - Must be a Better Way to Do This!
Disallow Continuous String of same Character
Can't Find Excel Interop reference
how do I choose only certain names from a long list in excel
XML Mappings to VBA
Dynamic range (object variable error)
ListBox external source
Run-time error 9 Problem
Use ADO to access SQL Database
Calculate a suspense date of 90 days.
What parameter changes upon new workbook Save?
shortcut keys in VBA
UserForm ListBox Events
Why doesn't "Resume Next" work?
replace text in files within subfolders
Checking the status of a checkbox in a user form
Date function: 1st, 3rd and 5th Mondays of a month
Copying values between sheets
How to ensure a VBA sub is run before closing a workbook
Protect a worksheet but allow column resize
copy subfolders, replace text in files and save files in copied subfolders
invoking music through VB code
Is this possible?
Macro from a different xls file run, still says file in use
convert american dates from a query
convert american dates from a query
Old Format or Invalid Type Library
Choosing different cell values by user clicking a button
sumif or sumthing else?
If statement with cell validation
how to combine 2 or excel into 1 excel file(different sheet)
Automation object question
damaged file
Format a number to display as alternative text
userform error
mail
Copy rows, but exclude blank rows
Vector addition and polar plot... need help
userform controls
Copy and paste between sheets
Re: Sort method of Range Object Failed
Programming Chart Series
Detecting when Excel user inserts or deletes a row
error with userform, "unable to create embedded object"
Code to Enable Macros
RE: Using Array variable in FIND function
RE: Using Array variable in FIND function
Re: Name a Chart so that I can adjust it's position on the worksheet(programmatically)
Text Box lost its leading 0 - need help
Move Data
Validation eradication
need list of unique values from array in memory
User Form Caption controls beyond formatting
Help - PasteSpecial Method - Not Working
Copy Problem
Userform Question (Load/Unload/Show/Hide)
Row number for End of Template
"FIND" function
VBA to Protect Worksheet
Search for word(s) in several sheets
Calculating a date within the OLE DB query
Hide Macro Process
My links in excel keep changing when adding another link?
Help: Compile error: type mismatch: array or user defined type expected
Text to Date
FIle Open/Browse on Macintosh
~Help~ converting Excel equation to vba function
Find and Replace several items
check for certain dates in excel
How To Reference The Previous Or Next Workbook s
How to copy a sheet from a workbook to another in different folder
How to transfer info automatically from an excel data base to a word document OR an excel
Add standard button on custum commandbar
VB to print one sheet twice, double-sided?
excel spreads
Combobox / Data Problems
What does Excel97 not like about this Code Q
DYNAMIC RANGES
Transfer pivot table data to another workbook
Range - Application Defined or Object Defined Error
Selecting a file from dialog
Macro doesn't work
how to call subprocedure from within procedure?
Transfer Excel Worksheet to Access
Export As Gif
SaveAs and always overwrite?
A script to write in missing text
A script to write in missing text
TreeView for Dummies
Parsing for middle initial
attn: Tom Ogilvy re: cell data in header
Looping thru all rows with instr() test
Excel2000: code too slow
how to validate excel spreadsheets
Save file without a password req
Conditional VLOOKUP?
Replace formula's in two columns with the value's with VBA
can we upload files in google group
More info
Copy Rows if Cell F? contains
Controlling MS Word from VBA Excel
Excel distributables?
Add controls to Frames at Runtime