Excel Programming [Archive] - Page 132

Looping Question
Looping Question (I think?)
Excel 2K VBE hangs on open
Inserting lines that don't destroy macros
linking cells
external data from web
Keypress and "Enter" key
opposite to Application.Saveworkspace
Problems, doing a find in another sheet.
error message in Microsoft Query - ORA-00903 invalid table name
VBA: Pull Record Into UserForm
ShowDataForm disabeling a field
ShowDataForm how to lock a field ?
Data Access Objects (DAO)
XLA
Active directory users
Find/Replace String
Locate Most Recent File
Paste problems!!!!!!
Help me valuating time
Colour functions of Chip - small problem
Delete Sheets Problem
how to do sum when meet an empty line in vba
vlookup & search
HELP!! Cannot set any sheets to visible
Colour functions of Chip - small problem
Copying Book1 to Book2 without selecting
Workbook close error
are there any excel exaples on schedulling on the internet?
attached file using outlook
Hide a page in a multi page userform
Text
Open password protected database
using macro to open every file in a folder
Select All Sheets in Workbook
Sum non blank values across - Excel
excel macro
Autorun Macro on file opening
using macro to open every file in a folder
Can this automation be achieved by macro?
'UPDATE' sql statement
ActiveX property missing
VBA: Pull Record Into UserForm
VBA: New Idea to lookup record
Multiselect Listbox
Macro Assistance with Incrementing Formula
truncation problem
Count rows based on multiple variables
Open Locked Columns to view code?
Auto populate and calculate between worksheets.
How to get Cell value and use as file name in macro
VBA: Copy from columns on multiple worksheets
strange behavior with copyFromRecordset/ADO
specifying range based on input
Extracting Excel Formulas into Access
Problem with Frames in userform
Selecting a range composed of current region + 2 rows
Select all pivot table areas/ranges on the active sheet problem
How To Get The State Of A CheckBox
Excel VBA Query Using Access Database Hangs on 2nd Execute
updating links with calculations in many workbooks
Sorting Algorithm required!
Vb macros to schedule the excel sheet invisible mode
Time Delay in VBA
copying vis basic formula in multiple column/cells
Time Dealy in VBA
Disable Dialog when following external hyperlink
Moving entire rows
Excel columns
Selecting a variable range
For Each with Hidden Rows
VBA: New Idea to lookup record
Public string showing empty
Saving file to a location determined by a cell
Linking Problem
Chart events - how to select points and not series?
Changing the locked propery of merged cells.
How to hide a process in the background?
Cell manipulation
query field
Saving file to a location determined by a cell
Screentip above shape
Need to test for file presence
Have userform & reams of code!
Add-in function calling problem on start
One final question
Save as to two folders
How a macro auto-determine unspecified range
Closest number match help ...
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox
Macros to store the formatiing in template
VBA: Pull Record Into UserForm
setfocus after a msgbox
Roundup Nesting
where are those toolbar button images?
Possible to move data to a specific cell?
Change the template version of a workbook
Please check my code?
Odd Error-Any Possible Explanations?
Code in Sub OKButton_Click to trigger actions depending on calling macro
HELP!! Cannot set any sheets to visible
putting data from hashtable into Excel Validation list
VBA: Pull Record Into UserForm
trying to determine where input goes
visual basic
Textbox-read text line by line
Footer, "fixed" date
Divide comma-separated string and look up corresponding category
How to trap the OnAction of a CommandBarPopup
Trying to open an existing Excel file in C#
Hyphens in Excel Sort
System info in header/footer.
Fast way to generate unique strings
VBA: Extracting Range from worksheet and inserting into userform
VBA: Pull Record Into UserForm
setfocus after a msgbox
Using a cell reference in a text box
Including prompts in macros
Formula for tickbox?!?
Conditionally disabling formulas
Command Bar Menu - Management
setfocus after a msgbox
Find the contents of a Connection property of the QueryTable objec
ColorIndex & macros
Why should Service Pack make a difference in this routine?
VBA 2 dimensional defined name access
VBA: Extracting Range from worksheet and inserting into userform
Problems with summing
VBA: Extracting Range from worksheet and inserting into userform
? Find method
Excel Developer pay in NYC
visual basic code
Insert Option Button based on value
List Of Sheet Names & Create Hotlinks for each one
VLOOKUP hang-time...
Limit to IFs ???
Column Widths help ?
Automatic running Plug-in functions on load -- Urgent
help with a transpose please
VBA Match Equivalent
Fast writing in worksheets
Excel 97 Workbook_Open problem
How to get the value in a matrix?
VBA: Extracting Range from worksheet and inserting into userform
Can this automation be achieved by macro?
Summing Number by Week and Month
Column Widths help ?
printing in Draft (part 2)
write error - even when no macros run
Testing for text
rounding
Column Widths help ?
Copying "ThisWorkbook" objects
Row, Column
VBA: Extracting Range from worksheet and inserting into userform
Re: Conditionally running macros
Recording phone calls
Using CallByName for conversion function
How to correct this formula and check if more issues are existing?
List Box Problems - Urgent!!
Whats wrong with this line of code?
How to set a variable in Excel and loop
help with a transpose please
Stay in Combobox when reaching end
Bitmap
Deleting a row of data based upon the value in column D
Test
User input as a range. What am I doing wrong?
More then 1 Excel object running at same time , how can I refer to right one in code?
combobox help
Unresolved local named range
Hide sheets before macros can run
Help formatting date
Grab Time with milliseconds included in VBA
Sorting data in a shared workbook
MAcro for validation of Date
Insert Option Button based on value
Autorun Macro on file opening
Bank reconciliation
how to calculate mileledge
Open file without Password
Recalculation takes too long - help!!!!
Extracting Excel Formulas into Access
Sorting Algorithm required!
if or statement
VBA: Extracting Range from worksheet and inserting into userform
Two workbooks
create commandbar / control button using codes
How to subtract a lunch break from total hrs worked in timesheet
Run-time error '380'
Integrals
how to create toolbar?
Formula Weirdness - HELP
Can a macro delete itself?
Clearing old data from a sheet
summerizing formula for weekly lesson plans
Is it possible to...WITHOUT OPENING EACH WORKBOOK?
Start button / timing access
Worksheet Change event
Excel VBA Utilities
Inserting data from a form into a cell
How Do I Load A ComboBox On A UserForm
Pointers to appropriate functions
VBA: Extracting Range from worksheet and inserting into userform
how to use the lookup wizard
Accessing Word Constants from Excel
Delete blank rows
Accessing Word constants in Excel
Excel RTD Focus Grabbing Bug -- Fixed?
combobox additem
assigning variable across macros and modules
Switching Rows
Userform with validation...
Trap Sheet Name Change
Cell References
Save as to two folders
Excel Macro with Access
Dynamic Hyperlinks (URL) problem in Excel
Excel-2003 Plug-In Program
Cell formatting when pulling into VB
Toggle Font Style Macro
Find and Replace Text
Copying "ThisWorkbook" objects
Reference Names via VBA
link to cell across lan
Making 2/more selections using button?
== How to test if a range var contains nothing
Deleting rows to get in a format.
add-in?
Two workbooks
Data in variable row numbers...
check and create folder for saveas
Columns.Autofit not doing what I want
Help With Query
Dropdown lists
save Wsh to closed/opened WB
userform create
Toggle Font Style Macro
Advance By Month With A CommandButton
VBA frustration
Toggle Font Style Macro
How do I create an IF function to hide cells in column B IF cells.
How do I create an IF function to hide cells in column B IF cells.
How do I create an IF function to hide cells in column B IF cells.
How to create ranges with auto filter
transpose 255+ columns into rows?
Count rows
Macro to convert dates in a Conditional Sum Formulas?
Declaring Variables Public
Time zone using VBA
Multiple ComboBoxes
Using a macro to format data: deleted rows with a certain charact
Auto Sum formula - how to write in Macro
Splitting A Report
Toggle Font Style Macro
copy formula
MAcro for validation of Date
Auto Sum formula - how to write in Macro
I need the original digit format with zeroes untrimmed
Macro how to
Using a macro to code a checkbox on click - Help
locating given dates from each year in data set
inexact search
Excel spreadsheet security
my workbook reference is not working
Locking button to a cell/range
Populating listbox from network directory
Office Web Components Charting objects
User input as a range. What am I doing wrong?
vlookup issue
Value of the "Last Cell"
Generating Reports from Text File
How can I correct color index errors?
list box
getting a variable's name
How to communicate between Excel and VB6 ?
Using Formulae in Macros
Importing File
last non-empthy cell
An Algorithm that matches two lists
Real Rows
Prevent workbook closing...
Memory usage
Paste text copied from Excel into External App.using right mouse click
Hiding data in pivot tables
Importing File
Disable rightc click
Deleting rows based upon the value in column D
Worksheet_SelectionChange
Declaring Variables Public
Multiple sheets selection and copy
Help locking column on date value
Calling Outlook Macro
close excel
Sorting rows based on the content of two columns
Macro (?) for comparing 2 Excel files/sheets
Worksheet_SelectionChange
printing via vba
Access data -work in Excel- save in Access
Sorting rows based on the content of two columns
MAcro for validation of Date
excel 2000 object reference anywhere?
Absolute value
adding references
Conditional row delete using macr
Add worksheets at end
refering to Pivot Tables
Macro Creating a variable which is to be used in a SQL in the Mac
Macro Creating a variable which is to be used in a SQL in the Mac
commandbar - rollout problem
Multiselect Listbox
UPPER CASE macro shortcut key anomaly
Tab Order Problem
stop timer
How do I change a workbook based on answers to questions?
In VBA, Open a file with macros disabled
help to speed up adding check box
Searching Problem
enlarge built-in checkbox control
How do I change a vlookup reference using the "Text" contents of.
Searching Problem
Interior class error/runtime error 1004
DIR function and compressed folders
Is this possible
Excel not responding or error 462
76 Find your favorite shop / business on the Internet 76
Extract Text From Multiple Word Files
Is this possible?
help to speed up adding check box
Calling the wrong macro
Consolidate Data from other workbooks
Consolidate Data from other workbooks
Saving ActiveCell coordinates
Problems with sendmail
Adding to an array
Toggle Marco . . .
Excel worksheet contents as result in a userform.
Pdf file text inserted into Excel Workbook
Module password locked
CountIfBlank Rule
Function to invert Range-selection
Edit macro formular
How to select other sheets using ADO
Trigger macro if an Activecell is within a specific Range
Removing specific entries from comboboxes
Standard Button Size
How to Resize Userform?
Re: not one sheet but all !
chosing record and editing it
editing a form corresponded a specific range
Split numbers and text from a cell
Delete Rows
Refresh object problem
Macro Creating a variable which is to be used in a SQL in the Mac
hide menu and bars
Re: not one sheet but all !
Macro Creating Variable and using variable in a SQL statement
Re: not one sheet but all !
Searching Problem
Range Contents Check
How to Resize Userform?
how to get more than one column in drop down list
VBA, UDFs and VSTO
String width in specified font/size when merging
commandbar at workbook before close - run time error
Sorting Macro question
How to Delte Multiple Rows Given a Value Existing
Best Way to Read the Registry?
Moving a folder
various macro problems
Multiply The Contents Of Two TextBoxes With The Result To Appear In A Third TextBox
How to Delte Multiple Rows Given a Value Existing
Pivot Table Formula using Grand Totals
various macro problems
?Passing argument/parameter
How: Need 2 Copy sentences with commas & paste into one cell.
autocomplete macro
Pasting cells without border info.
autocomplete macro
Need to copy rows in Sheet1 to different worksheets
Vlookup macro that returns data from worksheet, then Loops
Global event handler??
trouble with userform
can I sort using column headings, in a macro, not "a1"
how to change background picture
user forms
workbook question excel 2000
VB Form field highlighting
Need to copy rows in Sheet1 to different worksheets
Names of Shapes
Count If
Simple VBA Global Delorations?
Worksheet_change event.
Trigger macro if an Activecell is within a specific Range
Vlookup macro that returns data from worksheet, then Loops
?Passing argument/parameter
Find and Replace - based on font
Help required to debug mailmerge procedure
Find with criteria
How to implement an iRtdServer?
using variables in formula in R1C1 mode
How to Delte Multiple Rows Given a Value Existing
Quick question about using a barcode scanner with excel
Need to copy rows in Sheet1 to different worksheets
Ranges values with properties problems
Eliminate flickering
VBA: Array of ArrayNames
Need a formula that will lookup one item and return a range of ite
Refresh object problem
Number Formats In A UserForm TextBox
commandbar at workbook before close - run time error
run time error on commandbars
I don't know short title for what I need.
Making a copy using macros
Utilizing a Class Module
How can I hide zero rows in a pivot table with calculated items?
how to enable / disable customised button on toolbar
Which is faster code...
Variable in an R1C1 formula
Referencing Any Cell in a Column
Calculating the difference between hours
Deleting shapes/objects from a selected area
How to Delte Multiple Rows Given a Value Existing
Shortcut Key
auto sum macro if data is present above the cell
Find and Delete data in a column
Macro warning when no macros
In Excel how to make Column Values to Column Headings
save worksheets within workbook
Creating a formula using the loop variable
FollowHyperlinks opening multiple browser windows
Macro
parsing text field based on commas or spaces
How do you select a row
WEEKNUM Question
Activating & Restoring
Tab stops
auto sum macro if data is present above the cell
Develop 230 Graphs from Data
Eliminate flickering
test
FORMULAS
Deleting shapes/objects from a preselected area
Deleting shapes in an area
How to handle all delete row events in excel
Creating a formula using the loop variable
Loop through a range
General Question About Arrays
Formulas '=IF'
Installing font with VB
Auto macro question
Page Break Test
How To Get An Event To Run When I Exit A TextBox
Multiple blank lines, between multiple lines
Permission to use object denied
worksheet_change not working
worksheet_change not working
Writing a Word doc from Excel
userform help
Edit cell contents via userform listbox
date format
auto sum macro if data is present above the cell
Excel Visual Basic - Save (As) the document as the details in a cell
save as using macros
save as using macros
Updating links with VBA
Sort by Color
Can a macro create a hyperlink with unique cell information?
Open existing file
Hide Columns
Hey guys,
Finding the first empty row with VBA
How do I use an array function in Visual basic .NET?
pagesetup.zoom problem !!!
Using textboxes in sheets
Autoformat headers with dynamic
Delete Rows
Close file without saving
Excel Add-In
IMAGE OVERLAY
blank row macro with page breaks
conditional formating on pivottable
naming a sheet automatically
Counting numbers and letters
This statement does not work in VB
Close file without saving
group pivot table from external source
blank row macro with page breaks
How to run code based on a dropdown form changing?
blank row macro with page breaks
Delete Rows
Delete Rows
Scrolling through several graphs on one chart?
Looking for a sheet
Using a Macro with a check box to Change a cell color
GetOpenFilename
Delete Rows
One Macro Does All
Prompting a Cell Selection Dialog Box
Displaying data in pivot tables
One Macro Does All
Remove macros on save as
One Macro Does All
adding cells of workbooks not yet created
Macro to Show Conditional Formatting Criteria
How to speed up my VBA application ?
How do I unprotect a sheet within a macro?
DIR function and compressed folders
Adding digital signature programmatically
Runtime Error
String stuff again!!
Events
How to close a workbook which contains the macro that's just been run?
Insert a metafile with VBA
Require assist with VBA semantic regarding worksheet selection
Best way to create 27 charts with vba?
Hide workbooks that drive another workbook
how to copy record only with amount from 1 sheet to another
How to close a workbook which contains the macro that's just been run?
HTML/XML Import Error -ExcelName
Browser on a user form? with VB. Excel or Access.
Sub erroneously calls another sub
Can an excel XP 2003 file be exported to an Access mdb file if so how?
XLL addin not loaded!
Saving data with macro
Form controls
Count values in Cells Across
Add CommandBars take long time to return
Populating a database from a questionaire
Excel Help Toolbar
WindowState Question
How do I Add or subtract months or years from a date in Excel
How To Get A Date To Advance In A TextBox
auto sum macro if data is present above the cell
button awareness. i dont know if it can be done.
Determining last row/column using ADO with closed workbook
button awareness. i dont know if it can be done.
Problems creating a dll in Excel 2003 using addin designer
How to run code based on a dropdown form changing?
finding dates as close to, but >= then FY
macro help
text combinations
Mail Merge from Excel Data Source to Word
Mail merge from excel to word
Close a workbook without saving macros
CheckSpelling Method Continues beyond specified range
All combinations
Downloading a file from a website in Excel Visual Basic
Problems running Solver from VB: Windows 2000 users?
selecting a non-empty range of cells
Establishing Rows to copy based on Offsets
Function To Return Info From As400 Database
deleting dupes/certain values
Unlink graphics in VBA
Programatically saving workbook (or worksheet) without the code
VBA for Dates and Row Colors
Macro Help !!!!
HtmlConvert problem, Some fields missing in Excel 2000
Macro Help !!!!
Inexplicable - Excel 2002 (10.6501.6626) SP3
Test if sheet exits, create with name if not
Macro question
Adding positive amount, but ignoring negative
Reference the active sheet
=> How to setup vars when a workbookopen event is launched?
Test if sheet exits, create with name if not
Advanced Filtering criteria
Find the word "total" in a cell, delete row or column
auto sum macro if data is present above the cell
auto sum macro if data is present above the cell
close excel application.
Code to produce color font in data validation selections
Print in Color Macro
Print in Color Macro
Find a list of special characters and copy the entire row where th
Manual page break on certain word
Add-in to search and delete
How To Get A Set Entries To Paste To The Bottom Of The Correct Sheet
video clip in Excel
How do I get the difference between two times, including hundredth
Compare 2 dates
Opening Word with a specific document from excel vba
VBA macro does not save
How To Get A List Of Names To Appear In A TextBox On A UserForm
Pivot Table Formula using Grand Totals
close file macro
Probably an easy one
Quick question about using a barcode scanner with excel
Databases and List Box's
[HELP] closing a program with VBA code
Multithread
Range with odd column names causing problems
Simple List Problem?
Delete blank row only if 2 consecutive blank rows
Dynamic Range
Stopping pivot tables calculating
Range Match
Simple Macro Help
Compare current date to 2 dates
Stopping pivot tables automatically calculating
How to I create a macro in Excell to add multiple worksheets?
Sort by Color
Help with restricting InsertCopiedRow - Macro help
Excel AutoSort Macros
Importing / OLE DB Query
comparing a percentage
Updating Cells w/ Userforms
Macro Help !!!!
calendar control
sub TextToColumns
Detection of Print Problems
Email Workbook
Comparing one cell to every cell in another column
Referencing a Column in a Selected Range of Columns
Filtering results
Worksheet position
Probably an easy one
Email Workbook
Excel program help - desperate!!!
VBA for Excel Begginer
Cell selection in a macro
Sheet change event and list validation question
Edit cell contents via userform listbox
delete rows using macro when no data in column
Naming of individual points in chart
Dynamically adding code
Automatic Macro
DropDown List and Cell Lock
MS Office Project Manager
Save As Version
Problems running macro from custom menu item
Contraction of rows
RTD Advice
Script to start Excel and load the add-ins
selecting a picture within a chart via a macro
Moving/deleting pictures within charts via macros
Find / Search for text boxes in a worksheet
Adding Bitmap to Worksheet
loop through files
Copy Cell Above
using vb to select which printer to use
What file format that includes quotes and comma as delimiters?
customise button(macro) on toolbar / workbook protection
Selecting A Printer With VBA
Problems with the frame
Types in Add-In
Preserve a range information
counif with two conditions
Data on clipboard message...
button on toolbar
Returning Multiple Arguments from an Excel VBA Function
help with chart objects
Returning Multiple Arguments from an Excel VBA Function
need help importing photos from file folders
Sets of Characters in Excel VBA
Returning Multiple Arguments from an Excel VBA Function
Names in Combobox are hyperlinked to cells
error comparing dates
Hiding objects based on property of object
Count Down 48hrs
Sets of Characters in Excel VBA
How to Randomize Files?
Accumulating data
Accumulating data
I need to find
Calculating the difference between hours
how to create a macro/vba to read an text file and filled colluns on excel+vloockp
2 different Run-time Error '1004' ... HELP!!!!!
Filter x and y
Worksheet change event not firing
Accumulating data
Shell and Command Prompt Question
ImageList must be initialized
Inputbox and & character
Search text using wildcards?
Save Workbook or worksheet
newbie needs help...
Variant type for Excel cell percentage data format
Message box
textbox issue
sheetChange event and list validation
Names in Combobox are hyperlinked to cells
using variable names in VLOOKUP
Chart source data when copying from one workbook to another
Cell selection in a macro
checkboxes hiding or introducing new worksheets
Excel w/macros from Internet Explorer 6.0
auto sum macro if data is present above the cell
Copy worksheet values and formats into another workbook
How can I transfer data from excel worksheet into pivot table?
Include external file .BAS in Excel VBA
Conditional formatting
can I replace all with a macro?
Search text using wildcards?
Setting print area depending on a cell value
vlookup in vba help
VB Editor in 2003
Macro to change saved name
Macro in toolbar - how to use forever
Select writing area in sheet
Local file read
Activating a cell without an absolute reference
Macro to update workbooks
Help for add a short cut keyboard to my add-in
Macro for updating workbooks
OpenText Method of Workbook Object Question
Excel in web browser
Comparing cells
combobox loses first choice
Separate Concatenated First/Last Name
Separate Concatenated First,Last Names
Macro
why does combobox lose choices
Help with row selection.
Automatically Sizing PrintArea
Use ListBox properties in This Workbook
Need help resizing embedded chart with VBA
Changing DSN programmatically?
Delete method of Range class failed - HELP!!!
Assign Macron to Button
OnKey Method
Networkdays
Syntax Error in VLOOKUP Code
combo box nightmare
Worksheets Add fails with SP1 of Excel 2003
Excel Active X Support
Time zone using VBA
Strange error
printing page numbers
method of axes of object failed
Include external file .BAS in Excel VBA
how can i set up a mail routing better
Changes to customized menus are not saved?
cladding, cover gpago
how can i set up a mail routing better
Use ListBox properties in This Workbook
Undocumented ColorIndices
Email and if statements
Urgent: VBA Excel Templates Online-Book Source?
Quick string thing!!!!
Printing problem
Help link to custom VBA function
Automatically Sizing PrintArea
Copy Internet Favorites To Workbook
Checking for existence of value in another sheet
Find the word "total" in a cell, delete row or column
Show Data Form
Cases
SQL Code
Conditional load of form when entering a certain worksheet
freeze screen (userform)
inserting values automatically from one sheet to another
Comment to Add-in
Exporting to a new workbook
Edit Links Dialoge Box
Conditional load of form when entering a certain worksheet
Excel programming: change detection
Auto Open a CD and run an Excel file
Using Find statement in VBA module causes error 91
Copy values only, sheet1 to sheet2 without Selection
Edit cell contents via userform listbox
Hyperlink to existing files
Find and Replace - based on font
Convert excel 5.0 macro
GetPivotData and Pvot Table 2003
When building formula in excel, it would be very useful to have t.
When building formula in excel, it would be very useful to have t.
For Next Loop
For next loop
switch off messages?
does an item belong to an array?
Deleting columns other than those that a specific word in row A
Help on retrieve data in each worksheet
Combobox and data values
add data to a chart
Sets of Characters in Excel VBA
Macros run slow after first run
Help with row selection.
Start relative reference macro from specific cell
Sets of Characters in Excel VBA
Using Excel Programming to bold part of the text
Count the number of times a cell is colored with conditional formatting
Macro containing password?
Excel Jeopardy with random question picker
Count the number of times a cell is colored with conditional formatting
How can I unmerge the merged cells in a Excel sheet quickly?
Help with loop code...
how to control excel cells
Shear and Bending moment diagram using excel.
blanks in pivot
Sorting '# 9" numberically instead of alphbetically
Clearing old data from a sheet
The Course Booking Form
Horizontal Scrollbar For Lisbox
Saving data
Locking Pivottable Toolbar in Excel
I want to present and excel document on a .aspx page
Importing / OLE DB Query
Saving data
Need help with Command Bar Button issue ??
Macro to query data from a succession of websites and display in seperate sheets
blank lines at end
Excel Won't Unload...
Downloading a file from a website in Excel Visual Basic
footer problem
pagenumber etc.
Create Folder
Handling a Null Cell in Macro
Handling Null Field in Macro Loop
Downloading a file from a website in Excel Visual Basic
Null Field Result in Loop
Copying and Pasting cells within an Add-In
How to use: ThisWorkbook module
Copy layout to all worksheets
Calculate % with empty cells
Importing / OLE DB Query
Playing .wav files (why do a few cause warning messages?)
Worksheet enable calculation
VBA Code for Solver
Function that returns font style
Deleting Duplicates
Email and if statements
Runtime error textbox problem - help required
Deleting Duplicates
Comparing 2 excel files
Accouting & Database
IF then Active Cell
Web Enabled Excel Interface Problem
Find a workbook and "overwrite it with the latest Excel format"
Export Charts as JPG using VB.NET
playing sound???
Help file for excel program
Help with row selection.
Problem with time format
Find the word "total" in a cell, delete row or column
Select Case from Text Box Input
Userforms
Data Labels
Using a macro to add borders
ComboBox and "mmm-aa" format
Accouting & Database
excel word
Copying and pasting
dynamic workbook
VBA Formula Result Different Than Manual Formula Result
Inputbox - Dynamic Array?
Application.EnableEvents = true, but no event fires
"Else IF" syntax used in an Excel VB Macro
VBA Formula Result Different Than Manual Formula Result
Shortcut key
Circular Reference
printing out via vb and selecting the printer
How do I disable 'clipboard' message window in an Excel macro?
ReDim, Preserve and Multidimensional arrays
MultiPages
calling read only spreadsheets
Controlling ODBC queries with VB variables
Is the user Administrator
Help with row selection.
Cell Referencing
ComboBox and "mmm-aa" format
VBA Formula Result Different Than Manual Formula Result
Controlling ODBC queries with VB variables
Copying and pasting
Email question - Ron deBruin
Data Validation and List Length
Property Let / Get Statements
Test Score Tabulation - Multiple conditions
ComboBox and "mmm-aa" format
VLOOKUP? and Data Validation Combination
Retrieve CD TOC into EXCEL
Protect or Lock Column
Concatenate Text File
Help with row selection.
Objects, Macros & TabSheets?
Cell Formatting Lost When Saving
Prob: Custom CommandBars and .xls Files Being Re-Opened
Text manipulation with Visual Basic
VBA Formula Result Different Than Manual Formula Result
FORMULA
Graph object always missed info.
Printing twice instead of Once.
Excel should let me deselect an individual cell
how do I turn off option explicit statement in VB
month problem
Count Function
Trouble hiding commandbars
Stop Cell being Highlighted
Combo Box Code...
Excel 2002 and the .emf files
Textbox's and Dates the usual conflict
MIN/MAX question
Printing twice instead of Once.
Why my VBA Code Prints each sheet twice
pivottable mutiple recordsource
Combo Box Code...
Workbook_beforeclose +msgbox
Auto opening of a EXcel file on a CD
gathering data
Combing Workbooks
Copy/Time Delay
Missing VBA Reference
Copy the row multiple times while translating the columns
An Algorithm that matches two lists
ElseIf
ComboBox and "mmm-aa" format
time taken to recalculate
Excel 97 - Application.Iteration is always FALSE?
read-only default
WordBasis insert command -- text length limit
Handling Dead Hyperlinks
Workbook_beforeclose +msgbox
Edit cell contents via userform listbox
Problems with the userform multipage
Workbook_beforeclose +msgbox
Macro
Calculating the difference between hours
Excel 97 - Application.Iteration is always FALSE?
Send email Error...Please Help.
copy digital signature (certifice) to second computer
Macro for Parameter Query
Problems with the userform multipage
Problem setting a range
Prevent UserForm on top of a worksheet from being dragged around screen
Appending Tables
Method 'Cells' of object '_Global' failed
pagonis "wrong selection"
Excel Add In - Limited Use?
Invalid use of Null error
Number of Items in an Array.
array functions
Message Box Positioning
Tool Tip Text for Form control/ Active-X control
Finding out values depending on zone
How to Enable Microsoft.Win32 Functionality ?
XL'97 - Cut CommandButton Anomoly
Do not delete last item of each
Delete command button
Dynamic Sheet Tab Naming
Copying formulas using Pivot Table data
Filling Blank Cells
Dynamic Sheet Tab Naming
Command line options
Help with Importing Form Module into external xls. file
How to get the Mailing Address from Word
ClassFactory Run-time Error
Creating an array based on worksheet index
MsgBox to the front
Capturing a file path
Concatenate Text File
Data Importing and Exporting
Why can I change display value in locked ActiveX combobox?
Controlling ODBC queries with VB variables
how do I change the font in an Excel XP forms combobox?
deleting rows
pivot table value
custom footer
Options for three compartment analysis - Old BASIC program to Excel?
Trailing zeros are dropping off
Downloading updates a message box shows up saying SKU011.CAB file.
Formatting a Variable
traversing across columns in VBA
Changing control properties/code through code
save workbook as the date content of a cell within a sheet
date upon opening
Combing Workbooks
Accouting & Database
Top 10 for each Item in column
Pivot Table variable range
auto generated number
Excel macro help
creating FormFields
date upon opening
enter date upon opening
date upon open
Retrieve CD TOC into EXCEL
A procedure should run when one cell switch between false/true - but not with worksheet_calculate or change event...
getting runtime error
Emailing in Excel VBA
Charting a pivot-table problem
find row value, insert column
Excel - Powerpoint
Combo Box Code...
Can I use Excel to set up a tickler for financial statememt track.
Array Declaration
Rename workbook upon closing
Interaction Excel and Word
Email and if statements
Check Boxes
Changing/Concatenate Names from [FIRST NAME/LAST NAME] to [LAST/FI
Show value 0 in blanks fields
Add value 0 to blank celss
help extracting a value in VBA
I have a large worksheet keep getting error OLE.APP Help
Method 'Paste' of object '_worksheet' failed
"Selection" Code???
Copy and Paste
adding formula to vba code
worksheet_change on pivot chart
Show Data Form