Excel Programming [Archive] - Page 147

Insert multiple rows
Calling Worksheet SubProcs From Module
Return value for Cancel?
Running code from ~? Don't want to use <Ctrl><key>
Last used cell
Creating an private Excel.Application
Selection code
format border by group
Help creating part of a macro (find Empty column)
Merge Cells
formula - table - cells
Protect/Unprotect Sheets
Format dates and not Zeros
Custom made dialog box
Security Issue
Run Time Issue
Edit Data Query Programmically?
Count Worksheets - Late Binding
About Digital Signatures
Nested Countif
Can I Make Macros Available on A Floating Toolbar
access to cell values
access cell values
Re: using a macro to move a function into excel cell
Corrupting a Cell
Re: using a macro to move a function into excel cell
Finding 5 consecutive empty rows
Re: Modify Code Creating a Formula List
Modify Code Creating a Formula List
Re: Problem with "For each" loop using .NET Interop and Excel
Re: SQL Query from Excel
Trapping/Answering MsgBox When Workbook Opened From Access?
Using TRIM function for whole worksheet
MANUAL & AUTOMATIC Horizontal Pagebreak Report - an example
Disabled macro going from Excel 2002 to Excel 2000
Re: Macro button
Re: Macro button
Range Naming using cell data
In need of advice?
Help! - Formatting Oddity
Paste Data from the Web Into a SS & SS Runs Slow
Automation and Macro or VBA help in xl
Users in different countries error
VBA: Link Chart Title to Drop Down Menu
WRAPPING TEXT IN A TEXT BOX !
strange message
creating a range by searching another worksheet
User Defined Function
Is there a better way to do this??
sorting
Using formulas in VBA
I "DO" have a "DO"
Find and Remove Duplicates
New to macros...
References.Remove References(1) DOES NOT WORK for "MISSING:" Refs
MailMerge using a word object
why is select method invalid when sharing
Splitting up text between two fields
Sorting Worksheet Tabs
Re: need help with formulas/vlookup
Use of Indirect function in Data Validation List
Reset system clock?
Attaching drop down to macro
Move contents of entire column
Why won't this work?
More than 1 workbook in a VBAProject
Inserting Lines And Copying Them
Running a saved query
How to get Name of person signed on Computer
Empty row
How do I include wsh or vbs code/script in an Excel macro
How to keep this picture visible?
Automation Events
How To: Is a Row a Group Row
Using VBA to do this?
excel open file macro
How to set AutoFit property in Excel for merged cells
set cell to today's date macro
How to Treeview in VBA
Combobox with Commandbutton in Userform!
Userform Images
Updating the formula by program
IP Address
Calendar Control
formating the cell background color depends on the value
"for each element in group" question
VBA Code runs out of memory - too much copy/paste?
Save excel sheet.
Userform Size
Help With Restricting Values in Data Entry Forms please
How can I read/write file with binary format???
Row reference
How to enable/disable a button.
Help with Macro
how to confine the range of movement of cursor
Excel 2002, VC++ problem, CreateDispatch not working
repost: Print *.tif file from excel vba
Macro to copy daily text file
Search Row & Column
named ranges - changing ranges with month selected
Getting WorkstationID
How to make a worksheet uneditable?
Huh?
disregard the Outlook dialog box sending task/eMail from Excel 2003
Tab Key Behavior
problem running macro from schedule task
Make achange to this please
Variable usage in Range Command
PgDn in UserForm
Protection Message
Macro for selecting random lines
relative reference in a macro to define a name
Date Formatting Bug
Need help to write macro please
mouse move and exit event
Adding Comment and AutoSizing
Printing sheet order wrong for workbook
Userform question
Compile error
Very simple ActiveSheet.name question
Data type problem - ODBC Excel '97-2000 Driver
Max Memory in a Excel Com DLL
Re: Creating Charts in Excel 2002 (XP)
ODBC error to Access to DB2
Easy one: getting the name of a picture
Re: Where to start programming???
Posted Code
Auto-checking a checkbox based on cell contents.
parsing data into worksheets
Mouse over events for Active X objects in excel
Passing values to new app
How handle Hyperlinks
return the value of cells and not the formula
VBA Automating vlookups
What's wrong during VBA project compilatrion?
Fill in Combo Box with range values????
Using VBA to create cell formulas
Validation button using VBA
finding a cell has a wrong reference.
textbox formula outside procedure
changing font color and weight in comment boxes
IF , Then
Conditional Formatting
Find Next Empty Row
Modeless User Form and Worksheet Focus
workbook opens in design mode
Excel VBA - InputBox DEFAULT Value?
Interesting challenge
help with vba and command button
CODE FOR CHECK BOXES, AND EXCEL AS ATTACHMENT !
Too much recalculation
combine data
Combine rows of data in a worksheet
Embed a form?
Insert a Row
Copy and paste the worksheet to New workbook..
Subscript out of range?
Macro
Sleep, Wait and Busy cursor functionality
Division on a sliding scale
Creating a Toolbar to add-in
Removing objects without unmerging cells
Combobox.clear
Re: ActiveX control for chart
Is there a formula for this?
Update cell's value without refresh screen?
DATEVALUE and TIMEVALUE
Formula that captures criteria from 2 different columns "Help ME"
Excel 2002: Need help with Listview
Bob Phillips - are you outh there today?
VBA format cells
Re: Help! Macro to select all sheet from AA to ZZ
Re: setting value to be based on previous cell value
Combo box wont change selection?
End Of File in Code
Is this doable using excel?
Write a macro to populate a column with a formula
Macro
CONTENTS OF TEXTBOX TO BE THE CRITERIA ON A DATABASE QUERY
macro for matching contents in external file
Is this doable using Excel?
Macro Deletion/Removal
Highlighting a cell
Vba add data to cell from userform
Building/Creating an Array
Best place to learn about macros
Selecting cell next to a value
Disabling menus etc
Opening a workbook based on a cell value
Clearing a diagonal line in a cell
Change the sheets (Name)
How do I get an Excel Macro to repeat automatically?
VBA - Adding Rows
Macro to delete 0
How to get the available sheet name
Re: rng.value = rng.value
Insert Image in cell B13 on Protected worksheet
Date from InputBox
Macro and Pivot Table
Encrypt Or Hide Macro
Macro or IF statement??? HELP!
Listbox Data to Cell Comment
Printing and saving file.
Subscript out of range error
Positioning copied pictures
Macro to add 1 or more days to a date
Delete desktop icon with VBA
Stay in TextBox
Re: testing for the name of the file
User form controls add
Formula for a date
Refer to a sheet in a cell
done!
Re: Automatically add new row
Pause macro, add form button to sheet, continue macro when button clicked!
COM interop with .NET assemblies does not work (mscoree.dll)
Bug in OLEDB ?
calendar control - pivot table input variable
manually specifing a range in the code below
Convert decimal hours to time>24hrs
stop looping and comments on VBA
A Rather Involved Summation Macro
RE: disappearing worksheets
Re: command button and assign macro
Insert row between different item
form won't unload
Re: newbie: Getting the X and Y positions
Excel 2000 not responding, opening, loading
What is the control called in the list option of validation?
Big Big question
Working around a messagebox
setting a range not working, please help
TextBox
Retrieving External Data from Access into Excel
Retrieving External Data from Access
Can you query a graph?
USer Form Entry to multiple cells
Re: ComboBox move and size
Re: VB code
ActiveX Control Tutorial
Re: Operations on .DAT file in Excel...
Naming a new sheet.
User defined type problem
combo box close on selection help!!
must be too simple
Copy worksheet and paste it in New workbook, all data except Formulas
formatting email from excel to outlook
Sending formatted email from Excel
Range question
Creating an XLL with C#
Any ideas?
Column resize event
VBA Identify Workbook
Any ideas?
Inserting a row
Re: time and date
ComboBox_Change sub runs unexpectedly
Compare and delete or return value?
Communicating errors from a custom function in an add-in
Modal oddity
Re: time and date
Update a shared workbook.
Prevent File Copying
HELP!! Excel Add-in Problem
Re: time and date
using a Named Range (formula) in a UDF
Help with a loop
BIG PROBLEM
Macro to Hide/Show Columns based on control cell value
Excel VBA Inputbox Properties?
Creating a new worksheet from another
Using an array in Consolidation
Change text to all caps
COUNT Unique values
Convert an Excel Spread Sheet to a Relationship Database
Loop,Compare,Write
Background Copy Distorted
passing defined name to vb
adopting a macro to a general situation.
Where am I going wrong with this?
Create worksheets for each matching values in Column?
Canadian SIN
Merging excel contents to a Word Letter
Comparing lists
Programming for a save button
Task Schedule for Macro
Need help pasting usedrange in word bookmark
Force Caps Lock
Conditional Formatting
Pivot Change event
ProtectSharing
Disable Shortcut Keys
LOOKUP finding values it should not
Searching values in VBA
Maybe OT
Func wanted for drag/drop in ListBox
Used Range Question
Excel Lookups
Urgent! Save Excel WorkBook - a special way
How do I approach this?
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet
Fastest way of getting data into excel
Form Button
Using Microsoft Access via Excel VBA, Houston we have a problem
Application.Path (Getting the directory that my workbook is in)
DefineNames question
conditional format
vb versus cf
loop through Combobox
Setting Up Workbook Permissions
VP CODE
TIME CONVERSION
Wildcard
Copy Unique records
ListBox
Refreshing a query with a changing date
VBA user form
List Boxes
User defined functions
Creating a Graph as an Object : Urgent!
Load text file and write back
COMBOBOX WITH PRINTERS LIST
Hide Excel but show the Userfom ???
Userform
Macro created in XL2000 not working in XL97
User Form List Box
Remove item from combobox.
Creating a Graph as an Object : Urgent!
inserting rows on multiple worksheets
Delete pivot table
Getting Unixtime in VBA
Use winsock in Excel VBA
Convert number in text format to number
Place Valuse in Cell depanding on another
Using Events with Embedded Charts
Excel VBA assistance for a noobie
opening workbook as read-only
LoadPicture - how to keep .jpg compression
Convert function to sub
How do i place a graphic BEHIND an excel sheet?
Date and time problems in VBA
Check/option
Getting a Strange Message from Excel
Help with a Clear Form Macro
ActiveWorkbook.Charts.Delete
formula - average using a count
how can i change the Drive
use MS timer control in excel
Searching For Files with Dates
Use winsocket in excel
auto save with variable name with html extension
VLOOKUP PART 2....(Dave Paterson)
automatically gets month in an array
Re: Like or Equal
replacing spaces?
Print *.tif image file from vba excel
Data available for plotting vs already plotted data
Question about accessing worksheets on an AddIn file
VLOOKUP
Trapping Data Input with Curser Keys or Entry Key
Please help: How to make a button to show the sum?
SUMPRODUCT
Protecting an entire workbook
Excel SaveCopyAs COMException 0x800A03EC
conditional formatting vba code and calculation
Sorting rows beneath headlines in another sheet
Using path instead of drive letter
Excel Registry Add in settings
Workbooks.Open Beeping Problem
Used Range is not resetting
Recalculation
checking if text changed?
Registry Editing
Calander Control
VB form link
Need a macro to evaluate and sift-through data
Textbox trouble on a user form
Generate & print reports/forms
Normal Random Generator
Macro to cut and paste from Excel to another application
Sort sheet on sheet's Deactivate event
Personnal certificate and numeric signature problem (second try)
Carriage return in comment not working
Query during macro run
multi workbook cell referencing
VB Efficiency: Inserting a Row
Iterating through an Excel Range with COM automation
COUNTIF on one ranges with criteria from another
Excel Scroll Bar
Popup or Information Message
Open File Location
Sending XL data to work bookmark
Updating distributed Excel applications
import external data via macro/vba question
updating data lists using macros
Excel crashes when attempting to open workbook...even with macros disabled
Conditional formatting of an autoshape
Funcres.xla
Basic Excel macro problem with outlook
Password Brake....
Preventing Users from Modifying Custom Command Bars
Using VBA: Avoiding Writing Down Duplicate Solutions
Linking dropdowns
best way to query during macro run
Microsoft Query & Dates from Oracle
Wshshell / VB direction question
Check a cell for duplicates.
??Find and Replace Duplicate Cells
Create Macro - move selected rows to new spread sheet
Calling Forms from Forms - Exit problems
Macro Error When Sorting
Display files in a directory
AutoRun an Excel Workbook when CD-ROM is inserted; Help!
"Can't Find Installable ISAM" error
attendace %
Zooming of Excel
Manual Horizontal Pagebreak Report - an example
Calendar Control
help with excel macro
How to disable screen updating for the Visual Basic Editor
Find and display today's date cel
time compare in Excel
No Dashes, please?
Reference cells in Functions
Pass multiple parameters through macros
macro recorder question
Moving Cells
Kind of Vlookup
Using VB to change sheet name to match cell contents
how to check if a cell is populated or not?
Big problem
Copying a named range / Bullen's PastePicture
Re: Assign macro to button
OLE2 Compound file Format
A table within a cell?
Sync scroll of two ListBoxes
Assign macro to button
Wanted func to determine height of ListBox row
Calendar Control: Can't exit design mode because control can't be created
looping ... date formula ...
Find
Personnal certificate and numeric signature problem (second try)
Excel 2003 asks me for a protected worksheet password every time I start Excel
startup macro problem
"Not" and "Not Like"
Trouble with fields order of imported XML files
Can a Pivot Table pull data from Multiple WorkSheets ?
Is it possible to import XML with master-detail data into Excel 2003?
ListBox
IF-statement??
"User-defined type not defined" vb msg
Background calculation w/o updating cells
How to get the row of a specified cell content
Adding a macro to Excel (not to a document)
if not used..
Exception when uisng Intersect method
Writing a macro to bring back distinct value
Sheet Overflow
find problem
Using a variabel to make an array?
Incorrect date format
Multipage problem
Automating the downloading of web page and sending it via email
how to confine the range of movement of cursor
starting macros via scheduled tasks
Saving text files in excel 95 foremat
VBA Code problems!
Outllook
Looking up values in another file
Replace function in Excel with MFC
Finding out if subroutines exist in another workbook
user form problem
Re: How to detect if a cell is formula
How to Impot data from a text file to another worksheet.
How do you copy data from one sheet to another using a button
Anyone has any idea about XF: Extended Format (E0h) record ?
averaging from a fixed point to a non-fixed point?
"Excel VBA - Macro that returns and saves a value in every row"
Passing a named range to a chart/series object
"Excel VBA - Macro that returns and saves a value in every row"
Excel VBA: UserForm Component not Correctly Registered
Using variables to reference columns in VBA
User CDO for Win2000 in Win98
Enable Macros
late binding in excel
Countdown timers
Display first, next, previous on userform from recordset
copy data from sheet1 based on criteria in sheet2 to sheet3
XLL unrecognizable format in Win2000
Range problems
Treeview control in an Excel form
Ok heres a tough one....
Excel Mailto: subject: body:
Count up
How many members of the Bush Administration are needed to replacea lightbulb?
Changing plot order in series formulas
Sumproduct with text
Any Systems Analysts here?
Goto Next VISIBLE cell below
passing defined name to vb
Problems with preventing the user of setting a checkbox of a treeview
Please help fix my accumulator
Scaling
input form
Creating a For Loop
How to determine which dynamically generated control was clicked
Declaring a Range Object
Code equivalent to the Enter-Key
Random gen
How do I show Auto-Filter "Search" Criteria on Sheet1?
Copy rows to master sheet
Getting source lists w/o opening target file
Excel97 not quit
Sorry here it is again
Almost got it Bob- Active Shhet.Picture problem
filling a two column listbox from a two column recordset
Deleting pictures using VBA??
XLL Add-in help
Portability of program in Excel 2000
Getting text under mouse cursor
Retrieving text being typed and cursor position using VBA or automation, how?
creat a drop/down sub list
How Do I Check To See Id A Character Is Present In A Cell
Year, Month, Days
re complex "IF" Formulas
OnTime...Please Help
Excel VBA File Search Command Cannot "See" VBA Project Name
Auto set off for Bank Reconciliation
Sending Form Focus?
SENDKEYS change the "Number Lock" status
Shell function
Drag/drop - calc of ListBox row wanted
Userform stopwatch format milliseconds
Logical Comparison of Two cells
Userform Initialization
SaveAs and Excel Automation
DataValidationProblem
"Round" not found
Copy rows to master sheet
Populated cells
Here's a simple routine for LastRow, LastColumn
Streamline copying and pasting code
Automatic Sorting?
Copy and move info between files
Sub or Function not defined
Copy sheet to another specified file
Seemingly Easy Question...help would be greatly appreciated
Total of rows in UsedRange Area
Send Files To FTP - Can't use Internet Transfer Control ActiveX
Mapping in Excel Programming
Function for rate of increase re two values
Last Row Question?
Userform addition question
VBA to write Unique Solutions ONLY?
Run a macro based on event
Programming Excel "drop-down menu" functions
user defined functions
Delete Rows - include top row
VBA ListBox
RangeFromPoint Only Finds ShapesAt 0, 0 coordinates
running excel modules without excel
MsgBox for a range and not one cell change please:
Renaming
Re: Printing Multiple Invoices
Help - with macro
Form 'Refresh' problem
Regarding Crystal Report in Visual Basic 6.0
late binding in excel
Send email without security alert
Send email with alert message
send email through Excel
About calling highest level in columnfield
Find Max of Curve Equation
Show method stops macro
Web form validation using Excel datasource?
help with templete
Creating Range Arguments for use in function statements
Normal Random Variable Generator
Setting Custom Icons at Run-time
Progress Bar
problem with importing data from access to excel
Scrolling Marquee in a worksheet.
Re: Save multiple sheets in a single html page
VB function to reorder names?
Send current Excel File as an attachment using Outlook 2000
Worksheet_Change not updating with vlookup change
Saveas on Template retains existing name!
New Menu on Worksheet & Chart Menu Bars
Close External Application using VBA
excel menubar
Personnal certificate and numeric signature problem
Formula
whats the difference?
Find and read/update option button
Create colums based on a row
Please help - What am i doing wrong with this array?
What am I doing wrong? Sending values from one worksheet to another in new workbook
need to use vba to refer that if a checkbox is checked.. the contents beside it will be copied to another range - to add to excel form
organizing a large amount of data into a table
Class Module
Start a sheet event when i leave a sheet
Worksheet is no longer the active sheet Event
Range Names
registering the cell values of excel combo box associated values
'Yes' 'No' button on autoopen macro
how to get a number of rows in a given page?
Best Beginner-Intermediate VBA book
Worksheet Menu Bar
list for validation
How do I convert an integer variable to a string variable?
enable disable macro message
Supbook
Ontime event
fixing macro to highlight a row if a checkbox is checked
Font Size of Option-Button
Combo Box Control
Save Method
delete all sheets except...
refreshing or repainting worksheet
Change a cells text by another cell changing.
RE: Copy to wildcard
Adding Area Code To Phone Numbers
Make Worksheet Event available application-wide
setting properties for shapes
key Press on Forms Button
Active X controls
Macro assistance (might be tricky)
Macro assistance (might be tricky)
Re: Wierd named range RefersTo value
Automatic Value Calculation
searching a range
Column number in letters
Identify Comboboxes with Strings?
Another thing
Determine Shift Key Press
Programming Help
RE: Wierd named range RefersTo value
Workbook_BeforeClose problem
Macro Help
Type recordset/recordset?
Removing lines of data that do not contain required data (macro)
closing a txt file open in xl
Perconal Macro Book sabotated Excel's work
Runime Error 1004 Method Range of Object Global Failed
Worksheet Change to build product list
translate language using VBA?
Excel Macro
Userform updating
X button at top right of userforms
Pivot Fields
ranges
VBA Extensibility
Eliminate screen flashing while running a macro using VBA in Microsoft Excel.
RE: Net send
VBAProjects still visible after workbook has closed
Various Random Codes not working from time to time
How to hidde sheet?
Problem trapping an error
Still stuck
Rowsource not working properly :(
Calculating
Convert excel rows into individual documents in word
Macro to run on fileopen for all workbooks
How to stop getting system message
Right Justifying Numbers
memory
VBA error - run-time error '1004':
Damn error 91!
Move them to different folder
Loop
"1/1/1799" - is a date
Link from Userform to Spreadsheet
How to Hide Rows based on conditional value in cell
msgbox buttons
ExecuteExcel4Macro: Help with this
UserForm: how to print it landscape
Q re: TextToColumns
Missing Reference
Counting chars in a string
Deleting lines in a macro
Timer
importing textfiles with cariagge returns into 1 cell
Dynamic Variables
Macro to insert column
combo box auto refresh
loop through textboxes only
How to find *,@,#,$,&,^ ??????
Amending Right-Click Options
Updating Connection Strings
How do you "Round" a value in Microsoft Excel VB?
Copying only data validation
Extracting Colors from Image loaded in userform
Cells.Select - Why not in a module?
excel vba workbook_open event does not work help please
COMPLEX "IF" FORMULAS
FindNext
simple excel vba macro
Runtime Error '1004' - AddFields method of PivotTable class failed
Personnal certificate problem
File Search
How to improve this code?
ADO - Excel - External table is not in the expected format
Worksheet Change Event- Refer to Target Address By Name
VBA Code
Make a user form 'un-closeable'
Add-in tollbar
Macro to calc an intersection
VBA Extensibility problem
Work Underneath a User form
Increasing the date with a Macro
FORMATING
Excel Templates / Database Backend
Excel/VBA Questions
Solver Macro
excel functions and User defined functions
More Worksheet and Copy Pase help
Referencing a cell containing sheet name
worksheet
Looping Through Charts
Re: Indirect function
extract text
RE: Looping Through Charts
code that might be causing error - please review and comment
Formatting date & time
Code to Loop thru a Workbook
Dialog box help!
Concurrent Calls
Rename current sheet
Insert Sheet
please help with error message
Which button did I push
working with tables
How to sum Values in selected range?
Printing a range that is determined at run time
Help Finding the Final Row
Copy Paste in Macro
Importing LDB (Access Lock File) Into Excel
Colors in Cells....
If Select is the solution - how to avoid Select
How to use Macro to delete this row??
changing a formula range in visual basic
Do Loops
Follow-up to WorkSheet Function
Excel VBA - Wordwrap conundrum
Excel version differences
Re: Indirect function
Problem using Excel's "Shell" command
Help on writing code more efficiently (Loops)
Excel/VBA Questions
restrict row delition
Change the default for a comment
how to use vb to save the excel file
NumberFormat not taking
Documnet_open() code is not working
Comparing a single cell to range of cells
Drop Down Box Dilema
finding value in a hidden sheet
DeSelect certain values in row pivot field
Excel does not repaint
Re: Setting variable names in code
Copy and clear problem
vfp - excel programming
vfp - excel programming
Re: Excel upgrading = code problems
Trouble with a macro - copying cells
Too tricky?
Help needed to create a formula pls!!!
can we copy the sheetnames too?
prohibiting duplicate entries
Problem in VBA with function FIND(...
Userforms
A tricky one
Changing Connection Strings
Page Breaks Problem ( Please Help)
Autosize the column width
Setting Column Precesion (Please Help)
Buttons with symbols
Check Cells are EXACTLY the Same
Conditional totals
Recognizing something is being pasted in code.
Add-ins Decompiler
Need to Check Something
close excel
Negative Numbers
Font and size in a drop down menu
Macro working in Excel 2003; not working in Excel 2000
finds and concatenate
Transform.
How to lock the view of certain number of rows
Re: Microsoft Excel VB opening Access Application
Pagebreaks are not made
Using IeTimer in Excel Programming
VB code to move cursor 'one cell down?
VBA function to return letters of alphabet
Setting a variable print area
Automatically transpose
problem when changing forms
there must be a way
How to set two different &Pages in a Worksheet
Changing Colours on Worksheet
problem in changing forms
Using Worksheet Function Find in VBA
Best way to create and present cross tabulation?
problem using VBA in Excel
Row Height
creating a username and password box
Macro_BeforeClose event...Possible??
Excel VBA: Problem with copying an embedded chart from one worksheet to another
Combo Box Fonts
Setting the default filename in xlDialogSaveAs
Excel Add-in problem; button changes add-in path
Sort linked rows
Pop Up Message = Cell
Userform and Cell Email Hyperlink
Deleting 3 rows when current row number is unknown
menubar problem - excel 2000
Change Chart Typewith button
remove duplicates in listbox
Help with transfering info from Excel to Word
using cell names in vb code
Re: Check Box influencing other Check Boxes
Macro-Toolbarbutton
Getting protected cell error message when calculating (F9)
making generic graph with specific characteristics help!
ListBox items disappear upon Show statement
Macro Stops when Workstation is Locked
Excel/VBA - Synchronize combobox values
Changing The Changed State
searching for a range of dates
need for speed!
Please help me get this accumulator working
Recalculate Custom Function
Re: About personal.xls and add-ins...?
Code for variable criteria
Macro works in 2000 not XP for Progress Bar
Develop Excel application against MS OLAP Cubes
Assistance Needed with Comparing
Measuring Time in a user form syntax
macro
Database Query Password
Compress Excel File Format?
Re: VLookup function in VBA problem?
Zeitmessung mit Excel
Sending/Transferring Text?
Re: Excel XP VBA code to search all macro code in Excel module for specific search string criteria
IS THERE A WAY TO MAKE AN OBJECT AN EDITABLE PART OF A SPREADSHEET
Find a value if there continue
NEED TO CREATE 4 COLUMNS UNDER SIX
Re: Excel XP VBA code to search all macro code in Excel module for specific search string criteria
Macro Idea
Comparing two columns and listing differences
automated cell coloring
Re: Schedule a Macro
Securing VB Projects?
WorkSheet Function
workgroup
Re: Pass a range to a method?
Passing a variable between workbooks
Excel 2000 Macro and Perl problem
"Can't find Project or Libr." when using Form in Macro
attach manifest on install of a smart document
Changing (Part of) Header Without Changing Footer or Rest of Header
One how to please
Outlook - Meeting Requst using a Template
Installing a CAB file
Delete a macro
Outlook - Meeting Requst using a Template
Excel VBA to search all macro code in Excel module for specific string criteria
Disable Menu Item
Re: Deleting check boxes
Excel will not "show all" from an Advanced Filter on a sheet with protected cells.
searching different files macro
Insert a Row
workbook and application reference set to null after the user enters something in an excel sheet
capital letters and cell value
Search through individual data strings
Wildcards
auto refresh for combobox
ctrl A to copy whole worksheet
Finding next Blank Cell in Column
conditional printing macro
Run Time Error
Printing ranges error
Excel help request
Using 2 open workbooks
Combo box 2 columns
vba object calendar start date
Excel-Makro for automatically generated protocol out of todo-list
What is happening in this code?
workbook size
Aligning text in a text frame
Protecting the VB code from being viewed
KEEP blank rows when coding ranges
Selcting data from a list
User form question
Add Controls With Events at Runtime
Insert cells in a ListBox
Selecting previous worksheet
Inserting rows from a command button
Error on some machines ... VBA Sort function
Filtering .. Help...
Error only on some machines ... VBA Sort function
Selecting previous worksheet
Deleting check boxes
SQL against xldatabase in same worksheet
Referencing cells in a loop
Values of Rectangle or Check box
Finding All Range Names on a given sheet
Find a value in a cell?
Finding Excel application handle
CREATE EMAIL MESSAGE
sum cell address
Adding a data series to a chart
Can I use serial comm port in Excel VB script?
changing current directory to that of the current open file
Combobox with textbox and Commandbutton
Quit event missing in Excel.
Cancel terminate event??
Initialize event doesn't work
How to add new row with C# ?
Workbook-specific toolbar possible?
Setting the default filename in xlDialogSaveAs
Aoristic analysis
ShowDataForm Date format wrong
extract decimal component of number
Remove spaces
VBA - Summing data in columns
public but private variables
Disable Commandbars
Re: Array as Argument in User-Defined Functions
[sos]OWC datasorce hard problem with asp.net
VBE Font
Creating a database and PivotTable with a Macro
Cell value = 1 when open
ListBox Question
Simple Question
Deleting "variable" areas in a worksheet
Bringing focus back to source point upon subroutine run completion
Lookup up cell value in closed sheet
Code to tab from option button click
Excel Grouped Graphics Numbering in VBA
Computer Name
Printing a pivot table
Missing help entries in Visual Basic
IS Text?
test code
Unwanted spaces
ODBC file too large
Excel 2003 - Multipage problem
Column Alias in MS Query
how to reference UDF in xla from a cell in xls?
Excel VB Script Not Working in Explorer
How to Total YTD Income and Commission Per Person From Values at Adjacent Columns? (Tables Fixed Hopefully)
How to Total YTD Income Per Client and YTD Commission Paid Out From Adjacent Columns?
How can be done?
CHIINV
name bug?
Looping at Blank Lines
Re: Array as Argument in User-Defined Functions
unable to search linked excel tables due to file permission
Forcing Automatic Calculation
Breaking Out of an If Statement
Finding the next empty cell.
Cut and Paste Error
excel loses functionality when a Map Point Active X Control is accessed through VBA
Public Sub Help
opening excel file in separate windows
Re: Importing a large text file (>65536)
Populate a cell from a text box.
Select Another Open Workbook
problem with macro opening second instance
Macro Help
Excel VBA Problem - Clearing multiple checkboxes
EXCEL multiple criteria in countif function
How to find last row in import
Check a file in a directory
SIMPLE ?
How do I create a sub function
How do I go to a value
Find a . (period)
How to handle null numeric values in ADO recordset
Find and Replace function for VBA?
Creating a Sub Function
Dynamic Maximums
A way to programmitically lock cells?
Process Worksheets
How to start this Line List
Does worksheet exist
Conditional selection of two column, csv file
choose a cell anywhere and have filtered data appear there? Is there a way?
Any way to print only region with text?
Error Handler Not working 2nd time
Error 1004 when defining range by cells(r,c) format
Data from Access to Excel
Adding Worksheet_SelectionChange code by macro
Re: make my vba/excel program faster
NaN Validation?
Thank you so much, Frank Kabel and ~X!
How to completely disable Insert, Copy and Cut?
Specifying ranges relative to a cell