Excel Programming [Archive] - Page 153

Using Access forms as menu system in Excel
Using "Atan" in VBA
Replace data with new data
Sensitivity Analysis
Re: Error : Invalid Data
Force Enable Macros
Cell is a Member of a range or Not
Date field conversion
Question on Input Boxes and Auto-Filter
How to disable VIEW CODE in the tab of a workbook
Root of Sum
Set Focus
UserForm Change Of Height
Table Data on Chart.
delete dupes in column
Automatically substituting missing data
Returning Cell Refrences/range Refrences
debug -
Difficult macro to calculate and format data
Auto filling a select # of rows
Using VSTools for Addin-Programming
overworking code, infinite running
Userform control
Chart dimensions and mouse xy
Autofilter with VBA for Catalog?
How to call a sub from different file
Using VBA to perform a process each row
Vlookup, table array is referenced in another cell
Read only lock on rows
On Error reset?
Clipboard question
Select the next row after xldown range
Protection
Bob Phillips
On Error Resume Next TROUBLE
Changing filtered cells
Macro to load an add-in
Matrix Functions
Dynamic filename
Group Box Border
If search criteria is not found, then goto Repeat?
Auto_open and environ variable error cannot find library
How to record macro to work on selected column/row?
Putting path and filename in a macro
freeze pane command usage (clarified)
Unable cut in workbook
Print page
How to control the zoom between two pages
VBA Calc
cmd button, send form via email
Exporting To Excel With ASP - Number Problem
Excel VBA 3D Ranges
Open With...
Cell reference
Alarm Sound Function Not Working_Any DDE Gurus??
Copy worksheets into new file
Counting Data Field within a Pivot Table
Formula to lookup info in a table - part 2
Format Cell for All Cap Text
Any way to update links tru VBA code?
Rich Textbox
Links w address function.
Problem: Residual query data? Closing external connection?
FileFormat Macro Problem
Re: Generate letter
Re: Generate letter
Transpose dynamic range
Automate a macro based on the value of a cell? (call Sub)
Get workbook version
Invalid Data error
Excel
sending data to an MS-SQL dbase
Formula to lookup info in a table
Limiting the size of a worksheet
Strange code showing up in Immediate Window
Add-in with custom Face
Re: Zip codes in mail merges
Restricting Access to VB Code (xl98)
disabling the "view code" tab - sheet protection?
question about office web components in excel,
How to get the available printers list in a macro
Making Semi-Colon Delimited Fields
publically defined command bar variable problem
link worksheets
Delete Columns
Control which option is visible in Combo boxes
I hope I ask this correctly
How to subtract some rows from a range
Mail merge error
Command/option/spin button - no control menu available
Difficult concatenate No 2
Macro to delete specific rows
Finding The Next Monday From a Date
handling data in arrays? getting a bit knotted
IF wokkbook1 is open, open workbook2 Loop
Business contact organization
Collection Function
AutoFiltering problem
2 ranges into one
How can I detect abrupt changes in my data
Very visual basic
V.B selecting ranges for naming
how to save pictures in excel as gif or jpg
Macro to get from excel into Access
how to know if a xla is 'loaded'
reset drop-down menus with macro
Hide row when cell is emtpy
Code to compress files in XP
Recalculating Excel Sheets with activated autofilter
Auto Line insert
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B
Macros on Excel Custom Toolbars.
Don't plot non-values on a chart
Label plotted on graph area
IF FUNCTION
Copy 2 items to next sheet
Chart on a user form
Excel 2000 /2002 library problems
MsgBox Justification
Worksheet function & SpecialCells(xlCellTypeVisible)?
VBA Application.FileSearch
move formulas to a different column
Office 97 VBA Help and Windows XP Home
Bit Masking
Ftp
Clicking Cancel on an Inputbox
Time format problem
out of the ordinary question
copy/paste
Help: selecting part of an array
Conditional Formatting in VBA
How do i compare values from two sheet and copy & paste if values match?
Comparing Across Worksheets
Unwanted "Total" in Data Field in Pivot Table
more row deleting
Cell Formula to run VBA code
Formatting copied dates
Percentages
Only getting first 256 characters of text box
Do I use MATCH to do this?
Re: VBA String manipulation
Re: VBA String manipulation
freeze pane command usage
Re: Separating first and last names
Microsoft Excel and OLE action
Active user form
Debug ActiveX object
x = textbox1.value (somethings wrong)
Extracting data with delimiters
How to use ADO.NET in Excel 2000 VBA dev?
Counting blanks in a string
Macro: stop recording toolbar
Re: Save As
add-ins
Hyperlink window problem
Release files from memory??
Combine two udfs into an array
Logic to Determine if a Data Pivot Field Exist?
Formula Variable
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc
Delete rows with 0
Column Headers
Exporting Data from Access
Counting Columns in Dynamic Range
Header Headache!
Excel Macro text swap
Looping through multiple controls
clearing the clipboard
Opening and closing workbook with VBA...
Protect Error Excel97
BAD : Matching and auto highlight matched cell answers with colours
aligning control buttons on a worksheet
Highlight rows
Unwanted Total in Pivot Table row field
refresh in pivottable
copy to sheet code question
on cell enter..
Generic Window Activate
Auto Filling a column
I can not get out of the desing mode
Round Function has stopped working - Urgent
Using FileOpen
If AskToUpdateLink = False
dynamic formula
Help with macro to transpose data
Adding Range to Worksheet Names Collection
How to increase of specific column Width
Please Help With Function
Automatic line insert
2 things
Return Procedure Name
Populating a dropdown list with an Array
Problem with named range as VBA macro parameter
Last Modified Date
Text Box Printing, and Footer Question
text in cell too long? run-time error
autofilter range count
new guy with a conceptual question
Print area
Cell entry forces form pop-up
Copy an autofilter range
Printing a sequence of pages
subtract dates
Finding Number Of Days in a month
Possible to know who has called a function ?
Clear data from clipboard using VBA
Calling Procedures
Dynamic Cell References
Excel Function help needed please!
SUMPRODUCT not a standard Excel formula?
Numerical Integration Code
poping up a box with choices?
Filtering of dates
Formatting Cell Based on Text in Column Beside It - Round 2
function descriptions
converting csv to a dta file
Query on small piece of code
Control box help - visual basic code
Setting Source Range For Chart
Variable
Position cursor in multiple worksheets
Quiting Excel
Help with Date Inputs
How to aggregate in Excel?
close excel
email macro
Setting default "open" worksheet in a workbook
creating a database and database query
can anybody help me
chart to gif
Excel developers edition
Deleting rows with repeated number
Navigator utilities
Simple to those in the know
Preventing a workbook from being copied
Input #n
VLookup, Max??? Newbie
Disabling circular reference
How to save an Excel range into an Access Database
Detect if conditional format is true
using protection (but allowing a combobox to still work)
how do you disable a button?
Help with a macro please
ErrNum = -2147467259
Highlight Data points on chart
Running total using macro
textbox on form
click buttons to do, re-click to un-do
Get Max & Min from a chart series
Excel database query returns only 2 columns
Copy detail into subtotal line
Hiding Cells Automatically
Minimal I need in a server for creating xls files with c++ automation
how to keep the button visible always in the screen, thanks
Path/File access error: '.\VB??.tmp'
Addressing cells without selecting
Can any body help?
Apparently Empty Cell--with formula inside
replacing value by formula
Is it possible to activate a txt document in excel code?
dir
EXCEL dollar sign BUG?
Run time error - Adding Workshet
another won't work for you fine people
thanks
msg box and or sheet events
Userform Titlebar Color
auto insert copy of worksheet
Crashes when I delete Control
Help with creating a VBA
Directory "Locked" when selecting multiple files using GetOpenFilename
Help with VBA
multiple results search
y won't this work??
hit counter question
Extract Rows By Date - Follow Up
How to change xls format to text?
if column I is blank, then puts an "a" in column A.
Re: pagesetup 1004 error
format text string for SeriesCollection.Name property
Define name in macro
Help Needed Badly!
Left justify across cells with word-wrap without merge
Check for text within cells and make bold
Macro
combo box not updating
Copy values between files.
Userform not working
hot keys
worksheet error checking
Setting ComboBox Value
Lil Simpler
How to send a self installing .xla within a .xls workbook application
Is this slow code?
Vlookup in book which will change.
Add_months function problem
New Question, old thread
MultiPage problem
Pivot Table Question
AutoFilter _FilterDatabase Rowsource Listbox
Replace in Excel 97
Conditional
Add new Worksheet after filling first 256 columns
Excel VBA saving cells/rows as csv file???
filter gives no output, no copying necessary of current.region
Accessing worksheet cells from VBA macro?
Re: how do i test for the existence of a range name
Icon/Toolbar auto view
Is there a way to make Excel file an executable?
Simple Macro
Need Help closing excel and documents
TOM you made my day...
BOHICA needs more help
Update Data Field in Pivot Table with Dynamic Excel Range
Spreadsheeting Problem - Come Help!
Attachment.Add Parameters
Deleting code in a file with code..
Condition Statement Help??
Cannot get Common Dialog Control to work
A Dropdown Box Question
Adding a button
Re: finding names and copying
Variable in a formula
Excel 97 crashes when button is clicked
Excel Enable Macro message
how to set up default link update in VB
Criteria Macro
RE: pivotitems in a multiuser environment
Re: getting from clipboard
Quitting a BeforeSave event procedure without saving.
Xl 2003, recording WAV file
macro question
Screen suspend
Programmatci Access to Vis Basic is not trusted error message
Missing: Microsoft ActiveX Data Objects Recordset 2.7 Library
Copy range Cell text and font properties to a Textbox
making the worksheet menu bar not visible
Simple code error statement
Open dropdown list with typing
Assign macros to dynamically created form elements
Compiling Multiple Sheet Contents into one Sheet
Automating the depressing of ENABLE MACROS popup
i need help making code that will open an Xml file for Excel in VB.NET and delete tables that i don't want to show up
Duplicates
Word equivalent of Excel code
difficult concatenate macro
I need a UserForm to Auto Start
Automating Goalseek When moving points on a graph
printing problem
Saving Excel macros on a network
Duplicate Items
How to modify VBA code for Add-in?
Re: Searching by date
Re: moving to relative location after finding data
Deploy Excel similar to Access Runtime
Contradictory results of DateDiff function
how am i able to store a number as text? (ADO related)
Prb: Writing Array functions in VBA
disable the popup messege "this file contain macro"
file name
Trying to paste into a worksheet
Error using Auto Fill of the class range
class module in a xla file
how to extract data in .txt format from the excel sheet in a fixed length ascii forma
Readonly
Convert an Excel Pivot table into sql
Comboboxes
IF... change colour
Buttons
Macro to exclude blank line and total column
Context sensitive menu
Utility offering - getting rid of or remapping redundant Styles
A hopefully simple question about SLOPE()...
running a macro when cemm contents change
Marco to run every day at 12
test please ignore
Getting value from a TextBox to a vbs script???
Restoring Cell comments status
How to use Opentext method with xlFixedWidth?
AppActivate problem when called twice
Function for splitting a name to two cells from 1 input
How does Excel Alarm Function work??
Solver
load an add-in in VBA
Import UTF-8 text file to Excel
Save As without overwrite prompt
formula question
How to maintain the original date and time for the MoveFile command
Controlling Reflection1 from Excel using getObject
finding a value thats present more than once in a sheet
Userform_Initialize event failing to be called
special character - line feed
Find folder macro was in
run awk95 using Shell()
View Modules in VB Editor
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!!
Is there a solution?
NetDDE problem - from a non-interactive session
Q. Using the spreadsheet to set up a times table "15 X 15" etc.
removing formulas
RE: Duplicate Items
How to put excel macros in a 'global' place.
Buttons disappear after repeatedly running macros
Close file without saving data
Append column for pasting
Set cell value based upon another cell
Arguments...
Re: Web Query
Excel VBA - Userform textbox formatting
Links
Using Find method
NonContiguous Range Iteration Bug?
Open a word document in excel
RE: Referencing Calling Cell
New macro user query
Problem with Filesearch
Custom Buttons
Counting entries in a cell
Getting cell information
Non-Contiguos Range Iteration
Excel2000 VBA If-Then/Loop Failures
Application Defined or object defined error
Re: Referencing Calling Cell
Excel Array Question
Re: Referencing Calling Cell
Re: Referencing Calling Cell
Unique Items
combo box
Hidden rows > Database Filter
sending a singular email by selection
Access to class property in other workbook
protection macro
Print custom ranges
Exporting data from Excel into Internet Explorer
Using the "or" with "if"
lookup help
Help with Check Box and VBA
counting files in a folder
Please help! Macro to change cell contents based on cell to the left
Can I automatically start a macro if the contents of a particular cell change
Prb: How to remove default worksheets from workbook
relative reference button on end macro menu
Enable Automatic Refresh Pop-up Excel 2003
Combo Box (ActiveX)
object library invalid
moving macros between spreadsheets
missing macro absolute/relative referencing toolbar
Excel called from external app (OLE) stops after processing exactly 10921 rows
adding reference-to-range control to excel range
Create Folder
Re: How do i stop paste from spreading text across multiple cells ?
insert rows
Create a Folder
Having trouble with simple macro!
Re: How do i stop paste from spreading text across multiple cells ?
MACRO PROBLEMS
Retrieving formulas property in Office System in Spanish
Using WorksheetFunctions in Excel Macros
onkey
copying multiple row to a new sheet
Problems with Excel XP SP2 and Acrobat Distiller
Can't Change Commandbars("Worksheet Menu Bar")
RE: Macros
Re: Code - different Worksheet
a reminder, please - Range w/out qualified reference
Re: Compare and update please help
General Coding Procedure Question
XLM Resources? (XL4/Excel 4)
Multiple Web Queries on background fail
Identify precedents to cell in/outside of activesheet
Re: Macros
Re: Macros
Basic FindValue Q. "Find lword starting with A"
Custom Function
use of range and activate
Excel 2000/XP script to Excel97 script
Automatic Email sent based on data
UserForm Button Help
is preventing the appearence of the close symbol possible?
select only certain cells in a columns
Sort Method
Testing for text
Launching other apps
xlMinimum
Automatically name worksheet tab w/cell formula
Inputbox or msgbox critical + Cancel
Macro Help
Selection change: additional question
Selection change: How to run a Macro
More Then one Worksheet_Change
help with email from excel
Deleting sheets removing/turning off the xl prompt
Using different lines in an input- or msgbox
Sub Totals - URGENT
calling a stored procedure on MS SQL Server within MS Excel 2000
Multiple Conditional Formatting Using VBA
Modify text file before import to Excel
Questions on Excel Grouping and Links--Pls. Help me out!
Need help for closing the active worksheet only under conditions
data validation shortcutting
call the object of scanner...
MATCH with VBA - Can anyone get it to work?? (download my test file )
Excel VBA - choosing another Excel application
how to i use auto filter on a protected worksheet
MATCH function - how to find multiple matches ??
PERSONAL.XLS from Excel97 to Excel2000
How to find the location of a Excel .xla file
How to search the Windows registry by recursion until a reg key is found
error message
Calculation of records on spreadsheet
date/year method
International number format (Excel 2000)
Keyboard shortcut for Maximizing Windows
pivot table doesn't work
xlb location
Minimize/Maximize excel restores command bars
Combine worksheet
Function to return filepath given full filename
arrays, name, and UDT woes
Protecting VBA code
Running Excel Apps on the Web???
How to promt users to save their work?
Interacting outside Excel
How can I close a workbook using VBA?
formula gone array
Live chart on Userform Printing OWC10
Cell formulas with VB
Getting data from Oracle
Re: VBA code in EXCEL
input box reference
Inputbox and cancel button
if statement
Offset and Range Selection
Retreiving data from Excel spreadsheet through ADODB
Automate Microsoft Excel from Visual Basic .NET KB 301982
Execute procedure on startup
Excel formatting-cells
Please Help
Process a text file before import - which language to use?
Opening or modifying multiple workbooks with same filename
Using VBA with a DOS window
can't find problem with permutation algorithm
Split & Trim question
Re: Can't delete custom button and toolbar
Re: Extract Rows By Date
Disable Fill Down, Right, Up....
Excel Left hand side navigation menu
Disable Fill Down, Right, Up....
test
Re: Webpage/excel?
VB Script To replace space with nothing
MACRO execution speed
Cut and Paste Wide Spreadsheet in Powerpoint, spreadsheet gets cut off
Can't get rid of a button
Re: have input box. Need criteria entered to refer to cond. format criteria
Excel formatting
File location / Version errors
how to Interrupt text to speech run from word
PivotTable and PivotChart clear failure
Re: Where to place On Error
Excel Access interface
Is there a way to hide the VBA function or subroutine in excell
Capture Outlook E-Mail Address
Re: copy and paste
Re: copy and paste
Filter range array
Programmely written code don't work
More date issues
Availability of UDF
Re: using SeriesCollection to plot arrays of data
Re: passing arrays between functions in VBA
Re: Date time stamp
Application.DecimalSeparator usage.
additem to a combobox from other excel worksheet
Re: Date time stamp
Changing Formula References in Visual Basic
Saving workbooks
using text from a cell in header
refering to a range with a variable
How to separate First name and Last Name
filling a combobox (without being prompted to save the workbook EVERY time its opened
How to reference a cell address in VBA
Mimic Value Being Typed Into Cell
deleting a chart object
Splitting an Add-in package over several Add-ins
calculating and adding a range to a collection
Cell formatting from within a function
Strange or error : For each cl in Selection 'cl as range
2 questions re: sheets displayed at bottom
VBA code, Import data from Access
Test if a folder exists, create if it doesn't?
Eigenvalues and vectors
test for workbook open
[HELP] This workbook has lost its VBA Project, ActiveX Controls and any other program
move row from one sheet to another
referencing at module level
VBA - on a button event, open another closed file, post changes, close file
Macro needed; save a file two (or more places) at the same time
Which is better?
Not recalc in custom function
Email Question (Ron De Bruin related)
Syntax for WorksheetFunction
thought process
intranet + hyperlinks problem (open in new window?)
Macro not running on shared workbook
Run time error 1004 - Unable to get add property of the buttons class
copying dropdowns
Referencing A Subprocedures Name (Re-post)
AutoExpanding User Defined Function Output
Tampering with add-ins
Multipage
an array to step through sheets
Multipage
Excel problem
urgent..how to go to the next row
Printing a page with cell info
hide application for one workbook
import part of a text file
Could some one please help me to interpret the following syntax
Could we define series variables in one statement?
Passwords in VBA / Excel
macro to create a chart
Excel 02 v Excel 2k
Compare Two Columns of Data Using VB Excel
Code to find formulas that reference other workbooks?
VB6 -- Excel Worksheets Assignment
Hide minimise, maximise, and close buttons on form
need a macro
How to save file without the save message?
How to check if a folder/directory exist using VBA
Opening text files
sheet tab color
VBA code needing alteration
copying data into email
Macro interruption
Save As in VBA
two easy questions take two
Two Easy questions
Automating Converting Text File Into Excel Format Using VBA
commandbar control and application.caller
Calculating Cell Range in a Column
Re: calling C# code from excel
How to activate array formulas in a range of cells all at the same time?
Problems with XLA:s
Dealing With Unique Items
Using variable in WorksheetFunction
last non-blank
Increment Month/Year in "mmm-yy" format
automating a chart
Changing cell colors based on values
Dynamically locating value; selecting that row and everything above (or below) and deleting/copying
Find existing worksheet
How to ensure function does not refer to cells outside of workbook?
How to keep spreadsheet open in the BeforeClose event
Set The Directory to the Current WB Path
Switch Workbooks
date conversion question
(repost) Listbox Rowsource Headings Multi columns
Activate file without path location? Subscript out of range.
run-time error 438
How to add validation by VBA
Get excel to ignore cells with no value entered into them
Range Select
email submission tool for converting xls to pdf or xls to plain text ascii
Sort columns by Rank
Counting empty cell
AutoFit method of Range class failed
Splash Screen Problem
inserting a variable into VB
animated gif
Sorting in VBA and VB
Most Recently Used File list
copy and paste to new sht in one col
VBA equivalent vbscript start outlook & word
Trapping #NAME? question
Creating a pivot table using all named ranges
Macros works in Excel 02 but not 97
Why would this macro work in 02 and not 97
Pick cell and populate userform
Macro trigger?
Re: Automation Adding XmlMaps & SaveAsXMLData in Excel
VBAProject Properties
Re: Macro trigger?
Problems with VBA macro for creating named ranges - ARRRG!
Allow user to edit Ranges under "Protection"
My Three Wishes
Need some help writing code.
Could MVP's please review these Instructions
An interesting one for all you experts...
Solver macro slow when recalculate
Checking Number of Dimensions In Array
How to read multiple text files into excel?
Directory Code
have a "drop down menu" appear in a data form
Opening a File
Opening a File
Can this macro be made to work upside down?
run-time error
Populating ComboBoxes
Need to reset Check Box ID number
Challenge: selective parse of strings
Global variables cleared by forms?
Combo Box wrong lookup range.
Just a huge thanks to Mr. Bob Phillips
Is cell content text or numeric-need help with existing code
VBA Pivot Table Question
Correct Time Sum, by Formulas. Help Please.
Re-Post: Before_Print Sub Doesn't Trigger
Personal.xls won't start automatically
Still trying to copy info from one sheet to another
Environ()
Right & Split question
Help in Modification of existing code
Re: Performing an operation in successives files
Call VBA-Subs From Old XLM-Macros
Re: Using Macros to bold specified text in Excel
tab from text box to text box
loading a bitmap into an image control from the clipboard
Re: Using Macros to bold specified text in Excel
need logging before closing the workbook.
Excel VBA - link problem
TAB-ORDER from one TEXTBOX to another
Splitting/Combing data question
VBA function for having excel find range automatically.
New UsedObjects Property in Excel XP
Vlookup in VBA
Web import - number format problem
Building xll
At wits end
Using API with VBA in Excel
Send data to Word document
Intranet Link to excel file
Trapping key pressed in a worksheet
A control that does not scroll with worksheet
New Work Project - Rent Comparability Database
Passing parameters
Hello Again
Code to copy data from 1 file to another
several questions
Adding sub-total
definition of target
Delete columns
Help with a sumif formula
survey of the unemployed
??Programmatically set security level to medium
how do u...
Using a Decimal changes cell to a label
Format statement no longer throws an error
formula to code help
Finding the last cell used in a file...
File-Open import code available anywhere?
migrating program to wp
Bulk Download of Excel Files
Save selection as jpeg
Automate update of worksheet
"Looping" Code
VBA code refering to columns by name
Remove decimals but keep numbers
SQL "INSERT INTO" Does not Modify Definition of Target Range
SQL "INSERT INTO" puts Single Quote in Front of Text Value
Checking for open workbook...
Clear Doesnt Work
How to import one section of data from internet?
Really Need Help: side effect clears clipboard!!!
pasting into merged cells with a macro
updating links from VB
gformula to find formulas
Copy Cell Across Columns
reading inside a text string
Permanently change CheckBox control's value use VBA
Inserting . in a number
Turn off Save Feature
Extract workbook name within a macro
Create Array From Values in range
Calling Match function from code
Invoking Excel via Getobject(From Access) to invoke Excel Macro
Where does this code go?
Where does this code go?
Deleting Web Query Problem
Loops etc.
Excel Connecting to SQL Server Database - Need your Help
Exit Event
Macro trouble: inserting 'watermark'
A macro that will change all column refs from one column to another?
Action on Error
Printer Settings
What Happened to Previous Posts?
Listbox Rowsource Headings Multi columns Copy Range If Then Conditional
Run Time Error 424
Re: Delete find "Grand Total"
Re: hyperlink file via macro?
inserting check boxes from a macro
poor subroutine performance
Export Data from Excel to SQL
Error handling
time question
Re: Delete find "Grand Total"
Action on error
Where to put code for access by all workbooks
Past formula to the end
Overwriting/Overlapping web query problem
importing text file, removing data and outputting new text file
More PivotTable Trouble
Calendar control version conflict?
Name Manager update
How do I assign values to an array?
selecting txt before a, or return character?
Reference multiple cells
How to use function Concatenate
end of a pivod table
Which method is faster?
AfterUpdate functional equivalent at Cell level?
join strings in VB with Pivot methods
Prevent duplicate in Data Validation
Q re: setting up UserForm for filter criteria
Recommended Excel 2002/Visual Basic Book For Beginner?
Calling Sub / Called Sub
type mismatch on last part :(
Excel file bloat using ADO
Custom Button Scope Limitation
worksheet_change problems
Open Dialog
Converting a LARGE volume of numbers to text in Excel for VLOOKUP
application.username
Code to select print out areas
Calling Excel array functions in VBA
hyperlinking to open an embeded word doc?
Clearcontents
Find character in entire workbook and format color
Test if folder exists, create if it doesn't?
help with date comparision
Move data from different columns into one column, but different rows.
Copy & Paste
problem with a pivot table
Need Help Deleting
Excuting marco on entering data into a field
VBA Books - Detailed
How do I access the source cells in Workbook_SheetChange
Combo Box - text too small!!!
Code Fix Needed
combo on worksheet
How to reduce selection
ComboBox populated with data from AutoFilter
Combox/Print issue
converting 'TODAY' into dd-mmm-yy format
Macro want delete the date row?
from userform to userform.
Nested IF absolute referencing macro
add in
DataRow index
macro that doesn't work...
multiple user formshow
Toggle Worksheets
problem referring to Range and Cells
Macro Excel Lotus Notes V5 <=> Oulook 2000
KeyDown event in sheet
Get the total no. of worksheet & their name
For i = 01 to 20
how to direct users to the empty row below the last record in excel
Re: running an password protected application
Load Testing Tool required for Excel Pivot table based OLAP Application
Pivot table percentages of summed rows
Multipple copy relative value into columns
lookup options
Sendkeys {Spacebar}...?
Line of Credit
survey of the unemployed
SQL.REQUEST #N/A error
have Macro automatically delete and create sheets
help pls
Separate String into string + value form
Re: quotation marks before and after each input
Looping checkboxes embedded in worksheet
Macro to Save As with custom file name
autocompletion of cell input based on databse list
Move Different Columns of Data to Single Column.
UDF screentip
How can I look up a value from a table and return data for other column
Duplicate entries
MACRO HELP NEEDED!
Deleting blanks and shifting left - cont.
Email non-Excel file
3 Criteria on one column in AutoFilter?
how do I ensure enter is pressed
Beyond AUTO_OPEN
Excel doesn't quit
VB FORMs, buttons, window properties
Deleting rows
Re: Need to insert formulas into certain cells when row inserted
Functions that return multiple calculated values
Re: survey of the unemployed
Copying info from one sheet to another
Re: Passing variable from one sub to another
Or statement
Need Help
Find THIS and move it HERE
Erase Hard Drive
Adding comment programmatically
Re: Double-clicking entry
Determine if a workbook is shared
VBA: How to iterate through each cell of one specific row
Delete a blank cell and shift left
ADO inserts text strings not numbers when table is empty
Help with Filtering data and matching two data sets?
Delete all rows below The word Page: 2 of 25
Milliseconds In VB
"Look up" with multiple hits?
Delete a blank cell and shift left
Userform use along with ad-in "Template wizard with data tracking"
BOHICA needs help!
Putting items from list box multi-select onto worksheet
Need help pasting to open external workbook with vba
help with code/syntax
Loop through ranges columns
Inserting HTML into cells
Help create hyperlink from form
VBA Pivot Tables with unkown # of rows in the data set
hh:mm x $
Deleting records ADO
Last Active Row
Problem with Loop
Reference message box
Help adding 5,400+ rows of time data
Importing a text file into spreadsheet
inputing data into dynamic arrays
Copy information from Excel into Web form
Custom formatting numbers & dates with a template (for receipts/invoices)
Selection.Replace doesn't update the cell value in macro!
Email notification
Different text attributes...
Data Tracking question
Selecting Variable Row Range w/Macro
How do I copy information from one sheet into another?
"Too Many Different Cell Formats"
Adding data to SQL Server 7 from Excel
add values within cells
RE: Pulling in Data from Word
Simple range reference question?
Workbook Contention
How to get function to update itself with changes
Copy 2 application references
inserting subtotal() function in spreadsheet via Visual Basic/macro
type mismatch in this code
Close Non-Microsoft Application From Excel
copy problem
How do you test to break out of a find loop?
Borders(xlLeft)
AutoFilter Custom Dialog
Run a stored procedure in Excel 2K
Office 2003 - Initializing ActiveX Control
Excel Closing Event
Excel & ASP
COMBOBOX
Need help converting 1 column of data to several columns
copying the column of the active cell to another column
FormulaR1C1 and abs. rel. referencing
importing Excell data into Outlook
NETWORKDAYS Function in Macro
Reverse Characters-I want to print a page like a mirror is this possible
Excel 2002? Where to store code for all spreadsheet visibility?
run time error 2147217900
Pulling information from a worksheet into a user form
Hiding worksheets and workbooks
May I use a form in an add-in
COUNTIF
formatting decimal points
Inserting rows
Event in current sheet
How to disable hide/unhise command by user?
Just a big "Thank you" to Tom and Bob
Selecting only locked cells
Delete Row meeting a Criteria
Form in VB Editor
code to move certain rows to another sheet
Thanks
Loop through ranges
ADODB Connection to Access
Automatically changing the rowheight
Free Distributable?
assigning macros to a text link or create a drop down box
Code to ignore on-screen message concerning "Enable Macros."
XML Conversion
Vba enable close button
How to search the registry key
Find & Delete
How to find the path where a .XLA is located
Trim numbers to x decimal places
User Form Button Code
Macro in Shared workbook - Runtime error
Autorun Macro
.address / .value
Custom exel functions
RANDOM function
EARLY binding or LATE binding ?
How to skip numbers in a for next loop
Replacing Text In VBProject Module
Problem copying rows to new worksheet
Activechart.SetSourceMethod problem
ThisWorkbook.close doesn't wokk :(
referencing ComboBox