Excel Programming [Archive] - Page 73

Pattern search - Programmatically.
VBA help (Time crunch) please help
Problem with Pivot Items
Problem with Pivot Items
Disable print function on current workbook
Google Beta Reply to Author
How to put excel into batch mode
VBA print setup
Recordset / Named Range Questions
automatically date a cell when entering data in adjoining cell
Displaying sheet code name and sheet name
How to update web form drop down options
Odd Behaviour with Sub
Saving in text format: why are there ""?
Testing for type of cell value using Excel VBA
Testing for Date Format in VBA/Excel
Checking number of uniques instances of values in text string
Calling Excel Import wizard from DOS
NewBie questions
Excel Macro
How do I run my code
Discarding all hidden cells?
Finding a specific date from a week no.
Turn time into a decimal (number)
Streamlining Code
Test
Multiple source data for pivot tables.
Opening Notepad application from Excel macro
selecting graph
Convert Numbers
if i save as the excel file, macros path changed
Replace #VALUE with 0
Adding formatting rules for Comments in Macro
Need help with sorting of three columns
Fiel too large
VLOOKUP and delete row if found
Excel needs sheet groups that can be expanded like explorer
Allow 1 checkbox in a group to be selected
A Late night lazy general question re: sharing code ??
How do I bold certain words or letters in a Msgbox in Excel macro
Web Queries
How to count non-empty cells
getting values from drop down
check row in other document
Outlook mail from Excel
Cell Clearing
Restrict Command Button
Alt+Enter in Index Formula
Alt+Enter Formula/VBA help
Code to work with ONLY active Sheet not all ?
Data Validation without using List feature
Deleting rows and detecting range for format
help for text formula
Delete specific range of cells if containing "0"
Hiding columns whilst autofiltered - PART 2 HELP!!!
exporting to excel problem
exporting to excel problem
Copy content of ActiveCell in a variable
Open text file based on date.
refreshing a pivot table
how to add minutes to give hours using excel e.g. 30m +30m = 1hr
What formula converts mpg to l/100km
What formula converts mpg to l/100km
Please help
Copy to first Blank cell in Colum C Non blank cells still exist be
Continuing Val(Application.Version) saga ?
IF in vba
How to get the creation date of imported file?
Need help with macro
How to make a Plot of this
Prevent closing userform
Prevent closing userform
Inserting same Message in E-mail
Insert same message when e-mailing
Pivot Table - Calculating Field/item
.usedrange in closed workbook
Limit to number of rows copied in AdvancedFilter
Need to Query data on the same Workbook
Pivot Table Formulas Calculated Item / Calculated Field
How to get the latest data from a workbook
Edit listbox Items
Microsoft date and time picker
MACRO TO EXTRACT DATA
Numbers to Text
Pivot Table
system variables
Excel Object Model
how do I get rows of data from one column to another automaticly
jpg file name change
Using toggle button to get info for a combo box
Using Toggle Button to Retrieve info for a combobox
How to change to not active workbook
Excel VBA for automating a LINGO math program
Find only in visible cells....
2007 PlotArea.Left
using find method after using it earlier
Cleaning some blob data
PUBLIC VARIABLE for SELECTEDFILE
find value and copy in TEMPLATE...
Remote module call
Autofilter multiple criteria using array
Clear Undo?
Remove close Button
User Forms and List Boxes
Changing the active cell
Is it possible to import pic with look up formula?
Cells wanting numbers only
Programmatically preventing macros issues
how can I get excel to fill using a start and finish time
Changing column names and automating data merge
Command button failure
sumproduct and if
macro for duplicate checking in one column
E-Mailing a File as a PDF - Q
Error dialog
Deleting Objects Q
Help with - Sheets(Array(1, 2, 3)).Select
How to simplify If / ElseIf statement
Disable control
Puzzle solving with solver
How to simplify If / ElseIf statement
Have two hard issues... I can't seem to resolve!!!
Problem in adding rows
disable maximizebox in Excel Title bar
Conditional formatting - Traffic light system
Pass a cell in sheet to macro or command button
Export Data to CSV without closing source workbook
Can anyone help with VB please?
How to clear cells fast?
how to clear cells quick?
How can we tell converttocurrency what quantities of notes and coins are available?
Windows Vista
Syntax for TextBox ControlSource Property to another worksheet
Which reference library has Int64 ?
allowable no of character
I am trying to find a way to create odds for a office pool
Linked Pivot Table
Reduce a range to just be the part within another part?
Select a range within a range
macro to auto sum
Combining Text and Date function in VBA
Help coding a macro to detete blank rows and provide totals
Setting default value in vba created FormTool Dropdown
Reformatting data for a listbox
Making a call to a differnt sheet
GetObject Template
get range in pivot table
time to integer2
C# open workbook and suppress Read/Write dialog
multiple objects in single cell
other users cannot enter data into excel
Change file name - remove specific text
array variable is empty?
Transfer files to AS/400
determine if sheet contains mergearea(s)
Help with looking up value in list
how can i get data from an un_opened excel file using codes
easy!!!!
need subdirectory check 99
Insert hyperlink in shared workbook?
Auto fill a list with a formula
Excel 2000 macro for page format slow
Excel 2000 macro for page format slow
Use VBA to Apply various Security Levels in Workbooks
Next Cell Empty Issues
Add comment in a protected sheet, Excel 2000
Delete Empty Rows
WebException from within excel add-in
Urgent - VBA Code Not Running
Search and Copy
RE: Help with Syntax in Code
Excel Worksheet and VBA
Help with Syntax in Code
Macros gets corrupted in Excel Beta 2 TR
change a value on a string of data
How do I enable the CALL and REGISTER functions in Excel 2003?
Cannot obtain Filename
User defined date entry into message box?
Setting ListFillRange through VBA
Saving a file
Skipping a set number of rows
counting like items on one sheet, showing totals on another sheet
Define a range of rows having the same value in one column
read one char
how to select multiple rows using a macro
using variables to select multiple rows using a macro
using variables to select multiple rows using a macro
Relative range references in VBA - how?
Populating a combo box at run time
Copy from various sheets and create a master list.
fixed length file to excel? VBA macro possible?
Combo boxes
help:Excel 自动生成文件
Workbook Highlighting property
Workbook HighlightChangeOption ???
time to integer
integrating a userform with combobox into a macro
Workbook Highlight flag setting
excel 97 on new machine - object library not found -its o nthe mac
Logic and Drop-Downs...
variable paste or fill range
CountIf Greater Than/Find Greater Than
Which x was clicked?
Adding Name object to a collection does not add an object
Fill down to last row - copy formula to last row
Help with a vlookup
Variable inside a formula
displaying UDF input arguments "in yellow box"
Excel
CreateObject - start Access from Excel
Creating Macro to copy information from cell into another cell using Add Comments
Macro correction
EXCEL VERSION & VBE FUNCTIONALITY
ODBC Connection
Including images in a tab order sequence.
function call not returning changed value
How to get function,object, and sub list from imported reference library
Get an object's type if it's declared as Variant
Invoke Java web service via MS XP Soap toolkit 2.0
Disabling Toolbar
arranging worksheets in alphabetical order
auto fill the blank with value
need to jump down 4 cells, gather data, jump another 4
excel program be or not in computer
UserForm with multiple selections
Help on Which Way to go ??
I need to move the data from certain cells in multiple positions (different columns & rows) into a single row, then repeat.
unprotecting my worksheet
AUTO FILL CELL WITH DATE & TIME OF DAY AM/PM
Possible Text Conversion
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file
1 col has cells w/an H or C, tally cells for Hs and cells for Cs
Disable Focus on Command Buttons
Registering library
How to read an excel file whitout opening Excel or instancing Exce
Run Time Error '1004'
Autofill until Null
Error on Save As
Help on deleting rows using Macros
How to Evaluate formula results in VBA
Random corruption in Excel files
Using COUNT for dates and times
BeforeSave event fired but not working when triggered by SaveAs.
Copying all Rows with data to a New worksheet
cut a row of 10 items and paste as column
Compiling a report recommendations
20061005 should be a valid date format in Excel
How Do I Identify 1 to 1 Offsetting Entries in a List?
copying data
disable save as dialog box
Processing unread email?
Need help with IF Statement
Executing Stored Procedure
Hiding blank columns when autofiltered?
I need help deleting macros and VB controls and saving as new workbook
My first Macro try
Inserting an entire column causes sub to stop
Arrange Icons of Minimized Excel Windows
Form Micro
copy text of cells down to blank cells
Programmatically set print area in Excel
coping cells
Is there a simple function code to do it?.
Formatting A Pivot Table
Input data in a pivot table
determine if column is frozen with vba
Sheet File To Large due to Pivot Tables?
How to create mult. PowerPoint certificates using Excel data?
how to default WritePassword under excel workbook property for any files as long as those files are the offsprings of the parent file
Modelling Object Models
simple? print area?
One cell accumulation
Update a ListObject from a another Excel sheet
Calculate does not work consistently
archiving spreadsheet rows from one worksheet to another
Can a Macro utilize an auto filter?
String Together
Don't copy buttons
Referring to multiple worksheets via a variable
validation list length issue
Modifying an Excel 2000 Macro
How to get known by which application Excel was launched?
delete rows
Excel opening outlook emails
Pausing a macro
sorting columns that contain formulas
Clipboard clear error
reading cells by name/definition
Button to open another embedded xls file
Merging data between 2 files
MATCHING COLUMN AND RANGE...
Listbox size
I need examples of conditional time manipulation IF AND OR
time delay
move two columns to the right and then find next cell above that i
Unique data
Detect double digit
I want RS Symbol ex $
'External links' in formulas when the user paste cells to other workbook?
lookup and copy data and move it upwards and paste
Break Link
Thoght I had this Application.Version solved??
How could I default an excel file to be openned as READ ONLY once it is saved under a name?
Error 91 on Find second time through a loop
More than one level of sub menus under the menu item
Indexing in Excel
Different Sized Reports
Editing a recorded Macro
Speeding up Macro
Excel 97 DLL
combine CountA and CountIf
Trying to install an add in using automatisation directly via C++
Adjusting the msoControlDropdown
Add New Rows
Need help on deleting row.
Annual Timesheet: Two date ranges lookup in a single sum column
adding to a formula
Combine data in cells
Looping through data and Populate template
Date format
open Userform in Another workbook
E_MAIL WITH MATCHING...
E_MAIL WITH MATCHING...
Huhe ecel file size
View cell range in userform
VBA coding to export multiple calcualtion sheets as webpages
Using a Variable in a Formula
How can I share and un-share a workbook using a macro?
Update value of variable from one sheet to paste into another shee
Excel VBA - Working with Lotus Notes notesembeddedobjects
Creating a warning window
Call macro stored in Excel workbook from Outlook's macro
Hide a sheet based on value!
How to dynamically change the series range of a chart ?
Need help on moving to next column
Speeding Up Macro in VBA
Passing a variant object to a C++ dll
Newbie: Accessing data from one sheet and populating another
Macros sometimes automatically disabled
how do you display a wait message while
Finding the last row of a contiguous range
Direct Precedents of a cell
PrintQuality setting - is -3 a valid setting?
how to maintain settings when calling a second macro
Comparing date modified between two files
How can I use a variable to refer to multiple worksheets?
publishing documents: specifying the password
User Function Not Recalculating
Add new worksheet via userform
formula or macro
macro or formula
macro running extremely slow
Re: Data Field in Pivot Table
VBA platforms?
Run multiple excel files off of one macro
Lost password
Capturing a series of calculated values to analyse Real-Time Data
using a shared printer (pdf)
probably an easy question for you but I'm stuck
Radio Buttons
update listbox from combobox selection
Paid Support to write Macro?
("worksheet menu bar")
Macro to convert CSV to PRN
XMLSS European Decimal Values
How do I Take Data from XL Form and input to spreadsheet?
Excel Custom Menu - Insert Where?
User Defined Function - actioned in unrelated WB
Format decimals in VBA function
Bloomberg Resources
Calendar year change.
Capture All Actions 2
Changing Date Formats in VBA
Fill cell on exit?
RE: Building an XLL from C / C++
Conditional Formatting and VBA
Convert multiple csv files into one excel file
paste object failed
if Formula 2 scenario
Insert cellS(!) text into header for printing
Further help required please :)
Project Unviewable
If Formula
Month Names as ComboBox List
DoEvents
on Listbox in Userform....
Evaluate text strings as a formula
MouseUp Event
Capture All Excel Actions
Creating a new workbook dependant on a variable
Help
After printing to PDFs. How do I attach them to an email?
Summry Total using VBA
Scroll Bar / Spin Button Small Change value
Reporting using a PivotTable
Opening macro file as read only
Disable macros in Workbooks.open
HowTo insert a blank row and move existing down
Open Lotus Notes attachments
Userform problem
Add/Edit/Save Info into Excel
CountIf for unfiltered cells.
Does outlook allow automatic task updates from excel data?
Print button help
VB for multiple cell names
Public Holidays
Creating ListObject using an XmlMap datasource.
Excel Cell Validation issue
How to add a new row using Excel4 Macro
Using GroupName
combining workbooks
non continous cells
Personal.xls macro folder stopped working
Performing calculation in active cell based on user input
BIG BLUE partial screen problem?
Minimize to Tray Button
Math Formula Giving Error
How do I write a VBA script that runs from the DOS prompt window?
add totals for each date
Identify even (or odd) rows without toolpak and 'ISEVEN'/'ISODD' ?
added characters
yesterdays julian date as filename to link to previous days workbo
how can i create a macro
Highlight a row
command button to do F9 function
I cannot enter text in VBA search index
solver macro
Save Special Filename Multiple Times
Output - Results of an Array
Error when doing a paste
Use of Stream Object
Refeencing a check box on an Excel sheet
how can i create a macro that insert 2 rows
formatting zip codes in excel
access menu
importing txt file and wrong date format... MACRO vs MANUAL
Disabling the Print Banner/Separator Page in a Macro.
Runtime error 18 user interrupt occured on some Computers
Looping through workbook
Searching and editing data with VBA
HELP: Macro to conduct web query and return results
Sheet Range Help Required
Recreation of on workbook
Editing Link Source
Auto Print A Form From A List
Object Library problem
Moving ranges as input for Solver
Check if filtered cells contain data to delete
Consolidation Function VBA
Consolidating Data to one worksheet
last row number value question
Detecting Change in State of Internet Explorer
File encryption
new project requiring zipping and ftping.
Remove Picture from Image1 on a Userform
listbox change with combobox selection
Range function with Arabic Text
Tagging an excel workbook
VBA SAVEAS TXT DATA PROBLEMS
SolverSolve userFinish:=True still displays the dialogue
How come the function '=SUM(A2:A6)*24' doesn't work
Macro referencing identical text
Allow user to choose worksheet from newly opened file
60 Second Countdown NOT using the WAIT function...
Format
Dates in excell
About _Workbook::SaveAs in Excel 2007
Code breaking without reason
Incuding a picture in the tab order of a protected worksheet.
Import Worksheet
Capture data in one 'destination' file from varied 'source' file stored in one single folder.
pivot field autoselection
In a page where rows are repeated how does cell data change?
Changing Circular Reference
Textbox.change event not firing!
VBA to position my mouse cursor on my desired spot on screen
Derivatives
Create merge source in Excel, call Word to generate labels
Deeting rows based on entry in a cell
Moving to a cell from a button
ComboBox and if
web query - stops at login to private data help?
generating Excel files w/ .NET? (an ASP.NET, C# web app)
Using Consolidation function
Extract text inside bracket
Screen Updating
Fw: determine Dll version
Create Control Button
Sheets# and name
List of unique entries in range
Two questions, how do I disable ver 4 macros and how do I make radial buttons like this?
A Button that saves a workbook in the background
Deleting Rows with String Values
how to create a tabe in excel
File encryption
Eliminating choices on data validation
Run Time Automation Error - Help Needed
Macros: Step Thru Works, Run Works, Keyboard Shortcut Locks up
Excel SUM TOTAL (Not Programming)
If a cell contains a certfain value, Beep
How to assign a macro to a button
Read only
copy data down
text box visible on click
.net
Supress Warning Message
using advanced filter in VBA with a dynamic range
Sum Rule checking 2 and 3 cells.
Error in opening workbook
Enable Macros
determine Dll version
add row every two rows
change positive to negative and viceversa
Us date versus EU date problem
How do I calculate missing values in an equation
delete next cell
toolbar commands
Editing a worksheet while running a macro
indirect help
Multi names in one cell copied to single cell
Programming a 'frozen' cell
screen refresh
Merge Cells with excel 2003
Multiple Files to Import
The contents of the clipboard
Autofill till cell "x"
How to have Autofilter working in a protected sheet?
How to avoid: Error of run Time '13'
Loop and extend selection
VSTO Deployment
Checking string
Create A vba button on a spreadsheet that
Auto Deleting by sorting dates
enter opposite number one row below
Create a .xla to open a spreadsheet
How do I use chart type command in Excel
Start up macro to get a number from user
automated calculation except on one sheet
Concatenate variables
closng userform and canceling changes
Date & time question
Formula equation
Can't copy named range
Modules
VBA References Q
How to find multiple of a value?
OpenText, column separation problem.
Copy formats from row 2 down to nRows
hiding worksheets from certain users with passwords
Convert Numbers to Arabic Language Text
Lock VBProject for Viewing using Code
Workbooks.Open(URL) not working
How to save excel worksheet in .txt format fast?
Dynamic Ranges - Help Please
Coping with multiple versions of Office
Selececting a cell/range onscreen through vba
Determing last (used) row in a sheet
Problem with formula
Copy & paste cells fr open worksheet then close the worksheet
findnext question
outlook tasks from comments
find a value down a column and return seventeen values in the row
keybd_event versus SendKeys to open Access database with macros disabled
use vaiable for all sheets
delete dupes in one of two sheets
Vlookup code product and to copy commentary with photo of the product in vba
Every 5 digit combination
Re: writing values of a range inside a range
nexted for next loops
Method 'Union' of object '_Global' failed error
Macro that saves Excel worksheet with value in C4 as the file name
Export worksheet only
Subject: clicking on a button copies the choice *(VBA)
optimizing excel work sheet
add a button on a spreadsheet that runs a macro
Data Access Efficiency: Arrays versus Worksheet Data
union of named ranges based only on the names of those ranges
MS Excel VBA Programming - Definitive Toolkit
Re: Select Various tabs using VBA
Excel VBA coding - Outlook and Shut down issue
spread sheet
use primary key to automatcally enter data across rows
How to enter dates in Excel cells using InputBox
Recover Office Registry
Re: Select Various tabs using VBA
Spreadsheet security
Re: find...insert
Re: Interpolating missing data
Re: Kill Excel VBS
Re: Delete Every 2nd & 3rd Row
Thank You
Re: Code Execution Has Been Interruptred?
Focus on textbox of Choice
Automated printing if criteria are met
Using InpubBox to enter dates in two Excel cells
RE: Updating a SQL Dbase using values in specific Excel cells
Re: KeyAscii won't capture the <Tab> key
Re: VARIABLE IN EXCEL MACRO
Re: KeyAscii won't capture the <Tab> key
Re: Average Daily Sales
RE: Imports excel data to an sql table
RE: Kill Excel VBS
Converting to and from Named Formulas
Visual Source Safe communication
Rename Excel Files
Get default add-in path
Does *Anyone* know how to....
Delete Rows Filtered within Auto Filter
CommandBars.Add problem
IMEX
validate cells
Declare and array in a function
Excel confusion
Delete Rows with Empty Cells with empty column 1
Find Code Needs Help
cycling through pivotchart page fields
TextFrame.Characters.Text returns truncated string
Can and excel file be networked?
Question - can excel be used to write a POS inventory tracker - or should you use a dbase program?
Most Recent Date and unique name
ShortCut
Linking a VBA button to Excel cell
Interactive worksheet
Date change button/macro
Procedure fails after updating XP to SP2
programming a macro to display the current time
Determining if selection change was the result of ENTER
Copy a row down a column for the same number of rows of data in another workshee
Copy a row down a column for the same number of rows of data in another workshee
Change Author Name
Filter by value of cell
Format cell
create macro that erases rows having blank cells and
Delete a row when a condition is met using VBA
delete rows on value
how to get marching ants in Excel programmatically
Here's an Easy One
ignore blank rows
Pulling "Matrix" Data
create a macro that looks for (repost)
best way to find
Automatic Secuential number
How do I determine the file path with the file name at the end
Delete Rows then Move Up
creating custom function - need to receive a cell address as a par
VBA for finding separated ranges of data in sheet
Value between two spaces in a String
Function that gives the SUM minus 4 lowest numbers
Need some general Tips and Tricks for programming !
RangeObject.Delete method question
reply to questions
data cut off
Changing text in a rectangle (shape) using a macro
ADO connection error
Custom Sorting
Custom Sorting
Custom Sorting
ADO connection error
Filtered Data
comparing column data and add if not present
End of VBA??
Count lines code in workbook
Set Word Document Style
Select all but header row???
Getting the mac address
Input Box
Hiding columns based upon a value (or vice versa)
create a macro that looks for data and delete row
Help with Dynamic Range
go to end of ROW
Hide a Workbook
delete rows with 0 values
copy cells down
Paste a conditional format without replacing existing formats??
BuiltInDocumentProperties...some no workee
Unloading DLL's
quick question
CSV Import Issues (Newbie)
auto update
VBA Menu Nooblet
Custom help file in Excel 2007
Scroll Area
Delete and Move Up
selecting a specific cell within a selected range
Save Excel Worksheet As CSV - No Save As Dialog
Line Insert recall by name
Treating numbers as string variables to preserve zeros at the beggining
How do I lock or close t.bars for a workbook?
ActiveWindow.Visible = True
Formula palette.
How do I get a UDF to return existing value rather than recalc
Formating a Cell
dropdownlist - inputbox
Error during retrieval of ADODBrecordset
Exporting data to Excel file
ComboBox and text Box
Set tab stops in Excel
Making Changes to Cells from a user defined function
how to sort worksheets
Initializing control values of a form
Save Excel Workbook Question
Pause a macro to allow editing
If Statement with variables
powerpoint slide show .pps
??? application.screenupdating no longer works! Why???
Text box format
Visual Basic Textbox object
Need help editing the Function...
Inserting lines according to number of days, adjusting date
Worksheet_Change event to unhide columns based on value in range
Creating Hyperlinked "Map" to Complex Model
problem with my code for incorrect text box inputs on a userform
How unselect? Want to run ActiveWindow.VisibleRange but have Chartobject selected
weighted avg. of groups in table
select a range w/in a range
On Window change, a "flashing" screen
help SUM hyperlinked info
writing a macro for search-match-copy
Validation List - Reset to Top Value?
run-time error 91
vba compiler operation
create a loop macro
Conditional Formatting
Check if a document is open
Excel Import to Access null issue
Auto update of data in multiple worlsheets
formula to add values based on percentage of a bigger value
Newbie General Programming ??
Problem with Sort Method After Paste
VBA sucks
Modal window
Modal form won't leave
How to return to sheet I came from?
Hide Rows
Can't Paint Calendar (mscal.ocx) on User Forms - Crashes Excel
Help with this?
connecting 2 inputboxes and using the autofill
Re: Updating a spreadsheet with another
hide the #DIV/0!
looping through an array of ranges
average of group
Conditional Macro
Sub calling and passing arguments
Refering to an object with a variable
Problem with Find method
odbc security
LIST BOX HELP
Sub calling and passnig arguments
Interpolator function refuses to work...driving me crazy
With statement parameters
Sharing Macros
Copy Push Button and VB Functionality
Folder Author/Administrator
with sheet protection on, macro won't run to add borders around a
Value = this
Pulling Data from a Pivot Table using Look-ups
How to execute parametrised stored procedure from MS query?
Interpolator function refuses to work...driving me crazy
Opening a file through a macro - Help!!
Problem moving records to another sheet
Lookup and copy area
If-Then Help! Simple Situation it seems
Can we revisit the "Implements" statement??
Return amount with various number of decimals
excel macros
Copying VLOOKUO Formulas
Display zeros to the left of a number
Clear contents
Re: 2006 West Coast Excel / Access User Conference
TreeView mousemove event in Excel userform
Passing an Excel Range object to C++ DLL
Calendar field overlap
TreeView mousemove event
Run one Macro from clicking different Textbox Objects
How do I graph arrays using VBA?
Vision Question
Embedded button (ActiveX)
Formual Issue
Excel cell editing mode
Find Date error message
Using VBA to pull data from SQL server based on cell contents
Searching for Capital Letters
Part of VB not working
copy specific records from mulitple wks to single wks
Creating Unique Random Numbers?
Auto Importing of new files
How can I make a dialogue box pop up with a notice to user?
How do I set up an Object ??
Help!
How do I write a VB code for a 'Date' text box for spreadsheet
Importing a Sheet
Macro change on rename
CHARTS DATATABLE
Looping through folders and using the first file in each folder
Attach Open Excel Spreadshee to Email
Excel Add-Ins without VSTO
PERSONAL.XLS ??
Getting Access data to work in Excel formulas
delete all rows but rows with value =
"Object invoked disconneted from its clients"
Jumping out of loop with GoTo function
Remove Split line from frozen panes
** Macro to auto-increment a cell using arrow keys?
Code help
Selecting a Range using a variable
Canceling Workbook_BeforeClose does not work
copying sheets in workbook limit?
SUMIF not working when used in VBA
Trouble manipulating worksheet chosen from combo box
VBA COUNTA function and C++ automation
Urgently need help with a formula!!!
msgbox sounds
Userform updating via spinbutton
Userform: PC to Mac
simulate down arrow
24 hours Shift payroll
Scope limit of user written Excel Functions
Excel plugin to provide frequent updating of cells from other spreadsheets?
Reminder in excel
Range Error
FormulaArray alternative for A1 reference style?
nesting with statements
Convert string to variable
Emailing sheets
Combo box macro problems
ComboBox Filter which pulls very specific Data in Excel into preset template
Summarizing data from multiple (1000s) of workbooks into one wrksh
automatically sequencing 06-2597 thru 06-2600
Macro Help
Offset & Indirect Function
Complex problem
Find Problem
Protected Workbook Open, Odd worksheet size
"For Each" statements
Changing Worksheet State completely
emulating if else Like statements with case
Format cells the same in two sheets
Outlook Connectivity
Changing default Save As name to a cell location.
Returning results to multiple location using VBA?
progress bar issues
Using RemoveItem with a combobox
Excel Column Reverse AutoFill. Is this possible?
Export Access Table to Excel
Multidimensional array - lookup
Delete check boxes automatically
Saving E Mails
Call particular Excel function from command line
Auto show a form
Copying Data between files
Random Selection
Subtotal fails
Excel Addin: preprocessing the data on opening excel files in EXCE
How to read excel file in VC++
Copy every 3rd cell, define destination range for paste
Manipulate GIF that has been inserted using Paste Special
vba to select all autoshapes on a sheet
Capture RS232 data
Stop the Drag Downs!
How to print all criterions of filter at AutoFilter
ActiveSheet.UsedRange.Rows.Count = 5002? why?
How to get path for "my documents"
Find function
"for ... to ..." with input from list
problem in executing macro once for multiple worksheet
Userform to grab,correct and restore data
Application.Ontime help (Excel 2003)
TEXT (searching for a character)
matched entry complete not working
dim objects and dim long
Creating a hyperlink in Word from Excel
Page Numbers
Excel hidden data shown in XML ???
sub total array
Checking Excel Version
displaying pivot fields
displaying pivot fields
HOW TO RIGHT A FORMULA TO HAVE NUMBERS APPEAR IN ORDER
How can I clean the buffer from the folder picker?
[VBA] How to highlight rows in PivotTable
Computing a minimum in a user-defined function
New Workbooks for unique values
Macro/Worksheet interaction
Re: open an excel file
[VBA] Hiding rows in PivotTable
Paintg cells withtout go sheet to sheet
worksheet to worksheet . . .
call Text to Columns from another App
Viewing excel data on a form
sorting numbers as text
Custom Function Not Updating
Filter for Day of the Week
Please Help. Macro - changing data layout
Copy and Paste
Inserting Environment Variables into Cells
Do While Loop using time as the counter
protecting a macro button
Send workbook automatically as attachment based on input from user
How do you close acrobat reader using excel VBA
Reference the name of a formfield bookmark in Word
Please help with summative column (VLOOKUP???)
USER input
COMException With Microsoft.Office.Interop.Excel
Sorting DateTime Values in Array
getting rid of selection for formatting
Using Two Variables in Excel Calculation VBA
Moving to Next Sheet
Problem Saving With Different Version
Excel Experts Needed: Marcors on Shared Documents are slow....
Multiple workbook Match and Index
Update CurDIr??
Summing Cells Above
Second workbook not closing as expected
Adding Zeros in front of numbers in cells using Excel 2003
How to delete rows in a csv file?
Macro runs upon wkbk open, but no Workbook_Open or Auto_Open Macro
Range references in VB
now trying to unselect a sheet
Import Text file into an existing Worksheet
Relative vs Absolute referencing of Workbooks
Query to Return Value from Seperate Worksheet
VBA Find produces 1004 error
tightening up VBA
Multi Dimensional Array
Copying every other row
alternating between left and righ headers, odd and even pages or leafs using VBA
Count >= 3 multiples in column
Looping Problem
Is it possible to get full file path in titlebar?
Code Improvements
Print only if Cell is non-blank
How to code it in excel?
Help with distributing custom toolbar
align autoshape with centre / right of excel cell
Go to a new row
Do I need If Then?
Weird Error with ComboBox_Change()
Dynamic forms in a macro userform
Displaying series information for embedded charts
In Before Close Sub ActiveWorkBook.Close(False) repeat procedure
Automatic Error message generation for invalid data format entry
Verify Phone Number
Identifying embedded object # and location
Running a UserForm (seemingly) Independent of Excel...?
newbie question
Save workbook
excel workbook in explorer frame
Stripping spaces using a formula, not VBA
creating command bar
Reading Excel File in VC++
excel rand() negative
UDF Works in Debug Window but not on Sheet?
dynamically created listbox
Hyperlinking
Worksheet_Activate
How to retain the size of excel file after using saveas
Excel size
DDE connection
how to print all the criterions at once
Adding Minutes & Hours
Capital Letters versus Not
Data Validation lists
Compress Pictures with VBA
If Then
On entering a textbox problem ??
Write Worksheet to MemoryStream in .NET 2.0
Check boxes
start learning Excel/VBA, where to start from? Any online video lectures?
pdf..import/export
am in need of an excel professional vba programmer
Not enough system resources
Selection
Open dbf file then close. do nothing..ignore any message.
Add PivitField to PivotCache
Loop thru woorksheets
can't find link
fill cells values with range values
Capital Letter
Creating #codes
Problem: vba code for creating a button to save worksheet as Cell
application.onkey doesn't work within a cell
msgbox yes=password & goto sheet3, no= cancel
Can Excel pass variable from a spreadsheet to IE
Is there ADO "Help"?
minimum value
Range object and worksheet change event
Modification in the CODE to HIDE rows and columns that start with ZERO (code given)
Print Page Totals
Obtaining Sub Routine Name from with the subroutine
Error Help Needed On MyForm.Show
Recorded Macro
Disable print not working
spawning Excel and giving it a Print Command
using excel vba to print a pdf file
"pre-specify" print options
Extracting text from embedded Word Object
Invalid Characters in Worksheet Name (International)
How to determine How many files in specified directory
Divide Cell Across Rows
PC date format (M, MM vs. MMM) messes up formula...