Excel Programming [Archive] - Page 47

Excel 2007 for next loop bug
What is the quickest way in Excel 2007 to export all modules?
Limitation to Number Format in VLOOKUP?
linking problem
help for applying formula
Reading a Range from a VB6 DLL
Reference dynamic filename
Reading a file
Speed of fixed array versus dynamic array
Convert to Number Issue
How to create a To-do list in Excel20003
forgot the password
VBA look and Replace
Backup routines
How much slower is Excel VBA compared to Visual Basic .net?
How to do it on excel?
Printing contents of an array into a message box
Text to Column with fixed width in VBA
User Defined Types and Overloaded Operators
Excel 2000 issue with ComboBox list entries disappearing
On excel, can customer ID generate name address field?
How to detect locked linked xls file ?
what happens when this code is run?
Update when worksheet close/delete
Changing AutoSave location programmatically
range not carrying over
How to prevent vba code from running?
Need Help - Small Macro
"Add/Remove Rows Code" adds rows on grouped sheets, but won't remove rows.
command button caption
Searching external file for values
If Cell is Null Enter Value of Cell Above
Select range on a worksheet
User Form List box, unique records listing
Code to run Value of cell rather than the Formula
using selected data from a pivot table to populate new list
using selected data within a dropdown list to populate new list
Button Problem
Pivot Table help.
VBA statement "scroll active cell to center"???
Toolbar already exists, but where?
Wrap not working
Please help with my code
Mandatory Cell
disable a shape
Error handling issue
Modifying code to save data
Error Handling Issues - Pls Help
Initiate Macro via change in drop Down List
Export from Access
Search within a ComboBox list
Declare Function for global use then call on change event
Reusing Form Code
Looping through
Err 13 Cant find problem
compare 2 x files with same colum labels but different aranged da
Count Red Cells on a worksheet
SourceData of a chart
Numbering cells in a range
How to get of all number rows in the autofilter range
Accessing Excel worksheet names via ASP.Net 2.0
Addin interference
german text in english xls
Loop and simple calculation
time
Problems with application.worksheetfunction.correl
Error 13
Calling Fourier plug-in from VBA
User Defined Functions - Input prompts
PivotTable VBA help needed
check if values is already in listbox
sending message
Spreadsheet does not recognize my VBA function
Merging data between worksheets using reference index?
My Type Library is not complete
Password Protection
Sorting macro
Remove VBE Component failed
File Properties Location retrieve to refresh background query?
Late Binding access reference in Excel Module
Table ranges do not work in multilingual configurations
Declaring a collection as a particular type of object or a particular class
Data not recognized as a number
clear contiguous fields with one keystroke
Do Until Loop
Find text then cut and paste it
AutoRun
Delete in different worksheets and workbooks
VBA codes to get dates of files in a folder
Deleteing columns starting at a certain row.
Pictures on worksheet flickering as they are repainted
Hide Code
Rename Parent worksheet.name?
How to move to next cell automatically no keystrokes?
How to limit scrollable area
Macro to Conditional Format if cell contains a word
Userform Question
Get data from Access tables in an Excel pivot table
List box style
String Compare... Tough one?
Printing multiple embedded Word Documents
Re: Insert Existing Data
Macro type
Change width of 51 Columns
Hiding / unhiding rows based on change of a cell
Please help with my code
VBA can't remove drop shadows on bubble charts in Excel 2004 for Mac
Textbox.Value as a new text file
Using an Excel Spreadsheet as A Data source for Miscrosoft Query
automatically sorting
lock cells based on formula
VBA Code Colors
Linking Problem
Excel 2003 DataForm
How to activate a text box
91 object variable or with block variable not set
On Change Search for Value
Generate a combination list of values
Identifying whether an excel file exists
Data Selection for graph plotting
Hiding Named ranges
Email file properties via command button
no calculation during readin large cols (Speed)
Find last used row in a column (not in the whole worksheet)
Re If statement....HELP!!!!
Close workboook if it is open
Create Summary then export
Extracting data into a CSV file
Using cell color in conditional format makes Excel unstable
Formatted word file from an excel file???
RTD Wrapper called for every cell in an array formula
atm project
textbox backgroundcolor
Application.Enableevents = False doesn't stop all events?
Refer to workbook
[Automation] Why do my cells with formula appear as text?
Long Code
Calculation Project Date skip Sun and Sat
Evaluate Formula with Named Ranges does not work if Workbook isalready open
Evaluate Formula with Named Ranges does not work if Workbook isalready open
Evaluate Formula with Named Ranges does not work if Workbook isalready open
RE: Insert Existing Data
Return Largest Value in an Array
Cut & Paste Excel Format & Values to New Folder in PdF
Button Won't Work
VBS Script and ClearContents -- Code Throws An Error
Error 461-Method or data member not found
Transfering spreadsheet data to a master spredsheet.
Error testing combobox to variable
store default printer, change printer and then restore default printer?
Stubborn Excel Options
VBA Automation advice
Edit Query Window
Change Font Properties causes Excel failure on Save
Do Loop Goal Seek won't End Sub
Copy userform
Entering text in a Form
wrap text with quotes ("")
vlookup query - 2 parameter check....
Best way to send disparate cells to database
Protecting XLA
Change workbook path in formula
Apply footer code to all new workbooks
Need to find and collect all cells with a certain word onto a shee
ListView control in Excel 2007 jumps!
Pulling Data from one sheet based on value of column
chart and automation error
SaveAs in xlNormal Format
cell address of hyperlink
PasteSpecial failure
Enum Members Declaration
How to update data in a Control ?
How do I STOP excel from making a Backup"filename".XLK file
Changing From: emailing with Excel...
delete element is collection
Conditional Data Validation
Remove and Add Text to Numbers
Worksheet saved out as new workbook
Code to filter a database displays no rows at all
How do I show a "list" in an "if" statement?
key assignments
custom menu disappears when I File, Exit, Cancel
RE: custom menu disappears when I File, Exit, Cancel
Copying and Renaming New Sheet
Find a cell based on current month
Page print margin
ThisWorkbook Problem
Select method of range class failed
Disable Worksheet_SelectionChange macros
Data search and extraction from multiple text files query
Copy after autofilter if range is not empty
Can I get Excel to import XML like Access?
Prevent the user from Edition / Erase / Format
WorkbookBeforClose -> Cancel = True still closes excel
Moving rows with grey background color to bottom (2003)
Error with currunc
Create DLL
Filter a protected shared worksheet
changing tabs from a cell from a difference sheet
Limits of Excel
Accessing another instance of Excel in vba.
Not a 2nd print from the preview
Sorting triplets...
Re: select specific sheet and cell
Re: select specific sheet and cell
1004 error when saving as CSV
Is there any efficent method for searching in a large excel sheet
update all hyperlinks to another drive
Format Text & Numbers
Iteration funtion
Deleting rows that meet criteria
If and vlookup in macro
Write to Webpage
No Prompt for Read Only
reading range of data from excel sheet in C or C++
Set Cell.Value = text & dynamic value
Creating an Array from A Sql Statement
Trouble with arrays (transferring values between two arrays)
Code that sort of works
DataForm Fields
Copy non-contiguous cells from all workbooks in folder
Constants Tied to Arguments in Methods
Saving worksheet as CSV with correct usedrange...
Excel 2007 User defined fucntion, cannot paste in mutiple cells
Delete sheet on a condition: debug error
Cell Format
Exit from Excel edit mode using IDispatch
Scaling problem with userform labels
How to reset Used Range property of worksheet
Excel Developer Version Solutions - are there any?
Shell Problem
Open MS Project From Excel & read Task Properties List
selecting worksheet by its index.
Controls Array
If then else
"Sort" macro in late bound code
Please, help!!! How to keep userform from being moved?
Save data entered into UserForm to be Edited later
Error Adding to Spreadsheet Please help!!! Complex ?
Pivot table refresh automatically when data changes
Pivot table refresh automatically when data changes
Converting Excel files to MS Project
Stop Multiple Macros
Run Macro When Specific Sheet Selected
Caling fortran from excel
copying worksheet to another workbook with a macro more than once
Bordering Groups of Data
Comparing 2 cells using vlookup
Persistent classes
How to select a range and save it as a picture (.gif, jpg, bmp, ..
Searching for first 3 characters
Multiple Printing
Run time Error '1004'
Copy from one box to another on a user form
run stored proc from excel with a parameter
Button Question
copy and paste
Page setup VBA help please
Re: Vlookup Using VBA (without using VLOOKUP function)
FilterMode does not work? Excel 2003/XML
Conditional Locked Cells
How do I create a string from a range (Excel VBA)?
choosing from drop down list
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order)
In relation to coding
best lotro gold ,wow,mmo,how can i buy the cheapest gold
best lotro gold ,wow,mmo,how can i buy the cheapest gold
word processing within Excel
Seperate massive data within 1 cell into individual columns
Find range differens between two ranges/areas?
WinDBPro. Ver 2.0
How to create a setup of excel application with macros in it
how to select a single column when this column cross a merged cell
Reference different versions of Access
Deleting a macro using a macro
Formula for S-Curves?
add new chart in 2007
sql issue
performance question
WairForInputIdle
Cell Value to String?
Custom Menus With Excel 2007
how do I combine multiple excel files into one?
Is this even possible with VBA?
Filling an array with ranges
copy and paste
Inserting chr(10) from script
Statistical function problems
Excel application level control for Excel 2003
macro to change tab name to file name
Accessing data-subtotal via VB
hyperlink address
HELP!!! Promelem with InStr(1, c, Sheets("TEG").Cells(i, 18), 1) >
get values and colors back in a cell
How to know which pivotFields was changed through Private Sub Worksheet_PivotTableUpdate
Is there anyway to retrieve Registry Values from VBA???
Need macro to go to next blank row, copy formulas into next row
Object Module Constants Scope
Formating
Sum based on ranges pivot table?
Auto Close Yes no button
Inserting 2 rows above a certain cell
Naming a cell according to its contents
Query SQL Data in Excel with a function?
TextBox Accessing Contents
2007 UK Excel Conference - Nov 29 - Dec 1, Cambridge, England
Application.Match on an range defined to a variant array
Can this Code be Condensed
Graph on a form
finding values and put them in a listbox on visual basic form
validation
Help - Create a range that will update automatically to be used in formula
mail merge
Overwriting existing files
Keep Change History For
can someone please tell me what i did wrong with this if statement?
Conditional Formating
Pause a macro for user input
Add value if date is in an interval... tricky?!
Booking sheet
lookup formula or a macro?
Problems with a Combo Box
visual basic - select/activate but don't show sheets
Programmatically setting Conditional Formatting to a range of cells
How manipulate a picture with recording macros?
solver problems
Initial position of floating toolbar
Macro Recording Excel 2007
Clear check box problem
validation if a string is a proper function's name
Call back a Dim variable
Office xp
Add leading zeros fill space
Using Worksheet_Change(ByVal Target As Range)
How to copy and paste row as a text within workbook including numbers
KeyPress: how to delete last character
run macro whenever any cell is changed
Breaking a row into multiple rows
RE: !!! SOFTWARE 4 SALE !!!Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â *Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*Â*
Using SumProduct in Code
Excel - Passwords
Calculate the number of days between two dates
Text formatting
number formatting
Create Outlook Contact Error 13
Problems evaluating defined names in VBA
multiple sheets
Re: compile error, need to simplify/shorten
list worksheets in a workbook.
copy previous row down 5 rows
End sub routine, move to next
Change Cell focus base on value in first Cell
Average data and delete a row-need help
Making 5 Minute Wind Averages
Code to change code in a sheet and workbook module
CommandBarComboBox : AddItem - procedure to attach routine.
Store strings in a Define Name
Find a picture on a worksheet
SUM function Help Please
Using VBA to print a range
Scattered Cell entries into one Column
Re: Please help me simplify the given code
From Column A get Text from Colum B
Can Excel 2003 VBA module be renamed
Re: Pass named range to user defined function returns #value!
Help wanted
Re: Pass named range to user defined function returns #value!
Re: 2 Lists but different time frames.
RE: Dynamic formula creation and p;acement
Variable in Message Box Q
Need help with Visual Script Code
RE: Copy formula to cells on the basis of value in row 1
Re: Code Execution Has Been Interupted
Digitally signing VBA Project
RE: Spreadsheet to access
RE: Vlookup Using VBA (without using VLOOKUP function)
Re: Pass named range to user defined function returns #value!
Subscript out of Range Error if Null
Is there a way of finding if the user is a system administrator?
Range Next
Seelcting specific sheet and cell on startup
Delete rows
Wild Card in button caption
Recording a Macro
How to offset a row
vaRecipient = multiple names
Benchmarking Range to Variant times
Error 1004 Display Alerts
Coring on calling VBA6 dll
Rename Modules
New to Excel programming
Run loop until
remove "+" from =+ABCD.
Capture Forms button caption
dsum evaluating only the beginning of a string?
how to separate sets of text and numbers in a line with a macro co
Workbook.Open() Fails in Vista
Macro to Add Comments to Cells
Closing file with Macro
Excel 2002 has encountered a problem and needs to close /Code Clea
Cant Digitally Sign Excel VBA Project
roto13
CONDITIONAL SUM WIZARD.
wild card *
Calling Functions
How Can I Loop through all the range names in a workbook in VBA?
PrintOut problem
Open excel file and reffer to specific worksheet
Using Mappath
Excel wants to save an open file to another filename in VBA script
cannot autofill 2 cells info at the same time
Object instead of passing arguments
Digital certificates
recursive or loopless combinations
Aplication.Worksheetfunction.MAX() Stopped Working
command button
find cell address of last active cell in range
Sumif - Non Contiguous Columns - Syntax please
How to change textbox caption in Active sheet from UserForm
Setting Range Name using R1C1
Apparently not possible?
Command Bars
Validation List
Removing an addin from the available addins list
Is there a way to change columns index with Excel 2007,or is it a
Group and ungroup
Splitting strings, error subscript out of range
Possible bug with clipboard data? - Need Advice
Drop Down Box - Deleting Items but it repeats what is left
limiting rows
Find Certain Cell Value and Print that Page Number
Writing a Macro to Find & Delete Target Rows in a Range
Make file drop dead on close
Manipulating Arrays
Textbox control
No need to register assembly of DLL written in C#
AUTO/MANUAL Calculate in Excel when opening *.slk files
Pivot Table - I can't delete unused values in selection drop-downs
Pasting info from another sheet
Loading an Excel User Form
Messed up references when copying sheets from one workbook to anot
Copy Sheet
Macro to remove word from text in a cell
Printing move my camera picture
Using a named range as a source for a combobox on a userform
passing a parameter to an excel macro from a form control
If Folder Does Exit Create
Clearing the Contents of a range of cells
Printing macro code
Copy row to next empty line
Excel charting options using VBScript
Calling a function
Copy and Paste
Error Message Box
RTD cannot return an empty value
If Null Set Value to Zero
evaluate a year expression
Response to Userform Problems?
Trouble reading to object
Select Multiple Ranges with Certain Data to Print
Userform problem?
Establishing a default on dependent data validation lists
Control names on userform
Search cell for string
Excel 2007 AND Retrieving Data from Stored Procedure on SQL Exp 20
Open another program (VNC Viewer) and insert an address
Simple Macro... i guess
Open excel workbook within macro
Solver programming in VBA
What Name for GetIDsOfName() ?
HELP!!!!!!!!
Userform with Unicode strings
Query - Formula (Test for string)
If X = Array?
imput box
do we have constants for maxRow (65536 in excel 2003) and maxColum
sending active sheet by mail without macro (from Ron's page)
Move cursor out of sight
excel file properties question
Combo Box_Change
Nesting Collections
How to make Class Module universal
Work book event code help (re Bob Phillips)
UserForm Window size setting
Delete a Pivot Table
Convert string to date problem
System Errors Occurs Enable Macros
vlook up formula help
Export 1-dimensional array values to a two-dimensional table?
How to save OLEObject to hard drive?
"Or" statement not working
Macro
open outlook and add email address
Circular Reference Notice
Excluding one page in a macro
Multiple printing of cell data onto new worksheet
help Compare string to Combo box!!!
Relative reference to current cell?
Old question new twist?
How do I macro sort with a varaible range (differing last cell)?
convert a range of text into numbers
Advanced Filter Advice
Help with programmingBorders
error when opening a workbook
Run-time error '-2147418113 (8000ffff)':
Camera Tool
Disable Security Warnings Screen
Cells not calculated
Not getting the values
Summarsing Variable Pivot Table Data
Dynamic Conditional formatting
Consolidation
Automatically Execute Excel Macro at 6:00 am
Auto Filter-VB
same than end(xldown) but stops on hidden cells if not empty
Selection.Copy on Temporarily unhidden excel sheet - possible bug?
Fill Down to Stop at Last Row
UDF Prompts in XL2003
Linest in VBA problem
Copy values in a range to memory
Set Range of Visible Cells
Can I learn VBA quickly and how?
How to do the filter when applying formula to a pivot table
getting file path
send o outlook graph in html format
ArrayFunctions: How do I... ?
import data from excel under Mac OS
Need help with Excel Macro for searching
for each in range gives variant array
range or string or long type
How to use Decimal data type?
convert text to number
Data inside Cell Seperated by comma
Upper case in textbox
Copy Excel Ranges to PP in Office 2007
Replacing information
Sort by more than 3 criteria
Remove non-printing characters
Do Until Inputbox = loop count
Help with Date Format
u mann whitney
xls to csv conversion
help - how to list all excel files in a folder
Export from Access damages my Excel-Workbook
Passing a value to another macro
Compile error in Userform macro
Can I create custom symbols library?
Can I create a custom symbols library?
Excel Open error
How to check date format in display cell value
Access vba to Excel
do not increment variables in excel
Creating a Copy/Paste Loop
export excel entries into a calender format such as Outlook
Opening and processing all files in a folder
Copy ranges into email - HTLM and Text format
Button with hyperlink and asigne macro
Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data
formula not working
Conditional Formatting - Range
Counting macro
Macro misteriously crashes Excel 2007 - but not 2003
Validation code not working with pasted data
Formatting and Ignore error
change column fill color
Data Selection and Averaging
If a cell equals then macro
Excel AddNew QueryTable '1004' problem
What does the compile debug option do?
Problems seraching newsgroups with Google groups..
Excel Automation
How to paste data into sheet?
How to paste data in new sheet?
Trim the entire range
Nested IF's
Conditional Formatting - Color row based on one cell value
Disable inserting or deleting row in selection of rows
Excel 2003 VBScript
Hide Headings / Group
Technically, can anyone explain to me why Cells.Find() is so much faster than a loop?
PasteSpecial Excel Chart in Powerpoint
Disable Dropdownlist (Combobox - "Form Control")
Help with creating code??
select multiple cells
Use VBA macro to populate formula result in 'next blank cell'
Loop through SpinButtons on a Worksheet
Help to improve UDF please
Search column
difficulties using vba to save to the desktop
Copy Data From Worksheet to Another Worksheet
data validation defaults
Events are not disabled
VBA is Mangling a Query
Defined Name Formula
Can I Write A Macro That Will Execute Fomula In The First Empty Ce
CommandBarButton with toggle property (up & down)
Picture question
Enter login details on a web page using macro
Data mining
Load TextBox With Search Result Cell From a PAge
Loop through column(s) to check values, perform action based on check
USERFORM X BUTTON
Ditributing ComAddin's & ActiveX-dll's in Vista
function with a range as a parameter
Using FSO
Copy row 21 from all sheets to a new sheet except " summary"
How to manually regist the com add-in for excel2007
mininum with referance
Error loading type library/DLL for MSFlex Grid
Progress box
How do you do a file search in XL2007
Full hyperlink issue, please help - end of my tether lol
Macro to run an Existing Microsoft Access Macro
Complex SUMIF
separating data from imported txt file into cells
Code is changing date format
Re : Excel CheckBoxes to be activated by VBA
No Out put from UDF
Adevance filter using VBA not show the requested data
How to return column number
Character Month from Date Data type
Custom help attached to CommandButton
Game?
Average the sum of numbers in a list or table
Data Recovery
VB code for Excel sheet
Inserting Many Images
Question on Web Query .iqy Control Variables
Automation error?
print multiple sheets with page 1 of 2 type
Paste formula in a specified number of columns to the right
Excel Conversion in Progress dialog
Want to find/read excel files in SharePoint
another autofilter question
automating linking icons to different hyperlinks
Excel automation: how to disconnect correctly?
Join two tables
Break Up A Spreadsheet
Excel DocumentProperties
Excel VBA - Max Function - Syntax Error
VBA chart problem
Excel date conversion in .NET
update validation when change source
Looking for VBA sub to Invert and Multiply matrices
Automated .PivotItems boolean value
PivotChart Formatting and screen updating
event failing
UDF to find end of range
Calendar Control for Excel 2007
Adding the values of a sorted column if some cells contain #N/A
Print spreadsheet replacing recipient name
Error 91 Object Variable not set
Merge multiple worksheets into one worksheet.
macro to compare data in column A of sheet 1 with data in column A of sheet 2
Macro to add three seperate groups
Vadlidation code not working
Breakdown Excel 2007 worksheet to 65,000 worksheets for Excel 2003
Run-time error 9 when trying to copy a worksheet
Countdown Timer - not stopwatch
Create rows from existing rows
How to instantiate Excel 2003 when both 2003 and 2007 are installe
downloading, opening and parsing a csv file
FaceID for CSV-file (Icon)
An easy question
Office 2003 Buttons Invisable on a seperate computer
Use Access VBA functions from Excel
Change Negative Numbers to 0
execute formula
Find and Replace Dates in VBA
Spilt data into two columns
Workbook_SheetSelectionChange in an Addin
Function Error, Returns 0
Select limited character of a cell
char to numeric value
Com Addin Issue
How to cancel midway?
Year Date Format
How to run VBA code at low priority?
Year date format
PrintTitle using macro
Somekind of lookup?
excel file size problems
Dialog Box and mouse selection
Name of SMTP server
Using Now with microseconds Excel 2003
range.comment.Text(...)
Function prototypes in Excel VBA
The excel calling msquery question throught DDE
the excel calling msquery question throught DDE
Autofilter on non-active sheet
Checkbox from control toolbar macro
VBA - identifying which worksheet is active
VBA - identifying which worksheet is active
Non-zero cells returning zero
Print on worksheet
Loop and variable type
Sending e-mail with Excel
best approach for overcoming Input box errors & code optimisation?
Re : Excel VBA Array to be expressed as a variation of Partial Dimension
Excel Automation
Easy Loop question (with delete row)
Can I create a macro to adjust the height of the cell according t.
Pro Football formula automation
Ribbon events???
Using Autoshapes as macro buttons
Help with applying code
accessing data in backend workbook over vpn, is it possible?
Macro to enter week day dates only
Enable or Disable Forms Button on a worksheet from code
Inserting Pictures Based On File name
Why does ControlSource in Excel return a US-formatted date
Problem with Excel 2000 automation
Compare Sheet1 value to values in Sheet2 Column A
Pictures not displaying
RE: Help with code issues
Having data source and query code issues....
Repost: Update querytable connections and refresh data
Comparing two columns in two different worksheet.
Macro to enter week day dates only
How to test Excel 2003 & 2007 macro security level
Date format on opening a csv file in Excel 2007
Help with code issues
Unable to Read file
Str function does not work
Sheet change or sheet calculate?
Question on VBA : how to detect "idle" condition
Macro
Number of Columns
Increment Letter in a String
combobox population question
Charting from a different range location
Can anyone recommend a good book on xls query and pivots
Speed Up this Macro? Part 2
How to use the name for an array by using a variable?
Code to delete shapes each time a sheet is deactivated
Event Macro - On Cell Activate - Change Cell Format
Code stops after column "L"
Avoid Scientific Notation
Unable to read file
change attach workbook code to worksheet
Combobox questions
Auto row insert
compare contents between sheets and identify matching values
Unable to read file
Pls help me in finding duplicate entries in a column range
need macro to save HTML pages as PDF docs
Close Buttom
VB CODE REQUIRED..........HELP PLEASE
Aiuto programmino con array
please help
Changing a macro from a specific worksheet to any worksheet
How can I refference then search text in a worksheet text box
Named Ranges in Functions
Starting a Macro where the cursor is
type 13 error
Excel 97 - Excel 2003 Macros
Speed Up this macro?
Move and size a object on the sheet
Moved cell & Ref
Use SUMPRODUCT and avoid rows with #REF!
Using an Input Box To Define a Range
filter duplicates
Excel Formula or Macro
ActiveChart.SeriesCollection(1).Points(3).Select ERROR
Centralized event handler
Data Validation based on first, second or third data validation li
Limit the input in a cell to a single character
Using ActiveSheet to Disable Multipage1
Excel 10.0 Object Library ---> which Excel version is it?
how to select cells from a non active worksheet
Inserting rows
Creating a Check Box that produce true or false statement
If Font.ColorIndex = 3, Copy Entire Row and Paste to New Sheet
Help with code repair
Formula in a macro
sub won't fill down via code
Iteration
Using "Like" to match strings
ActiveWorkbook.SaveAs question(s)
Open and Enable xla file from vba code?
Update querytable connections and refresh data
Wildcard in workbooks open code
Calling a public Macro from a Private Macro
type mismatch and/or obj req error from inputbox
Filiter and Limit selection in Combo box / List Box in the UserFor
Make Variable Range in VBA
Excel PID process casting
Run a Word Macro from Excel VBA
Worksheet_Change Event
convert workbook to html
What is going on during a workbook opening?
Copy Validation to next row
Check Box Macro
Listbox in excel data
Problem with Pivot Table Fields In Field List Not in Source Data
A problem worth gurus, I'd say ...
Risk and Decision Analysis @Risk, Evolver, Decisiontools, Roy Kelly FloorTrader Tools 8.3, AmiBroker 5.0, MultiCharts 2.1, NinjaTrader 6, OwnData 2.6, VantagePoint 7.0.11.2, other ...
Lookup last value
Make ArrayOne = ArrayTwo
Programming Excel to send emails
Problem with dBase
Changing the ActiveSheet
Using VBA to open Excel , Auto_Open Procedure not running
Check Box macro
Access to the value of a merged cell in a formula
Formatting a Pivot Table
Hi, I am Starter in Excel Programming
Reference of Range in another file with VB
Itreration
Receive Error File Not Found
Sort by unique values and sum
packing slip
protect workbook
Database summary
Tool Tips on a new
On change event for specific cells
prompt for parameter/criteria
Database Functions
Delete Rows that fit a certain criteria
cant see the macro
VBA finding language versions
Type Mismatch error
Re-setting Forms Spinners or Combo-Boxes
How to declare the active worksheet?
Do indiv. sheets (or cells) have "TextToColumns" properties?
Excel sort formulas
validate and offset
formula refresh problem
date range
Relative Range Selection
Edit Links
Allowing user to locate and select a file and save results in stri
Slow Code
listbox selection to load to new form
find names of routine in modules in many workbooks
Save range to text file.
Programally add a Macro to Multiple Sheets
How do I display time in gmt when my system clock is set to local
Macro to slightly modify the subroutine
Why my workbook suddenly open slower than before?
Exporting Excel to Word
autocreating hyperlinks in excel? ie 500 cells to 500 hyperlinks?
Get data from another worksheet in same workbook
splitting cells programmatically
Open a specific sheet with VBA
Excel 2003 - Code to print and/or delete
Controling Matlab from Excel
How to make this work??
How to get Excel results into Word
Combobox and spinbutton causing object disconnected error
Run an HTA as an embedded object in a sheet for help
VLOOKUP with 2 criteria
Copy non contigious data from another sheet that meet criteria
Print Macro
Chart Placement incorrect in macro due to differant screen resolutions
Run Macro based on IF
Resubmit of Macro needed to search 2 columns
A negative to using Application.Onkey
Getting own workbook
Can't remove problem reference
Import Access 2007 report to Excel
Serious help
input box - user selects range with mouse?
Error running GetVersionExA
Sorting cells in Shared Workbook...
Choosing what information to filter from SQL in VBA
filtering he data is not always correct
Problems with long text
Error LineStyle property of Border Class
Insertting multiple rows
insert images/pictures
run macro on a CommandButton from another sheet
sheet names displayed in first workbook sheet help
Decimal Point Placement
Hide WindowsMediaPlayer1 Media Control Bar?
Graph series collection
Enter in a workbook and copy to another automatically
lookup from one document to another and paste in adjacent cell
Create a Macro to Delete All Rows that meet a certain criteria
Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column
Getting excel process id
Turning off/on protection in a macro
Variables Name
Trim content of a column
Attaching a function
removing leading and trailing spaces
How do I create a picklist macro?
Can I Delete A Module On Exit?
Adding to A Collection
Update two cells by changing another
Change size of font if cell value is greater than 0
Macro to check data from excel list against access query and return value back to excel
ActiveSheet not in ActiveWorkbook?
Picture pasting where it should but also in alot of cells it shouldn't
Selecting rows and columns up to a certain point
Workbook_Open event fails to fire
Creating COM Objects or Add-Ins from VBA
Opening a Shared File
Update txtbox from combobox
How to select program to open Hyperlink?
Macro needed to search 2 columns
Date Calculation - Continuation
insert page break at each change in column B
Code question
Link spreadsheet control and Excel worksheet
Find source WS from Chart
subscript out of range (help)
Create WB, create new Sht, paste data. (Macro not working)
explanation
Vba has errors on other computers but not mine
delete rows if cell in row contains "a" or "o" or empty
Help with code issues
Print one-sided and override two-sided default
Deleting columns/rows
REFEDIT.DLL???
help on sizing a check box created using the Forms toolbar
finding the scale on a chart
ctrl-p
Inserting multiple rows...
Macro imports data into cols A,B,C. Would like the data in D,E,F
Help with compile error
Condition Formatting Code for text in cells
Print an Embedded Word Doc
How do I get a list from an excel sheet into a userform/listbox?
Explanation please
Custom filter setting
Object LIbrary Versions 11.0 - 10.0
SYLK files Excel Picture format
Some wierd and wonderful macro required
Sumif SumProduct Several Criteria
keypress interception
Determine data type in a string
Error on all My Excel books
Test for Values Q
Close worksheet, dont save
Error Loading UserForm
Macro to add word to existing text in different worksbooks
What is the maximum number of unique strings in Excel 2003
Message box and loop
Count Specific Total Numbers from a Set
McAfee problem
User forms
WindowsMediaPlayer1 Mute Sound?
macro to filter rows containing user defined data
SUM Macro
Manipulating arrays
How can I reuse function for a userform button
My code works in command button but not in public sub
Correct approach for clearing memory with repeated Database queries
setup project for Excel addin, won't register addin
combining different size tables
Newbie : question on VBA and checkboxes
how to bring a value from access into excel based on criteria
Macro to Paste Data in Non-Office Program
Set Row as Variable...
Check Cell Content before continuing...
Change code to popualte into cols D,E, & F instead of A,B, & C
Moving columns about
Txt file properties
Copy data from Workbook Alpha & reorganize it in Workbook Bravo
Consolidate a worksheet from different workbook into one master
Named range prob using VB to move wksheet to an existing wkbook
Search Multiple Sheets Then Add Txt1.Txt to Cell
VBA Imaginary Breakpoints Error
Compile error - Can't find project library ????
Compile error - Can't find project library ????
Need Help Expanding Macro
Counting Occurences According to Time
Macro name issue
Excel Equivalent of Access OptionBox
Error: Block If without End If
Macro to change the column references automatically
Macro copied from ng returns a #VALUE!
Line break in cell
Borders on Fixed # of Columns, Variable # of Rows
Borders on Fixed # of columns, Variable # of Rows
Menu Vanishes on Opening a Worksheet
averages with formulas
Selecting which macro to run based on a user entry
BeforeSave event
Updating Custom Menu Code References when New Workbook is saved
Change Default Printer Causes Abort
Query Close code question??
Pivot cache when pivot table copied
Alternative VBA to copy a worksheet
Toggle buttons, Check boxes
Select Entire Row if Text is Red
simple edit
clearing memory using VBA
Insert Row Specified Sheet
Run-Time Error and UserForms
Sum macro for a variable "i" in a loop
Sum Left Formula, Excel 2000 & 2003
Sum that ignores text
how do i link a picture to a vlookup result?
Text box value lost
Move Worksheet from one Workbool to another - fails on Excel 2007
API Class Question
Exporting / or copy to Excel
VBA Code : Example 9-1 David Bourg's Book