Excel Programming [Archive] - Page 141

deleting blank rows
Help! Excel Macro Delete function!!
"Out of Context" Message?
.NET remove .net code from Excel spreadsheet
Need help passing an array as an argument
Date as worksheet name
Excel Date/Time problem
Error with Form
Add page breaks from VB
auto-populating columns
match problems
CheckBox on UserForm
Event for a file being changed?
Spreadsheet Dropdown ?
specific name for saving.
Macro or VBA help
How do I use VBA to add a formula?
Re: Incorrect msgPrompt
Add a multiselection list box to a spreadsheet
What if AutoFilter is NOT on?
Running Macro in Minimized Excel Window
Re: Excel if & hyperlink formula
Is it possible to load an .xls file
Using Variable in Rows(x:y) function
Q. Consolidating a long list, in single workbook.
Create an .xla
code to delete a defined name
Does OnTime slow macro down?
Macro Expert Help needed...
Using LinEst function within VBA macro
New to ComboBox
Opening & setting data from Excel to webpage
Excel VBA-Creating Menus
IF THEN STATEMENTS
Unprotecting Worksheets in VB Script
How to change Text
Msg Box
Msg Box
Msg Box
Named range
Directory List - Ron de Bruin
combo box
A Turing Machine in Excel
Re: Grpahical selection of points on Excel charts
How to make Excel the Top-Most application programmatically?
general validation question
Re: range class problem
Buttons
Re: Creating pick box with unique input values from a worksheet in the
Simple table query
Mail Merge Error
Mail Merge Error
Multiple Column Cell Compare looping through Rows
Re: Populating blank cells with the data in the cell above.
VBA Script to detect user input
decimal & percent format
activeworkbook.saveas - saving format changes
Please help..urgent !
function called from worksheet and bad result!
Unprotecting!
Unprotecting!
Unprotecting!
Filling An Autofiltered List
Filling An Autofiltered List
Custom Menu return to Excel Menu upon Closing
Problem with TabBehavior on UserForms
which declaration to use
Insert Excel Sheeet using VBA
Problem with printform
Permission to use object denied.
Go To Home
Programatically navigate to depedent cell(s)
Option of Print Preview or Save As
need time calculation formula
Autofill Destination
How To:
How to save a bar chart as an image file programmatically?
Excel VBA: Create new conditions
print userform (for MVA)
cannot unhide rows!
cannot unhide rows
cannot unhide rows
cannot unhide rows/columns in the worksheet.
Freeze pane
Excel Grid to Template/Form?
Open Office Kills my secrets !
Setting printarea through range object
Help in Excel VBA Programing - How to check an Excel Worksheet?
Recommended Book on Visual Basic for Excel
Changing Cells, How to
Trouble opening worksheet
Check if empty
How to justify in merged cells
Remove reference names
Problem with external_data
Excel Chart Class/Object not work propely in IE
If/Then Matrix? Can Excel do this?
Object variable error
Command buttons duplicating themselves
Deleting named ranges by looping through range collection
How to create new sheet in excel using VJ#.Net
calling windows with variables
Turn Off Scientific Notation
Turn Off Scientific Notation
How to set default font for forms?
How to locate record in VBA of Excel2000
Find
Possibilities Enhancing Auditing Features?
Rows Count of a particular column
Rows Count of a particular column
Using same VBA program in diff. Excel versions.
VB Code
Quick question about dynamically adding and naming worksheets
Excel 97 - Prevent Renaming/Deleting Protected Worksheet
code help cont.
Re: If Statement
code help
sorting rows
Filling a Word form from an Excel spreadsheet
ComboBox on UserForm
Command buttons stack up!
Excel "Work"menu option
filter code help
DDE function
loop to delete rows...
Have a Macro create a Macro
Multi Check Boxes (Selecting Just One)
R1C1 vs A1 addressing
Macro Names
last cell in filter
Help in opening powerpoint file variable from excel
Dynamic Cell Selection
Pivot code
TextBox focus 4
application.enableEvents
dbx file duplicates QUESTION
prevent coping from CD
Populating other cells with combo box selection
Copy and paste subtotal to another worksheet
dynamic chart title
Worksheet change subs.
activating cells
Device I/O Error
CONDITIONAL DELETE
Jon Peltier question: use of MATCH
Excel/PowerPoint E-Mails
Advancing A Number With The Push A Button
Textbox error checK problems
Excel <-> Application clipboard data transfer
Infinite loop? Help.
Create Concatenated List with Incremental Values
ComboBox on UserForm
combo box
VBA / IF - Then / Custom Toolbar
Number to text with leading zero
How can I insert 4000 rows of Excel data into a sql database
unique entries
Excel Math Bug
.Protect ET .Validation.ShowInput
On Error GoTo
Marking ActiveX control as safe
Write no closed workbook ?
button
Help with Mr. Dave Peterson's Code for Consolidating Many Sheets to One
how do you change a row height in a protected worksheet
How to create a digital certificate>
How to create a new sheet in VBA?
file can not be opened
Resource of excel to connection mssql to get data
Excel bug, variables reset?
Getting external data...
Adding other bars disabled ???
Scrollbar macros
Help Needed to Search and Find Specific Data
Protecting Macros
Update Links on file open
Use a RefEdit to select a single cell
Forms Unload for No reason
Which function to use to open an .asc file?
Changing Text in grouped shapes
enhance trace precedent via dialogue box?
Disabling Circular Reference Checking
Combo Box
Option button problem
Avioding "Version Update" Dialogue Box
Using a Macro to Write A Marco
Programming Formulas
Excel 2000: Web Query not working for https site
Text Box - Restricting Entry
Writing to Network Workbook
Convert CSV Files to XLS
Dynamic Range
Re: Reference Error
specific cell values in two ranges
combination of numbers in lottery
Coverting worksheet macro to regular macro
Populating Cells in a row.
excel with project embeded in it
Using Querytable.add to import data from a closed workbook
List Selection to First Empty Row
VBA Function to evaluate hlookup text string as formula
Date Conversion Formula from Bob Phillips...
Connect a Template with the data source.
Opening a new file from a template
Re: A development of a Macro by Tom
How to create a "combination drop-down edit" box?
Setting LinkedCell on a CheckBox Control
Re: How to determine column letter in a spreadsheet?
ICD9 Code Evaluation Function - an example
Splitting first and family name
Macro to copy text from ColumnA to B
Immediate window error
Listbox refuses to resize
wrap text in combo box
Macro compatibility between excel XP and 97
Personal Settings Causing Error?
Cannot assign value to Filesearch.Lookin
multiselect on a listbox from Control toolbox
UDFs: A simple question.
Re: How to determine column letter in a spreadsheet?
Microsoft Script: <x:Name>Auto_Close</x:Name> causes errors
Error check and resume
can not assign value to LookIn
"value" works in sheet, not vba
IF THEN ELSE in VBA
VBA - Cells
add a workbook.
Kill Syntax and path
Invisible AutoFilter Drop-Down Arrows
copy to the same workbook
Insert row if box on userform is checked
Slow coding in VBA Excel 2003
Wrting values with macro.
Removing Outlook Warning Dialogs.
Removing Outlook Warning Dialogs.
Move to a specific cell
Macro problem with protecting worksheet...........
Help with Vlookup in VBA
Linking Or Copying Filter Arrow
Should be straightforward answer...
Concatenate formula with relative cells
Saving Excel 2000 files as .xml
Empty keyword in statment Application.caption?
Conditional splitting of cells
Month end report ? expansion
Conditional Formatting
SolverOK, he not so OK
Import modules EXCEL caused an invalid page fault in EXCEL.EXE
Deferred Mail(2)
Workbook_Open() not running
Userform date format problem
How to check that a string is a valid formula ?
Pivot Tables Messsyyyyyy
Code Execution Has been Interrupted
Re: Left JOINS in multiple table MSQuery in Excel
Excel 2000 V Excel 2003
Re: Please help me improve macro to convert spreadsheet to tabular for
Force a new Excel instance
Detect Macro Completion
Search "Total" in all worksheets and delete rows containing "Total"
Copying ranges from one sheet to another
information From Global Address Book into list box.
Creating a powerpoint presentation from MS-Excel
Combo box
Returning range object from custom functions
Cells.Replace need to keep track of result
6E+02 what is this ugly scientific format?
Check active sheet not the one with macros
Passing Dates to SQL From Excel
Modifying an Excel Chart in VB - DOM question
Macro Error(??)
Create a days in calendar year add-in
Re: Assigning 10x1 array to 2nd collumn of 10x3 array
WAV Files
Best Course to Import XML with DTD...
if it looks like it matches, it's a match
RE: Would like to add 0 counts to worksheet after data is returned fro
Re: Assigning 10x1 array to 2nd collumn of 10x3 array
Re: Need Help! VBA screen capture question
Excel macro to control Word Problem
Importing Text Data into Excel
Macros with vlookup
Select cells in a column
Re: Macro with Query
Re: Modules
shifting headings over on column
How to Process Query Data after Query is Refreshed
shifting headings over on column
Re: Modules
For loop with non consecutive number
User Defined Function used in Macro returns #VALUE
Page Break Preview
Directory List
Convert Date Format of 7/29/04 to Date Format of 072904
Excel 2000 VBA - Using Split() with no Lelimiter in string
Break mode not working
Need help with report output....macro???
workbook-specfic Macro Menu in toolbar
Autotext equivalent in Excel?
SumProduct function
Autosave
How to find this value
colorize celle from a range of date
AutoLoad UserForm ?
saving excel file
compare two ranges in different workbooks and copy data to a new workbook
Print Excel files without Blank Pages
Re: saving excel file
VBA code for Excel File Save As
XL2K: ADO's Find method (once again.)
Query in Excel...
question about the macro vb some one help?
Query in Excel
Re: Resize Dynamic Ranges
Input Box Code Please Help!!
How to extend a standard class (like Worksheet)
Groups and coding...
Can I do this with a TextBox?
created form, want to require input
How to Mute/Enable Windows Sounds whilst running VBA code
Removing Range Names
Run macro after Pivot Chart refresh
Worksheet Change Event
How to insert a bitmap image into a Excel Cell?
Re: Resize Dynamic Ranges
textbox
Resize Dynamic Ranges
List boxes
sizing columns in code
How to insert a bitmap into Excel Cell in C# program?
Tim
Event Procedure Programming
How do I convert Dates from Text back to Date format using macros
XL & Access 2000, ADODB and the Find Method
Get source from a web page into a worksheet
Finding name of last user who modified Excel Spreadsheet
When opening a worksheet I want it to go to a specific cell
auto Filter broken - frozen?? please help
"Refresh Data" Question
Re: Insert blank row between data
Using named ranges in a function
Copying ranges from one sheet to another
Publishing Worksheets as Webpages
Using a field to let user +/- from values.
Macro Modification Help
Unsafe ActiveX Controls Issue
Re: ActiveSheet.Printout
Excel - Visual Basic Complie error
Conditional Formatting Formula
Calling Macros From VB6
recording
Re: saving files in a macro
Excel VBA - String concatanation problem
Help a Newby Please!!
Runtime error 91: Objust variable or with block....
memory problem with excel
TextBox focus 3
Odd results getting files properties
Array Question
Number display in formula bar
A fun but not essential problem...
Deferred Mailing from Outlook
Problems with solver and vba
End-of-line markers in tab delimited text file
Printer Set Up in VBA
Compare and delete cell?
How many new customers every month?
adding XML element using Excel 2003
Why I get "Stack overflow" err 28
SORTING AFTER AUTOMATED REFRESHING OF DATA
Excel Macro help
Chart is being dumped into the wrong sheet
append row
Re: Retain SQL Login information for Microsoft Query using Excel VBA
Adding data from Excel sheet to Access database
Is workbook open on the network?
Copy and past drawing objects name problem
Insert VBA code with a macro in a .xls file by workbook open event
Consolidation: Combining groups of identical items
Shell Command - Net Time (Cannot create text file)
changing the source cell for an embedded/linked object
moving worksheet to another workbook
Help on nested loops
how prin in cells by using vb macro
auto download file everyday
Delete/Hide PivotTable PageFields "(ALL)" Option
Cell Echo Help Required
Need Excel Solver Add-in
Converting to tabular format?
help with displaying information
Macros and if statements
Assign Results from If...Then and Loop to an Array (VBA)
Re: Would like to add 0 counts to worksheet after data is returned fro
Keep my activecell on A1, no matter about the cursor
Scope of macros
Help reading binary file
Problem with using the "Like"-Operator.
Re: Excel VBA Test For Blank Cell
Macro to hide rows based on a zero value in a particular cell
Random Function in VB
Missing movements from kernel32?
Can you sort a list based on catagory names without useing a custom list?
Click Button to Load External Data Into Spreadsheet
Need Help: Dynamic Range
GetSaveAsFileName
Re: ThisWorkBook BeforeClose Event
Re: ThisWorkBook BeforeClose Event
Using variable names in formula
Combobox
RE: If-Then Formula
RE: If-Then Formula
Error 1004
How to select a celrange?
Web query - using cell contents as part of URL
Multiple-step OLE DB operation generated errors
Re: saving files in a macro
Resource / Time consuming macro
VLookup problem
Please HELP VBA problem!!!!!!!!!!!!!
Re: Help getting code to work.
Trying to set cell value using macro
Inserting CGM images in Excel changes image aspect ratio
Need Help Please
Excel VBA Test For Blank Cell
Process data in a sheet within workbook using SQL query?
Excel VBA Test For Blank Cell
Selecting a worksheet with a ComboBox
Conditional formating
Programming command button to execute on a different worksheet
Line continuation error
Problem running a probram using SQL 2000 Job Scheduler
Replace with total
SendKeys to a remote server application
Feeling beatup by Combobox
CommandBar code does NOT work if Excel is Already Open :(
Publishing an autoupdating Excel Worksheet
Count Rows with VBA
Re: Date in userform being saved as general not date which affects sor
Find folder with next to latest date
Help getting code to work.
Searching and matching the textvalues in specific column ranges
Subscript Out Of Range Error Message
Re: Subscript Out Of Range Error Message
Macro to Create text file from range of cells?
Help
Dynamically determining .From address when using CDO
countif help
Macro Help
SaveCopyAs
Opening and pasting in active workbook
Please help..
Scroll view doesnt work in Code
Cascading ComboBoxes
How to check cell data
detecting row or column insertion & deletion
Picture scaling in Visual Basic
Data Formatting
Re: Need help on challenging question
File name into a variable
Programing buttons
Manipulating a Range
Access query vs. Excel query
cell entry
Removing text
opening and viewing an access-database
Re: button in sheet
Formulae to sum up values including special symbol?
Excel 97 VBA - CURDIR, not reliable
Re: button in sheet
Cells format
code interferes with function charts()
Hidden Macro
setfocus on multipage tab form gives error message
Need Help with interesting Find & Replace macro
Excel importing of .csv and .xml
Excel 2003, XML, databases and macros
Changing Cell location within a formula
Addin for Excel - general doubts
Alternative to SendKeys
modifying conditional format
VBA to VB
Worksheet_Change problem
Add-in not working
Excel VBA -making Objectnames variable
Invisible macro?
Excel 97 macros in cells?
VBA - hyperlink
comments' pos
File size grows enormously
Workbook opened with macros disabled
BEFORE SAVE
colour text
Check rows and paste
Crazy problem when using a WHERE-clause in a SQL query
help wanted urgent
help urgent
help urgent
help urgent
Copy PasteSpecial
Disable Save As dialog on ReadOnly spreadsheet
MS Query & Criteria
macro coding
Data Validation Boxes and Ealier Versions of Excel
Using Cell Contents to Reference External Workbooks
Find ColorIndex
Linked excel objects in word, and my resulting problems :)
Linked excel charts, changing filenames generates exception
help: selecting rows within an equation
Userform - Label Caption - How to update from a variable
Replacing characters with leading zeroes
can vba import code to vba project ?
Dropdown Rowsource
Programatically Entering an Array Formula
Select Sheets via Array Macro
avoiding hang when formula is being edited
VBA QUESTION
Combo Box Question
naming ranges
Lookup...maybe
Locate all occurrances of a value then transfer to 2nd table on another sheet
Locate all occurrances of a value then transfer to 2nd table on another sheet
Using array to select rows to copy
disable print option, not Workbook_BeforePrint
value lessthan x and greaterthan y
Problem updating Excel using ado.net
declaring a public array
Disable sheets tabs right mouse button!
How to Reference Global Variable for external application.
Re: inserting a row with data
Help with xlDialogsSendMail or other way
Macro from a different workbook
SpecialCells used to enter data
Next Empty cell after Row A10
Command buttons etc
Counting records in a filtered list
Keeping user-inputted data with pivot table contents
sql.request
Re: readonly attrib on a open workbook
Adding Range for Search
Re: Run-Time Error 1004
Self-Resizing Formulas
Help with VBA/macro for Excel data
Creating a new sheet
Converting a Date to a string
Converting a Date to a string
Excel Clipboard Problems
Re: Importing web data to a VBA Array
Unprotect and protect....
using functions as parameters
using functions as parameters
If Satement Modification
Deleting Duplicate Rows but keeping the most recent.
What's wrong w/my code?
Re: Adding values in textboxes?
sendmail issue
SeriesCollection
Simple If Statement
Haeder/Footer param
Find text in Column to sum
Freezing panes?
Help ¡¡¡¡¡¡ Please
summing range
AutoSave a WB copy everynight at midnight
Re: Right Function Doesn't Exists in Excel 2003?
Launching other Applications from Excel
Run-Time Error 1004
Re: Run-Time Error 1004 Copy method of worksheet class failed
Selected Cell equals x then..
Excel 2000 VBA - Set Print Range in dynamic range
Re: attaching range (from different rows) to combobox
Re: Force a Number to be Formatted as Text (keep leading 0's)
variable inside a formula?
Re: Formatting Number as Text
Re: Resetting menu option on close...
To Mark Rosenkrantz
Formatting Number as Text
Formatting Number as Text
Formatting Number as Text
Excel spreadsheet/template for developing a retail price calculation
Formatting Number as Text
Re: Two Questions.
Re: How? Can i avtivate the buttons
Re: Control
Re: OrIf formula needed
Re: Calling a private sub
Re: If-Then Formula
Re: Hi
Re: OrIf formula needed
Re: faster than VBA macros
Re: Run-Time Error 1004
Re: Combobox Problem
RE: Run-Time Error 1004
Re: Inserting rows with a formula
Re: If-Then Formula
Re: Looping Through Names
Re: Combobox Problem
Re: inserting a row with data
Re: Adding values in textboxes?
Re: Looping Through Names
Re: how to format a date/validate for a text box entry on a user form
Re: copying cells
Conditional Formatting comparing multiple values
Re: How?
faster than VBA macros
Re: Macro code question
chr() for quotation mark
Re: Conditional Formatting comparing multiple values
Re: Sheet After Double Click event?
Re: Inserting text to certain cells
Re: how to disable listbox change event
Re: User form search criteria example
Re: Conditional column selection
Re: Display values in combo box
Re: faster than VBA macros
1st attempt vba-how do i whatnext in this sub
Re: Protection Error
Re: Inputbox to enter date
Re: Adding values in textboxes...
Re: Positioning a graphical object
Re: Adding values in textboxes...
Macro Names
Multiple conditional on conditional format formula
Protection Error
Re: Multiple conditional on conditional format formula
Activechart.SetSourceData Source???
Excel 2000 VBA - Selecting populated range
Macro Help - check existing tabs
progress message in status bar
Worksheet change code
IsArray on Variant/Object/Range returns true??
Frustration -- >Filtering a list with the click of a Button
Error missing file when running macro.
Placing checkmark beside menu item
ActiveCell.Address
Excel 2003 - Showing Userform
Automate delete macros
Protecting a sheet with filters
pulling out info. seperated by a comma
Sequential Page Numbering
Changing Excel Object's page setup wthout having a printer installed
Object Variable question
Control & Break
Pocket Excel
Validation Drop Down
Default Path for Add-Ins
VBA-Make Custom Menu Item Fire
Concatenate function with 200 arguments
Inputting data on one sheet and automatically updating other sheets
trouble with a listindex value...
Getting records from Access 97 to Excel 97
VB Delete Sheets
Pivot table giving an error
TextBox focus 2
Set range based on cell contents - help required
Extract MS word data to MS Excel
Formatting textbox currency on userform
Sub Menu Items
Worksheet name
Workflow OnExpire Event
Finding and pasting over a row
matching rows between worksheets/books - best practice
How to handle other workbook events through personal.xls workbook
flickering organization chart
How to use mouse events inside an Excel Sheet ?
How to create a Macro to Copy Information in one sheet to another sheet.
Clicking the text in a textbox erases all the data in the box
Excel Macro - Relative Path
Copy and paste
Transpose Dynamic Ranges
Re: mswinsck.ocx
Converting Time in a userform
Locking(?) an excel session
CheckSpelling + TextBox
email question
works on 2000, but not on XP
It works on 2000, but not on XP
Re: Copy cells
GetOpenFilename changes dialog to modless
How to get the macro record button back
One on One Training needed in Houston
passing variables
MACRO for copying active sheet without using a certain name
DisplayAlerts Error
Excel VBA : Coding Problem
Mail
Excel Pivot update from Access
Find column name/number of a value in a row
Excel trouble
xlDialogsSendMail
Assign named ranges
Combining Macros to make one Macro.
userform & textboxes
Excel and Outlook Email
Macro syntax error when running query
Define a Dynamic Range Based on an Index
Customizing commandbar problems
Open Macro Dialog Box
Is it memory problem?
right-click shortcut menu
help with hide or delete
Precisely reposition a graphic
Labels in User-Defined Function Not Working Right (First Problem)
Macro again...
Mapland Excel Addin - Programatically Create 1000 distinct maps
TextBox from Drawing toolbar - 2 questions
Referencing Listbox on Worksheet
Splash Screen
macro prompt to show/hide rows
Setting variable = to sheet name
Spin button questions
help: extracting Execel tables with ADO without reordering them
Dumb Question
VLOOKUP for spreadsheet compare
Up Capture
If Then
Visual Basic code help needed
VB.Net: Create Excel File/App?
userforms
Inserting Blank Lines in Selection
Splash
Email using CDONTS
please help...
Re: Hi Guys...
Getting Grades
"Last Saved" information
Calendar Control issues
Functions returning multiple answers
NEED HELP ON FORMULA!
Excel 4.0 Macro to VBA
select a range base on Column A
Keybindings Collection in Excel
Movement
parsing complex numbers
How to tab to a command button?
Date checking
WAV Files
Offset
Delete a Macro
Deleting
error message on combo box
How to Activate procedure with parameters
auto fit-wrap texted merged cells
Help needed...
macro to create a chart from several worksheets
Prevent User from saving
Pivot Table - Sum up Average's in Pivot Table
VBA Integrated Development Environment basic question
SQL statement returns zero records
Excel If Statement ??
New Menu Name
inserting a formula with reference to a new sheet in a cell using VBA
Load and Unload Form commands
ADODB Recordset problem
Merging cells must be text format
Running Powerpoint from Excel
macro to run a separate macro dependent on value in cell
Playing music
Is there an easier way?
How to use digital certificate in xls file
Problem Loading Data from SQL to Excel
on error error
ruuning part of a macro from another macro
VBA for opening file/populating combo box with sheet names
English and American dates...
saving excel 2003 file in excel 97
Help on counting occurences
Hiding columns
tuning possibilities with checkboxes?
"LabelColor" an appointment in Outlook with VBA in Excel.
Does file exist?
Copy the results of an Access query into an Excel spreadsheet
Is workbook open?
Is workbook open?
MultiSelect Listbox (Forms Toolbar)
Macro to Insert Rows After a given Text in Col A
Renaming Sheets automatically
Maths-Integration
save file via Marco
Help with very repetitive task in excel...is there an answer?
option buttons run Click code when value is changed via VBA code
templates
combining cells' data into one cell
Capturing an Error
auto type text onclick in a cell
Sheet Update Help
Help in calling excel files under portal
Please help with inserting hyperlink
Change range name
search or goto command needed.
if then elseif on text file imported into excel
rename sheet automatically
Change the assigned chart number
"Pausing" a macro for recalculation
Locking VBA code via Project properties but cannot save the workbook over itself
urgent!
Get Date today from WeekEnding
Solver: an unexpected internal error occured, ...
Solver
Text and TextBox problem
Artistic Spreadsheet
Macro
deleting rows
code help - onkey
user defined functions
"Member not found" exception...Help!
Paste range of cells on E-maul Msg Body
Date formatting a file
Rounding & Formula Bar
How to format listbox
Cost Transfer System
Thank You
Populating data on userform
how to protcet my code?
Add an event / meeting in Outlook via Excel ?
Modify a conditional format formula in code?
more than one item Y/N ?
how to call Access's function in different module in Excel VBA
Text Box Focus
urgent-pivot table
Charting by column name
inserting a column to the right
Multiple conditional branching in excel
Progress Applet
Changing this code ... Please advise
Code not rounding
create a subset range in a VBA UDF
Loss Deviation
Thorny Problem
UDF Help.
Date local format
Same workbook, different problem.
How can I do this
TextBox - CheckSpelling question
help with macro
Code generation
Sending Mail from within Excel
changing format
Help with VBA programing
Importing a document
Identify Cell Color Index
Removing conditional formatting if it exists
Counting the number of different names in a row
Getting rid of one side a border?
Changing a conditional formatting formula?
Changing a column's number of decimal places
Sheet number
Chart - display point details on MouseMove event
excel missing library
how to call Access function&module in Excel VBA??
summ gg
RE: Excel:Runtime Error 7 "Not enough Memory" with CreateObject (SAP.B
RE: Carriage Return / ALT-Enter in Textbox control
Date format
Excel shortcuts in Root Directory out of nowhere
rename sheet automatically
GCD & LCM: ANALYSIS TOOLPAK
Re: Creating a list of directories
I know selected picture is a shape but typename says is picture
excel VBA - keypress code
Progress Bar with Timer
Slow Array formula or is there any alternative
PS to PDF Problems
[/B] Problem: multiple DATA SERIES [/B]
Populate cells with arrays
Select a range and copy to new workbook
Best Way to protect sheet & workbook with VB
Time formatting
Canceling SaveAs dialog box without saving workbook
Macro doesn't perform correctly when using right click menu
Re: Copying merged cells
INSERT INTO..SELECT
LEAP YEAR Validation
dynamic multipage
Help!!!! Selecting a cell in another workbook
How to make the macros work for different Excel versions?
Excel VBA - Has someone already created this
Importing with ODBC
web to variable
Excel VBA INPUTBOX() - Please Help
Hiding 0 in Pivot Table
Re: Copying merged cells?
if a cell is >0, how do I select a range of cells?
Increase a range size by X rows and x Columns...
Creating a log sheet
concatenate two cells, but with conditions
hang when formula bar open
looping through to assign type
ActiveXTextBox with SpellChecker ?
Display range values
Searching multiple files and copying text
Update Range upon Load
Cell referencing
Updating For Loop statements
Change Formula Name
which optionbutton is on
Input VBA
copy cell to another specific cell
Macros not working in different versions!
PivotTable Field Selection
Excel VBA - Type mismatch during While
Long autonumber beginning with a 0 (zero)
Invalid Property Value Error
VBA - Transferring Information via "If - then"?
Can we copy a sheet from workbook1 to workbook2 with out open workbook1?
Re: Identifying Button Clicked
Date
RE: VBA macro to join up strings
Re: Identifying Button Clicked
Re: VBA macro to join up strings
Running Unix commands from within Excel VBA
Re: Timesheet /sum client fifteen minutes intervals activity
Problem with a macro
Conditional Mean
Re: Carriage Return / ALT-Enter in Textbox control
hiding processes
Input Box
Re: Deleting Columns in a range through VBA
application.run for returning arrays
Range type variable oddness
Re: Win32::OLE.pm and Hyperlinks
Re: Colorindex in a Conditional Format
Re: Passing Variables
In Memory Recordset Without Creating Database
Re: SELECT statement
Checking if Target is within different ranges
vba command button
Textbox restriction
macro - copy values only
Finding Last Row
Searching across all sheets
VBA retrieving row and column info from user supplied range(s)
Excel crashes on close - macro related
Listbox - write newly selected item back to the worksheet
Can't fix VBA code of workbook - Form
need to ad one more step to code
Display data in form from worksheet using Filter
Efficient User Form vba coding for saving to worksheet
Hide rows before printing
Adding to List Box
Hiding 0 values in Pivot Table
#VALUE! from OLAP CUBE
Creating a sortable column
print userform and setting margin
Find last real row of filterred data table
Help with Message Box Please
Loop cells - get all rows with matching data - paste into different wb
algorithm to INVERT a multiarea selection ?
Array Combinations with a Twist
Re: Returning to original workbook
validation of input in textbox
Customizing the tool bar
Capturing an error and then ignoring it
opening worksheets
Option button problem
ByVal?
Automatically paste cells that return a value, otherwise maintain existing formula.
Selecting specific excel charts using VBA
Setting chart data range automatically
ListBox Error
Formatting worksheets
Help
VLOOKUP MACRO
Giving help to the user of my function
Printing worksheet with printer tray # 3
Active Sheet
Excel VBA-Changing cell color with if then function
Calling (Function?) from Userform_Initialize to generate list of unique values for Combo box
select date range and copy
Deleting worksheets
Count rows in text file by loading into array
Formatting text with VBA
How to capture screen through VBA?
changing nested if statements into a user defined function
listing sheet tabs
Excel 2002/2003 Macro Compatibility issue
Addresses To Columns
MVP Site
Creating worksheets with cell values as names
Converting text files to Excel - a difficult one
function 's cell caller
Microsoft Excel Error
Pop-up box with no 'okay' buttons
Turn Off Macro Warning
Pasting Data in VBA
Enumerated constants defined where?
How do you delete a row in a macro?
VBA IDE
Is there a maximum number of Add-ins allowed? - strange Excel behaviour
Return Row Heights for Rows in Active Worksheet - an example
Fill in forms
Hyperlinks.Delete without losing formatting?
Re: Slow Code
Linked DropDown's
ISNumber VBA
Re: Splash screen stops Solver add-in working
Addin installation
Size Format of Images in Worksheets
Re: Copy range content as picture - truncation problem
ActiveX combo box
Re: Delete VBA code in worksheet through a macro