Excel Programming [Archive] - Page 139

How do I get this VB Call to work?
Problem with Help file in VBE
Status Bar and Column/Row Headings Help
strange error message following INSERT INTO statement
Test for exact match in string
How to reference # of copies in print menu?
Error 91, Object var or With block not set
Siple but what was the formula for splitting names?
Two Questions
Drop down lists
Can you make a cell on a certain page constant on all pages?
Preventing User Access to VB code
expandable listbox
Identify CD-Rom drive
Eliminating Duplicates
Closing
Re: finding the last column and referencing it by letter
Vba - generating button into worksheet
Auto close excel without saving
My program uses up resources
Moving VBA scripts to new workbook
Stupid End(xlup) problem
Code is not working....please take a look!!!
creating a drop down list
GETTING THE NUMBERS TO POST ONTO THE NEXT LINE
Toolbars
Modifying FindNext and Copy Code
Run Macro w/o Opening Excel
Array question
Re: Macro to find name of sheet tabs
Merging two or more workbooks
GETTING DATA ON TO SHEET2
SHDocVw.InternetExplorer
Sheet Group & Formating in VBA
Passing Variables
Problem with format()
loop through form objects
Get table names from access through vba in excel
Can I Group Form Check Boxes?
Moving objects on a form
An efficient find function
Picking the latest entries from a column
Deleting Duplicate Rows
Is it possible to teach ones self VBA?
Re: Only allow certain users access to specific sheets within a workbo
Validatio Problem
Re: FindNext and Copy Help (Urgent)
How to paste cells from Excel into Outlook email body?
Highlighting cells with vba function
Save problem
Open all files in a folder
Re: FindNext and Copy Help (Urgent)
Running Code From Controls On Other Forms
recovering linked values in macro
For Each Next
Re: Virtual Memory Error when running Excel
Re: Hide VB Source Code
VBA - Flexible Sort Macro
Inserting Rows Macro -- please help!!
Togglebutton with the triplestate turned to True
Saving Range of Cells as Image File
Macro for Custom view
Invalid Use of Null
textbox & tab
Web query & Passwords & Java & HTML
Re: Personal xls will not open automatically
combination of numbers
Auto New macros?
How can i get the value of the AsktoUpdatelinks form ??
Create Barcodes in EXCEL 2003?
Need Comments on Code
If statement in VBA
Range.calculate debug, Excel 2000 VBA compatability with Excel XP
Sheet properties
Worksheet Function using VB code
Command Bars
Starting Easy
Extra feauture to the following code
I have a Function Call that won't cause calculation.
TypeConverter Excel-Automation problem
User Form to display more than 1 reslut
Check if clipboard is empty before .PasteSpecial xlPasteValues
problems with XL 2000 files in XL 97
Setting ComboBox ControlSource in code
How can you make an array of objects?
PRINT AREA IN PROGRAMMING
Qn: Date Format in TextBox in UserForm?
Help File
solver.xla fails
how to get onkey macro to fire while another macro is running
Excel – Macro Problem – Appending Data
Get the list of data inside AutoFilter list
appactivate
EXCEL 2002: How do I user/simulate a Timer event in Excel form
appactivate
Pivot Table - Subtotal of 3 columns
Don't want to insert a partial row
Looking for faster method for Copy & Paste
Question about removing Web formats and content
Filtering data out of access database
Changing only source file of pre-existing text import QueryTable?
2003 Secutity Issue
Select an item in a listbox using code
cursor position
MS Progress Indicator Mimicked. Thank you.
Excel 5 macros
Copy a range from a CSV file in a webpage to my local worksheet
Adjusting screen layout?
Relative time in SQL
How to launch excel spreadsheet and load xml file from cmd line?
Replacing keystrokes
Fax
list of extended properties for use with ADO connection strings
Vba - User email direction
Protected File
Copy cell without border
How to declare variable as Excel constant?
Loops in a range for a more than one ocurrence of samevalue
looping and copying from onesheet to othersheet
How to do Cut and paste
creating Toolbar on Word 2000 using built-in Visual Basic Editor
XP upgrade and old 2000 macros
Triple Lookup Formula!
Lock Commandbars
the anatomy of a nestled condition
Comments
Vba - automaticaly closing userform
Excel VB help
properties of object on another sheet
How to hide rows?
Counting Days of The Week Only In a Formula
Hiding Formulas
Prevent save when content change?
IsDate Function
OnAction Variables
Importing text from webpage into excel and then loop?
Using Dates in VBA functions
Double Drop Down List & Corresponding Text Info Disply
How to input a range in a logical test?
I want to compute this formula: =IF(Q48=Protected!C27:C35,+Q48,"".
Delete Folder
Comment box sizing
Using Hidden Sheets to populate listbox
Confirm formula change
Application.run Macro Code Problem
File in use open read only
enter todays date
transferring data between two workbooks
Mimick MS Progress Indicator?
Format Cells
Extracting Global Address List (GAL)
Copying row data to another worksheet
Sharing a workbook
Tabs
Delete menu
Add large ammount of formula
Change Multiple chart source data
count cells if >""
Which PC has workbook open?
problems closing excel
Should I keep Trying INSA - VLOOKUP?
Help Please - User Database
Is this possible?
Re: Highlight Button...
convert cell contents into a comment
Run time error 70 permission denied
How to total Items in a List "not that easy"
Path in footer
Address Book - Outlook
Picture or Object Blanking out??
Qn: Define a variable in Initialize for Userform
apply conditional formatting
Manipulate user permissions in a worksheet using VB
Qn: Plot a position on a Chart??
Re: Long Text in merged cells not copying correctly with sheet
Advanced Conditonal Formatting
Re: Relative referencing
Qn: Checkbox Enable??
Help needed
Still having a problem checking cells
Virtual Memory Error when running Excel
Excel 2003 Commandbars
Excel in network
LTRIM Problem
making a timer
Bypass Replace File
Excel VBA -Custom function sumproduct
Copy Array pointer rather than entire array
Insert Row when data is different
Problem sharing spreadsheet between Office10 (Office XP) and Office 11 (Office 2003)
Formatting using VBA
Simple way to add a reference to a cell
Custom Menu
finding duplicate entries
Toolbar Buttons and Macros available always
align a picture/shape in a Range!
MsgBox2
Declaring one bidimensinal Array
Multiple ThisWorkbook's Causing problem
too many conditions! what to do?
writing macros to hide rows
Help with checkboxes
MsgBox Title
Update Alert
Renaming a Worksheet with a macro... but...
Copying formulas, formats, and sheet names across workbooks
Countif Error --- Please Help!!
.Textbox won't word wrap. Why?
Re: updating charts
labels and comboboxes
Protecting / Hiding the Code
Re: Naming an Excel Workbook
Re: Quit Application Without Saving
Re: Quit Application Without Saving
Is this possible
Control Toolbox buttons
Userform doesn't recognize other user form upon re-load
Excel data to Access?
Does SUMPRODUCT work with "INDIRECT"?
q. Using a macro to transfer data from Excel to Word
Re: copy & paste macro
paste as value
Searching for cell values
Unsupported methods for XL macro in IE
Re: Naming a newly added sheet
Re: Naming a newly added sheet
Pivot Table Name Reset
haha
Re: Getting PrintForm to print all Frame Captions
Re: How to save as a semi-colon delimited file
Decimal portion to a seperate cell???
cursor problems
Lookup Help
Filling a selected range automatically
Change Shortcut Key Programatically
Userform does not show on startup over LAN - problems
Excel comments field
Can't stop Excel help autotile :-(
Cell color change on mouse over
AutoFilter Criteria VBA
Custom Menu Bar
Excel formulas
Excel VBA - Printing Seperate Graphs
Becomming an MVP
Consolidate - Relative Reference
Signature lines in footer with "No Dupes"
Prevent Workbook_Open macro
Urgent help with nestled condition is needed
J-walk face id menu - Problem
Excel Mergefield?
Date/Time Stamp Macro Button Problem
Removing extended dash
Footer Memory leak
how do i copy a formula with different cell reference?
How to keep a running total on a col that has frequent new entires
Send mail from Excel
msoControlEdit
can it be adopted for a 16 team 4 group?
script for a form
Worksheets Add & Naming
Inserting a variable number of rows in a worksheet
Count of characters
Pivot Table - show 0s in empty cells
The value of a ListBox Item
Newbie's question.
Workbook comparison results in subscript out of range error
SetFocus Question
Macro Fails to Run Correctly
Macro/Command Button
followhyperlink method issue
Excel menu toolbar hyperlink issues
Correct Syntax - Collection Key
How to use Digital Signatures
"!" at end of variable
Problem with formula: need rolling average of 10 months
Macro for "close w/no save"?
finding non-standard years in a dataset
Do loop to add a new worksheet
Excel to select a row based on previous rows
Excel 2000 VBA date format changes in subtotals
UpdateLink Question
RE: Edit Text Import
QueryTables Error
MsgBox - Don't Show Again
Automatic Macros
control excel from Agilent VEE with ActiveX
multiplying data
Time format behaviour
Validation
Is Active Workbook ="ABC"
Creating an installation file
Automating Fill series Function Multiple times ?
File Search
Assigning global macro to keyboard shortcut in Excel 2003
Automated export from Excel to Outlook
Load 2nd form - second one not working after hide - help pls
Set a cell to blank (Null)
What does this message mean?
Default Menu
Re: Trendline Data
Macro to delete duplicate entries
Re: Easy Array Question...
Re: Easy Array Question...
Re: Easy Array Question...
Read Only Wrkbook Sheet
Re: Trendline Data
ClearContents Not Clearing Query
Re: Trendline Data
formulas for pivot table data
Re: Copy Formula loop based on number of rows w/ data in a col B.
Sendkeys and wait variant
updating Excel from DotNet
Re: copy sheets selected on user form
sending email with commandbutton
Re: copy sheets selected on user form
Qn: Ensure Number is valid for a circle??
Class module in VBA
Retrieving a value from a cell
Exception Access Violation (0xc0000005)
Setting up default chart properties
Code Execution has been Interrupted
Listbox Problem
RE: VBA-XP-Excel 2000-2003
Set print Range
code for converting data format in another format
Adding columns with dates -
Re: Put the value of a cell in a variable
Time format behaviour
Time format behaviour
Re: Time format behaviour
Re: error handling off??
Textbox
Any fast method to parse a string into row & col information
Re: RandomNumber Generator
Exporting & Importing Macros
Range
Adding columns - with tech info
EXCEL Checkboxxx Props.
excel VBA problem - setting workbook as variable & opening/re-opening
q Using a macro to paste data from Excel to Word
string length
VBA - find double quote (") in string
Macro fire at given time, through command prompt
Excel cannot complete ......... when screen saver is activated.
Re: Running Event Procedure When Cell Updated on Excel Worksheet
cell-fill-macro again
export form??
Make a built-in toolbar permanently not visible
UserForm events
Help with Do Loop that names rows as ranges
Data from Excel to Access
cell-fill-makro
Delete
Adding columns to get correct results
Class module to filter textbox entry
Print Macros
Read only mode
finding text
Loop until underlined border??
Filter
code to select a column down to last poplulated row
Web query on password protected page
.GetOpenFilename assitance
Calling Solver from an Excel 2003 Macro
Disable Customize in Excel 10,11
Need for Application.Volatile?
Open wrkBook (auto_open) programmatically
Offset Range
repositioning aging categories in a pivot when present
ChartObjects
Excel 97 to XP problem
Merging data from several sheets
How to use function CELL(Infotyp;Ref) in VBA?
Excel Validation Help Needed
Difficult project using arrays
Commands fail on different PC's
another lookup!
Check box - checked or unchecked?
(Disable macro's while) using the GetObject
Excel automation through .NET Interop: NumberFormat property looks like NumberFormatLocal
Move ? spaces to the right
Macro for comparing 2 values (number and date)
web page object reference
[variable] definition
search for one column values in another col ?
Device I/O Error
save w/o prompted and activate a file
MsgBox position
Using If Statements to change colours
Save without prompted and activate external file
Save without prompt and Activate a file
Customize Pivot Table
Pivot Table - Code Optimization
Find the last Row in a Range
using a macro to copy cells from one sheet to another
Convert *.Xls to *.csv
Disable Macros when opening workbook
A VBA code that clicks a checkbox
How could I run my macros in a protected with password worksheet
Excel error after using macro
Filling a textbox with text in another cell
remove help icon from inputbox
Find...FindNext Problem
Formatting &[Date] in header Excel 2000
vba/macro for loop-based summing?
User Input
Missing coefficients in multiple regression
forward and back buttons in EXCEL
Quick n' dirty code to delete rows?
Excel Macro question? Column position
Summary on one page
Merging cells text
remove drop down arrows
Excel 2000 / How clear drop-down list in Pivottable?
Template behaving like .xls file
Help with a macro
Negative numbers
Auto Edit HTML Page
Re: Conversion from currency value to currency text format
Excel calculation
Closing Excel from VBA
How to automaticaly hide all toolbars in in workbook when another workbooks are open?
Tracking changes
workspace
RE: Adding Macro Button on Standard Toolbar
Adding columns
Link multiple spreadsheets to one central spreadsheet using a macro
entering formula using variable in Excel Macro
Control Button stays on screen
Remove First Row from Variant Array FAST?
Excel 2003 blows me right out sometimes
converting dates
Pivot Table Vba Automation In 2002
Adding two columns to determine number of days to pay
Return value of Property Get when using enumerated type
VBA - Lookup address
Macro File Help
Re: Is it possible to get cell contents from another sheet?
apoligies:changing excel icon
VBA - Lookup cell address
Is it possible to get cell contents from another sheet?
Re: Is it possible to get cell contents from another sheet?
Hide Sheet If....
Sound when running macro
Updating Data to Access Error
right
referencing previously selected cells after macro execution begins
specify the exact size of a chart through microsoft script editor
MS Query problem
problem evaluating custom functions
What is wrong in this Sub?
Opening an HTML doc - inconsistent results manual vs macro.
Re: Upgrading to Office 2003
Splash screen on opening excel
choose the right volume
passing reference arguments to VBA function
mouseclick events
Re: File specific Auto correct entries
Excel spreadsheets formatting
Qn: Position of Cursor in UserForm1
Qn: Load Data into UserForm1??
passing criteria via Get External Data from a macro
Qn: Paragraph or LF in ONE Cell??
Excel macro recording problem
Qn: Sound in MsgBox??
Protecting Cells with macros
Qn: Display Text in TextBox in Userform
Shortcut keys for buttons on forms
Excel Template Wizard?
Opening an external file
Opening Recovered Sheet - 3rd Post
How do I count in Excel?
Make 1 row into 4 rows
need to copy row above but different thoughtout data
Lost the 'Help' menu, urgent!
VBA Primer
Suspend code
New Line Character
User Defined function - second posting
How to see if the opened workbook is opened by another user ?
Removing Dialog Box
code for select a group cut, paste and delete
Automatic Activation of Design Mode
Error Handler
Automatically Close Excel
Saving
goal seek problem
Reducing File Size - Turning VBA into txt?
How to suppress the prompt from merging cells
Refresh Multiple Pivot Tables
adding new data on new sheet
cell displays formula instead of value
Like Sumproduct() but using values from a list
PUT data in closed workbook
Visual Basic Text Functions
I try again with auto tab
Please help with this filter
select alternate rows - quickly
Executeexcel4Macro?? (Dave, I need some help)
Workbooks.Open not functioning properly
Autofilter global Show All function disabled in protected worksheet
Selecting first cell in a colmn after a filter has bee applied
how to save only one sheet as workbook
Excel 2003, problem with UK date format, using OLE
calling an MS Access query from within VBA for Excel
Get Pivot Table count of rows in VBA
Timeout problems
Disabling Right Click Menu
Worksheet That Works Like Pivot
difference between 2 times
excel
selectfile control
excel
Help with applying function to cells
EXCEL 2002: How do I user/simulate a Timer event in Excel form
Inputs.
Re: HowTo Count number of replacements
Chart question - Walkenbachs book
Is absolute security for Excel VBA code possible?
Open a TXT file from WEB ?
RE: Worksheet as file
Re: Still can't get it right
Re: Calling a procedure in a procedure
Color Text
Passing data to an open workbook from Lotus Notes
MsgBox - How to display In Other Instance of Excel
coloring cells
Re: Calling a procedure in a procedure
How to open an html file from within a macro
Re: Calling a procedure in a procedure
Running an Access Query From Excel
Macros incompatible for different versions?
Populating data from an external database
Open a Spread Sheet In a Mdi form In Vb.net
Select a row, copy and repeat on the next row
dYNAMIC Array declaration, a small correction in my last thread!
Declaring variable as a dynamic array?
Macros incompatible for different versions?
Autocalculation settings when multiple spreadsheets open
Saving files
msgbox title
Re: HowTo Count number of replacements
Advance Filter problem
Re: how to open a Workbook and activate a specific sheet
SELECT ... INTO ... IN ...
Re: how to open a Workbook and activate a specific sheet
find location
Deselect top row in pivot table
Macros incompatible for different versions?
Cut and Paste to A Seperate Worksheet
So close and yet... (Pros Only)
Verify Totals
can it be done without using code?
Combo box help
Need to do a SQL-like functions within Excel. Need HELP!
Re: Could not set the RowSource property
Text Boxes / ctrl-f
RE: Insert method of range class failed
Insert method of range class failed
Divide up Worksheet
Save file with fields within quotes and comma separated
Creating a chart (Getting the correct input and output)
range data type
Save takes seconds vs. SaveAs/Save As takes minutes
User Form Template???
ComboBox Values
Apologies: access/excel ado via vba - forgot a line
access/excel ado via vba
Copying Worksheets from one book to another
Opening with a password with VB
vlookup from VBA on a closed workbook
VB programming interactive macroes
Conversion to Text file
Hourly calculation
Excel VBA- If Then statement
Dynamic Validation Lists
Problem populating a multicolumn listbox
Adding add columns and not getting duplication
Inputs into equations withwout having to repeat the equation every time.
Hiding Excel Menus
Hiding Excel Menus
Hiding Excel Menus
Counts
irrational problem
can i add a row for (x,y) values and perform its maths?
How to eliminate any new pivot Items
Adding - Thanks - in reversing the formula it worked
Re: VBA To Replace Duplicate Values with Zero (Complex)
ParsingCellData
Read all -- Adding columns for paying
User defined function
Help with Pop up screens and Error Pop ups
Need Help With A Loop To Copy
Windows Explorer Right-Click Extension
Make Option Compare Text the Default??
Adding columns for purpose of payment
Update cell selection of embedded worksheet in Word
Print Array in Cell
Repeated validation lists in several worksheets
How to use QueryTable with insertion sql
Userform cannot return any values
Test if Clipboard is empty
programming the VBE for a new event procedure
Can I attach a toolbar to an add-in?
Find Method
Find Linked Cells
Using cell references in Excel Macros
running a webquery after every 5 secs
Searching text lists
Password protect excel code
Colouring cells
Difficult returning result !!!!
Search for criteria and count
TextBox Controls--tabbing
Insert a heading
deleting row using macro need help
Additional feature to code given on August 6th
Tab Name same as Cell - PART 2
Naming A Table Array in Vlookup
Naming A Table Array in Vlookup
Naming A Table Array in Vlookup
VBA execution stops at ActiveSheet.Copy -- but only sometimes!
Help with some code please
Excel VBA question - Running a autofil
RE: Access and retrieve data from network workbook
MDB add-ins for Excel 97
read text file
read text file
Cannot suppress an ErrorMessage
How can I use web query with a password protected page?
Read text data
validating macro
screenupdating workbook open
Countif with row criterion
Autofill
Sort options by Excel VBA
Activate button when row selected.
Recognising cell values
Paste special to the active cell
SQL Query Headache
Switching Names Around
a faster method in changing cell value?
How to parse the comma seperated strings into the excel sheet
Cell Comparsion (a bug?)
countif usage ?
Moving between Worksheets
Re: Cancel return on keyboard
Excel Math Bug
Re: Okay, Let's ask this another way
Combo Box initial set up
Row Height
VLookup question in a macro
AutoLoad Custom Tool Bar
select row in userform listbox with right-click?
Changing a text entry format
Searching an Array
How to include a double quotation character in a string?
Animated charts showing change with time
Variable sheet name in formula
next empty row
RE: Formatnumber
Copy Worksheets from one book to another?
Display initial value in combobox
Converting Excel Worksheets into PDF
Relative Range in a Formula
code to insert add'l code ???
selecting worksheets
Tab Name same as Cell
Excel - VBA Macro Not Found
Copy file while in use
Removing Personal Information (Author etc)
creating a new dataset
Cells = Worksheet name
Reordering with Multicolumn Listbox
Network Workbook (access data, etc.)
Week to date
Need to print different sheets conditionaly
Input Box Question with Code
Need help with this reference problem
RE: Input Box Question with Code
Re: Input Box Question with Code
Re: Numerical Input via an inputbox method
Re: Numerical Input via an inputbox method
Re: Input Box Question with Code
How to run an excel Macro in VB?
Excel on the web using .NET
Formulas and making info invisible
Access and retrieve data from network workbook
exporting categories - excel
Unloading UserForm not working
PasteSpecial Values
Re: List boxes - help
Searching for mutiple items in txt files
Editing Code - Help!!!
Editing Code - Help!!!
Filter blanks and populate with a series
Re: Toolbars
RE: Toolbars
error message in Vlookup
Improving data retrieval system
moving mouse pointer
moving mouse pointer
Active Directory? (reposted in case it was missed after a quiet weekend)
Enabling Line/Column number in code
CommandButton
Rename worksheet
removing words/phrase from sentences
Multiple personal.xls files found!
User Indicating the Arguments while code is running
Add an exception rule
Running macros in the background
Multiple persional.xls files making macros NOT work!
Re: Macros in HTML
setting the focus using VB
Can Excell 2000 do queries
Delete empty array columns
Currency formatting
Another Reference Problem
Checking for Open Files
Re: Volatility With Comboboxes?
Change pivot Table color on Condition
Returning Range Total in VBA
Delete Password protected macros
Converting <b> to bold in excel
Command Button
set ToContact Outlook security workaround - help
Numberformat vs string question
Subtracting dates to come up with number of days
Excel VBA - go to cell problem
Error Handling when database not available
error 50290
chart problem
Accessing Server Date
Userform does not always show on startup over LAN
Run-time error '91'
Problem is using any method of Range Object
PDF converter to xls
Problem in using Advanced Filter
Workbook_BeforeSave()
Open Files by Clicking on a Cell
Code - Repost
Memory Leak When Copying Charts
Problem with removing qoutes from string
Printing
Printing
how do I get data into my *.xlt from my *.xls
Save As.....
Clearing Combo Boxes.
Cell Reference in formula increment
Active x Calendar control error (-2147417848 (80010108))
Code snippet storage
error
Adding to Chart Popup menu
Converting From DAO to ADO
(no subject)
Need some events...
Navigation Tree
Excel 2000 V Excel 2003 and Pivot Tables
conditions in Excel
Effecient way to check, add, delete duplicates
Detecting Applications Run using Excel
Excel VBA - delete hidden column in mergence status
How to reset Worksheet Menu Bar in VBA???
Tony Barla
Mail merge issue - ghost Excel process remains after closing application
How to stop having to re-assign macros every time you open a workbook???
copy data to another sheet
Display Excel file in Internet - an interesting question
Charting with VBA
Userform with Formula
Insert Rows after text appears in column
Mail merge issue - ghost Excel process remains after closing application
Forcing "Macro Enable"
Populating listbox
How to leave a combo box?
Forcing "Macro Enable"
Delete Rows
Clear vaidation
Newbie question
button to activate userform
save as loop
Daily Automatic Transfer of data from one ws to another ws
Pivot Table SQL Query saving
What are XLL Add-ins?
Creating Add-in with library of functions
Print userform
working by column name
using vba to copy from excel to embedded word doc
Date change macro between worksheets
Copy textbox contents
Display sum of selection with SelectionChange procedure
Data Validation
Three short questions regarding importing of data. See code
active directory?
hiding / displaying the excel application window
ADO recordset returns -1
Workbook_Open Question
combining two cells
Suppressing Pivot Table totals
Availability of fonts in VBA
VBA programming textbook/reference
Occurances of value
if its open...close it
auto no save
Transparent subform
Why does this code not create a button when called???
Create new sheets from data in either of two columns
Passing IP address from Excel to a Web site Locator
putting ' in a column of cells
Workbook VBA not recognising half the new worksheet!!
Vba - Opening Outlook with Vba
VBA code for automatic download
Help with Excel
Collection Variable
number format
variable in a formula
Lookup Mail Contact
insert two text values
re:loop through controls
looping through userform controls
startup a userform
VBA to create PDF using Adobe 6.0
Hide Worksheet
ActiveX properties in VB and VBA
Worksheet as file
Send a range in Excel as the body of an Outlook Express message
Macro to sum up the amout?
Assign Sub to Custom Button
Dynamic Range Chart Macro Question
Can Excel use as a VB form creation?
Insert Text at Bottom of Last Page
wildcards with sumif/countif in macro/vba
looping through userform controls changing enabled and locked properties
Adding in data from another database
Fox Pro Data Base
Re: QueryTable's
opening another workbook
ordering
Extracting sub arrays from a 2-D VBA array
newsgroups
Not exactly a programming question
cursor position
Mouse Over
Rounding
Chart Tab Name & Worksheet Reference
Help with error 1004 in database query
Data Validation Lists - drop down.
inputbox Auto response
ok... but not a solution to my original post...
*.xlb file missing!
clarify
excel.application.run macro1 --> added code to respond "yes" to a inputbox
Re: Future Value of Increasing Payments
clarification
clarification
A way to create a Command Bar without code???
Filtered counts
2 questions : ordering and placing
macro problem
Code for Tom and Frank
For Each Worksheet Problem
Opening Recovered Sheet - 2nd Post
Edit userform
*.xlb file missing?!
MSFT Encounters Error
ODBC/OLE DB to access Excel file and get weired table name Sheet$_
links update
Data types Questions
Clearing all items in a collection
Run Time Error 1004
How to imput " " (quotes) in to your cells
Re: Passing value from Hyperlink
Need code
inputbox and application.run macro1
Re: Populate cell values with sheet names
Excel Macro Help
Re: Populate cell values with sheet names
Erase Arrays
Changing text color
Values run out of range
CopyFromRecordset does nothing
consolidating records
How to rename a picture?
A variable in VB
Newworkbook
Code and thanks for/to Tom and Frank
Save As... prompt
Re: textarea
Re: textarea
Countif in VBA
Maximum Unique Records in Pivot Table
IF THEN ELSE STATEMENT
protect cells
Macro to force delete tabs
Automating MS Query
Paste
Attaching toolbars to spreadsheet, but macros do not follow?
Code
text box reference
Imported Text File Worksheet Tab Name
command button color
Finding Files on a server
Excel Pivot table on the web
VBA - Writing in XL XP, executing in XL 97
Reading data from a database
worksheet protection
Trigger an event when a cell's value is changed.
What next!!!
VBScript to Change pivot table layout
Object Required Error
Need help on blank cells
GammaDist Worksheet Function
autoshapes round 2
Fullscreen
ActiveWindow.ScrollColumn Sort
Help Please
How to use "Transpose"?
autoshape
Returning the result of an SQL/Query to Excel
changing user name on windows system folder
how to capture data
Sort a range randomly
Excel macro to extract information from MS project files
Speed - or lack of it
Synchronise 2 dropdowns
How do I create a user form in excel?
Selecting autofiltered cells
Restrict the user from ADDING/DELETING column/rows
Macro sending Excel template data to database
Appears that HotKeys have been used, but where in Excel 97?
Performance Issue with Database Connection
Find range in one sheet, then paste in the other (one by one)
Protect Macro
Lookup Help
Re: ??Names ranges, charts, and SERIES function arguments
Populating data from an external database
Macro that cut and pastes
Re: Help with VLOOKUP
Excel Security
add a reference manually
Another Outlook question
Re: Limitation on controls/objects?
Re: Find last filled cell in a column
Macro to upload tasks to the Outlook Calendar
speed up macros
Open Folder - Ogilvy code
public macros
Re: VLookup with VBA trouble :-(
Help with MS Graph
VBA Errors Through Webpage
Excel PivotTable C# problem
macro that sends email with attachment and address
RE: InputBox code
Re: Recordset object loses validity in call between function & subrout
Convert to military time - part II
Excel macro script to copy only formulas and not values from one sheet to another
Re: Help sending mail...
Data type conversion
Excel Characters
Menu/toolbars/macros defined in Excel 2003 not working in other versions?
calling excel macro
Re: copy outlook contact information to excel sheet with macro
Formatting Zeros
Excel Spreadsheet using SQL.REQUEST - System Requirements
Data Label Object Position not working
Sorting multiple range using a macro
Remove UserForm
Need help with writing variant back to sheet
Autofiltering Makes Button Control Disappear
Re: Recording page set-up macro
unique copy
Can a function return two values?
Vba - Generating Micr Outlook Alert from excel
URGENT: Alan Beban - SubArray not working - any thoughts?
Alias FROM: when sending mail in Excel
SOme problem on VBA Userform
new worksheets based on list
URGENT: Comparing Ranges, Selecting Values, and blah blah blah
Note to Bob Phillips
Trouble with Workbook_Open()
VBA and SAS
An MD5 Hash with a single quote = grief in SQL query
Writing Macros in Excel
vba - counting different items
Data Validation
Browse for folder - Jim Rech's
Syntax
Re: Help sending mail...
Assigning range to array not working
Display Alerts
Re: InputBox code
VBA date in function
RE: Pivot Table
This should be an easy one for most programmers but im having some trouble...
period of sum of sine waves
Automate Embedded Word Document
RE: Using Access DBs from Excel
RE: Find last filled cell in a column
Returning number of blank cells
IF ELSE with an AND?