Excel Programming [Archive] - Page 72

VBA programing
Initializing UserForm
Web Excel Workbooks versus Excel Workbooks
How Do I Use List Box for VBA Script that Converts Excel Files to Any FIle Type?
Newbie -& I am not getting this
text box validation
vba output: formulas or values
Macro to keep 15 specific records and delete 1000 other rows.
Folder shortcut
Locating the third item in a Range
Cell protection problem
Appending cboBox values into cells
How do I work on data starting to a cell a cell with a required va
RE: Converting numbers stored as text into number-format
fill color to a cell when the value is negative or positi
Novell server full path names of VBA references
How are actual file location of VBA References treated?
Print Preview Macro
Modal/Modeless Forms
Paste cells from one workbook to another
LOOKUP BETWEEN 2 DATES
template questions
ask about excel formula.
bold or fonts in a textbox control
FileDialog grey's out the View box
Regressive Logarithmic Retail Markup
RE: Converting text to numbers
custom formats for plus or minus
Reason for increased size of workbook
Re: Sorting rows (left to right) programmatically
eliminating text between two specific characters
Alow certain Date Range
a better way
IF statement to evaluate time data
autofilter help
Counting Loops
Application.Run for every open workbooks (one by one)
complicated copy/paste/delete
Excel and MS Query
Calling a macro
setting a condition to call a macro
GO FOR A REAL BACK-UP OF EXCEL FILES
Hiding changing columns
Code to concat "Jo Smith" and "Ja Smith" if there are multiple "J Smiths"
txtBox/VLOOKUP
getting the sum of the last 20 cells
Adding positive and negative
How To Update Formulas Without Refreshing Links Each Time
How do I plot a 45 degree line in EXCEL VBA?
Re: Password reused
Vlookup Mutiple Values
Re: Don't unhide my worksheets
Updating cell values on sheet based on selected combo box value
A Serious Round-Off Problem !!
Re: Don't unhide my worksheets
Re: Don't unhide my worksheets
Query retrieving data from the web - excel 2003
Merge 2 workbooks into 1
Trouble with emailling in XP
Need help with email code (PLEASE)
Finding the last used row in a specific column...
If Then Loop....
comment change trigger
Application.Run (WorkBook.Name & "!MacroName")
Avoiding the triangle (formula error checker)
Combo Box Drop Down with a Protected Sheet
not necessarily a code question, but
string comparasion
Protect Worksheet While Allowing Autofilter
Need help programming charts
ftp ---> VBA
Expunge cell from memory when late binding involved
Deleting exact duplicates in a database
If then statement
Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab?
adding worksheet name to a named range with VBA?
Redim Preserve form a userform?
DataObject
get the value of a formula in cell B1 into cell A1 without changing my current cell selection
getting an average of No of Days on board verses month departed.
copy specific cells in workbook to new workbook
Approach for lookups
Transpose problem
Add Sheet Name to Cell in Worksheet
Application-defined or object -defined error continually haunting me
Check for open workbook
F1 help for ChartObjects
Open all excel files in the "volatile" folder
Copy Cell Formatting
Change the "Labels in Formulas" function to an add-in.
Excel VB - WHERE syntax error in Access web query.
Code Cleaner (Rob Bovey): Compile? Means what?
Wild Character in String
warning signal
Make visual basic truely visual!
Workbook_Open Event not firing
capture only part of inputBox or of cell contents
Pivot tables
RE: Sorting an Address list - 1 attachment
Drop Down menu in a Cell
Toggle Button Caption
Event code to continuously monitor change
Dynamic Charting
VLOOKUP error 1004
Modified "For Each wbk In Application.Workbooks"
ReDim ArrayXY
Combo Box Print issue
Do Until syntax problem
RE: Returning values based on a cell
When is it necessary to "calculate cells" - Relocated post
AppSentinel
Assistance with VBA code on MAC
Re: VBA corpus?
Re: False 'Document is already open' error
File open and close, get some data
Update worksheet formula
Excel VBA putting text from textbox into SQL statement
Copy/paste macro blocking
Sheet Criteria
Instead of opening Solver Excel starts up a sub from the VBA project
stake space
coding an anagram function
Problem: keyboard shortcuts get changed unintentionally
Web Publish Pivot Table: Enable NoDragToHide using OWC
[QueryTables] showing results on a per row basis
copy from multicolumn .txt document
Re: union of RangeName
Re: Sorting rows (left to right) programmatically
Re: Sorting rows (left to right) programmatically
comparing 2 columns of numbers
Error when saving Excel output file
Howcome the workbook opened by VBA library reference changes?
Excel Programmer in Brisbane, Australia
Select noncontiguous multiple columns by column number?
RE: Don't unhide my worksheets
Re: How to stop a scrollbar from blinking?
Re: Don't unhide my worksheets
Re: Refresh / Update URL
i'd like some help using an array
Parsing a Text file into worksheet with VBA
"advanced data entry forms and proprietory formats"
Combobox userform help please
Linking multiple scripts by user OK
.Formula Property returning or setting inconsistent results?
Use Advanced Filter to Detect non blank rows
identify first row after subtotals
Seeting up repetitive code
Cannot Find Object "Lock Picture Aspect Ratio"
Finds date but won't change cell
path and file name
Macro not showing up/missing under TOOLS>MACRO or VBE
Use SUM and FREQUENCY functions to count unique items
Use SUM and FREQUENCY functions to count unique items
Sequential numbering
VB subroutine
ADODB
Duplicate rows a given number of times in Excel?
Cut and Paste Macro.
how to format numeric click up/down for a cell on tablet pc?
How do I get gold stars?
New to Microsoft Treeview Control
Macro creates two graphs instead of one?
Hide or protect hidden rows/columns - macro help
Indirect & Round Functions
Save copy of workbook
Disable Drag & Drop
Multiple Charts
codenames
Worksheet name changes on external reference
autocorrect question
prefixing a cell?
Checkboxes
Date and time entry on button click
Hiding Rows and Columns
Help with creating a search engine in excel vba
Allow spreadsheet scrolling behind userform
insert fields
Removing Objects
can textboxes let users format text or cut and paste
select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc...
If target.count > 1
force Excel to open in Internet Explorer
Need help with Range object in Macro programming
Is "" the same as NULL?
open word macro from excel
Convert column letter to number?
Macro Save with Worksheet as file Name
Error from repeated chart copying
Automate Menu item with VBA?
Using AdvancedFilter on range of data
Print Message Box
Creating CSV Comma Delimited File
Need to delete last value in column but not delete entire row
Turning numbers into days, hours and minutes
Loading Macros at Runtime
Return column letter, rather than number?
Click event not working
run-time error 1004 - VBA Gurus Please Help
Automatic Macros
Code seems to stop, but no error messages show up
Adjust Row height to FONT
Referenz to running excel application
multithreading / distributing excel code
Default Header/Footer values
Macro Excel
Macro Question - Excel to Access and back again
Help needed with Vlookup & copy row to new sheet
Check a column for correct type of data
Assistance with error message on CELLS
ComboBoxes
VBA Save
Object Variable Not Set
Data is added in 1 column instaed of 4 columns (in listbox)
non-contiguous range
SET A CONDITION
help designing a speedometer/fuel guage type chart
a question about diagrams.
International Issues
Find and Replace
Calculate the number of hours between two dates and times
UserFrom Back Color
Selection.sort Run-time error '1004'
Setting VBA reference programmatically
frozen panes question
Change Addin File Access to Readonly?
Sorting a List Box
Pivot Table Range Address, Row & Column numbers
Late Binding for Excel CommandBar and CommandBarControl
Pixel position of cell
Remove Module not working
Identifying Excel Version
cut rows from worksheet based on cell isdate value
Copy rows to multiple sheets based off column value
Issues finding date in range of data
Cell result must be a minimum of $1; way to round up to that for amounts between $0-$0.99?
Excel emailing from spreadsheet
Access popup window from IE object.
help with adding list box to userform
Export Import Modules File Name error
Using an index with a class module?
text to excel-2nd request
Help Please: Run Excel based sub from Access using GetObject
How to connect to a Unix box from Windows and execute a script?
text to excel -Help
Repost of Listbox Headers
Chart Source Data
find replace
Advanced VBA Question: Copy data to another sheet to make Validation List
Using a Defined Name Value in a Pivot Table
Inserting static times into cells using command buttons
HELP: Web Query does not seem to get the data
time card program
Can someone recommend an Excel VBA Book?
OK Button in UserForm
Don't Give Up!
Userform initializing problem when opening
Trying to ceate an event tracker: linked to dates on a calendar?
What does double quotes signify?
status update during program run -- DoEvents doesn't always work
Setting a Worksheets Codename to a variable programmatically
Code to delete rows where cell value is zero
Insert columns copied to clipboard results in vaues not forumlas
Select All Shapes
display the name in a list with the maximun salary
Displaying Number Only Once in a New List
Deactivate workbook commandbar for one sheet?
Functions
Combo Box: Vlookup Multiple Cells by referencing to Text Box
How do I write a VBA for 3 consecutive dates?
more find help please
Manipulating a Pivot table....HELP!!...
Assign name to chart object?
adding row from userfrom and copying formulas
Adding Headers to a listbox
Loss of data in very large calculations (vba in excell)
Create popup alert based on date match
Excel formatting saved in a database?
More information on Method 'Open' of object 'Workbooks' failed
any clue why this won't work?
Installation and Solution Update Question
I need to get the integer value from the address R[4]C, any ideas ?
How to get row number from R[4]C
auto copy from one sheet to another
Index Match Lookup
Help with filter Range & delete rows
Finding Row Numbers Within the RangeName
Save new file in same directory
userforms
Creating default values in Excel
name checking or cross-referencing spreadsheet
VBA to read "form"
Form Object Difficulties.
IF Activecell
List Shortcut Assignments
Using VBA to insert a multiple-row title in the CenterHeader
data sorting according to the date
Can I add a Calendar/ date picker graphic to an excel doc?
How to stop search / replace prosess in large excel worksheets
Date Format
The Infamous Aaron Kempf.....
FIND DATE xlLastRow and searchdirection
Adding 1
AutoFit Visible Rows
creatin new sheet macro
R/T 438
NamedRange Column Names
Clearing all values in range that aren't formulas
Dates
Help with Loops is my guess
Referring to non constant columns
Colour of multipage textlabel
Using VBA to set Excel Data Validation
Protection - Hyperlinks
Arabic / Hindi Numerals
Sheet Selection without using the sheet name
When to use With - End With?
Help with VBA
Calculating percentages
How do i export selected columns from excel to an Oracle database
Insert macro
Inserting Rows, but keeping row size
Opening html versions of workbooks
REPEATED VALUES!
Screenupdating
Checking some values in Workbook
How to activate a worksheet when a macro is running in the sheet m
Memory Leak
Place rectangle and define its height?
conditional row hide
change event for drop down
how do i set up auto invoice numbering in excel2000?
Doing a "print preview" slows down an Excel 2003 COM addin.
Make a number flash on and off
Copy VB code from one worksheet to another using VBE
Input box function in 2007
listbox assistance
Small grid control on User Form?
Getting printers list to put in userform
variable given by user
Option button and Highlighting an area
Finding Source of Chart Data
Userform doesn't react on enter
e-mail address via outlook address book
working with hours in xs of 24
User form caption automatically populate with excel file name
find syntax help please
Last saved By in the footer of a print
Run Time Error 1004: Application or Object Defined Error
Run Time 1004 Error: Application or Object Difine Error
If Worbook Name = "X" then Prevent Macro From Running
VLookup
What does # mean in front of IF statements
Retaining Changing Font Color in Cell
auto e-mail to numerous people
Help with finding a row number
Compare Two Lists
Excel Macro binding
Merge two text lines into one? Macro help needed
Dynamically adding data after the last column
excel formula
Calling an XLL from VB?
Need help in a hurry
Sort Scenarios in List manually or programatically
Help with creating an Excel equation similar to a database
Extracting comments from all worksheets in workbook
VB Macro - Cppy rows of one sheet into mutiple sheets based on column value
variable scope question in user-defined function
Using VB6 and OLE to add a new column to an existing Excel worksheet
Calling JJ re generate form at runtime
links
US date needs reformatting but not recognised by my UK computer
Global Password Change
excel 2000 fails to open excel 2003 file
Public array
Can't find file
Help with Problem code needed
defign a function in one workbook and use it in another workbook
using a user form to add data
inserting line break within a row
referencing another worksheet in a formula
pop up message
Label with randomly selected text from cells
Automatically Move to a cell
copy data from several workbooks to a master workbook
Excel locks up - reloads in SAFE mode
Offset issue
Calculating cells
previous day
Existing Code to loop thru all w.sheets in wb
Start a macro when a clock goes down to zero
rounding to .5
Searchable database
Combo Headache
format many rows depending on record type
generate a form at runtime?
Combo Box Loading
Switching Between 2 workbooks using VBA
EVERY SHEET ADDED = 1.5 MEGAS... I´VE GOT A PROBLEM!!!!!!
New row
thisworkbook.saveAs triggers change event?
Form label not showing
Preventing Recalculate on open
detect validation list
Logging what procedures are executed
Help with code problem
Determining All Instances of Excel
Accessing value of drop-down
Converting excel speardsheets/macro into a database system
Picture on Form
Using Postscript in a WebQuery Accessing a Russian Website
Retrieval from a Web site
how to paste a fomulae cell in a protected sheet
how to get commandbutton name
data validation list does not trigger worksheet_change event
Unload User Form
Need help with modify this macro to copy.
loop through cells in a range and pick up corresponding cell values in another range
Assign a 2D array of constant values to a range
VBA to set value of a cell
Place 6-cell row in another folder when cell #3 is verified
Enable/Disable CommandBar Buttons Based on Events
named range in conditional formatting
Detecting Cancel in an InputBox Method
Changing string input in a query within a macro
Enumerating PivotItems collection fails to display duplicate values
Is there an AfterUpdate event for excel combobox?
format last row on sheet with VBA macro
Range Replace
Variables in Declaring an Array
macro to create CSV from Wave File
Use of Intersect: Place Value in one cell AND remove from another
Remove unwanted values
Need help. Simple check box then print the next cell.
Download File From URL
Cancel Hyperlink Click
Problem making a spreadsheet writable
Sorting Ranges of Data
Program Buttons in EXCEL
Sorting Issue
Open Multiple Queries in New Tabs
Send to mail recipient( as attachment)
inserting line break with find and replace.
copying field names from Access query
Attach password to Button?
Hyperlinkingto an Intranet
Create chart shaped like a clock
Search for active file name (modified), then....
Help:option buttons custom views and Private Sub btnPrint_Click
copy all rows before empty row
VBA error with Open for Output / Append: File not Found
Load Data into userform
range selection help needed
Locate number within range, copy number below it to another cell
Using Counta with a range
Display MsgBox wait for 10 seconds then click on yes automatically
Ctrl+Shift+Down in a macro - doesn't re-run
copying worksheets to a new workbook without formulae referencing original workbook
why won't this vba work, when this one does...
Search and Move - Cannot Figure This Out - Please Help
How to send specific cell ranges to multiple e-mail addresses
How to send different ranges to multiple e-mail recipients
Drop-down box automation - cell duplication.
RTD server in C#
Changing the Format of a Graph Legend...
Copying DataList Rows
Newb Q: XLL and XLA?
Random Clears
macro to hide columns and/or worksheets
Range Question
simple for each
simple for each problem
Help
E-Mail attachments
CommandButton and a variable
Macro for Breaking out Rows
.Paste not working everytime
Code, is user form open
Form is open ?
Aggregating data from various file in one.
Displaying data in user form from active worksheet
Run a UserForm in the middle of a Macro
Loop not returning to original workbook
Conditional replacements with VBA
User Form issues
Clipboard Message
Workbook Protection
Disable mouse scroll wheel
can anybody speed up this macro
Delete ROW if COLUMN = data
Delete ROW if COLUMN = data
Accessing selection list within a user form
Command boxes not appearing
Copy data from .txt to .xls
Range Selection
Macro for Frequency Data
Msgbox with randomly picked text
Excel macro using email - Security warning from Outlook
comprae cells
Example form Book
macros in excel application object
excel application object
Date file created
Parsing Excel documents with C#
combobox increment
Excell and changing cell colour
Pictures/Graphics in/out Excel-cells
test if a character in a string is alpha
Pivot table header that changes everytime
Start macro automatic
Array formulas - too slow
Deselecting active cells after pasting
Dynamic menus
How to start recording a Macro & Retrieve the contents via Atomati
Recording Macro & trapping its contents via Automation
Sockets programming in Excel
Collection VS Scripting.Dictionary
autofilter, command to select filtered range?
TIMING EXECUTION DURATION!
Deployment problem with Excel WorkbookProject written in C#
check box
research data between 2 sheets
A query in continuation to the nested bordering - To TOM, JIM and others....
Show method of dialog class failed
import data from web site
On Error Command
Select by format
Save Extension
'Open File' Functionality
'1004' - Application defined or Object defined
Button on custom toolbar appears only after mouse hovered over it
Finding last cell and insert line
autofilter with variable criteria
Cycle through Pivot Tables with Pivot Items
Why doesn't OnKey work?
Missing Assign Macro Command
excel vba to save a page
Help with data Comparison
Format Time
Hyperlinks
Print Frame1
This Hyperlink formula doesnt work
Vlookup on second WorkBook
Setting Forms controls from outside
VBA Range error - How does this work and what am I doing wrong?
Identifying toolbars.
how can i get duplicate data on excel sread sheet
Change color of title bar on user form
Determine the number of outline levels using vba
Determine the number of outline levels using vba
Decimal Places in TextBox
Find in multiple sheet...
Show Form and Hide Worksheet on Load
macro to edit cell contents
Group Shapes
Merge & Match 2 Excel Data Tables
Automation and lack of resources (error)
refresh web quiries when workbook is opened
Formula for historic pay rate
Time align New Product Launches
Macro Help for Simple function Please
problem with fetching data from excel
Calculation total not to exceed a specified number.
Copy cells in active row
Looking for a Utility with Multi Line REM conversion
Time Comparison
Userform + listbox question
Selecting frame in Internet Explorer from Excel
application.inputbox
X-axis labels in charts
X-axis labels in charts
Transparency Discrepency
Sorting issue
Intersect Code too slow HELP
URGENT! Expunge Excel from Memory
Modify macro code to export multiple cell contents to multiple Text Files
Need help taking values from List box to spreadsheet
Delete A Macro
VBA Column Conversion
Getting compile error: out of memory in VBA How do I fix this?
Code to calulate percent of total in column
Find next blank cell via macro
Force Input when opening file
Combo Box Drop down & Sheet Protection
TOP - Justify and Autofilter the Data in Excel
Array slowing down event procedure
how to program the equal filling out of an individual selction of fields?
split text into rows and have the first clumn information repeated
Need to search a string for numbers
Help with 1004 Error
Can I make "Option Compare Text" the default
UserForm Question Need Help!
Importing .PRN files into Excel spreadsheet
Importing .PRN files into Excel spreadsheet
VSTO 2005 - How to use ThisWorkbook as an Excel.Workbook
Date Entry Issue
vlookup cannot see value for some cells
Run Time Error '1004'
Is VBA Class have Constructor like java ?
clear results when any input box changes
Comparing ****fs macro.
ActiveSheet header including a named range
external data
Calculating Growth Rate
Array's, Calculations and Results
Finding Number Within Range Then Copying Data Below Number to Cells
.Net Automation Add-In - Execution Always Ends in Edit Mode
.Net Automation Add-In - Execution Always Ends in Edit Mode
Textbox in Userform - data destination
passing parameters to function assigned to button property onAction??
Disable a new paste button
AutoFill down a varying Range
filter listbox on Userform
Best practise XLA add-in
Formulas
Copy and Paste Updating HELP needed
help
Checking for non-blank cells in named range
Checking for non-blank cells in named range
Checking for non blank cells in named range
Query data within a PivotCache programmatically
macro to move contents and delete existing row
Checking for nonblank cells in ranges
Checking range of cells for entry then checking for total
macro to move contents and delete existing row
macro to move and delete contents
Variable in a textbox reference?
Part 3, Formula help
DATA SORTING MACRO
suppressing "do you want to save changes..."
Error with Goto command
Add Day to Date
delete cells with a value of 2
How do i covert a number to its text value i.e 1 to one
create xl workbook
Paste Range to New Workbook
MS Query Error Message
MS Query Error Message
ADODB.Connection
For Each...Next not working
if statement
Excel to Word
Cell update formula
How to start template with connected workbook
How to open connected workbook with template
csv file not recognised with ms-office 2003
For all guru's. Can this be done?
VBA - Save with new filename
VBA - Save with New Filename
Formula help
Forumla question
RANK
How active office 2006
Re-Post - hard formula (Bob Phillips out there anywhere?...)
macro to copy numbers based on criterias
Macro Shortcut Key Conflicts with Application Shortcut Keys
Macro Shortcut Key Conflicts with Application Shortcut Keys
X-Axis labels
Find in a dynamic column...
SendKeys to emulate ALT+TAB, TAB, TAB
Find a string in a range and return two values based on offsets
Format results of Macro
hyperlink URL forced to localhost
VLOOKUP - Multiple Worksheets
VLOOKUP - Multiple Worksheets
Database record add
Descreption Seperation
How to change the default Command Button
How do i unfreeze excel formulas to work
Can somebody help me with a slow macro problem.
Count number of files in a folder
Message Box Prompt
Need more than Sendkeys. What is the tool for the job?
Creating a hyperlink to a webpage
Combo Box Code
Copy and Paste Values not picking up on cells with formulas
Text file db where record already exists conundrum
Print sub returns
Password Protect Worksheet
Toolbar Images
PivotTables and Changing the FileName
How to set range for charts?
Return to excel from vbe
How do I run code when exiting a cell
Offset and Merged cells
Paste Special Formula
X-Axis labels
Displaying something within a range name in an Excel Header
Macro with eayfilter
Automation Error
macro to move cell contents and then delete the row
macro to move cell contents and then delete the row
toggling between 2 workbooks
Convert Columns of Sensitive Information, and then convert back...
Calculating Date Ranges and Weight Totals
Paste Graphics in a specific Loacation
GetUserName help
Protected VB code - Run-time error
Error when creating menu item on command bar
BMPS stored in a Resource Editor File
Help with auto Fill
Copy Data on Row Change
Retrieve Data from a Serial Port
Hide Pivot Table Column if Total Sum is Zero
how do you turn off overwrite?
Workbook Reference Problem
HTML for Excel Question
Using Range name in Header
Using named range value during Workbook_BeforePrint event
Complicated formula.......
User Form texbox insert text in cell - excel 2003
Question about User Defined Functions
Help with auto Fill
formate date by month & day & ignore year
Need to run auto_open before user disables macros at startup
DAO issue : Data source name not found
Copy and paste code
Deleting Sheet with No Data
How do I make a commandbutton in Excel 'launch' a custom form?
Recorded Macro
MACROS: Protect a cell depending on the value of another cell
Is workbook beforeclose event the best place to do this?
Arrays
Reading TSv files in Excel
VBA to VBA Script Function
Accessing pasted pictures
Loop and delete
Urgent - how to run textbox exit sub?
Set sourceRange
Inserting a line in a database - alternative colours
coding greenbar
PublishObjects(x).Publish fails
Adding a macro to all new workbooks
Making a Tricky formula even trickier!
Updating a validation list macro
creating an event of pressing 'enter' using VB
Excel Chart
Identifying Userform Control Type
Auto refresh for VB script to take effect.
Multiple line
Count & Select Window
Scripting.Dictionary
Scripting.Dictionary question
using excel wizard for file download which contain many fields
Help with this
Word and Excel should be more identical in their features
Using Code from another workbook
How do I perform a partial word search in a cell ?
object on RHS when there is a type-mismatch
Getting a type-mismatch no matter what I do.
Passing Data to a Line in a VBA Script
Hidding Columns with R1C1
Hide Column Based on Partial Text Match in Header
Asigning code to Button with Macro
Recording who last saved a workbook
Run-time error '7'
Run-time error '7'
[OT] Internal file structure
cell referencing
looping thru range extracting data based on character
Check box format
find and delete a character from multiple columns
Pull a set number of characters from a cell without cutting off a
Pull whole words from a cell up to a set number of characters.
Hide Option Button Control
Why does adding columns slow down processing speed?
lookup or some other type of similar function
Setting sheet tab order based on sheet name
Maximum number of hidden columns
get data from one file and put into another
Trouble Removing a value from a ListBox
Adding IF statement to custom function (VBA)?
Vlookup
Created SplashScreen but workbook opens before SplashScreen
combobox problam
Removing a value question
vba to detect if column contains partially hidden text
row number and column number of cell
Removal of VBA from Excel not working
Type mismatch error on Find
Simple Problem?
VBA Code problem
Merging Cells from C# and Interop
Check for file in folder
How do i fix this macro?
Evenly dividng records
SpecialCells help
Go to row # that is in a cell
Know the real name and surname of user logged
Know the real name and surname of user logged...
Writing and erasing code with code
Test if WorkSheet ComboBox list is open
Pulldown selection lists and Worksheet_Change
Copying Based on if the contents of a cell have a certain format
Getting range of cells with specific text colour, then using in a COUNTIF formulae
Listing Userform Names
BeforePrint Event - "PrintOut" does not give Print Dialog
Comparing to lists and extracting the difference
Save As file name + Today's Date using a macro
column/sheet protection
Can't make loop macro work - help?
Disable alt+tab
Array/Matrix
OLE Object
irrational userform/combobox behavior
WScript.Shell
Macro needed to provide week commencing and part week commencing d
Can't add a command button from Control Toolbox to a Sheet.
Saving Text Files in Excel
How do I create a new Menu in Excel
error Messege "Cannot shift object off sheet"
Another excel/email query
Comparing character strings in separate cells
Compare Rows - any unique into new sheet / delete duplicates
Class programming - how to return chartobject from a class?
Acess Queries, Parameters and VBA Problem
Macro to place dated rows in email and send???
Menu bar location
progress bar for XML
Modify Function to Return Value
Bullet points within message box
Restore Excel Application Window after proccesing ...
Lock sheet to certain pc
(another) Custom function to search text string for values occuring within it
Load Template
How to close ALL instances of Excel
Clear Contents of a Selected Range
Copy to different worksheets on next row
Copy to different worksheets on next row
Delete Row If OracleID = Value
How to protect a button click from being modified by others?
How to protect a button click from being modified by others?
How to protect a button click from being modified by others?
How to protect a button click from being modified by others?
XML Spreadsheet Warning in Table - Cell Of Grid
Subscript out of range
provisions
xl2003 why does 'rel. reference' icon not appear on macro start
problem with excel invalid procedure call
problems with Worksheet_Change function when drop-down lists
Problem reading value from Excel spreadsheet
Extracting data from Access
Question Only
copy value from another worksheet using formula
Importing Text files w/o losing special characters
Outline Object
VBA Application.xlCalculationManual
comand line
Need Comand line or VB
combobox and userform help!
Need Comand line or VB Script
Consolidation Array Help
Consolidation Array
Auto Open Password
how to save /make excel file as read only?
Car Mileage Tracker
re-occuring text 99
Array Help
Form Question
simple question "disable command buttons"
simple question "disable command buttons"
simple question "disable command buttons"
Absolute vs. relative hyperlinks
Security and working with VBComponents
Deleting blue paste area
Pass cell contents to MSTSC.EXE (Remote Desktop)
Relational Mapping Pattern for Excel/Relational DB
Name an active cell
My .xla custom menu items doesn't show up when using 3rd party software
Converting an array formula to VBA
Disable spell check in outgoing email
Code to switch between workbooks
Named formula VBA insert error
trial period
TextBox in UserForm issue
For Loop only executes with F8
Autofilter question
Sheets.Unprotect not working
separeting a string
Enter data
Copy Paste Macro Using Drop Down Boxes
Copy Paste Macro Using Drop Down Boxes
Required cell content
Database operation
Sum a Spreadsheet Column from Access
LINK ONE CELL TO AN ENTIRE LIST
Asstance need
Using axSpreadsheet
ColorIndex returns incorrect color
Setting hyperlinks
External data import with a formula, fiormula is not evaluated
Sort/Merge rows
If I remember correctrly .... (Binding to Cells together)
Excel Worksheet sent via e-mail to Outlook
Can you help me please! VBA is so amzingly difficult! I love it!
Help VBA Programmers!
Macros are disabled (How to)
Help inserting row after text
Assign Sub Name to a Variable
Match TextBox Back Color to Cell Fill Color
Auto_Open & Application.Quit - Now I can't get back into my macro
Pick lists
Merge Excel field to HTML document
Problem with sub..._Change
Free flowchart generator for VBA?
Getting endless loop on DoUntil
Excel Sheets (running from Access)
Macro to insert headers..need coding help
Userform listing
Listing all userform controls
test - ignore
Customising the default behaviour on "Insert" chart
Copy Paste Macro - Pls Help!
Duplicate File Macro in Excel
Programing a vlookup
Scope, Public Vars, Referenced workbooks
Data Compilation Macro
Data Compilation Macro
save file speeds very different on differnet Excel versions, areSave features tweakable?
IF INDEX MATCH formula inside VBA with variables
copy values in more cells
Single tab for my addin
Listing Application Userform Contents
Pivot Table Macro (Show Hide)
Adding negative currency automatically
comparing columns
Textbox equals certain field of last record
Getting Data From Access
Colourcoding range between two values
Newbie: How to get another range?
Control Names
tricky formula
Refer to a control name from another sheet
Help to insert image from a file in Excel with the help of C#
financial data management , need help in developing a template
Problem with Application.Help
Determine number format of excel cell
Activesheet.Calculate failing to calculate
Timestamp in log
Data Validation: Blank Cell Not Detected
VBA for idenitfying text and copying it to a new line
Open workbook using VBA but don't run macros
Pass Defined Name to a Command Button
Determine if any Cell in Range Equals a String
Excel auto updating worksheet
Help!!! MoveFile Method
Confusion with Names
pattern matchimg in VBA Excel using LIKE operator
Pivot Tables
Problem with nested merge with bodering - Please help
Add-In Keyboard Shortcut
Visual Basic Timer
HOW 2>> Auto Close and Save CSV file
Get current cell value and place formula based on it in another column
Input Box - Hit cancel
Looking for Software - Tick Mark add-in for Excel
Data validation
Need direction on validation
Need Opinion on Toolbar Creation
filename 99
parse filename 99
parse filename 99
VBA question
IF/THEN Statement - Simple Question....
IF/THEN Statement - Simple Question...
possible to subtract 2 dates from a closed workbook?
copying a row marked with a checkbox Please HELP
Dynamic Creation of Invoice number
Refresh Autofilter
refering to a named range on a different worksheet
HELP PLEASE - Delay Signing Error
Sort a group of cells
Trying again : run-time 18 without apparent cause
conditionally copying cells
Trying again : run-time 18 without apparent cause
Conditional Formating - Currency
Capturing Email Address
Prevent user from inserting sheet via "CTRL-F11"
Specific macro help - runtime error
Macro disabling ??
Specific macro help
Custom function to search a string of text for certain values occuring within it
mid function causes a compile error
mid function causes a compile error
Subject - Loop/Conditional formatting 3 cells above. - more than 3
Loop/Conditional formatting 3 cells above - More than 3 conditions
Coping info inside cells
Reading & manipulating the Excel data programatically in C# progra
i need a monthly business planner calender, anyone got one?
group summary totals
Printing to word from excel
How to simplify macro
ReDim Array
ReDim Array
window2003 server and interDev 6
Request: screen shots of Vista Excel custom toolbars
Macro to Save As to a specific location
sort data / items in drop down list
Sort data / items of drop down list
Cell contents in header/footer
what's diferent in vba between 2002 & 2003