Excel Programming [Archive] - Page 111

open powerpoint file
Change Code Windows
Help with inputbox cel reference
How to copy cell base on value in different cell
formula help
Debug.Print "Test " vbCodeLineNumber & ": " & varName
Before close - not always deleting sheet- WHY??
Loop not working!!
Loading UserForm gives error
How can I add a control to an Excel chart?
I want to run a macro when i press return
Search for text, copy the number in front of text
Dates and Strings: Last day of the quarter - string "Mar 04" to #5/1/2004# ?????
Application.FileSearch on only one level of sub folders
Excel 2003 file sizes
How to solve this problem?
CSV file
application quit problem
Finding Links to XLA
type mismatch
VBA / SQL: problem with dates
ADO Connection to SQL Server
VBA problem going from Office 2000 to Office XP
Date depended update of data
Vba - := ????
2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
VBA - Efficient Macro
VBA
Shared File/Locked for Editing
Advanced users please look! - MACRO help Needed!
EXCEL FORMULAS
Trendline Data from Charts
Hide Certain Sheets based on Cell Data
Pivot Table Hide Levels in VBA
Re: Incrementing a cell
Hiding Chart Changes
Format Worksheet Tabs
Incrementing a cell
Compile Error: Expected End Property
Counting Nested If Statements
adapting the findnext function
checking for empty rows before copying?
VBA Excel Formula Limit
how do I judge current document is a blank one?
excel macro
Lock Cells
format number....
Vlookup and named ranges
ï¼¶ï¼¢ï¼¡ã€€ã‚³ãƒ³ãƒˆãƒ*ãƒ¼ãƒ«ã€€ã®ã€€ãƒ©ãƒ™ãƒ«ã ®æ–‡å*—ã®å¤§ãã•ã®å¤‰æ›´æ–¹æ³•ã¯ï¼Ÿ
How to copy data as per date into new worksheet?
Textbox accepts alpha only
How to capture file name in a folder?
code for program run once everyday
How do I set up report linking data that changes on daily basis?
Save charts in a Excel file into another new one
my macro is clearing the wrong sheet
Macro to insert specified tabs to all workbooks in folder
How can I use Outlook express to send mail rather than Outlook by VBA code
Macro to insert row.
HELP : Excel 4 macros not working any more
Set Properties of TextBox in VBA
Can I remove a VBAProject under macro control?
Function Required
Application.DisplayStatusBar
automatically put in page break after 14 lines.
excel file repair
Creating an Array Formula
Buiding Array Formula
Re: Folder Inventory & Count for like named files
Dynamically assign ComboBox.List from named range areas
newbie needs help with collections
Last row, last column revisited
Excel Bug or Macro Problem?
Continued SumProduct Woes
If username not match then print out report
continue statement in a loop
Auto Save
How to show the active cell after running a macro?
Resize chart area without resizing plot area
List Fill Code
Can't trap error when checking for keys not in Collection
screenupdating = false not working in Workbook_open sub
Regional options support question
MACRO RECORDER
Insert letter into empty row ?
SMTP problems using CDO
Excel OLE data in PPT reverting to OLD data after macro updation
trouble w/ creating a VBA function that uses an enum in it's parameters
Delete a blank row on spreadsheet
Using Explorer - multiple copies of Excel open
Help with getting first letter of a string
selecting cells with an input box
compile error: invalid qualifier.
Safeguarding Excel Products from Piracy
"Random Number Generation" Window?
DDE Programming
Print Formatting
Macro for date highlighting....
Conditional Formating
Endless loop?
Worksheet Overwrite Macro Change
Error with Auto Open Macro
Assigning macros to buttons on a custom toolbar
Help! How do I shift rows down?
Publish active sheet as static web page
referencing a cell in a workbook on the web.
Find purple cell color, change to red
macro that adds left and right footers
RE: Find purple cell color, change to red
opening each file in a folder
Increase a row by 1 cell
Can i use range-object for .object.value=
Using "Case .. To"
Rename a sheet
Excel File Renamed to HEX
How do I set Excel cell format to "Text" from VB.NET?
Input boxes - writing entry to cell
vba advice how 2get a input box to quit by entering the word quit+ 4 a msgbox to disp
Error with passing collection as parameter
Success in unprotecting VBA module using VBA
Command Button Alignment Problem
Mysteriously terminating code
Activate Different workbook?
Adding a validation list by code
Alignment
Plz Help Me
referring to names
XML in Vba
Adding a line in footer
Closing Excel Instance
Buiding Array Formula
Creating and naming new worksheets
Ron, I found some code that works with Lotus Notes
Creating a Template with drop down boxes
Get selected cell name/address
VBA and Constructors; exist?
copying data for multiple rows
On Error? Creates 1 missing worksheet then never detects any other missing worksheets
Lookup
go to the first row without data
Run time error '1004'
how can i input data into a pre-recorded macro
how disable a button forms ..
VB Extensibility Library - 97 to 2002
How can I use Outlook express to send mail rather than Outlook by VBA code
With block does not work on inactive worksheet?
Worksheet ActiveX Objects
How can i get activecell address
Copy data in new worksheet as per date
Saving workbook in code
Select row from macro
Highlight Cell
Stocktake spreadsheet
Formula error with Mac resulting in '#NAME' error
If-Else Simple Loop function
set macro security level through VBA
Sheet Background
What's wrong with this code???
Run Access Action Queries from Excel?
workbook.save
face id / create new icon
face id / create new icon
sumif or sumproduct with date as criteria
Problem accessing control in another form
checkbox
combine cell value (alpha) with number for cell address
Preventing Form Dialog dismiss (Red X)
Clearing the status line
VBA - Last Cell In Row
Passing large number of variables to function
copy chart area
Errors
Showing image from internet on userform
Help with Application.FileSearch method
CheckBox Value
CheckBox Value
email to multiple users via excel
vba solutions a.s.a.p please
Applying a change based on a CheckBox
Sendkeys/general automation question
Updating Outlook Calendar from Excel
get summary of cell range where all cells fullfil a certain vlookup request
Vba Help With A Solution
Prevent user moving to next control
help writing loop
chech if a cell contains a substring
macro/workseet/graph interaction
sudoku
sudoku
This is odd!
Hidden property not working when deleting a row?
spell numbers into text
VBA - Delete Drop Down, Retain Values
Referencing Call to Another Project
Aborting a Sub procedure from a UserForm
Combo Box programming
æˆ‘æƒ³å¯¹Excelæä¸€äº›å»ºè®®
Activate a Pop Up Calendar Every Time a User Double Clicks in Column A or C
Importing data from a webpage with password protection in excel
VBA - Last Cell In A Row
Checkbox question
Reset UsedRange
Help with changing formula
custom function problem
check box in userforms
search column for specific cell using vba
How can I replace a formula with its result using a macro?
Alt-Tab works differently if Form called from Menu or Buttonbar Icon
Copy/ Paste Special
Problems with an invisible form
Excel Search
Re: cells beginning with an alphabet
Setting a defaut path in a Macro
Class confusion
how can I create a ODBC database in excel
translateIT updated. Autotranslates Analysis Toolpak functions
Copy Data as per date into new worksheet.
square chart insidewidth insideheight
Variable cell in vba code
copying cell formula from one workbook to another
Automatic Shading
Insert record into Excel database using a custom VBA form?
use of a variable......
sumproduct question
Mac issue with macro recording user login & date (run time error '
Help for Send Mail via Outlook
What key was pressed?
how to increase my column length to enter 600,000 entries
Unable to ftp workbook with excel 2002
How do I replace data from one worksheet with data from another
Syntax help!
Re: Update a picture
Re: Comparing slightly different strings
Macro Help - Delete Duplicated Data
Importing Data from a website to excel
Sort - OrderCustom
VLOOKUP with mouseover?
Excel linked to Access
Open an Outlook folder when a user clicks on a command button ...
'Embedding' fonts
troubles with SendKeys
VLOOKUP - dealing with lookup_value differences
Finding all unique values
Printing Problem When Changing Printers
comparing & copying data over from another workbook
userform output to procedure
Calling a variable macro
DOUBLE POST--Sorry wrong category first--Convert to VB Pleaseeee
DOUBLE POST--Sorry wrong category first--Convert to VB Pleaseeee
Saving input figures.
ComboBox populating problem
Data Validation in code...
Update vaules only with Macro
conversion needed
User Defined Objects in VBA?
Shift formulas, but not formats
Macro to export data from active .doc form to an existing .xls
Nested loop order?
Buttons in Excel VBA
check for IsEmpty(MyArray) = True
issue with countif in vba
Loop thru named range of second sheet
Assigning Macro to a cell
vba undo stack
Deleting blank cells
Exiting WorkBook Save event
New object on spreadsheet
VBA Code To Import Historical Stock Quotes In Excel
Code in one workbook to call code in another XL file
Calling executables from VB
Do Until Loop?
Easy question - If ...then Change cell value
Name Verification
Worksheet Deactivate
Shifting Array Elements
text file with tab
Macro for blank cells
Opening User Forms
Data from Excel into SQL
I would like to build macro's to do pivots or part of pivots
Matching text files
Excel shuts down after opening dialog
Excel VBA pulling data from Access
Using checkboxes to determine what data to carry over
Reset 108 text boxes
Checkbox Click
Find the value
Message box to pop up if a particular value is entered
Password in a single cell
VBA - Passing Cell Contents Into Comment
Named cells in a worksheetchange macro instead of hard cell refere
VBA Code to unprotect VBA Module
msgBox pops up twice ??
Conditional Formatting for more than 3 conditions
Copying matched criteria and relevant data columns to a new worksh
pop up message depending on cell value
how i add picture in excel using vb6.0 at runtime
Opening an Outlook public folder from Excel using a command button...
show different text in a text box depending on cell value
Update links automatically
Starting Userform
Changing Tab Color With VBA
Looping thru values in a Range of Cells
Auto picking of value from multiple sheets.
Run a macro after data Import
Reading Functions from Common Place
make a list of files in a directory
RE: Screen Configuration
Change event triggered by a named range
Programming Help???
Display format for Total Column of Pivot Table
Replacing characters
Set focus on sheet and keep viewing vba window
macro beginner
RE: macro beginner
Workbook opens very slow
large data file problems - pivot table with vba
large data file problems - pivot table with vba
Data validation problem
Can I select a range based on the cell's contents?
What are the character codes of a carriage return entered in a comment?
date and VB
Loopy Code
error 1004?
Checkmark and Value Automatically Appear in Cell
Database needs to be repaired HELP!!!
Macro won't run from d: drive, but works on c: drive
Using a named range
shared workbook runtime error 1004
elegant programmed solution to local minima with constraints
RE: Macro
Setting a Prinout format for Printout of a page.
access macro to excel
Unable to open MSN stock quote query in get external data in Exce
Copy a Sheet
Pop-Up Windows
VBA Macro Grade Curve Question
Loop Problem
Chrw function giving compile error.
Copying the colors of one Matrix to Another?!
Autofiltering
calculate textboxvalues
Checklist to make worksheets visible
Goto next visible worksheet
Compile Error
Replacing HTML Tags in Excel
Change Security Level on Spreadsheet open
Floating Window
worksheet change on timer
Option button
Macros forcing file open
Hide workbook instantly on open
Are Reversing Macros Possible???
example of a polynomial regression analysis
Order of modules in the VBE
import batch file to excel
how do I transform data from excel to spss?
PdfDistiller Error
Format Borders
Repost
Findind values in a worksheet and fornatting them
Option Private Module not preventing cross project referencing
Can a macro delete itself (and others)?
Freeze Location of Hidden Toolbars?
nested if statements
Storing values to arrays for subsequent use
Using FileDialog or GetOpenFileName To Allow File Creation
Deleting rows without losing formulas
ADO, pls help!
Take out row...
Userform Textbox Sorting
How to force <enter> to behave like <alt> + <enter> within a cell
Conditional Formatting
Apply Border to range when first cell has text.
iI need a capacity learning chart
Autocopy between 2 workbooks
Multiple Email Address in Notes
Multiple Email address in notes
how can use C# write data into excel with password?
WhatsThisHelp in VBA - setting the help file path programmatically
Excel xlodbc error 2042 with SQLRetrieve
Creating a new excel file from an existing file using macro
Re: Installing an Add-in from outside Excel
Re: Installing an Add-in from outside Excel
Open a file do a macro ( made) and open next succesive file
macro to Insert rows at every change in a column
Get in DEBUG mode on workbook open
Get information on changed cells
HLOOKUP problem, help appreciated
Macro to hide a sheet
VBA - Compare Two Spreadsheets
GetOpenFileName called from modal userform.. enables workbook windows. BUG?
Subclassing UserForms !
ADO & Loops: error in code?
Selection Code
Unique Values
RE: Combo Box
Nested if statement problem!
Macro to select a view
Macro Speed
Passing Control when workbooks have the same name
Updating synchronized spreadsheets
Protection and Grouping
Re: Modification of listbox to listbox code
Hiding all visible toolbars by writing their numbers to an array
Cell formatting based on date
Synchronizing VBA Script
Loop Function unable to loop
List Worksheets in seperate worksheet
I need free Microsoft exchange automatic reply for my office
Re: Printing multiple sheets in an array
Auto-open Excel and run macro
Version Control
Strange VBA Behaviour
cells beginning with an alphabet
Counting accummilation of hours??
Re: Custom Array Functions
Re: Custom Array Functions
Problems implementing advanced filter code...
Multiple like statements?
Check contents of text box
Re: Modification of listbox to listbox code
Automation Lotus 1-2-3 Objects
RE: if until requirement met
Macro to auto Name a Range based on criteria
Re: Printing multiple sheets in an array
Can't test for Empty objects in an array
command button
Help with email sub()
How do I create a "Certificate" for myself?
New Twist on a Previous Inquiry
Change entire row color
Use of "Formula" prt2
Macro buttons causing XL fatal errors?
Excel XP/2003 crash
Disable MACRO
if - loop?
is this possible?
How to put to work an Excel macro in intranet?
Outputting the contents of an array
Is it possible to create custom AutoShapes?
Complicated Sort-Compare-Delete Question
Complicated Sort-Compare-Delete Question
Inserting formula with absolute cell and relative cell
Resize an Excel Column from VB
ComboBox fails when last item selected first
Need Assistance With Pivot Table Please
InputBox
VBA written in 2003 failing in 97
Excel to Access (new Issue)
When attempting to run macro Excel opens different workbook
word form field info
DELETE COLUMNS ONLY IF THERE IS NO DATA IN THE WHOLE COLUMN
Using CorruptLoad from C++
Inserting an image in an excel sheet using QTP !
Inserting an image in an excel sheet using QTP !
VBA macro for wrtting to Notepad
Selecting most of very many programmatically
Deleting macro after saving
Fill Textbox from cell
Inserting an Image in an Excel sheet using VBScript.
Quick Interface Question
Please Help! Shared Workbooks & VBA
Need to automatically "click" yes on a popup
Sequential filtering
invoke a function
Button Magically moves....
combo box beginner question...
Cash Flow
calendar with scheduled projects
test - please ignore
Multiple workbooks
Testing if file is open
removing rows that have a blank column B only
Textbox Code
I've stumped College Prof. with this one!! NEED HELP!!
Tab Order
reversing order of columns of data
weights
Filtering data
Creatn multiple sheets in single workbook
closing a spreadsheet
inset vba module using vba
Delete Cells Based on Range
If OR Statement...
Event when a row is inserted into a sheet
When does TRUE evaluate to minus 1?
Macro to disable screen saver
Run Macro with Excel Object ( from MS. Visual FoxPro 7.0 )
loop through rows evaluating 2 cells
Tricky array formula issue - Using array formula on one cell, then autofilling down a range
Insert Columns on Every Sheet
Equivalent Of VAL
Can someone find this error?
Referencing in a text box
How do I limit the character length of a cell when typing
Find duplication Macro
User Defined Object help fast
put data in columns
Cleaning the page file
Simple Question (insert new line)
Transferring part of a multi-dimensional array to a range in VBA
formulas
Speed up Code?
SUMIF with multiple criteria for multiple columns to sum a single
VBA - Cell Assignment
Drag & Drop !?
Public Array in a form?
Help finding a "batch processing" technique for a userform???
VOIP autodialer
Getting pre edit values
How change cntrl toolbx radio button from T/F to numeric output?
Writing formulas ...
Macro to read filename in cell and open new file
Problem with Mail code
Goto "Start of Sub"
Copying formula
Getting Value of Array element in Immediate Window
Running Total
Auto macro opening excel workbook
empty autofiltered range
Picking up E-Mail Details
What does this Code Actually do Please
Combobox data from Database
iterazione macro
Combobox Issue
Assign macro to each item of a drop-down list or combo box - how?
Data from Excel to Access
worksheet calculate repeatedly calling itself
Loop all sheetsand delete empty rows
Accessing worksheets in xla add-in file
PivotTable Multirange Challenge
Find method syntax
MS Query links
How to apply colouring as in Cells associated with Forumla
Links in excell
Vba Excel - Checking if changes were made
When does ISNUMERIC point to a number?
Label control - suppress GetFocus
Manipulating Strings
need help fast!
Changing RightClick event handling
Fitting characters of a font size in a cell width
Help: UDF Used in Conditional Format not Initialized
How to apply CLEAN func.
how to populate a combobox with a list of unique values?
re: Automatically Delete WorkBook 2 modules by using Workbook 1 module
Working with web server DB
Indirect reference and worksheets with single quote in the name
Working with Dates
Recording user and date of when a file is opened
Macro command
newbie: manipulating cols & rows in named range
Swap range values
Macro to Format the Pivot Table drill down
Buttons moving when print preview is done
Sample Size
Macro to protect/unprotect with password
Import Txt file via vba but still choose column types
Validation Problems
Macro looking to Outlook for namespace.
Copy only first row of each group.
Deleting Range Names is Erasing My PrintArea
Tabbed form problem
Program for calculation a power trend line.
VBA Macro for Solving Linear Equations
Complete Newbe - Is this a MACRO function or VB ?
combine worksheet events
Need help with date problem.
Need help: delete colums
Strange Charting
Named Ranges
Program for calculating a power trend line
Problem: Control Toolbox Control resizes when clicked
Cell value Change Event - Need to activate macro
Microsoft Visual Basic Run-time error '1004' No cells were found
can navigate through intranet site with Web Query (VB code?)?
Open File Dialog Box on UserForm
How can I automate a macro to run in timed intervals
Problem with vbext_pk_Proc
Protecting Excel Options-Tabs
Page Break Macro
In a excel/VB macro I am trying compare cells in different workshe
Delete cell with red text
I would really like to send information to your marketing group
ActiveWindow.ScrollRow and ScrollColumn
Entering Data
Auto E-mail
working with cells and text
If sum = 0, delete row
Where can I find the Function names in other languages
with random No's calc how can I stop two different columns predic.
Worksheet Calc Gets Stopped When Sheet is Clicked
Saving a file to a different path
Find Folder Path + file Name Length and Insert into Spreadsheet
Find Format
zip files
Saving a workbook with a variable name
Is there a function for closing Excel using VB?
Worksheet Protect in Excel 2000
Combobox Question
Refreshed Pivot Table still have old items
POSSIBLE CORRUPTION WHEN LINKING DIALOG BOX
Looping procedure calls userform; how to exit loop (via userform button)?
Add spaces to cell
Activating sheets with same name in multiple workbooks
Saving a workbook with a variable name
How can I make macros execute on a protected sheet?
Delete Rows with Value greater than X
Help deleting a row
initialize form field from previous entry
Simple question on For...Next loop
How do I refer to other macros inside a macro code?
Check if Active Workbook is Empty
Open a workbook in the background (like filestream)
HELP - Tabbing Between Items
If you feel that this bug is relevant you can pay me rewards....
Disable/Prevent Letters or Numbers in textbox
OnStartupComplete and activeworkbook
VBA Project Window does not show file folders
Open new workbook
VBA & SQL: INSERT TO... problem with date
Error Table For Excel Comparisons
close WB after clicking DISABLE MACROS
richtextbox
Functions won't calculate without F2
WEB Query + IMAGES
Re: Autosave:: off
How to pass interior colours of specified range to a control.
Autosave:: off
How to center text in a msgbox
Enable toolbar button in one specific worksheet
Auto height rows
resize colums / rows in range
How to put the image under the text
Restricting Access and applying a button
add different button images
AutoUpdate cells with statistics
E-mail look up
program excel worksheet to automatically not print blank rows
sub script out of range problem
Date Problems
Range holding non-contiguous cells
count / move files
Double lookup
button to print a sheet
Help using macro
Web to Excel, the format run out
Word Or Notepad From Excel
Application.DisplayFormulaBar Kills CutCopyMode
runtime error '6' overflow
Delete rows in multiple sheets without loop?
Dynamically adjusting Vlookup
macro button
Reading a CELL value from another Excel
From excel - open word doc and copy form field contents to excel c
move text from form textbox to next blank cell
Charts in VBA
take text from form textbox and put in cell...
Choose particular files from a directory
Big Chart Printing Problem
VBA column hiding
Macro to save to .csv
Newbie: MsgBox, etc
CommandButton displaced after hiding/unhiding rows
Running Macros from Command line
Apply Border
Code not working
VB print to Terminal Services Printer
Cell On change
Delete Sheets in VBA Project
How do I set Excel cell format to "Text" from VB.NET?
Find Unique Records from two sheets
Programming and the Task Pane
Send Formatted cells with VBA to Lotus Notes
deselecting...
Disabling Cell Editing
combobox limit to list
Hard breaks in text to soft breaks in Excel
how to use object variable to change the property of a
Macro names in a Module
Like Function
Inserting Form form Visual Basic...
Looking for a Good HEX editor
Editing VB Code with VB
Fill Down & Copy
Automatic email when document changes
Office 2003 Chart Web Component
creating excel spreadsheet from webpage using VB?
UserForm with Frame - Problem
transposing contact info
Drop-Down List
adding code to shrink columns to reasonable width
picking some data from a column
Adding Items to an array
COPY - *want* to include hidden columns
ACTIVESHEET.PASTE not working.
Copy and Paste Function
Cell Select
FormulaR1C1 gets strange application/object defined error
application.ontime
Re: find and paste
SendKeys
Worksheet copy issue
find and paste
Code execution has been interrupted
VB scripts to calculate as NetWorkdays
Page Break bug update query
How do I write macros with relative reference cells
sumif does not work
Problem with Conditional Formatting when Inserting a Row
Reference a User Name via macro
Fill in Formulas
Check for References to Blank Cells
.NET code hangs setting up a chart
EXCEL Macro calling on Outlook
Forms accessing SQL Server data.
If Then Statements HELP!
Problem with using variable in Find statement
Printer Dialogue
Macro warning when opening excel
Need help with coding a solution.
code to export excel table to word
Naming Worksheets
Counting CheckBoxes
Additional Recipiants in Notes Send to
macro to remove a named range always called "database" & if possib
how do I let a macro repeat itself in excel
Printing rows in 1 block
Getting value from an unopened file (indirectly referenced)
Find and print in new sheet
Comparing 2 lists
Linking a comment to a range
clicking on a point in a scatter chart
Repeating formulas in VBA
Excel section in a word document
SendMail Method
Absolute / Relative References
For Each Function??
delete duplicates
beforesave and beforeclose
ActiveWorkbook pointer for Macros from PERSONAL.XLS
hiding/disabling areas in user forms
Cell location
Language
How to make Dropdown box Jumpup
A Challenge (Linking word and Excel)
Countif using vba
detect column name of last populated data
Problems with Combobox
How to prevent dialog box
Change Colors With 5 Different Conditions
problem about sending data in Excel to an Access database
dynaically updating a defined table name address
Just a few questions...
Creating Folder Folder in My Documents VBA - HELP
VB editor not saving desktop
Run a macro when a Worksheet is clicked/activated
How to launch one XLA from another on Excel launch
ADO & SQL
Semi-transparent label background??
Why I get #Name? When I use a sub
Re-POST: How to close forms opened from other workbooks...?
Different Controls across different excel versions
PageBreak Macro with Hidden rows
Editing Macro
Can't get rid of Command Bar
rows
Paste after print to a new line
pasting and Ifelse function
Public Declerations
Dates
Sub Exits Unexpectedly
Controlsource errors
sumproduct?
How to build a forward/back range finder
Invisible Worksheet - Keeping it Hidden
MODE spreadsheet help
Excel Check Box
Auto Filter + subtotals
Entering a date in a textbox
Compare cell content from two worksheets
Code assistance
object defined error
declaring public variable value
Thank You Nigel
how do I copy from textbox or combobox into a cell
Automating multiple entries from Excel to an Oracle-based database
Change the FOR loop top
Highlite Items
Counting people
combobox
how to use histogram in vba code - analysis toolpack
Data Filtering
How to Delete Another WorkBook Macros
Data validation across worksheets
Referencing a file name within a called subroutine
Hiding macro menu
How do you convert Bday into Date in VBA
Custom toolbar with existing formatting buttons
Dynamic Chart Range
New Web Query Macro
copying to external workbook
Issue with Do Loop
RE: Q:Excel/ODBC/Login ....
no word wrap in userform textbox??
How to Delete Another WorkBook Macros using Macros.. Possible?
How do I make Excel copy entries from 1 workbook to a new one
Update workbooks from a master
advice.
Choosing certain files in directory and one in particular
Fill and sort multicol listbox from VBA code?
what do I do wrong?
hidding worksheet within a workbook
Comparing Cells in Workbooks
Event Procedure - Data Validation List
Formatting text in a user form text box
Macro Creation for name formating
Setting Extended Attributes
Excel BNF
who can make excel appl. useful for Euro zone
pictures and buttons
search a column for a specific piece of data using vba
Control save prompts in VB code
GetOpenFilename restrict file list to "ord*.xls" i.e., only list ord*.xls files
VBA: Pasted Cells Not Formatted
Search and Copy within Excel using VBA
column of entry for textbox value
search column for a specific piece of data using vba
Group Pivot data by week
Auto Run Excel macro subject to condition
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ??
VBA text file to .xls
Handling Dates in VLookup
showing hidden items of a pivot table in a cell
specialeffect to command button
VBA: Answer YES to Contents of Clipboard
calling procedures from worksheet buttons
Make a Workbook into VB Program
Excel vs Access what art the question?
Identifying and separating groups of data.
How do I pass info from excel to a hyperlinked explorer page
ScrollArea
Business day difference between 2 dates
Concatenating
Code to bring my company up to date!
Additional send to address for notes
Thanks Norman Jones... You are a Genius
worbook.name not accepting range value
Insert autoforms and objects dynamically
working Excel worksheet on the astive DESKTOP
Email with notes error
Listbox
Excel Database
PrintArea
set "value if true" to "fill cell with color"
msgbox to lookup part text any help pls
Subtotals and inserting formulae
can I clean old excel data format with macro on funny spread sheet
Macros written in Excel 97 will not work in Excel 2003
ActivX in Excel
Runtime Error 1004 on selecting range
assign objects into array or object variable?
Queries / Excel
Random Number Generator
increment number by code
how to replace a hard return?
Send Worksheet in Email
TAB properties in a UserForm - Requesting Help from Excel VBA Guru
Compare/Copy columns from two books?
Print a Spreadsheet w/Task Scheduler
How to prevent unautherize change?
Options other than VBA
How can I do an Absolute Cell Reference but non Absolute Cell Pais
How can I do an Absolute Cell Reference but non Absolute Cell Pais
Error opening Excel app via automation
How do I count number of occurrences (dates) in a rolling year?
Round a decimal to the nearest sixteenth
ActiveWorkbook.Save DOESNT WORK !!
Recognizing Date Ranges in excel
Need a macro to do this...
Hiding A Row
Print Preview and Modeless Form
Userform help needed
Time comparison
Selecting columns through a loop
visual basic & chart data labels
disabling a message box
Newlines in a line-wrapping Textbox
Scrutinizing Controls on Form for Certain Value
VB code to update existing Pivot Table
Showing bookings in a calendar
Apply Border based on last Day of Month
Text file import using ADO - XL converts fields to dates
copy formula in a range
Can I change this to work for a closed workbook
Excel Save Issue
Excel seems to become lethargic
consolidating my BOM
Insert a chart on another sheet
Insert 19 cells "Shift to the right" if cell contains "->"
Conditional Closing and Saving
Send from excel to webpage...is it poss?
RE: Excel Doctor
Why Type Mismatch error
Populate a Combobox from range.
Conditional Commenting
last cell
OLE comboboxes
copy from 1 sheet into another?
Cut/Copy Combobox - I can't update
Use Excel as Access
Conditional Date Formatting
setting minumumScale of an axis programatically
Design
Why can't I delete this shape now?
Error Code 6: Overflow
Deactivate sheet
Setting the Print Area in a macro.
disable the close "X" icon
modular arithmetic
Open multiple HTML files in succession
add/subtracting date:time in Excel 2000
How to automatic calculation and macro execution between 3 workbooks?
Problem running row color macro
about macro
LastValue Function
Userform-Change textbox color and font based on input in other tex
UserForm Tab Order
Searching within comments added to cells
Can anyone see the problem with this code?
Open multiple "unknown" filenames within a macro (array setup)
Macro to border row from start column to end column
Macro Security and other painfull issues
TextBox1_Exit niet uitvoeren!
Too large-how do I split
how to get a macro to record F2, Home, Delete keystrokes
i cant format textbox as number!
Advancing to the next cell
Newspaper Columns
add an extra row
VBA SumProduct Problems Contiued
How Invisible Can You Make Your Code???
Excel combo box - value list?
Make a cell required
Variable Percentages
Application-Defined or Object-Defined Error on simple code
How can I delete rows accordinng to formula
Assign formula array in vba
how do i delete just 1 hyperlink in a column of many?
Excel Query linking to External (outside domain) SQL server
customized function
How do I link cells based on true/false?
Problem with error trapping
Compile Error: Procedure too Large Question
VBA macro in Excel to control Project
Help!! code to paste
Renaming of Worksheets from Input Data
Macro and Protected Sheet Problem
VBA to select a defined range
vba code doesn't work
Conditional Print Macro
Enter key movement direction
Capabilities of linking excel cells with outlook calendar
Variance in an array
Save As File Control
RE: Macro to Insert Comment to a cell
How to find my favorites?
Selection highlight color
Document variable in Excel
Marching ants
moving between Excel sessions
how to determine column heading from lookup
excel 2000 macros
I can only manually update?
offic XP (Excel)
Autocopy from one cell to another cell in a spreadsheet
Pivot Table list box
Toggling the NUMLOCK when using SendKeys
open, copy, and paste
Paste and Save As using Cell as name
open cell formationg dialogue from macro
Re: print preview
Workbook Before Close Event Cancel flag not functional(?)
SAVE AS code
print preview
delete all the spreadsheet
question on vlookup
Open file without macros
Automatic cell formatting
breaking a link
The opposite of .Verb in OLE Object
only display positive values
CDate Problem
messages from excel --> to avoid
Basic Code Problem
Excel User Conference - Book Winner Announcement
updating spreadsheet.
OLE combobox
Filling out word documents and printing them