Excel Programming [Archive] - Page 157

VBA function return matrix?
When has Excel finished printing?
Data Validation
calculate the derivative (rate of change) of variables
VBA to copy entire sheet data + formatting
Variable sized average macro/function
Re: running a sub
running a sub
auto suppress unused rows when printing
Problem with the Workbook_SheetChange event???
Cell Formatting when copying
Re: Saving a file with a name from a cell value.
Re: Saving a file with a name from a cell value.
Code to Update a Record
Client unable to establish connection
Re: Add-In - Component not correctly registered
Using VB to save an excel object to another file format (excel95 or csv)
EXCEL VBA - Run-time Error 1004
macro too fast???
Problems with Shared worksheet/workbook
#N/A
refer to the sheets Name property in my code (not what is on the Tab)
UsedRange problem
Defining Names Programmatically
Inserting rows with same format
Help-Copy&Paste code
Activate / Deactivate mouse move event
Addin for Excel 2000/97 (In Visual Basic)
Use combobox for universal purpose
Data Validation using VBA to reference to another book
Accessing Closed Workbook Information
Cell Text Upside Down?
Novice Question: Text Size on Command Buttons
Multicolumn Combo Box
CSV export, deliminating character
Placement of Code
Countif Function
Excel VBA - Select all sheets
Simple Way To Step Through Checkboxes
Two tables, one chart
Triggering an event based on reference
calculating with timestamps in format hh:mm:ss.000 in EXCEL VBA
Brian B: Copy values between workbooks
Excel97: Fillup cells with ascending timestamps
Can Excel macro have functions to check POP3 email!
Sum Up Dynamic Range
ChartObject index
Sumif in VB Code
Copying from other sheets
Put Email Address from Excel to Outlook
Looking for info. on documenting a programme [Start to end]
Need Help with checking records
Macro Security on XP
Sql.request for GROuP BY
How to email A file
Inserting Rows after Input Box is used
Re: 3-D Reference
Help needed
3 digits then move the focus
Help with decimal half fraction
using vba to download file via ftp
pause for input during macro
VBA + Excel Web Query - Timing Issues
Force macro security warning to be displayed
EXCEL VBA - Data compilation coming in from an external feed
Run Specific Marco
DOS Messaging
What is the difference between "=if" and "=+if"??
Deleting Duplicates BUT with a twist
Quick Question with selecting cells
Passing arguments to a sub routine...
Excel VBA SQL
HELP
Break string into words
Autostart
Printing to Acrobat
updating range value via knowledbase 278973 fails when cell contains formula
Managed Add-ins in Office
Adding a BCC and a second recipient to E-Mail Commands
Create a new property for the current workbook.
Testing if a file is open
Sharing variable values between open workbooks?
Managed Add-ins in Office
Convert String of 512 numbers to a range
Updating the X and Y Values
Producing a list of all possible combinations
Excel VBA - Importing columns from different sheets
date formulas
Display last date edited in workbook
Retain cell format while linking cells
Re: overlaying frames on a userform
How-To - Forwarding Excel 2000 events to .Net application
Subject: Re: If Statements
VBA 'PageSetup' performance
Is there a bug in Excel 97/Office 97 running macros ?
CLIPBOARD
Writing Command Shell (stdOut) to Excel Cells
Advanced Copy paste
My Macro problem
xldown and xlright
Macro Problem
Using MS Query to Push Data to Oracle
Re: visual basic macro code for deleting referenced rows
VB Projects stay in memory
My biggest excel brain racker yet...this one isn't simple
Re: visual basic macro code for deleting referenced rows
Making UserForm Values "Permanent"
I'm getting #N/a but i want 0 or '-'
Date Conversions
linked workbook
linked workbook
Scroll Bar
Securing Macros/VBA Code
Recommendations (macro)??
Rounding time
Formulla
Identify: VPN or Network - What API Function do I use?
PRINT
dialog box displayed when internet connection unavailable
Command Button & Macro
Auto Filter From List
Delete row?
Save changes command
Formula & Dates
Message for Ron de Bruin
Binomial Tree
Search-Copy and Paste-code
How to get Active Directory Usergroup information
Macro Issue
Excel macro migration resources
Sheet's Name
Code for autofit/merged cells doesn't work
If Statements
Textbox to look at a cell in spreadsheet
User Form movement
formula help
Paste as values
trapping error
Sheet protection error msg - Unrequested sheet activation
Can someone tell me what this means?
Embed payment alert function inside worksheet
How to control sheet number when adding and deleting sheets?
Is this an Excel workbook event triggered AFTER saving
Why won't this loop?
F3Dynamic.dll
A rather Taxing question
Opening a worksheet in VBA
Cannot create transparent XP CommandBar picture
Highlighting individual words in a cell with VBA
Active movie control
Re: Email from Excel WITHOUT Outlook
Email from Excel WITHOUT Outlook
If Statement Help
Excel template-run code on open
Password in Excel
Delete multiple rows
Avoid asking to open with macros
Macro Run Error
Searching for a value in another sheet
Email from Excel
Applying Sum Function to 2nd Dimension of Array
Re: How to change number formatting
SpecialCells(xlCellTypeFormulas)
Re: How to change number formatting
Re: How to change number formatting
Re: How to change number formatting
EXCEL LEVEL FILTER
Scenariao needing help with. convert range to string and back,
EXCEL VBA - Run-time Error 1004
How to call File Open / Save Window in a Macro
listbox control in VBA
Worksheet Serialization - Is It Possible?
problem with this code
Alternative to web query in Excel 97?
A way to have a 'cut' command affect only the cell value?
Adding SQL Select Statement
Addressing envelopes
Password/Multiple Sheets
text box
assigning a macro to chart
Format a cell
Check if a range is inside another
Nothing?
printing in excel vba
Open Outlook from Excel and send attachments
Insert blank row
before print event not working
Msgbox
Macro generates new sheet
Excel as a Database and entering multiple records
Macro generates new sheet
Help for final touch up to my code
Macro to View Protected Sheet
How To:
How to load userforms in excel (vb)
Customize Pivot Table
Execute VBA macro whilst editing a cell
Selective import from CSV
Kind-of extended sumif
TreeView Control
Create event triggered by Pivot Chart field button
Size of Excel workbook
Hi
Password exposure
How to find the drive letter?
excel VBA - Userform cmd problem
Accessing Closed Workbook
Automatic generation of Trouble Tickets
Form info to different spreadsheet
copy values between workbooks
Help - where to put VBCode on a network
ADO Security Warning
save dialog when installing an add-in
Calculation based on lists selected
scrolling in module window
QUICK PLEASE Outlook object Reference name
Simple Code Required
Open & run a workbook macro.
help me Mailing in Vb, Excel sheet
add 1 when click
file size gets double
Excel VBA / Data Sorting / Maniputaltion
Is member of an array?
Comparing Spreadsheets
Re: Fit to page
Excel to ASP
Closing VBA editior programmatically
gas and mileage
Re: Adding buttons with macros
Make macro go to first empty cell in column?
help with my macro
Nuber of Days between two Dates
VBA - Convert my variable range array to single cell string
Sorting 2D Array
Excel Application needs a DLL
Excel 2003 "bug"
Excel 2003 "bug"
displaying picture in a userform
Creating a Range and Range Name
How to get the size of the excel file, a sheet size (in bytes)?
Automatically email document out of Excel
sum in multiple sheets
Conditional Formating of text
Simple LOOKUP problem
Solver VBA Help
Help - How do I reset usedrange in excel 2000
Syntax using variable in cell Formula
Excel Macro programming
Series Question?
Copying and renaming files on disk
create a find button
Playing a .wav when a cell's value changes
pivot macro
Userform cell reference help
Bad QueryTable Row Count
DataBase Connection
SaveAs
Microsoft ADO Ext. 2.5 vs. 2.6 for DDL...
Help: Formatting Percentages
Saving files
VBA Autofilter nightmare
PROBLEM
GIS mapping / routing / driving / addressing / postcode information in Excel
Finding & Deleting Spaces from Cells
auto sort
Determine if Excel is present on the OS using DOS
Excel 95 VBA to 2003 VBA
Printing a VBA Form in Excel
Setting a formula using VBA
help with loops
Determine used range of worksheet
Identical menuitems referring to wrong workbook
.TransmitAnsi does seem to work
Excel Workbook hiden when written to from Word
Databasing in Excel...I'm in way over my head
Using the "Ready" Message Bar instead of MSBOX
Script/function to extract duplicate entries between two columns?
Template Macro Execution
Downgrading Problems from ADO Ext. 2.6 to ADO Ext. 2.5
Embedded Controls
Automate text import
Freezing a row
Sheet.Calculate limits??
Help! MsgBox and Prevent Save
Calendar recognition and codes
Splitting out text in VBA
Workbook_Open not running when Analysis Tool Pack Add-in selected
Parameters with fixed set of possible values
macro to set printer range base on the word subtotal
Input Box to rename sheet?
5D Array using Name reference
Protection nightmare
Shared Workbooks and activecell
Using variables in SUBTOTAL functions in Excel/VBA
Using VB to format Excel cells
Counting etc over multiplesheets
Month Day Functions
Macro creation with IF statement
copy from one book to another
2 rows of email addresses!
Open One Word File from Excel
Remove Enable/Disable Macro message at startup
renaming the active sheet
Code-Copy & Paste in Text Boxes
Autofilters in macros.
Move non date/add blank row
macro...
keeping VBA script with a workbook
prompt for input while macro running
Crystal reports 8.5 in excel
Fill a combobox
compatibility between excel 2002 and 2003
Extracting from one cell to another cell
Filtering data within macros
Re: Hiding calculations
Names Collection
sum a column, but only for specific rows
copy values from one workbook to another
Defining ranges in VB code
Re-setting the serial number of text boxes
How to find if a workbook is open
Clicking on a cell to execute a routine
Re: Problems from ADO Ext. 2.6 vs. ADO Ext. 2.5
Assigning values from a selected range to individual variables
AutoFilter
Can anyone help?
Shorten Code?
Re: combobox duplication
Define Range for Combo Box
show msg box if a cell is still blank after a date specified in another cell?
Re: sql server connection
Re: Calling up the Solver function in a VBA macro
Print
Textbox adding problem
Can we get the size of a sheet ?
VBA code delete code but ask for password and unlock VBA protection
Resetting a variable to nothing
Re: Select text boxes code
Emergency ( Adding Worksheets dynamically in Workbookds)
Clearing row and columns
ExecuteExcel4Macro Page.Setup Runtime Error
Help with Edate Formula
GetUsedRange Property does not release RAM.
Creating/Destroying Toolbars Programmatically
Macro to enumerate subdirs and files in a directory!
Using wildcards within a text box
Repetitive IF THEN Statement
Comparing a cell value to a range value and display a matched value
Comparing a cell value to a range value and display a matched value
Re: Identify Cell location in VBA
Sorting Arrays
VBA.Left
Re: Addition code for 110 TextBoxes
how to write other language in text file from VBA
Re: Addition code for 110 TextBoxes
Re: Excel User Form- Format Proper Case
User Form-error 1004 unless opened in sheet w/combobox data
Re: Excel User Form- Format Proper Case
Re: Maybe an easy If / Then statement? But I can't figure it out. Help!
DownArrow?
Re: Excel User Form- Format Proper Case
Setting PrintArea by using Named Ranges
Re: Cell link in a form listbox - can it show a word?
modifying formulas with code
Formula
Using Network paths
Help with textboxes requirements and msgbox
Sheet Protection and sorting
Calendarization code- A real brain teazer!!!
Excel & COM
Saving Macros
set path for Application.Run
smart tags - Subscript out of range
clear textbox contents
Different Month, Different Workbook
Creating a Macro that will Import Forms from Outlook
Accessing the Systray; what language/function does this?
Delete workbook after 30 days ...
Macro to Cut & Paste Rows
Excel combo box
Problem with PageSetup & Printing
seperate numbers in a cell
Is there any way I can increase the size of the virtual memory in excel while running the macro?
Search for Locked Excel files
Date-Math Calendarization Codes
Excel2000
Increase decimal macro
copy/paste selected worksheets
create macros that uses if-then-else statments
Control Button Clone
Macro and slowing a progress bar.
Need help with VLOOKUP
Multiple ComboBoxes and TextBoxes on Userform
Dynamic Array
cell overflow problems
Excel Spreadsheet-Salutation Column
copy and paste in different columns with conditions
basic variant to array conversion
How can I loop to find the grouped shapes count
How to: Make user click End User License Agreement acceptance
Copy value to last available cell
camper
Link Data in specific cell in Access to Excel
Macro
Excel 5 on Windows XP (2)
unique random numbers
Showing a userform based on a condition.
Creating range name for a range selection
error message when using a userform
Interesting Treeview problem.
Propblem setting OnAction property at runtime
Summing rows
Q. Can my Chart Area contain more than 1 pie chart ?
False UsedRange in hidden columns
Question on "Splas Screens"
Excel Automation - server hangup
VB Error Codes - where to look?
Userform activate event question
Macro Help
Sorting into Alphaebeticla orde
button to launch my userform
coolbar control in VBA
Row Height = ??
Excel Macros
creating buttons with a macro
Open method of workbooks fails when Excel is hosted in IE
Print & Print Preview crashes
Bad declartion of Excel in VB program
Comment Question
Code for Trial Version
Macro Help
filtering list based on formating
Best excel macro (vba) book currently ?
Programmatically adding buttons to a worksheet (Shape Object)
date data types
Totaling & Subtotaling duplicate rows.
positioning msgbox and userforms
File Specific Toolbar
set printarea to invisible
Using Autoroute from VB Code
macro to calculate cell vlaues not working on decimals
Writing a formula into a cell
reading data from text files in VBA
Help with formatting fractions
Promote / Demote
PivotItem Delete deletes ActiveX Controls?
Function Parse Problem
Excel 97 - Cannot delete custom toolbar from file
Email from Excel att: Ron de Bruin
Cell Values On User Form
copy result to a specific location
Islike function
Delete workbook after say 30 days ...
how to find out when a ListBox is populated or select it
Excel papertype
ChangeLink
Saveing a file (Confirm Replace)
Hiding "0" rows in printing.
I need help with Excel 2002
Creating Range Names
Dictionary objet
InStrRev function not working?
path names in getopenfilename
Export a form via code?
VBA Solver FormulaText
doing COUNTIF() in code
Formatting number in a UserForm TextBox
Deleting rows without a fill
Working with times
page break
Working with pictures and text in cells.
Show Dialog of File/Directory
stop the column widths from changing
address of cell formula is in
How to refer to controls by string
help: master control macro and user form
VBA References
custom toolbar always available
kill worksheets
Copying Worksheet triggers Click event of combobox
Macro is too fast for SQL request.
Macro relative to button position
Looking for some help.... How can I do this in Excel?
Select a cell in the middle of a macro execution
workbook as variable
User selects a range
Test for VBAProject Locked from Viewing
High light cells or conditional formatting
Adding specific rows together
Deleting Duplicate Rows
Transforming date ranges into discrete dates
Assigning Array Values
Global Common ?
Name of a new workbook
How to call startup folder vba function?
copy formula
change a Dialogsheets
Suming up a Split second timing
Using Excel / VBA to automatically email forms - how?
Need help with simple VBA Script
is there a way
Email from Excel
RefreshAll Data with VBA
Formula
Using Collections
Pivot Table Updating Issue
Merging data in a pre determined form
Out of Memory Error
Dialog Box List of Current Open Workbooks
special characters
Submit User Form Contents to next available row
Getting Data From Sheet
Changing colour of text in cell
problem with: hidden (invalid) external reference
formatting macro with a toggle button
expanding sumif
userform
Array Scramble
Flashing Text
Veiw Full Screen
Workbook and IF,THEN, ELSE
More help with Sumproduct VBA
UserForm / Protection??? :(
Help with Macro in Excel
VLOOKUP
Help with Macro in Excel
Using a macro to set a range name in EXCEL
Any delete rows macro faster than this one???
Defining input box data type?
print pages when text area changes in size
Undesired Rounding in VBA; accumulating values
3 possible methods for adding value to a combobox
Textbox formatting
Complex identify values then cut/copy/paste query
Excel2000 Upgrades
Excel Graph Range
VBA Compiler Error Cause Excel to Crash
Relative Cell References in Macros
type greek character
Looping Problem
MakeCompiledFile Method
Macro bug - looping thru multiple worksheets - workaround?
cut and paste a text from column (B:G)to A column
Use VB code to remove code in sheet1
Need help with cell protection...
arrays again
Word+Excel - merge
Help with passing date value into Auto filter criteria
External Data Queries and Cookies
If statement? Or lookup? Or both? Please help...
IsBroken property
Macro clipboard problem
value of active cell into a variable
Altering cell contents
excel web query problem, data not on actual page?
Returning VBA results to a cell
matching data on seperate worksheets
Macro to hide rows.
Ascending data form auto-entry?
Activate Excel worksheet after showing a user form ?
Enable events
Multi Function Excel Data Form
Range Reference
macro needed for sorting txt in a ceratian manner
Where to put code
Sending data to Access MDB Table?
Accumulated Amount Problem - Excel VBA
Returning Data From Access
random numbers
Help with SUMIF and criteria
how to put a reference from a page of a multipage form to another page
Send current file to an e-mail address
creating macros to auto fill cells
Dynamic Web Queries
Formatting
filling combo box
moving data between excel and access
update Access Table in Excel
keeping a print header tied to a worksheet cell current
Excel App
Easier date entry
Excel App Deployed on Intranet
+ 1 to each cell
specifying workbook for worksheet code name
Error when merging files into new WorkBook
selectionchange problem
2 Macros
xyz
Add-In Virus Scan
Memory Problem
Re: Selective protection of charts - permit only beforedoubleclick?
InputBox Method Logic Problem
Automatically add a new row
Getting around Excel Macro notifications in AD
Select.Range function in VB IF statements?
finding a Color Formatted Cell and then displaying a cell's value in same row??
different IDispatch in event handler
Worksheet Save Event
Question about inserting data into a PDF
Formula to COUNT certain criteria
Resize Range Problem
paste special
Help with pivot tables
SelectionChange problem
SaveAs Method and sheet protection
How to make IF logical expression equal to any 5 digit value
Modifying formulas through code
Macro Help
tokenizing equations
Code for many check boxes
Excel-Tools
How do I loop through workbook and rename all chart titles?
adding Tiff files to the list of image files
Trouble with SendKeys
Status Bar
NO
Can vba put an icon in the systray?
Trigger code
Bizarre and frustrating bug
Creating custom library of functions/macros
Temporary Userform
POP-UP WINDOW
Print
Identify rows with certain background color?
Landscape print
Days of the month
Mouse Down event
Userform Position
color code dates due
Call macro - duplicate shortcut keys
Copying Worksheet triggers Click event of combobox on another worksheet
Object variable problem
Excel 10 number problem
Importing Data from another Excel File
Extracting Excel data and uploading to access
Combobox & locked cells
Combine Code
Buttons or Check boxes to filter data?
xlpagebreak Property
Form VBA
Column and row width
Saving file with current date
Macros - Adding & Subtracting Time
Macro issue
Copy Column and insert
Custom Menu Item specific to a workbook
Macro Enable/Disable Window Should Not Appear But It Does
Do Until
Auto Sort Formulas
TXT to Excel
Initiate Macro Formula :: Combo Boxes
Using VBA to change macro security level
linked wrkbook
referencing sheets
Customizing VB Macro on Menu Bar
Preventing deletion of a custom toolbar
Renaming a file
Application.OnKey problem
converting number to string
B = Y Intercept
opening buttons
sumif formula in a macro
Workbook_BeforeClose Event
Saving worksheet as .csv type
Triggers events
Type Scope
Macro to select non empty rows in a given range
counta in vba
color code dates due
format number
Runtime Error
Defining a range
Storing and Retrieving Variables Question
Exit buttons in excel
worksheet copy problem
VBA DriveList / DirList Controls??
VBA Code- Copy and paste into a generic text box
VBA versus Worksheet function
Re: allyssa milano nude
EMF Files
Excel VBA - Create worksheets
VB Toolbar
Re: Worksheet Protection - Enhancement
Excel VBA to get MS Outlook Contacts Records
How do I check opened wokbooks?
Re: UDF becomes #NAME - with test case
Naming the current cell in Excel
Find and Replace with VBA and Error messages
Excel Graph on web
Rounding
Send current file to an e-mail address
Find value and adress
How to get rid of the bottom scroll bar in a ListBox
how to program lottery checker in Excel spreadsheets?
TIMESHEET
Auto cell range calculations
rtf file format.
Opening a Word doc and more
Creating own filters
Deleting "Personal.xls" file
Date and Time Formula
Do Loop
writing array into excel sheet
Find and Replace
Opening excel spreadsheet from within a VBscript
Dynamic range problem #2
no messages from microsofst,.public.excel.misc
Process Theads
Is Controlling External Apps with Excel VBA possible?
Date but not TODAY() ...
How to install a workbook as a shortcut on the desktop programmatically
Scrolling with mouse wheel in VBE
random number generation: loop
Validation issue
Disabling a 'Group' of OptionButtons
Onkey Method
Using Range with R1C1 notation in a macro
Class Module query
Sum if formula
Events firing willy nilly
Out of memory error
FaceIDs for VBE Menus
Cant run insert row through loop
Sumproduct VBA Conversion
Syntax Error Runtime Error '424' Object Required
Calling all MVP's
Testing if Variant is Range or Double?
cursor selected range from a text box
counting functions
delete all but protected cells
Question about "smart" text comparing
Code for Many check boxes
VBA Help - Hiding Rows
conditional formatting to drawing objects.
dyanmic range
Re: Tracking Virtual Memory
Converting Text to Numeric
Excel VBA References
VB Macro Buttons
RE: Tracking Virtual Memory (bump)
object required error message
Code Question
VLOOKUP - indirect reference to other sheets
Question on custom commandbars
Removing links
align data in a cell from VB
Msgbox - Puting current date in a message box
XL Versions install base
EXCEL MACRO DEVELOPMENT
Problem - Filter based on color?
Using worksheet codenames
using AutoFilter object
Bulletproofing a worksheet
formula help
Determine data type for Pivot Field
Re: What is wrong with this code?
How to Make Multiple List Box Selections Populate A Column in Excel
Bob Phillips: Program Right Mouse clicks?
Add-ins
Get Value of Equation on Chart
How to get the 10 lowest numbers out of 20 in Excel
Excel Validation Problem in VB6
Combo Box uses
Make A Set Of Date
FindControl ?!?
F2 + <enter> without sendkeys?
locking information in a cell
Active VBE Module ?
summarizing data from several worksheets
What is wrong with this code?
Automatic spell check
HARD PROBLEM! Need help stat!
Copying text from a text box into a cell on another sheet
Creating formula range by last name.
Re: UDF 2000 compatible?
Re: UDF 2000 compatible?
how to refresh entire sheet?
Plase help me clean up my code
Range Selection shouldn't be this difficult!
Creating a VBA form in Excel
Creating a range
Using Functions from an Excel Addin
How do I include a wider range in my code??
Subject line in E-mail
dynamic color changing within cells
Stop Excel Updating formulas when cells are deleted?
Allow access to cell but don't change cells formula
Pivot Table & Time
File Copy Macro
Conditional Sum
Formatting to Percent using Excel Object Model
Serial No. of PC from VBA
small excel project
Autoexec Macro
Protect sorting buttons in menubar
how to create ado recordsets from rows of data?
Enter formula in cell
Email worksheet using VBA Code
Getting the Label or Caption of MenuItem Selected
checking for duplicate worksheets
File size comparison
Setting up a SourceData:= in VB
Moving in multi-sheet document
copy data & format to mutiple sheets
reshape area
WORKSHEET
ListBox Scrollbars
checkbox numbers
Incremental filling of cells
Calling Webservice from Excel
Delete row if value in Column X is 0?
Insert path and file name in excel 2000
I need to select some values in a Listbox????
Macro
Excel VBA Highlighting/selecting an unknown range of cells
Worksheets - Add / Move between
Best way to Update Master Database - via Spreadsheet - sent to sites
Delete certain rows of data...
VBA Auto selecting and calculating ranges
macro to find a text and return a message
Coyping from Excel to an MS Word Header
VBA Database access - How?
VBA Database access
Updating multiple cells from a UDF
From 1 sheet to the next?
Search on a part of the cell value
short message after button click
Excel-Macro running through SQL update.
Email an Excel form input using VBA
How to Include exl charts from closed worksheets into PPT slides
pivot table - %structure with subtotals
Generic Macro
Importing data from SQL database - Variables
Date in worksheet on opening ...
VBA - Preventing duplicate entries using a macro
what's wrong with my code????
removed vba code
can we hide #N/A display because of VLOOKUP
for Ron de Bruin
Multilanguage issue
Save as FIXED LENGTH
Emailing Web Archive Formatted (non-interactive) Excel files....
automatically enter time
Combo Box List
SAVING A COPY OF WORKBOOK W/O THE CODE IN IT
mkdr
Calculating Last day of month
serializing excel objects
Excel has encounterewd a problem etc
Macro to find the 6th occurrence and move range
System Root directory
Data Form question
Permission Denied: no write occuring [Excel2000]
clear object
Masked Edit Control Version 6.0???
Excel Print Page setup macro...
macro runs except from function
Pasting a Range to Word
Option Base and reading from Access
"file not loaded completely" error
data between sheets
help
insering a row to spreadsheet using VB
Worksheets - Add / Move between
Dropdown Macro
Cell content formatting
Macros terminate early
Cell Reference within NamedRange
Transfering VBA Array Column Range to Excel Column Range
How do I: Cycle through selections by clicking on cell
Trap Right CLick Insert
Reading PivotCache for Pivot Table
How Do I Display a Range of Cells in A Message Box Using VBA?
Turning Design Mode off in VB code
Is this "If Statement" Possible?
Status Bar Every Nth Loop
RE: Running macro at startup
VBA and Crystal Ball
Loop using cell names
Getting output from an excel output back to cscript..
Demonstration using XLS files
Re: Delete extra rows at the end of macro run
Delete extra rows at the end of macro run
Command Button
Drop down menus...
Licensing an ActiveX control
Worksheet data linking ???
Re: How can I return a Cell reference to a variable.
Loop through workbooks in a folder and return the value of cell M43
Re: Running macro at startup
isolate macros
Searching in a row with push on a button
Re: Running macro at startup
Excel hides below other windows
Creating Table from Web-Based Material
overflow error
VB Printer Object
specifying workbook for Sheet1
ODBC question
Requesting file names
Re: Running macro at startup
File name seach within open filetype
MBTimer.ocx Reference
Formatting SubTotals
Loading Excel Array from VB Array Faster
Code to open new workbook
Rnd function used in VB on network
vba to add and name worksheets
EXCEL keeps running in task manager
Solver Bug Fixed?
Whcih financial year?
Getting VBE to recognize a new sheet
Pivot table....building arguments for the .RowField property
personal.htm & personal.xls in Macro
Exporting chartsheets and breaking links
how do I: click in cell and make it change color?
AutoFilter question
using AND and OR as an if then condition
Help reading in a text file
Question AND my 1st positive contribution
Re: Use current sheet name in Macro
Inserting Picture Excel Sheet
Add Unique item to Collection
make new .xls file
macro that sumif a specific range
Importing Data from a Stored Procedure (SQL SErver)
Column Total Needed via Macro
how to send a workbook shortcut as attachement in an e-mail from a userform
On Sheet select Macro
checkbox identification
VBA Excel.Application
starting a msdos exe from excel
QueryTable Field Name formatting
Help finding changes made
hiding menubar & toolbar
worksheets
Re: move mouse or cursorpos
Need to merge 1500 files into 1!!!
Re: 4th Repost with no answer, Urgent reply needed!
What's wrong with this bit of code
create TEXT files for EACH row in EACH xls Spreadsheet
extracting information from workbook to another
Bob Phillips
Can border formats be locked?
Opening .csv
Re: VBE code pane
Importing data from external source
Floating information box in a worksheet
Checking with code to see if a Workbook is Protected?
Re: VBE code pane
combining Two excel data sheets
closing excel after closing a workbook
Data Migration
Populate a matrix, How?
Count Down Timer (Seconds)
Re: Data Tracking Template Wizard
Re: Saving hidden data with a worksheet (preferably without using a hidden sheet)
Combobox: Selecting values from a row and place in combi box plus update
tmp files - so many tmp files!
Transmittals & logs
Want to Bind ADO Dataset to Excel 2003 Pivottable
protecting sheets from a macro
Import useerfom, module in .xlt
x Axes valus
Open sheet1 always!
How to run my macro on Insert->Rows , Edit->Delete
Transfering data from one worksheet to another Worksheet
Excel Add In Problem
Uninstalling an add-in
Modify excel userform controls through vbproject?
different ver Excel - problem with decimal separator (for experts)
copying between office apps ( excel & Word )
Column Width Excel VBA Problem
Setting the range in a chart using VB
Visual Fox Pro ODBC msi package fails
Remove VBA code
Evenet when excel menus are changed
send contents of cell b4 to a plain text file
How to display japanese characters?
Combine VLookup and MAX ?
problem with Subtotals and ClearOutline method
Howto Show importerd userform
RunTime Error "1004" QueryTable is Invalid
question about custom button
MBTimer.OCX file
Excel Add-in
Forced Capitals
Linkedcell Problems...
Refer to a Name saved prior my macro Starts from VBA excel
Syncing Horizontal ScrollBars of Two Excel ListBoxes
Urgent-formating of columns
Row/Column Insert/Delete
RE: Changing a macro to save as Unicode text
Macro file format not valid
Error 91 but only when sheet is protected
Formula between Worksheets and Drop down list
Option button task
Looping thru columns beyond Z
Help with code for two cell accumulator
Re: Checkbox to hide or show rows