Excel Programming [Archive] - Page 92

Listbox selection creates form
HELP TO COMBINE MULTIPLE SHEETS IN MULTIPLE WORKBOOKS
Convert Percentage to number
Sort Issue
Calling same event for all the toolbox controls in the sheet
Restored XLS password protected file, but now corrupt?
Changing links when protected
0 entry vs blank cell
Linking website to Excel
Prevent other users from selecting next available auto-populate cell
Break Scheduling based on Input of Calls Volume
Reset data entry fields to 0 or nothing
Increment Alpha Numeric Cell
Compiler Going Flaky on Me
Prevent Screen from flicking from one place to the next
Color input vs formula cells with 1 click
Auto_Open Frustration
Exctracting Literal Value From A String Variable
Exctracting Literal Value From A String Variable
Compile error HELP
case of the data
default printer print quality list
Open unknown file name
Keep Before_Save from running
adodb connecting to a server issues
If one column is full, goto the next column
macro to delete duplicate rows using Filter
Input Title on MsgBox
Stock Charts
Increase date by on year
Excel html workbook
Comparing Dates - Generic Function?
Data too large for Excel, need to query Access data for results
How do I close a file system object?
Copy Data From Cells To Array
How can I modify the SELECT statement?
Cell input mask
Addin has problems with the ActiveX security warning
Create Macro Dynamically
can't delete columns
Best practices for pulling data from a network Excel file (mult users)
How can I execute this query?
Exit Sub is workbook is not protected
PivotSelect
Validation not triggering Change event in Excel XP
Can I merge an excel list to an excel sheet like mail merge in wor
Pasting Dates from Clipboard of Web Page to Excel
Validation not triggering Change event in Excel XP
Range Name and VBA
script to import parts of txt file
EXCEL file corruption
Function not working (but works as a sub). Any ideas?
DropDown
Summing multiple hits using match, offset and index method
Change Range & Row
Macros and Printing Footers
Delete data if not within date range
Return a row with the Min or Max funtion
Quick Simple VB Snippet Needed
Error Handling for Duplicate Worksheet Names
Exit Sub if sheet is hidden
Sheet code name
simple excel macro Q
Sorting an array
excel not calculating
Showing Userform
Fixed Asset/Depreciation formula
Programming question
Multiple cells in cells function
Delete all pivot tables on a sheet
Visual Basic to Control a Citrix Connection?
Open Excel using Access macro
Copy data from IE to Excel
Excel Automation
Removing rows from a excel spreadsheet using a vb script
Incorrect syntax near '#' problem when returning to MS Query fromExcel
remote query & date range?
Increase Column Heading Part 2
Checking usewr has input a valid address
Control WORD from VBA EXCEL. ¿How can I erase data?
Reading data from a cell to a text box
Checking user has input a valid address.
Range issue
Macro to create a comment with contents from Paste
Increase column heading letters withing routine?
How can I do amalgamate 3 select queries and then get unique entries from the result
Have 2000 and XP versions on same machine?
Error Message When Using Replace
NEED HELP! - Excel Object Model & .Net Compact Framework
Selecting the right cells....
XML downlaod through visual basic - tag problem
How to store custom data into Excel cell
If cell is text, then
how do I make a counter cell in excel
Excel User Conference - Atlantic City - April 2006
Passing arguments into function to bring data array from closed wb
macro to display items of a same type
Creating Pop-up Info Boxes
Subscript out of range
Fixed Length Text fields
How to copy and paste number formats only?
Sub halts with Run-time error '-2147024809 (80070057) specified value is out of range
Creating Hyperlink in excel 2003 VBA
hyperlink in excel vba
Data validation within a userform
Problem with macro to email file using CDO
Pivot + Macro
How to Delete a Range in Closed Workbook
Handling 2 workbooks
New to programming
http post from excel - user authentication from excel to web
Getting the image selection using VC++
Summing with Dynamic Data
Import => New web query
How do I paste a source data reference to a chart using a macro?
Connect to internet
emailing using Excel VBA
Display Alerts
ActiveWorkbook.SendMail not working
Column Searching
UDF & Add-in Issue
Duplicate Row
automating flowcharts in excel
underline size 1/4 point
Run Macro after value change from drop down list
Code Erasing Cell Contents Inappropriately
Excel DataAlchemy Menu
Loop using Month() and Year()
Scroll bar increments select case?
starting from bottom of range instead of top
File SaveAs
Fields in access database
Fields in access database
Multiple files question
Version makes the difference?!
Unloading a Form
macro to control printer settings
Save or SaveAs Macro
Copy data from a range in a workbook based on a value in another
Version problem?
Adding time selection to pop-up calendar
dates and times in excel
Reserved Names in non-English Versions
Reserved Names in non-English Versions
Sum totals at last row
Custom Checkbox control in Excel
Re: copying worksheet
Excel Calculation Question
Increment Alpha Numeric Cell
moving to next cell in range
V Look Up Annoying Function Help Needed
Combine csv files
Reserved Names in non-English Versions
Summing figures generated by formulas
adding a page break in a pivot table
Reserved Names in non-English Versions
mouse click event?
Find/Copy Variable length range
The Monday of the previous week with VBA
Need help with code
Built-in for Selecting Ranges?
Looking for a way to avoid many If/Then statements
Reference A Combobox On The First page.
Copying A Worksheet Only, Excluding the Code
Save just a worksheet from a workbook
VBA User Forms
new macro problem with password protected worksheet
VBA formula building
Not understanding with/end with
Adding More Conditional Formating
Un hide non empty columns
call a "dll" in Excel X for mac?
range, cells won't work
delete defined names
Autotab does not always work
error 438
Great Code : Need Modification - VBA Save Button
papersize
Invalid Picture error for new users.
Excel add-in with modeless dialog
New to VB...any good books?
Very new to VB...any good books?
File name varible problem
Sum Range and enter results in the last row of the column
counting dates within a rnage
Increase the date/time in a excel table
Reading data from a list box
Tracing problems with macros
Excel automatically starts another sheet when calculating formula
Multiple sheets, one user form, and a unique ID
Stuck on Formula
No toolbars when viewing through IE
Function wont work!?
trouble adding to list.
Min but not quite...
Drop-Down Macro
reseting adodb commands? help please
MsgBox in Enter event causes combobox not to run Change event
reusing a recordset for a pivot-table?
Bit of a VBA problem.
Stopping a Macro
UserForm Show problem
formula in VB not working
Changing digits in a cell
Transfer to adjacent columns
How to clear the clipboard contents in VBA
Hit a button with VBA code
Paste bitmap to Excel
print macro
Re:Creating submenus....
I am new to excel programming, can you help please?
xml bug
create an outlook reciepient in excel VB without getting an error
Import from Sql Server
Fast Data Processing
Move data from on sheet to another keep duplicate rows
Change Macro
Creating Submenus
Creating submenus
Cut, paste and delete
XLL Memory allocation problem
updating log
updating log
Worksheet function?
Repeat macro for all open workbooks
Excel / Word Interaction
Count Data Within Range
Getting user to enter file name
Spreadsheet in a form
Open Command
userform and formula
Lookup-function does not work
Formula with arrays
re: imitating cut and paste - #REF! problem fix
Changing cell colour in Range
SpecialCells and Names
Error with calander
Step by Step Macro Help.
doubleclick to make cells move to another cell
Refedit Control
looking for an excel template that will simulate a bank account
Row Color
Data validation function and drop-down lists
message for tom ol
Calculator in Excel.
validating numbers n text in same cell
Inesert value of column B of the current row into active cell
I try it again. Howto. Proposed Filename and path different by the default with VBA
Simple request
Script fails in Excel was okay before.
3rd Party toolbar to automatically enter code within VBA
help on triggering macro if cells change
Import/Copy some data from one workbook to a similar workbook
Help Please - CountIf and Array formula
Count question
Adding a comma after an int field
vb code to save a spreadsheet to file
Error in Macro: "Method 'Paste' of object '_Worksheet' failed"
search and deliver
Expanding a Selection
extending this formlar
combining and copying
Timed and blinking messages
extract hidden date
valadating a data match
Can I use "or" in a select case construct?
Date Validation for Date of Birth
Page Setup.
Filling Array with uniqur random numbers
Help with a macro
Protecting and Hiding Formula
Class Module Question
Working with dates
Mysterious Error 1004 caused by AutoFilter?
Detecting conditional formatting
Machine work load
question about exiting a procedure
Copying Autofiltered cells
change sheet codename
Why does Excel ask me to save changes?
copy a workbook outside of excel
AutoFill on selection
concatenating a number plus a formatted number
Why WorkbookBeforePrint doesn't run?
Excel should update trendline equations when data is altered.
why If, THEN does not work
Macro to identify year within a date
Move worksheets to a new workbook
inserting decimal two places from the right
USING OUTLOOK FILED ONEXCEL
Is the cell really blank?
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
every nth value
Help! with Macro - delete entire row
VBA version of ISBLANK()
how do I call specific worksheet
ipf.value question
Calculate the Number of Subsets
import .wmf->Excel 3?
Combobox rowsource
Mailmerge from a button in excel
See old posts
Calling Bob Phillips - Please
Worksheet Protection
Listing combinations in excel
Save options
Choosing default path/filename in Excel with VBA
Context menu of Cell
Secundary Axis
macro to find date in the string
UserForm TextBox with fixed Width and dynamic Height
macro to merge cell
Listing multiple rows on other worksheet
Opening an Excel file from a Userform
Retrieving Values Saved in Names
Find text in a string that matches value(s) in a range
Locked Cells Problem...
VBA Forms in Excel crashing on exit?
Copying data from a listbox to a textbox
Is there an easier way of doing this??
Creating a Backup copy of workbook
Checkbox and inputing answer into a specific cell
Inserting cells
Web-Based Pivot Tables Refresh Question
Programatically creating a toolbar to run macros
Create a subfolder
xlstart folder
Why do Template names increment ?
Need help
how to print list of all worksheet names in a workbook?
Collection - object required message
displaying data from a range
Message Box
Using FormulaArray in VBA
MsgBox in ComboBox Enter Event does not allow update
View limited sheets in workbook based on logon/password protect
MSQuery Optimization
Activating a macro after a cell is updated
minor but irritating problem when generating Excel files with Perl
Variant userform problem
Stochastic function macro
Data validation cell default
Copy spreadsheet into another file.
Programmatically determine Chart's data source
reporting services
Userform into Web page
Application.Run and VBE "phantom" projects
If statements
Checking for open file
Move to bottom of table
Excel Workspace Save trouble
How do I combine multiple workbooks in Excel using a Macro?
Automate Excel upload into static Access Table
Adding a folder with code
Comparing and updating worksheets based on cell content
Not finding value, range method failing
Macro Help
Excel vba print file to pdf (Problem)
Application.FollowHyperlink Query
formatting decimal places in code
Key Press Event
Get a specific Program files folder
How to get print area borders - UsedRange not correct.
Hello I am a newbie and need help
Cursor Movement
Custom textbox in Userform
Compile Error: Block If without End if
input of single value into multiple cells simultaneously
emailing a userform during runtime
Digital Signature Email
VBA Project Not Viewable
Hoping its an easy question
3D Sumif - help using!
Using forms?
worksheet function for InStrRev()
Selecting data from another workbook
Use VB in Excel to close open Word Document
Create a toolbar button
recognize a sheet
Source for toolbar for code within VBA?
Can I make VB programs external?
Calculating ELO Rating (UDF Query)
Workbook security question
How do I generate a report in Excel?
two questions
Delete File in a folder
2-column combo box via code...
April 2006 - Excel User Conference
Windows File Dialog box problem from "Office 2000 VBA Fundamentals
Copy from Excel to bookmarks in Word
Select a column based on a index
Copy method: How to remove dotted frame
calling oracle stored function with CLOB parameter
Msg Box input string
Msg Box input string
Need help with chart
Circular reference in an open workbook
dim statements for worksheets array
Loops & Ifs
AutoCalculate at Defined Intervals
macros -"OK buttons" part way through ?
Traffic Lights
Problem with Lookup-function
calling an oracle function from Excel
getting a horizontal scroll bar in listbox
Easy question
installing an addin
Pivot table refresh error
Problem with application.getopenfilename
line delete interception
Clear Clipboard no longer works
Create "Name" in UDF
Problems with SUMIF in Excel
Refresh of data
How to get number of working days
Problem:Query Cell contain Formula from QueryTable is always get old value
Conditional compiling between Excel Versions
querying a spreadsheet with formatted cells using ado
Inserting a Value into a Range
Macro / Sort error
top 5 number is LARGE function with N/Afields
Textboxes and ComboBoxes
Wrong Settings Or Something Else
Update data wihout opening the file?
Digital Cert Error
Revise Macro from Worksheet
tutorial-venn diagrams?
code with eomonth problems
Application.FileSearch challenge
formulas
UserForms stuff
information on protection for excel and macros to allow scroll bar
A Huge Thank You!
Code Conflicts With Worksheet Change Code
Do I have to close an odc in a macro?
Consolidate - edit code?
Footer Page Number Question
drop down list in excel
Re: External query of SQL server
Cell Colour based on text in Range of cells
Re: Cell Colour based on text in Range of cells
Clear a sheet
Out of Memory Error
excel freezing
Need some advice on the following code
Inputing a " within a "
Hex2Dec and Dec2Hex don't work
Preventing code continuing running
Worksheet copy with rename
Named range, maximum characters in RefersTo property
get cursor position when clicking on an image
Copy all sheets into 1
Macro run from If Then function
Copy contents only
the ' symbol ends the SQL string, how do you replace it Excel
Protecting Sheets, automatically protects the workbook
excel formula
XLL and user defined function + xlcFormulaArray
Selecting columns
Link spreadsheets
Looping through each element of an array
nesting for 2 dependents, and 4 formula options
User forms help
A computer with morals?...it doesn't want to "kill"
Runtime error 1004
Value over Mouse
Unable to set the orientation property of Pivitfield class
How to open the //Text Import Wizard// from within a macro?
Word 2003 Find/Change Automation from Excel 2003 crashes Excel 200
Again Filter:
Moving some cells.
Populate Range
Refreshing Pivot tables link to a SQL Server
Workbook size has grown
how to identify a cell address
3d Sumif
Using VB In Excel
Keep macro running overnight?
Macro to round highlighted cells to nearest hundred
How change unprotected cell formats on protected worksheets?
change fill color of a range of cells based on color of a cell?
Elapsed Time in Hours, Minutes and Seconds
Create/Write to an Excel File in a C# Windows Application
Pivot row order query
Insert Col data into single cell
hide and show columns using one control button
Check for blank arguments WITHIN Macro - how?
Looping through Cells
Project data exported into Excel
Deleting Certain Rows
Need help with Nested IF - How does Excel read
Moving Data
how do you get a drop down list to equal a value in a separate ce.
locking vba code
Help generating combinations
I have been pointed in the direction of a checkbox event
Week number converted to date
using if statement to compare text
Keep dbf format when opening dbf files in excel
Code to protect sheets, protects work book also?
massive sorting exercise!
optional args in UDF
Fill in the blanks!
popup box
Fill in the blanks!
Fill in the blanks!!
pop up box
Sending Email
Select Cell Range
Excel VBA OR statement
List all values of a column
Save function in VB
Help with range
Disappearing charts
extend vba code to other sheets
downloading data
excel add-in
password
RangeName blocks of data
writing formulas in VB - referring to the values contained in cell
importing .wmf from CAD pgm?
go to today's date
Centralizing Vertically of Label and TextBox
navision sales data from excel vba macro
Keeping an add-in loaded
Form Tab to text fields Excel 2000
excel macro
Adding formulas based on range names
referencing external worksheet (named) in sharedrive
Return Exact Value
Calling a worksheet via a codename
Calling Macro from Workbook_BeforeClose
If...Then...query
Deselect cells with formulas in selection
Searching for spanish/italian-translators
Quotes in Macro Formula
How to show help for functions defined in addin worksheets
Adding values to a cell based on entered data
How to check from VBA if sheet exists?
Create non-contiguius range "IF"
cell color macro doesn't work
Search for specific value
How to search for zero in sheet
CDO Query
help for macro for formatting pie chart
Imbedded .pdf or .doc files
Zoom in on selected picture
Compatibility problem?
Excel Pivots!!
VBA Option Button question
Using specific columns of a dynamic range
Sub to extract path from hyperlink formula and insert picture into comments
Mail Merge problems
Save As File Type
If workbook is open, save workbook?
Return Path of selected item from dialogbox
Execute Code
AutoFormatting Style Selection
onAction events on NewMenu
sorting a listbox in a user form
MultiDimensional Dynamic Arrays
No of rows as Range
A better way to copy and paste special between worksheets
Incorrect resolution when printing.
Position independent code
copy cell
Is there an easy way to make Excel update Access, and vice versa?
How to import data from a foreign DB TO a combo box?
Programmactically add calendar control to userform
Help with VBA code
SQL queries from CSV page in excel
Getting non-Excel file properties
How to know cell's address from Excel Query
Deleting several cells at once causes a VBA error
Manipulating Numbers
Hardcode links - loop through sheets
SQL stored procedure using values from cells into Pivot Table
VBA password
Calling macro from a different moldule
Sorting database with images inserted in cells
how to Run an Excel Macro from ASP
how do i use array of values for dim statement
search of first #N/A position
Save active sheet into new workbook
"Static" Behavior without Static Defn
Copy data without opening file
change cells on cell change
Delete Worksheets Prior To Access DoCmd.TransferSpreadsheet
Update Links - no prompt
Update Links
VALUE FROM DIFFERENT SHEET
Array vs. Cells
Stop code from running when I click "Cancel"
Create excel chart from LotusScript, change xlLine line weight
Use a macro to create a desktop shortcut?
How read a csv file to load named cells
Error Trapping
VSTO running unattended
xlDialogSaveAs question
3D Sum
Pop up box/form before save
Compare worksheets and populate based on match
Auto advance to next field -tab key AND option button to reset fie
Populate userform listbox from access db
Working on FindPrevious command in a userform
Conditional formatting
combos and dates
hex2dec
conditional sumif
creating userforms(urgent)
In need of VB some assistance
Deleting Rows
Help understanding truely strange error involving access query and filling cells
SheetChange event crashes using Range.set_value (C#)
Output array to Excel blank rows separating groups
Extensibility Library
Error 400
Sum of rows Column wise - Strange behaviour
How to set the Column Header value for list box?
SOS: Connecting to External Application (AS400C)
Loop and AutoFill
Create Outlook Distribution lists (default txt file) with excel
F=$100, G=$-100, cut rows & paste in new sheet
For, Each, If, Loop?
How to use TreeView control
How do I create a macro that prints to any default printer
using the value of a macro variable in a concatenate formula
who origonally wrote the workbook?
Conditional formatting error, odd!
Excel 97 - xlNoSelection - problem
How do I hide the form?
Sorting Data, Text and Numeric
sumproduct using 3 columns and using (LEFT wildcard)
sharing violation while saving file after adding this macro
copying from multiple worksheets
Try-before-you-buy version?
Align labels and data together
set cursor with api
SQL question
VBA with Select Case problems...
Insert Blank Line after the Word Category is found
Application.DisplayAlerts = False - Not Working
Events in a Userform
Help with a option buttons located in a userform
Code will not fire
Locking Specific Cells
Text only in toolbar buttons
Merge 2 pieces of code
traverse until non integer
Selecting a dynamic Range and sorting
Split text , uniformly paste in rows and columns.
Reading Excel Spreadsheets in VB.NET unattended
UDF to compute using ranges
Copy/Paste Macro
Replacing
Backward compatability
Need a slight modification to code
Avoiding sheet deletion by VBA
Possible bug?
Open Workbook using URL instead of network path
Custom Sort
Send mail problem in Office 2003
Dreaded 911 cell character limitation
Error 1004 occurs only in specific cases
Last used cell in a column
variables inside a formula??
FileSearch behaviour
Need to have control of the calculation to specific ranges
Using common VBA code for a series of Woorkbooks.
Replace pieces of text
Code for Printing All Filtered Rows Separate
VBA front end for Excel
Why doesn't my simple macro work?
Inconsistent Operation of SendKeys Command
Protect Worksheets
Excel User Conference April 2006
Help! macro needed to join two worksheets, using a coloum on each sheet to pair entries
Change cells inside a function
Database library methods in Excel VB
concatenate locale bug?
Re: all filenames on A:\ into Excel?
Calculate doesn't work right
Hide Macro
Define a variable for dynamic chart
crate group of date, with Dynamic Range in Pivot Table but not wor
counting cells using multiple criteria
Hyperlink
HELP! Calling subroutine in different workbook
Deleting rows
Custom function to simplify vlookup formula
hOW to retrive the Data after did UPPERCASE
Doesn't work as it SHOULD .. Rows.Hidden /with SpecialCells
draw 999 x 8 random records from file with 8614 records
Microsoft request for slow-calculating workbooks
Custom FaceID's for Custom Menus
auto insert
Compare shapes for obtaining a value
Header using cell data
Eliminate DataLabels created upon eachother, not readable?
creating controls using code
How can i email the contents of a userform?
IF function
text to column
Hiding blank rows
automation error
Find end of week and insert Data
Register Calendar Control and Network Drive
Calculate,Copy, Paste Cell Group Macro Adjustments
VBA to Select All Visible Sheets
formula help to get oldest date in column based off another parameter
Best way to pause?
Resize Named Ranges Help
Enum type variables
Excel "Insert Formula" dialog always call my user defined function
Le dialogue de fonction d'excel appel ma fonction "user defined"
received message: Can't enter break mode at this time
create new column with last name
Toggle Code Calls
Status Bar Font/Color
Copy data thru searching all drives in PC
How to use more than one databases in a macro
web query in VBA (format dates in url)
Help with copying dynamic column selected based on remote cell value and dynamic formula fill
Using CDO and trying to add multiple attachments...
VBA code to check if another window is open?
Need help with row color
Save Cell Properties into an Array
AutoExec Code to Open Template Dialogue on Startup
copy from sheet 1 $a$1 and paste on sheet 2 $f$2
Quotes in .formula calcs
Rename active sheet to contents of specific cell
Regular expressions
How to define a range based on first and last cells with data?
SHDOCVW in Worksheet
What book is the most efficient one to study Excel VBA
Hide the current month columns
How to do this?
Hiding row and column headers, scroll bars
Looping across two parallel ranges
Find next time in a range
Identifying the first date(s) from a list
Output the range
Select failed?
Sort hyperlinks by time
Format
newbie range question
Format Subform
How do I set up a macro to save an Excel worksheet as a .prn file?
Command button help
Write 1st and 2nd dimension array values to cells
copy if checkbox checked to sheet two
Subtotals in wrong positions excel 2003
SCRIPTING
How do I find max/min around the perimeter of a spud plot?
Code for auto filling in Excel based on number of months, & start date
Excel VBA to VB.NET conversion
Excel VBA - Linking .hlp help file to Function Wizard
Identifying workbooks with links to external file
send all over to word
UserForm when opening workbook will not fill screen
Excel sorting in VBScript
VBA Bypass Delete Sheet Warning
Need help Editing Ron de Bruin Script
Hyperlink to VB Module
URGENT ASSIST NEEDED IF POSSIBLE RE VLOOKUP/MATCH
Excel 2003 ListObject question
Keyboard Shortcuts
sending email with Outlook using Excel
Error 0x800A03EC when trying to populate a worksheet
command button that puts specific numbers in a range of cells
need help with 'counting' between values
VLOOKUP but return a different row
Opening Excel issue
vba user defined function help
Save a workbook using FileFormat in .txt but with data in csv for
Allowing user to choose what mathmatical operator macro uses
Saving contents of a Userform to another file.
Edit/Replace from Table
Scroll bar starting at bottom of form
Creating a conditional screen based on multiple criteria
nested if
Borders around cells...
Import HTML table
I'm trying to do a comparison if statement but it is not working!!
Changing the Office Assistant
Printing document from code
Conditional Formatting Cells
How to add a row
Simple Count problem
Ole Links (C++)
Excel file access ole object
Excel Not showing any result after Automation
Accidents Per Million Miles - How do I write this?
Event procedures for spreadsheet cells ?
Back to original Formating
looking for Excel VBA work
Sheets Tabs Function
Function for simple code
Auditing cells: Find "dangling"cells
problem with double value
workbook_beforeClose
Copying Macro
New to macros, need to update worksheets
Conditional formatting
consolidation of tables in excel with text and figures
is there an "if for each"?
Using variables while running macro
listing all sheets in all workbooks in a directory
consolidate data, dynamic ranges
Blank Cells when Sorting
Saving file using Explorer Style box
HELP!!! problem with list boxes
Start a Macro within another Macro
Please help
query: print dialog with entire workbook set
Can you filter sheet of data & on another sheet make four groups under each other?
Paste doesn't work when module is created
Can you create dynamic named ranges containing array formulas?
Hyperlinking to a Glossary
hi
Using ADO with Excel
Server swap & ODBC DNS refreshing
Print a Hyperlinked HTML file
Copy row to another sheet on each day
excel crashing after deleting shapes
Multiple print areas
root file path
On error...
Unable to get last filled cell address from Range.End(xlDown) method
Unable to use Range.End(xlDown) method
Y TestBox don't Change?
Loading information from a VBA project to spreadsheet
Loading information from a VBA project to spreadsheet
Starting Excel from Word
Automatically update column with weekdays
text to date
Setting print area to text
code to copy excel sheet from 1 file to other
Regsvr32 + calendar control + network drive = confusion
code to create new excel file
select method
what is itemdata equivilent (if exists)
How to select a specific column with Excel VBA
code wont compare negative numbers correctly
Need macro to clear contents
help! trouble with triggers...
PDF. If you know.
Zero fill, no decimal, need postive/negative sign
Find and copy the row using VBA
Hyperlinks to =Hyperlinks formula - Challenging
link a graphic to a cell
Range WrapText and AutoFit with Bold
using both sum and average in subtotals
Remove or Edit a set of custom preferences for Excel
Setting PageSetup Properties in Multiple Worksheets
How to access MSSQL table in a user defined function
Formatting a List in a Combo Box
Named Ranges
Is there any way to change the name of a Module?
Can't select
Loop help please!
Insert "Weekly Subtotals:
Yet Another VLOOKUP issue in VBA
Multiple parameter database query
"trying to access e-mail" when worksheet opened
Allows users to only paste in cell A1
listing all sheets in all workbooks in a directory
Showing Hyperlinks in another column
Creating a "Search All" function
Updating a dropdown list from SQL server
Error when adding web reference
Cell Text Search & Insert Value in Next Column
Dropdown with all tab names
Importing cells to new worksheet
Need to consolidate multiple ranges
Open a picture based on Excel Value
Find last used row in Range with Data above and below.
Deleting empty rows in a worksheet
wage mulitplied by hours and minutes
Prevent deleting spreadsheet
I need to create a macro that extracts daily files data to a mont.
Why is my code not working the way I intend it to?
first day of the current month
Simple Macro Needs Digital Signature?
Can I code Styles
Dynamic summary sheet for a workbook
Copy
Creating a menu in code
excel>keypress retrn of simple hyperlink?
How to shift the cell based on the location of other cell?
Control Displays Number Instead of Date
Excel and Access Performance
Can Excel produce multiple profiles of charts/tables of row data?
Problem moving data
Macro Date Manipulation
Pouplating a list from an array
Display the Cell Number of Cell if Value =Value
Convert date from dbf files
Paste Append from Excel to Access
Date Calculations
Inserting Proc-Call Into BeforeSave
Refresh Multiple Queries via a Command Button
Navigate through Computer Folders in Combo Box
paste a forumla and copy with a macro
relative addressing in code
VB type
VBA showing a specific range on the screen
How to turn off control toolbox while showing a userform
Spinner, worksheet focus problem
Compile error in hidden module
challange Please Help
Macros setup deployment
Disable sheet copy/move
Macro simplifying - copy rows to worksheets based on values in 2 different columns
if then loop
CreateCubeFile Method - RARELY Used - Need urgent help
has anybody come across this before?
relative path for const in vba code
define relative path from xls to xml file
Excel hangs on "Delete Comment"
passing parameters to dos from vba..
Is anyone on here with DVS Reporter???
Combining all the excle files
Passing Variable from Sheet to Userform
Confused about referencing multiple object code rows in other worksheets?
Display Text and Play Sound file
Capital & Small Letters
Activate a web page
Worksheet exists
ListBox Populate and Refresh
Bar code into a form
Converting Large Text files to excel
Division
Retrieve Sender in Calculate Event
Problems with sheet unprotect
Convert external links to internal
exporting a macro
Subtotals
help with a macro
Execute javascript help
How can I make program of accounting in excel for small business
Adjust Time
Help with Visual Basic programming
How to name a cell
Is there a better way of doing this?
select workbook to update
VBA - Delete row if cell contents bold text
Search Replace in VBA
Is this possable
Animation in Userform
Formatting text within VBA
what am I doing wrong?
dynamic data capture
How do I copy validated lists
Commandbutton to Workbook Open
Isnumeric
Inserting row based on critéria using VBA
Workbook Event
Extract filter items from Drop-Down Automatic Filter
How to handle automation error?
Is there a "Select all Pictures"
Auto populate a cell
link word to a number
help, please
Nested IF statements
Saving a workbook
Format all pictures
Defining a Label
In Excel, how to select and then add up the best 6 scores out of 7
parsing blocks of cells for charts
Insert dummy variables
Article creation
searching data thru 20000 records
Several questions about Userforms
What is lifetime of public variable?
Display Text and Play Sound file
Maximise and Minimise buttons
how to define a web query in Excel&VBA??
Multi-page and Scroll bars
Call SaveSettings
offset cell position when there is value in a selected cell
Sorting, one last time
show icon caption bar in userform
VBA
Combobox values used in macros
Unprotecting Question
Sheets Array help
File Extensions
Picking text from a string
sum cells in same column selectively based on value of different .
Hide sheets when book is opened
Userforms checkboxes and printing
Integrating Outlook, Word, Excel macros
subs or functions with user defined types
If all cells = "OK" then.....
can OnEntry be limited to certain cells only??
Paste vs PasteSpecial
return pageBreaks
Paste-Special - R/T 1004 help needed
copying changing range