Excel Programming [Archive] - Page 123

activeCell.offset in another worksheet
Sending a Notes mail via Excel VBA: MIME format
Run time error 1004 General ODCB Error
Removing semicolons
Help: Making a copying macro from cursor position ?
Programming using VBA and Userform
createDocumentFromURL
Protecting sheet temporarly
Change entries in a workbook
Formula for labels!
Interesting problem!
DSN Listing
insert changes Named references
XIRR in VBA
prtotection in macro
Problem doing Query to Access with Excel sheet protected
Output an image from Ms Access to Excel
Repeated application of Solver to new equations
Stopping a 'multi-level' procedure
Adding ranges
Check Excel's state to see if a workbook is loaded in App
Speedy line item entry with Macros
Code Sign PW Protected Project?
Multiply a range
Problems with AutoFill xlDown macro on certain computers - DESPERA
Capturing query table errors
Questions About ComboBox
List the contents of a directory
Dynamic Range: limit ?
Further Array Element question
keep form displayed
I need to compare two formulas that are being fed different raw d.
List Box Selection
worked yesterday- doesn't work today
Remove/restore cell shading (colorizing)
Help Please! (This one is a bit tricky)
Looping w/calculation
Can't seem to get to fill down
Copy a table from Access into 2 columns
Hiding/Unhiding sheets and rows (An easy one for most of you....)
macro to copy specific rows to a new book
Automatic Date Computation.
Make excel think txt and csv are same thing
Macro to delete and replace a text box
VBA SolverOK not inputting all values into Solver...
VBA-EXCEL CANCELAMENTO ABERTURA DE PASTA TRABALHO COM CLIques mous
change event
conditional formatting and interior.colorindex
Save Every Worksheet as its own Workbook
Open non-Office prog. macro
Macro to input and compare date ranges
prompt for # of copies in print macro
How to Access Array of Arrays?
Protecting Cells
Trouble Naming Range
Macro to remove ";"
Disabling Macros
Create Outlook task from Excel Macro?
Lost Focus apply to cell
Excel and drop down list
print a certain range depending what is in cell?
Formula Question
Long file paths in MS Access Linked Table Manager
Re: Copy Formula Down
GetObject method from excel to other application from remote server
hard drive swap means vba code isn't running
missing chars in a comment box
drag and drop objects from outside the workbook to a specific cell?
modeless userform during shutdown phase
Using The Text From A Textbox In A UserForm
Advance if statements?
Re: Ping results into Excel
Is this right? SetFocus weirdness
document for VBA
Offset Glitch
Sumproduct Questions
Finding Cells that are included in Chart Ranges
customized menu is empty
Balance Sheet Formals
Can I make a cell flash in conditional formatting?
refer to a cells value in a macro
Excel Macros
Saving worksheet as CSV after pulling data from an external data source
Filecopy, file attributes
Tree Structure
Adding controls to userform
Macro to remove ";"
How to format text in a control?
Advance if statements?
Looping code in Excel macro
Selecting a Range Of Cells.
RE: Problem Closing Excel
Copy and Paste macro needs to paste to a changing cell reference
Dates as input to autofilter?
how to use excel to do plan
Advanced if statements?
autofilter and adding comments
Row height and Merged Cells
Remote data query stopped working
How to handle shifted columns
Delay Visible Updates??
Just a learner...!!!
refer to user selection
Over 1000 Sheets in a workbook
How do you get discriptions on sales invoices to save from saved .
Column Headings
Re Worksheet Change Issue
Msgbox API
avg test failed or no virus found
combo box header
Filldown Problem
Setting Chart MajorUnit for Clean lookng Chart
Saving AutoFiltered Data off as a smaller file?
VBA to make key entries into application
listbox months
Order of Excel Add-ins.
help with data parsing
Object definition and structure, with variables
Select Case for Sorting / Grouping Columns
Can excel be formatted to use as a timer?
RE: Page Break Preview Page Number as Data
Convert numerics to alpabetics?
Saving CSV to a template
Yet another question... This time about the VBA Editor
Code Problem in BeforeSave Event
Problem with Userform and different code modules
Add ins & data in the add-in workbook
How can you find out where a VBA function is used in a spreadsheet?
using pword and auto protect
Create One-Dimensional Array from Two-Dimensional Array
Sending active worksheet and renaming
Does Alt-Enter insert a non-printing character in a cell string?
Read/Write VBA Form to .dbf
Vlookup question
Microsoft Query
Copyfolder
Sub Total Report Appearance
Excel conditional formula
Why does my formula change to a number?
Macros stay available
Hyperlink Addresses
Call Procedure
Network file has been changed, overwrite dialogue
Using VBA to Send Keyboard Entry to IE Page
Array Element question
Worksheet name
hyperlinks to files in all sub-directories
Add toolbar buttons to userforms
Error: Method 'OpenTextFile' of object 'IFileSystem' failed
formatting combobox
autofilter : how to go to next row ?
Date flips around when using Autofilter in VB
Dump 2D array into Control
Excel VBA - Problems with 3D Column Clustered chart
drop down list location
How to find ranges in a sheet
Can someone help me make this code more robust?
Capture Excel Events from other application
Visual Basic run-time error when printing from web application...
Controlling Office Clipboard in Excel with VBA
The number in this cell is formatted as text or preceded by an apostrophe
The number in this cell is formatted as text or preceded by an apostrophe
Saving to users My Documents
Is there a way to pass parameters to a web query in excel
Help with drop down menu
Accessing solver in XL2003 from vb
Moving sheets
vba(SOX): ftp connection & hard coded password
creation of data input window in excel
For Each..Cutty Pasty Loop?
Grouping Userform Controls
A question relating to "for each cell_in_loop in range"
Code to NOT include row 1 and 2
disabling Excel pop-up dialog boxes
Find Variant
why does it sounds every minute?-Help please
variable in object name
Reading Data from the clipboard
range values counted problem
Filter in macro
Displaying Result from Drop-Down Box in Seperate Cell...Can it be done?
Product not found error
Sendkeys debuging
Copy Formula Down
Find x number of lowest values from a 200 x 200 matrix
Help on macro output
Find 1st occurence of value in Range 1 in Range 2
Display macros in addin
Macro launch - Button vs Manual launch , has different results.
opening in break mode?
Find range within a range
Filesearch returning files not in alphabetical order?
RE: Event Schedules
activeworkbook problems
What formula do you use to determine a number within a scale?
Passing a variable from Excel to Word
Detecting a sheet unprotect?
Number of sundays
Detecting Ctrl-Tabs in User Form input fields?
Append data in a separate spreadsheet using a Macro
conducting a count on unknown number of records
Formula insertion not working
Pointer to a userform
SendKeys?
Drop down arrow disappear
Excel
how to go the the next row when autofilter is activated
Fill formula down to last data row
not sure what's happening
What is the difference...
VBA Error: Method OpenTextFile of IFilesystem3 failed
jhs2000.xla
VBA Error: Method OpenTextFile of IFilesystem3 failed
VBA Error: Method OpenTextFile of IFilesystem3 failed
Selecting ranges of cells
Scrollable Frame
How do I calculate 30, 60, 90,120 days delinquency in Excel
How do I repeat a column when printing in a macro?
data refresh all worksheets in a workbook using vba
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys
Programming Excel with C++ .Net (MFC)
Clear and control the Office clipboard in Excel
Database Count function.
default drop box to a value?
Controlling HTML and web pages through Excel?
Get long value for a date string
removing a toolbar with code
dynamic toolbar
How can I programatically identify and delete an image?
Data Stream Converter ??
Value in a inputbox
combo box vba issue
need help with password protection and macro
Color Palette
Email again in excel
Excel Combo Box & Web Service
Moving rows to other worksheets
Export / Import to / from Text file
Getting Computer name and User Name
Find all instances in formula string
Cant select my Calendar
lowest row with a value?
OnClick event
cells, which write to each other
validation warning for macro data
can VBA be used to sound a *.wav file on condition(s)?
opening toolbar with file
Change text of chart tips?
before print function
Web Query Doesn't Return All Tables With Excel 2002
Go to next blank row
VBA ActivePrinter
listboxes
Manipulating embeded exccel in word (Repost)
Event warnings
Undo list
Excel Function prototype popup box when typing formulas containingUDFs
Code for Array formula
next cell selection
Printing a form from Excel
Passwordproblem when saving to ftp-server
Sending mail from Excel with CDO - return SMTP value
comobox-name as variable
Command buttons
Excel Charting
Deletion of rows where a value is satisfied
Skipping confirm
Calling Macros from another sheet without any hard coded references
Defining Range of For Each Loop for Cells and Worksheets
Passing variable to VarType of other Variable
one cell entry made up of two lookup results
How to copy selected data
Get the Result of Excel Dialog, when closing excel?
how to make a macro and run in every excel book that opened?
Hiding/Unhiding sheets and rows (An easy one for most of you....)
Break Key doesn't work
How do I query a website
dynamically assigning to a combo box
Creating a Control Array
URGENT problem with Autofill in a macro
How do I access worksheet cell data (i.e. cell sheet1!a4) from vi.
How do I access worksheet cell data (i.e. cell sheet1!a4) from vi.
Importing Word Paragraph to Excel - 1 cell, same formating -- I lose the format
IBindStatusCallback
add-ins & security
Reference for MAXIF array formula
Append code to a xlDialog
trouble finding object to use
Display dates on userform
Save as w/ Time Stamp
Excel Erroring on Close
Shade rows A:J
Problems Unhiding a Worksheet
hlookup via vba
How can I combine loan amortization schedules
Code to Prevent Adding Worksheets
Selected Sheets
ping in excel
Copying data from several worksheets to one worksheet
Opening
Not for the Faith of Heart - Macro Arrays
Excel/VBA Packaging Wizard
Increment an Array question
How can I insert the contents of a cell as a filename?
I can't figure out listfillrange
In a pivottable is it possible to substitute (blank) for "-"
Make Windows XP menus open fully expanded
Add formula in the code
Excel - erreur Automation
RefEdit control by 3rd party or other option?
I need to put text in quotes(")
Trim all but the first 5 characters in cell
Match Inputbox Value on Values in Column
Opening an Add-in
hex2bin - HEX2BIN
API To Find File
Extra ranges
Edit Query from Excel will not open query in MSQuery
listboxes
filling text boxes from a combo box
Network Issues
Find specific text in a string
t
Auto/Re-Calculate user function
Emailing a sheet to someone that doesnt have excel
Test - Ignore this message
How to Download hotfix for Excel 2002 (May 6, 2004)
Using A Macro To Add Event Procedure To A CommandButton
Merge Cell
SumProduct with variable array
Conditional Formatting
vlookup problem???
Worksheet Handler (int)
Vlookup array problem
printing to multiple printers
Make all menus fully open
Calling Text Boxes from a sheet
Opening an Add-In
Archiving specific records to access
Selecting next drop down item in pivot table with a macro ???
Using A Macro To Add Event Procedure To A CommandButton
use ADO invoking dbf file in excel
Using Microsoft Query
Retrieving Acces Querry by Use of Macro
Filling In Data Beneath Current Rows
create macro to move label type data to column data
Inserting Data Beneath Current Rows
Using A Macro To Add Event Procedure To A CommandButton
Date Event
Compare two ranges in a worksheet
Worksheet_Delete event?
Programatically Rename Tabs
Catching duplicate filenames when renaming a file
RE: Current Workbook Path
VBA Code for a pivot table to open database and to reference table current page
Prompt user login when refresh data
Worksheet.GetCodeName/Get_CodeName
controlling macro execution
Initialize a Private variable
Any examples of VBA and Amazon Web Services (ECS) Programs???
Combo box
I get error 91 when trying to run Bullen's FormFun
random number
Checking a list of new data against a database
Lookup Result in Array
How do you continuously update time and date in an Excel cell?
VBA Code to list vendors
web components - msowc.dll
Autofit some columns
User must agree to User Agreement
entering data from a serial port to excel
date sumfi
Changing a pivot table field items to current database
Catch drop event in excel
Code for Correct location of Add-ins for all versions of Excel
Stephen Bullen FormFun
How to view VB Code behind Pivot Table created via Wizard
Combobox
problems with dialogs
Photos in excel and email
why is personal.xlsbackup created every time I run a macro
Some Basic Doubts in Excel Macro
Excel - database
Using VB to renam files
Permutations - 8 columns
How should I interpret this set of laptop specifications?
stubborn Excel crash when editing code with code, one solution
Thorny VBA problem. Any creative solution appreciated.
XIRR in VBA?
Public Variables
Application.GetOpenFilename
Subscript Out of Range
Option Button Value
Another issue to resolve
Conditional Formatting
Excel Macro
Comparing Different Sized Arrays
moving data from excel spreadsheet to word document
Filling Cells from Textboxes
UDF is cancelling (preventing) SheetChange Event
Pass Data from List Boxes in Userform
Formula is the problem
How can I stop a macro for Human Interaction
unit testing advice
ranking columns
Missing dll to work with Ron de Bruin's code
counting # rows in a worksheet
Search Engine in a Workbook
Backing up IE Favorites
Is it possible
Please Help, No Toolbars in my view->toolbars!
Problem with speed of PasteSpecial for large ranges
Combo Box
File Handling
"hpme for all sheets
Allow code to continue regardless
Apples or pears
Split question in XL2003
easy to crack vba password
Copy From A Range To A Range
ForumulaArrays - help needed.
Text box
RE: Current Workbook Path
Copy worksheet instead of Move
MSHTML Objects
Transcribing cell formulas into their comment boxes
I want the macros to be locked up when cells are locked up.
Emailing files using a do until
Can I set an input mask for a cell?
Can I set an input mask for a cell?
Re: Pivot Table/ % Change
Re: ? for Tom O
Help with instring code
Missing vbTab in listbox
add a word to text in a cell
Contacts not showing up in MS Fax
RE: Setting Chart Min, Max and other scaling
Re: start Macro when file is open
font size
Disallowing Update
selection all textboxes in userform at once
HELP on this strange errror : Method OpenTextFile of IFilesystem3 Failed
I need help with parsing cells ...
Running Queries to Oracle from Excel 2000
How to insert Asian characters into a cell?
Generating multiple sheets within a workbook all titled with a ca.
How can you open a tab(Sheet5) by clicking on particular cell say.
Recalculating Functions
getting a drop down to start listing from the top of a column
Application.match--Documentation?
Close Excel if macro stopped
hide detail / close group outline
Copy help
Personal Workbook exe
Transpose variable columns of data into addtional rows
Pausing procedure until worksheet finishes calculating
print macro and email
Re: Current Workbook Path
7+ if statements
Re: Save One sheet
Coloring Cell Font based on Cell Contents
Re: Importing Email from Outlook
7 + if statements
Need a shortcut for copying formulas on a master sheet that gets .
RE: Code for dividing amount amounts
Re: Save One sheet
"dragging" down the solver (macro needed)
Re: converting constant/text to formula and evaluate it
Re: Use Autofill in a macro to fill blank cells until next text -
Syntax for de-selecting a control?
TextBox on a Form How do I.......?
Re: Macro no workie workie - Help Please
Atomatting Worsheet Creation
How 2 remove this error - SMTP Server, Email using CDO
Un-protect Multiple Worksheets
count function
how to detect mouse pressed(down) event for work sheet
Hide blank rows in a range
Code to compare cell values from different worksheets
If cell contains
CurDir("c")
code to add rows to combobox
Close all Instances of Excel
VB Code or Excel macro to run Query/Import on Access file
Help please with listbox
Customer Button on Startup
Creating a report by For Each...
Pivot table sum data
show/hide rows with listbox
Insert auto serial number in Excel template
Changing file references in a macro
VB code to "Send To" Multi addresses
lookup function
Import sheet error
Length of a Validation Items drop down choices
Temporary Files
FileName SaveAs
UNC Paths
mask
Evaluate cells for change and then action
Multiple text format in Excel cells
Which language will be suitable for excel programming
Number Group Seperator
I need to auto exit MS Excel when user leaves workbook open over .
apologies for posting it again but...
Set object1 = ????
Auto filter off
Using The Value property of the ActiveCell object
macro to insert pair of formulae in x number of rows -URGENT!!!
VBA Modify Registry
Need help with code location PL EASE
A simple copy problem
Listbox
How do I save a 2003 version macro in separate folder for other u.
merging cells and formating text.
How to set a formula in a cell? Application-defined error.
using the RefreshTable method
Macro code please
File Properties
need help writing normalize function
Copy worksheets from one book to another
Wouldn't it be nice - Code Signing in Bulk
Read Outlook DL Lists
adding info to combo box
Macro question
SUM values in a column till you reach a flag in another column- Urgent
Report Manager or Hidden Setup Sheet?
Application-Defined or Object-Defined Error on simple code
vba
Help with updating formulas
LastColumn used as letter(s) in VBA
Combine cells and text wrapping
Chart with dynamic x-axis names
Excel Opens with Manual Calculation option on instead of Auto
VB macro using ODC connection returns field type 'CHAR' queries i.
Need Help w/ SUM Formula Syntax
IRR, NPV
if statement depending on month
How do I make a command button invisible or visible?
Create Access like report in Excel.
Create Access like report in Excel.
Dir function
VBA Book Recommendations
How do you create a new inputbox from the menu bar in excel?
How do you create a new inputbox from the menu bar in excel?
Can someone help me make this dynamic?
Command Button Moves
Protect cells function
How do I save each sheet as a separate .xls file by using macro?
How to auto update Excel Web Page
Urgently need VB Help - Declaring "Global" Variable?
To know cell color
Centering MsgBox text
Define OLEDB connection string
excel, vba and construction of a formula that updates properly
Controlling EXCEL on open properties
activate a Word Window from Excel VBA
How do I Delete Asterisks from contents in a cell of a column (kn.
Excel cell size
Response to menu in VBA
Place in A1 the value generated by formula in B1
How can I validate data input by macros?
XMLSS and Worksheet Name
Excel and Adobe Acrobat
Wordart color macro
Can the Autoshape number in the namebox be reset?
trying to DDE from Excel to Word using DDEInitiate
Protect cells backward compatible
Shared Workbook and Macros
used to worked OK with Win98+XL2K but problems with WinXP+XL2003 now!
Test to see if a workbook is open
VBA Function
msg box - default answer
dynamic cell references in formulas
delete pictures
File available for editing notification
Creating non-volatile Date
Close Adobe Application from Excel? Anyone?
Writing Macro - How to get the cursor/Active Cell back to top of W
Appending data with VBA
tasks-Object ??? or an alternative
Clicking on a help topic causes an error...
"Advanced" Text file importing
Splash Screen problem
Passing Variables-Excel VBA
microsoft query voids out spreadsheets
How to copy range to diffrent workbook ?
Excel VBA
Get the name of a cell
conoslidate from different files with same format
Pivot table custom formatting of group levels
Auto filesaveas vba code
Error Handler and Error 1004
Arrays: compare fields?
Specific XY datapoints in graph
Project Window not showing up
start value in a combobox
Waiting Mode when query data from Db via VBA!
VBA-Excel. File-SaveAs
usedrange
Line Feed
Convert Date to Age
macro setting?
macros
Put Sheet name in cell
count instaces of text string in range
Decode MP3 ID3v2 and WMA tag info
Passing a value from command line
How to find Excel Page Break?
Excel Help!!!
Shell
Custom text formatting in Excel 2000
option button to hide rows, with password
concatenating puzzle
ActiveX Control
Copy a sheet to the body of an email or attach part of a spreadsheet
Passwords
How to test if a repertory is valid
Copy a sheet to the body of an email or attach part of a spreadsheet
Addin Residual Memory
Status Bar Hangover
Please help with do while
Application.visible help
macro to retrieve path to opened file
ComboBox Value Comparison from multiple worksheets
dimensioning across modules
reading data from a range into a cell
Copy rows from all sheets based on cell value
Determine 1st 2nd 3rd in PWD
Toggle a range of Julian dates to Gregorian Dates and Back
drop down list
10 X 10 grid and finding distances from multiple points...
Check Box Status
Filesystem again
Assessing range values 2
Assessing range values
Programmatically disable new smart options
random non-repeating names
Nothing has changed but macros won't work!?!
macro problems
Having stack/heap memory in Excel VBA
Accessing an Embedded Project Object in Spreadsheet
Web query; protected site?!?
How to combine lines of code?
Arrays: Subscript out of range
Prevent Pasting
to close a workbook via VBA
Cell Protect Lost
Help Please Cutting and pasting based on cell value
PERSONAL.XLS times 2
application.match Returns what
protect format - page setup
Formating currency in text box
userform problems
Easy but not for me!!
Problem with looping through userform controls
Need help with inserting comments
userforms
Turning Spreadsheet into attachement in an Email
Is it possible to insert the sheet name into a cell?
Run piece of code for each line of data
Range select
Screen artefacts
Adding another formula to and Exsiting Formula
Macro's
Stranger Behavior ?
userform problems
Wondering where the information comes from...
Where does the knowledge come from?
Why does code execution stop? HELP!
Code stops at range
Find
Macro to Copy data from e-mail and paste it into a field on a website
Retrieving all precedents address
How can I turn an Excel file into an add-in?
if emthy
VBA Stops Working?
error
write to external file
Exiting Excel - Addin Password request
On Time code
protect/unprotect grouped worksheets
Assessing range values.
Colors in dropdown cells
Message: Links not updated because file not recalculated before sa
Add to/Modify WordArt Gallery
External Data Source
NAme range
custom views....printing the names
Printing Chart Sheet from a dialog box...
duplicates
Can I run a macro from a command button in Excel?
macro problem again
MS Excel IF Statement w/pictures?
Loop through Range and Cut and Paste
opening an excel file that is too large
Hyperlink activation by speech recognition
hperlink activation with speech recognition
Find Text or Part Of Text
List of commands that work with shell?
Is there a rule for number of variables and characters used in a function
Copy Cell and Paste in Same Column Only
Compare ComboBox Value from multiple Worksheets
variable scope
speeding up vlookup
Cant seem to make an embedded object really transparent.
private workbook_change and Goal seek
Multiple file macro
Userform with 5 textbox and 1 needs to refresh to have total
Userform with 5 textbox and 1 needs to refresh to have total
filesystemobject
Copied data prompt
Pivot table custom formatting of group levels
Auto run macro on open file
Close Adobe Acrobat from Excel - attn: NickHK
What codes can make Excel Macro to submit forms on web
catch the amount of negative numbers
Excel 2002 - Iterations - Find the iteration sequence number
How to sort a PivotTable based on OLAP Cube by one of the data fi.
Populate Excel Userform with Sheet names
The way to continue do macro recording
to view a column text in another column
last row value in a range
Automatic File Name from Templates
Formula to show cursor's whereabouts
How do I change a buttons contents depending on a cells contents?
Reading a zip file
Listbox
Renaming adding and deleting directory
Excel 2002 Crashes
UserForm to view contents of spreadsheet
Macro & runtime problem
How can I get my macro to appear in ALL worksheets
OPEN.TEXT function in Excel 4.0 macro
Sorting subjects into groups
ActiveWorkbook.RefreshAll
Calculating Time and Date Differences
Need sopme help coding Dates and Sheet names. (Please)
Conditional formating 1 column based on another?
Change sheet tab name from another sheet?
Can this be done?
C# vba development
Combining and Sorting Lists
Advice on database in the form of text document
Macro Security & Automatic Link updates
Linking Excel With Vba Please Help.
Exporting Excel Data into Notepad
problem withcell format
Keyboard freeze when using hyperlinked sheets
VBA editor replaces 'Range' with 'range'
sheet "hidden" vs "very "hidden"
Developing Multilingual VBA Apps
Newbie Problem
Saving user specific binary data
Can value at A1 toggle hide/show of row 2?
Learning about the ScrenUpdating property of the Excel application
How can I program a message box to open when a user opens and exc.
Help with datediff vba
Analysis Tool Pack: Random function help
dynamic hyperlink or onclick event
formatting macro
VBA script ActiveX .ocx embedded
integer value won't change
how do you setup a auto run marco to run when excel opens?
naming cells
need some conceptual guidance, advanced excel
Quickest way to copy then Paste Special-Values in place?
Auto_Open vs. Workbook_beforeopen?
Tracking changes to Excel worksheets?
VBA sending e-mail using Lotus Notes?
Type Mismatch in Auto-Open Macro
Repetative conditional formatting
Failure on MacroRun but not EditorStepInto
can I make a general object event procedure?
How to iterate through all Text Boxes on a Form?
How can I lookup data in other sheets, without the choose less da.
Find last row of data and delete empty rows
Merge a workbook as another worksheet in a new workbook
Excel
Pulling Access data into Excel
I need a macro....I think
What am I missing here....?
What am I missing here...?
What am I missing here...?
Close Adobe Acrobat from Excel
combobox with columns
Moving rows to 2nd tab when worksheets protected
'ActiveWorkbook.SaveAs Filename'
Add in blows up! Author disavows responsibility
Values being formatted differently when opening spreadsheet using ado.net
Autofilter macro for noobie
Referring to a Range using Cells(Row,Column) system
Pre-numbered tickets
Formula Bar
How do I create formula in excel
Register vba project
Prize Calculation
I want a non-blank cell to return 25% in an adjacent cell.
Prize Calculation
vlookup worksheetfunction
TextToColumns delimiter setting ignored w/in VB loop
MS Query
Adding Code to an Existing Command Button with VBA
hyperlinks & email - Excel 2000
Inserting data within a named range..HELP
Looking for information on creating a formula in excel
Can INDIRECT hold only the column value constant?
Case on filtering.
Textbox Control Source
Cannot eliminate Clipboard Message
For the hard one -- myabe Tom??
Multi Select Cells
Using .pagesetup with no installed printer
Addins not loading when opening from code
Negative format
Saving Text Delimited to Excel - T. Oglivy
It did not work...
VBA loop
Hide a workbook before saving
New RefEdit for excel
Can't get "handle" on named range??!?
Combobox Vs Combobox
formatting text boxes
formatting text box
Using excel to embed multiple transparent links to other excel...
txt file from filtered data
how do I stop pop-up message after spell check
disable spell check pop-up message
delete Userform control programmatically
Excel macro/vba loops
Range.Delete and Range.Resize.Name performance issues
Functions
combobox question
Create drop list on form from range names?
Save As
Remove all rows that contain letters
Repeat value in the same cell on each sheet
Remove all rows that contain letters
UserForm Initialize event doesn't fire reliably
Hide Row macro works in 2002 but not 2003
formula construction
RefEdit ActiveX control
Excel security flaw
Display an Image in it's associated program
GREATER THAN
Names of Drop_down Boxes
Can't Open Excel 2002 File in Excel 2003
Seaching across the top
Changing Text in a Forms Button
Testing text on a shape
modify values in Graph
Named Range in VBA
VBA Password Removal??
Shared worksheet and form function
Saving a file
Can an excel macro handle colours ?
Project Protection
What Are And Can I Delete .EMF Files in WINNT/Temp Directory ?
Adding Data at the End of a excisting Collum
SaveAs doesn't work
Find a value, then insert a row below that row and copy the contents to the new row
Auto Create Custom Menu Buttons
Emptying cache or "history" before opening workbook
Save as
Adding numbers in text box
Using combo box
Can not open macro storage
How to load a .bmp picture into a cell?
Passing Params to Embedded query programmatically
hlookup & addresses
Update Vlookup lookup_value
Auto-Executing Macros
how do i release memory
Disable Auto Macro
Sort PivotTable by ColumnField totals
Sorty PivotTable by ColumnField totals
Add worksheet as template
adjusting charts using inside dimensions
Using Excel to check CoOrdinates
Excel crashes when it starts
Missing Reference?
A better way to get rid of spaces
help with workbook
Copy only where data ends in column
Macro to hide or unhide columns
Round time with conditions
Sort Each Worksheet
A Macro that Fails to Perform Correctly.
First Friday in a Month
Formula Translation
How to write a macro to import an event procedure to ThisWorbook?
Access Database
Go to line in Module
VBA: Add cell value to another worksheet cell using Find and offset
Rowsource Property
how do i directly edit a connection string in an Excel workbook q.
Referencing worksheet CODENAME in a chart object.
No display : keep information in clipboard
Fileformat XLText
Problem using analysis toolpack when automatically running excel
Problem using analysis toolpack when automating EXCEL
CopyPicture ?????
Analysis Toolkit does not work when automating EXCEL workbook
How do I start solver options in a Macro?
Can I set up sublists under Data Validation
ChartObject Name Restricion or Excel Bug
Range vs IRange What's the difference?
Help with repeat rows for header & Footer
Referencing cells on non-active sheets
Removing all rows that contain letters
Listbox control does not get refreshed
Another Simple Error - More Info
Require a lookup to return multiple values
How to fix this error
Importing external data
Trying to match fields and return a value
Setting default printer using wsh
two cool points for whoever can solve this one...winsock
Make Excel a runtime application
mexcel macro to run onselect
Formatted cells on summary worksheet
Another simple error...
Import selected data
Deleting a button
Worksheet.copy changes references
VBE References List
create a second combo box from a first combo box
intersect function problem
Delet row if bold
Cell keeps give me an #valid error
Array Formula
Excel 2003 Range problem with .Net Interop
Overflow puzzle
PDF to Excel as flat file, via macro
Copy 'value' of cell to other cell, same sheet after entering value
Range("Weekending").Cells.Columns.Count
Do Until Loop strange behavior
Copying a cell value to a different sheet with a macro
Scroll bar protection
Copyoi
UserForm only
Search and destroy
Creating Userform Controls on Frame
VBA for put cell C2 in overstrike/black when B2 checkbox is ticked?
deleting mutliple rows in different ranges at same time
used range question
impose a value from workbook A to a cell in workbook B without for
Change th cell Background color with sylk format
Is it possible to have a code that counts coloured cells?
Msgbox
display text from a link
Marking Checkbox from VBA
Dataform
Find Function
Run time error - "out of stack space"
Does MS Office 2002 have support for managed code extensions?
BCC
Shell command ignores parameters
Worksheet Buttons disappear after Macro runs!
Excel data to word template
VLOOKUP and wildcard
Autofilter - allowing for error
Importing Access record into Excel using MSQUERY question
Help with Getting Totals of Matched Numbers Please
Excel to SQL
How to refer to programmatically Dynamice Range names
TextBox RowSource Question
Help with selection code
Possible to change the file name?
Very strange add-in file behaviour
Pivot Table - VBA
Excel in VB6
save and restore "Workbook Menu Bar" & "Cell" menus
Proper Case Odditiy
Re: copy method in office:mac 2004 Standard edition
allow comments, unlocked cells, protected sheet
Insterting Text Into
Dateformat
setting format in vb
Centering In Screen
Matching value of a cell to a sheet name
Redefining the UsedRange of a Worksheet
how do I use scopefolders in excel macro in windows xp
HELP! Object specific Code
HELP! Object, Properties & Methods
How: open a workbook with auto macro disabled using code?
Constant definition
Bypass Workbook_Open when opening a workbook with VBA
VBA, Bookmarks, Word and Excel... help please!
Name List
Digital signature, code alters VBE
vba copy code
userform problems
Date Format
Displaying a picture by pushing CommandButton
Decimal numbers not recognized as numbers
Using a variable to refer a cell
loop to time in 24 hours format
Creating Temporary Userform with checkboxes
Strange effect when exporting as text file