Excel Programming [Archive] - Page 61

Help with "If" function?
Select a contact & paste it in Excel
[column(101:200)] confusing
Pause/Delay to Import Data, then Apply Protection to Sheet
If and?
Dynamic Sum
Verify date by week.
Edit cell to add value to existing number
Macros that run between Excel and WORD
Why does change event fire when workbookclosed
Cancel = True
array formulas in vba help
Date format
i need help in microsoft excel
Losing calculations when deleting a sheet
Animate objects
columns read 1,2,3 rather than A,B,C
Need to use multiple values in the If function in Excel
Excel and VSTO
Libraries in Excel
Data logging with excel vba
Time Fromula
Ongoing Row Count
Filtering protected sheets (again).
Sum with Parameters in a Subquery
Referring to the only sheet
Concise Way To Tell If Range Contains Any Data?
How do I change the state of an item in a (form) multiselect list box
Text box w/ scroll ability
Text box w/ scroll ability
Before Close event
How can I print find all list in excel?
preventing addIn opening in second instance of Excel?
excel and scrollbars
Changing graph axes using named range
macros to save then email
Remove specific text from cell string
Data Validation using multiple columns
getting rid of the border
Compare columns and move data based on a value and change the sign to negative
Xl2003: Validation.Add method gives error from Command Button
Xl2003: Validation.Add method gives error from Command Button
Range Names Limitation
Custom Filter by Daterange or Month
Msgbox not ok
Validation
Opening excel
Populate Userform Listbox with Access values
Excel Calendar Generation
excel macro help
Query database results in a named range
EnableEvents doesn't work
Combobox Change_Event
Excel Macro to find instances of a word
Create New WB, Specify Parameters and Replace Selection
Check if there is a decimal point
What is fastest? "If .LineStyle <> xlContinuous ..." or ".LineStyle = xlContinuous" ??
Searching a sheet for rows that meet more than one column criteria
Formula for time sheet req
Running code on a list of variables
WORD AND EXCEL SHORTCUT KEYS
Finding a cell on a workbook that I have opened
Generatring a C/C++ header file from a Spreadsheet
Copy a worksheet and ensure range names stay local
Find single unique entries from 2 columns
Excel VBA Paste of Range with PrefixCharacter fails from VB.NET
Problem interacting between VB.NET and VBA6 with Excel 2003
Create Dynamic Range by all cells with the same value
how to get node values in textbox
Floating UserForm
Test for Cancel in Inputbox
can't hide workbook or trap error
Search for a column based on the column header and then past data from it to another column in another workbook
macro to execute code on all worksheets in workbook
How to record Keystrokes instead of keystroke actions
User Form Vlookup help?
Looping Problem
Copy & Paste Range from all Worksheets in all Workbooks in a folder
Shade Active Cell - Shade the cell the cursor is in only while in
Deleting blank (Cells/Rows) in Excel-VBA
Moving a file with VBA code
retrieving standardized web report data
macro help
functions or vba solution
Sheet Protection, Hidden Columns, and Autofit
Runtime error 1004
Worksheet Change Event - Colour infill cells
Search
Run a vbs file from MS-Excel
Flashing Printer Dialog
Excel 2007 SDK?
If Statement
Controls Locked
Find in column and copy
Macro Related Query
macro definition
Inserting last row from one worksheet into next empty row in anoth
Search multiple workbooks
disable a macro
How to display multiple lines in a cell
Error on auto filter
Input box code
Count Non Blank Rows
Matching rows in 2 sheets and copying matching rows from sheet 1 t
CVErr Usage
Checking formatting in a LARGE workbook
Search lastname + firstname (search on uppercase)
Refering to a link in a cell
Excel 2003 SP2 fires events without reason when saving workbook
Download Merlin Data Compass 2
Help needed with altering dates and date formats in VBA
Vlookup not working correctly in macro
Writing a logic for shape coordinates
How to get values in 2 text boxes when we click on the tree node
Marco command to name a range?
e-mail selection from VBA
Month and year problem -
How to link strings in a formula in VBA?
Project window pane stuffed up
report creation
Date problem
Opening another workbook and then closing it.
Macro Scatter Graph Plot
Is this possible???
Is this possible???
Problem with PrintOut Method
Sheets.Cells.Value = Sheets.Cells.Value >> Should this be very slow?
Counting with multiple conditions
Update data from pivot table in Excel
Forcing cell with user function to update on workbook open?
Resize offset
VLOOKUP - Possibility of using a negative Col_index_num?
Have an Excel File update a table in SQL 2005
Condition
Incrementing rows and columns
Runtime
Creating reports per Pivot Table PivotItem
Tea Breaks ??
Help! Need to reduce number of markers in a series
how do I update cels through iteration
Auto launch application & run macro
Undo ALT+ENTER (line breaks inside cells)
Ignore Command in VBA
User Password
prompting user for the directory to save an excel file to
combo box question
Web Query w/ Javascript
ADO connection string error??
Add a Dynamic Name Range
Help needed to write UDF to calculate value based on 8 conditions
Filling cells
Merging adjacent repeated columns with a macro
Excel and ASP.NET Web Services
selecting a contact from Outlook for Excel
range to cell
Copy Excel tab (worksheet) to another Excel file
Pivot Table: Change dates to fiscal year
space of single dir on a server dir
Consolidating Values
Blinking TEXT - Help needed
Summing a Column of Variable Length
How to run Excel 2002 and 2003 on same computer with different Associations
search xl file w/vba
Inserting a Row Range at regular intervals
waiting for an .exe file that runs
Summing to cells using VBA
Loop Until out of named range
Conditonal Formatting : color the cell if it contains a formula
How do I use VBA to find which named ranges a cell belongs to?
Unable to Draw Shape
Looping through sheets
How to Reduce the Number of Data Series Markers
color format with conditional formatting
Multiple cells in to one cell x times
.NET or ActiveX control in VBA UserForm?
Get Milliseconds in a timestamp
names.add does not list those names in the "Go to" dialog box
remove two letters when searching
Question with Excel Automation Add-in
MESSAGE BOX IN EXCEL
Convert Worksheet to a Picture
ActiveSheet.Evaluate Problems
ftp Excel data
Trouble with Arrays
If/Then ... what am I missing
Macro Compatability Excel 2007 vs Excel 97 - 2003
change values to formulas
quick question about array addition, multiplication & division
.accdm database not recognized in code
Consolidate many WBs into one ...
Atlantic City Excel User Conference - Registration deadline
how to parse string into array or variable?
Macro to copy multiple selctions to different pages
Creating a Workbook Copy
Share and Protect question
Amend SQL Query with VBA
Preventing custom bars from appearing
Removing dropdown arrows from a filter
Programmatically delete window menu commands
Recorded macro's to be simplified??
Selection hides when Excel lost focus
Using External VBA References for 64 and 32 bit XP
VLOOKUP function in VB
disable/enable makros automaticly
Treeview error please help (SC)
Sort data whilst autofiler is on
Count blank cell in a column
Cell formatting code
Where is ADO Data Control???
Help me Pls.....
How do I view connection string
In over my head and paniking.... desperate for help
rETRIEVING DATA FROM EXCEL WORKSHEET TO CONTROLS IN USERFORM
Can we use our(custom) cursor in xlwait?
Bob Phillips' Common Dialog problem
Alternatives to Application.evaluate(Long Formula)
Help Needed - Blinking TEXT
Excel VBA Passing Parameters Through Cell
can a vlookup be used in a pivot table to extract data for graphs
Anoying Excel 2007 glitch
RE: Retrieve Access database Path and File name
Passing a value across workbooks
Dynamically updating Combobox
Import, Find End of Used Range, Offset or Move Down 1 Row, Continu
Delete All Names - Even Invalid "#REF" Names
e-mail client that opens .xls files automatically?
Worksheet names in VBA
dll files in Excel VBA or ADO
datePart Function
Data validation dependent on value in another cell.
worksheets.select doesn't work
quick questions about array addition, substraction, multiplication
Dumping list of folder contents into spreadsheet
Can't reference a named cell in VBA
Unhiding worksheets if Close is Canceled
Editing a list of cells
Marco to delete all rows except those containing 'MZ' in string
Expanding cells again
Shapes selected from menu in which text changes each time it is pi
Maximization of a Cell
What event is associated with a CHANGE in a validation list box?
dynamic legends?
HELP: opening/closing Excel remotely!!!!
Selected sheet(s) Page Setup
Cell Format Problem
Re: Remove formulas and links from 500 workbooks
display in web page format & paging
code on a template sheet
Cell values from mulitiple worksheets to two columns on another ws
Date Ranges
Pivot Table with variable # of columns
How can I set a cell to conditionally change background color?
Copy Rows to New Sheet based on User Selection in Drop-down List
Move, Rename, Format & Delete Row *.csv file
Compile error
Locking worksheets
Testing for blanks cells
AutoUpdate/Recalc of Dependant Data Validation Lists??
Please Help! Copy named range to new workbook without changing references.
Macro call from custom button opens old file
Slow code when used as VBA code instead of macro (copying visible columns)
TreeView Error_SC
Code help: Combing data from worksheets in a directory.
Replace script
Return to original location
Find position of cursor in text box
Determining whether XP or Vista is the operating system
Guess my number game.
Email worksheets via name on worksheet
How to fill a column with color in statement
Excel Blinking TEXT
If command
Chart position newbie question
Capture IAppEvents using VC++ COM Addin
Multi-word WB name
Problem with Worksheets v Ranges 'Again'
Macro / VBA for Find
total columns by colour in excel
formula to count the No of people who scored above 50% in excel
Excel 2000 protected worksheets problem
Click event on menu item is lost after first time firing of the event
Simple Cell Manipulation
OO4O and Pivot Table
Check if file Is Accessible
Insert image in the excel cell.
Macro to open a word document from excel
How to use Excel VBA program to execute SQL SERVER stored procedur
Copying Data from one workbook to another
Turn off auto redraw while updating chart format
Downloading excel files from a website using VBA
Combo Box
Re: Calling worksheet-level names using insert Autotext in Word
copying specific rows to an existing sheet, based on user paramete
RE: Copying multiple worksheets to main worksheet
Shorten Code
Why doesn't this work in Excel 2007? Is this a bug?
Compile error when opend from other PC
Showing/Hiding shapes
Running a macro in another WB
Expanding cells
Moving Average of values within an array
rename the new worksheet
Average of last 3 non-0 numbers in row?
convert hrs into decimal
Hiding Columns with Merged Cells
Copy a range with application.inputbox
SUM in VBA
XL2007 vs XL2003
Importing Data into a Calendar
Range inside Array not working
Conditional Formatting
Help establishing ADO Connection
where can I download the trial version of access 2003?
copy worksheets
Can you assign a value to a picture within excel?
Extract rows matching condition
CDO.Message
Code to Unhide set of rows (SC).
Excel 2003 vb scripts and toolbars in 2007
Sloooooooooow Chart update on upgrade to 2007
Set RNG
Add control to menubar
How do you import sheets into an Excel XLA Add-In?
Copy / Paste Specifc Row based on Input Box Value
copying worksheets
Execute class method on all worksheets?
Worksheet Copy fails (xl2003)
Cell Address, Last Non Empty Cell
Input Box as Parameter for report
recognize the text within a cell and copy/paste whole line to nex.
Warn a user in Shared workbook
Custom Menu item disappeared in Excel 2007
Center Toolbar
Another odd VBA glitch in 2007
Pivot Table - Reference is not valid
VBA code to CC email
Partition + Grouping
Delete row on another sheet same workbook problem
Loop through worksheets & empty cells based on color
Re: Excel 2007 VBA
How do I close form
ethereal in excel
Code to hide and unhide cells (SC).
InputBox help please
Bringing conditional data from another worksheet
xp/2003 vs vista/2007
error "Set wb = Workbooks(FilePathName)"
How to Program Excel to Create a Warning Signal?
Releasing Outlook
Selecting and merging range within numerous rows
Array error in subtotal method
Column Width Problem
Checking for cell content
Save a sheet of a workbook to a sheet in a new workbook
Protect sheet Excel 2007
Pivot table refresh on open
Data validation to control a pivot table field
Store Data in Access
Inserting rows after Paste Linking
How can I prevent calculations upon opening workbook?
Reverse Order of Copy
VBE-Neutralizing a set of lines from eunning
Web Query, Help!
VB Script based on combobox selection
Create a drop down list dependent on selection from another list
function to convert Printer share name to ActivePrinter string
I need some help...
Scroll Frame after user event
converting word to excel or access
Isblank function not working in VBA
Parsing a text file
Control ToolBox - CommandBox Accelerator Underscores - Retry
formula partial change
Placing data in specific columns
Looping subroutine
SpecialCells(xlVisible)
Moving cells
CSE formulas in vba(ie: averageif in Excel 2003)
Pagebreak property
is there a way to put a slider bar into excel
Only print rows with text in col B
cursor control
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor
HELP!!
find and replace macro problem
Macro Error When It Can't Find Value
Excel crash when doing OpenXML, apparently involving DisplayAlerts
One spinner that controls whichever cell I select
summing up values in a column based on values in 3 other columns
Test if cells are selected
Avoiding a hidden sheet
Excel List Comapre
Making a change in all worksheets
Need help on IF condition
Large Table Matching
In excel 2007 macros gets disabled when i am trying to open a work
Protect macro and comments
Could Someone Explain this Code
Selecting A Range
how to return a file name
keeping original workbook open when saving
Filter on today...how possible?
grouping same rows in report
Saving information between uses? (Userform)
Find & Replace help solution?
How do you format negative numbers to have brackets around them?
Pivot table clearing phantom page fields
Date formattting in Excel when using OLE
Data Grouping
Pivot table macro problem
creating pivot table with similar columnames
Excel & Two Monitors
Can u help me?
Save workbook with a predefined name
Barcode and VBA
Error copying sheets
Help in Excel VBA for simple task
Check Ms Office/Excel language version
Easy Makro for Deleting Rows
Simple meassage box
Change VBA macro
Worksheet Change Events
Checking if a Chart Exists on a Sheet
Disable Worksheet Delete Warning
If Function with Text Formatting
Specific list sorting
Insert Worksheet Names
VBA code to protect data in MSaccess and excel spreadsheet model(URGENT)
Using a variable in a Rows Hidden Staement
OpenText Method Question
Can I automate Wizard options in a macro?
Loop through workbooks and worksheets in each workbook
Excel 2003-how to apply identical info on numerous pages?
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros
Conditional Format via Macro?
access to xls
Control ToolBox
Image in user form
Worksheet selectionChange problem
Help: Macro Copy Active Cell to Range Name, loop
Hiding complete Rows using a procedure
Extracting Relative Propert of TreeView Node
Improve the speed of copy-paste
Runtime Error 1004 - File could not be accessed
Drag and Drop from List to Tree View
Get a range of cells from a selection of cells
Evaluate Open Files / multiple instances open
Losing Items in Forms.ComboBox Problem
Newbie, how to save file with date and time as filename
Pass highlighted list variable to caption
Newbie, I dont want macro to reference worksheet name
VBA: determine if value is invisible in autofilter
Storing macros in one workbook
Grey out listbox in userform
TreeView Control 6.0 in Excel 2003
Modifying a Template from another Workbook
How to Find values in one worksheet and copy them to a new workshe
Trying to clean outlook contacts. A differnt take
Public Variable
TreeView Questions
User form ComboBox Items: Remember user entries?
HIDING CELLS AND COLUMNS
dateadd
help on find and copy
compatibility checker in excel 2007, turning it off
Insert blank row after every 11th row.
What's with this MS message that keeps popping up?
MD5 -- can I use one from somewhere?
point to a cell from the Custom footer
Page break preview makes everything smaller
Macro definition help
Moving Active Cell to Upper Left Hand Corner of Screen
Question
VBA Sum Non-Contiguous Columns
Limit to numbering of auto-generated shapes?
programmatically save new workbook with custom name & location
Copying non-blank rows only
do not delete rows in a list.
Just Launched! Ride the Cash Cow $1500 Daily!
Excel 12: Question about updating a table tied to a SQL query
"NZ" instruction periodically fails
Insert a formula down 50,000 rows
Copy a Named Range to a New Workbook without changing the Reference
Autocomplete in data validation with separate workbook
Excel Formula
Merging cells changes values, bug?
How can I Left justify the center section of the print header?
Copying a tick box
Radio Button Values
Text not diplaying in the Text box
Switching workbooks before close
vb xls command button access key
Simple Macro?
Listbox Item Focus
Finding Cell Address of All Errors
Counting occurrences of textString in variant array
Newbie Cell Selection Question
How do I remove the red corner in excel comment and keep comment?
Logical text checking of a cell
Lookup in Access return result to Excel
Three Diminsional Array
Extracting Text from a field
Calling my macro is only working if certain options are selected
2007 EC Excel - Access User Conference
Send To: Mail Recipient without Macro
almost there ... code modify help
comma seperated values using multiple vlookup
check value in cells against all values in a column
I want to cylce through all the open .xla's as well as the .xls'
Help with Tree View functionality.....
Excel 2007 VBA problem
How Do I get percentage of any figure in same Cell
a latching function
Combo Boxes and Worksheet Events
EXCEL: OLE DB provider for OLAP Services 8.0 Missing
Finding numbers or numbers and dashes in text
Find Row with Value
paste problem
frame control inside an image control
Why isn't my error handling working?!
Application-defined or object-defined error
Reading Outlook Calendar
Returning each month between 2 dates
Launching Macro from Validation List
Solver slow for large workbook
Macro
Manipulating this text.
How to change the default interior color palette index in Excel 2003
Got a Class, got a wb - now what??
Updateing a workbook from another workbood
Cancel the printer setup dialog
Re: Drop-Down List
JLaham..Please Help!
Nested IF statements
Can't find a macro that is available in all workbooks in personal.xls
Assigning Cell data to VB Variables
Crazy Data Validation ... List Validation Not Working
Trying to clean outlook contacts in excel....
not completeing mission
Macro to Sort Left to Right
Multi-user file save
Problem with strings and a macro
VBA Code for Pushing Info out to Server
VB for Summarizing Sheets (3D cell refernces)
Find mulitple records Vlookup type function?
Finding a number within a range in Excel
Enable Command Button base on UserName
Changing search feild in middle of seach
Extending Conditional Formatting Capabilities
Copying header rows and inserting them into all worksheets
Pasting rows into a list
Wrap a custom number format
Button to activate macro
filepath variable
If-Then in ComboBox_Change..... (VB Code Newbie)
None working formulas
Changing Links In Excel Causes Formulas To Change
Will importing tab-delimited, extra, data affect attributes/formatting in prepared XL2K file?
Citrix NFuse and Events Not Firing
Pivot Table(s) - refresh in sheet - macro - automate
Copying, Pasting Autofilter results to a region more specific than a specified worksheet.
Copy of workbook woithout formulas.
MS Office Excel 2003 assigning cell values to variables
Loading Sheet Index number into array
Change To Read Only
Formatting Excel from an ACCESS MODULE
graph range update from macro
Cell Change Trigger
Excel error message
Help w/ VB to match & calculate
Hiding/Showing Rows
Macro to run automatically on Open/Close
edit a dropdown list
skip to worksheet
Insert bold, 26pt * at end of cell
more than 3 conditional formating
Re-post
Selecting all items in a Listbox???
Cell search, match part of string
Set print area on variable range
Skipping files which exist as named cell values - 1004 application error
Problem when I store a copy of an object in a new variable
about using Excel component in ASP
about using Excel component in ASP
Automatically change cell comments
Remove last CRLF in text file
Continuous running macro
Start & Stop Time button
Insert > Name > Define Help Please
Set PrintArea Not Working
Resizing a Picture
Changing chart name and sorting by chart name
UserForm Text Box Percentage
Find last Entry, add row below + copy formulae and formats from ra
Set mySavedSummary = ActiveWorkbook.SaveAs( .......
Does ActiveWorkbook work when Screenupdating is turned off?!
How do I link separate files so all update when I alter one?
Auto Re-Sizing Merged Cells
Mactching Values & Returning Values
Find the next one
Problem with xlUnlockedCells Q
Date format in Excel
More trusted jobs here
Macros
My new Add-In is useless.
Copy or Print from User Form?
Code dependency reporting
Is it possible to be able to merge say 60+ worksheets into 1 workbook?
macro to increment/decrement values in selected cells
Problem with Find method
need help
Using a macro in multiple sheets
range pick
Run macro when cell color changes
Unable to set NumberFormat Property of Range class
Undo Code Not Quite Working
Range in Macro error
elseif
Easier way of adding new sheets to workbook
macro to hide all rows that have a cell value of "complete"
Userform won't go away
USing Match on 2D array
DoEvents and Semaphoring
re : How to delete rows.
Making Sheet Visible
Help with what is wrong with code
Hide controls in a worksheet menu bar
all worksheets into one workbook
how can i convert an amount into words.( say for example: 1= one)
Change 'Caption' on ToggleButtons with VBA
Excel
Reset cell after change
Run-Time Error -2147352571
a macro for inserting
RE: Userform won't go away
Delete Selected Records
Automatically Send Email based on query
Totally Stuck...Help Please!
RE: Change 'Caption' on ToggleButtons with VBA
The way to make a Class and a Collection static
ADO/VBA
Simple CHeck box to view/hide rows
Wildcars & cell references
Wildcards & Cell References in Filters
Combo box problem
RE: Unable to set NumberFormat Property of Range class
RE: ADO/VBA
RE: macro to hide all rows that have a cell value of "complete"
RE: Excel
Error in Retrieving Worksheet.OLEObjects property
Hyperling to Microsoft Word Enables Transition Effects
Selecting all records from one text file wright to another
hide / show rows based on two drop down selectiosn
Image File Path for Linked Pictures
RE: USing Match on 2D array
Creating a static function
RE: USing Match on 2D array
User defined error
RE: Excel
challenging
RE: macro to hide all rows that have a cell value of "complete"
RE: Excel
macro to hyperlink individual files in multiple files
How much RAM in system?
list box on user form
adding command button to menu
Closing Excel from Access
RE: Fields requiring input
RE: Excel
Format all new text
RE: Making Sheet Visible
RE: a macro for inserting
RE: Excel
Select next empty row from macro
command button
Re: xls vba find method to find row that contains the current date
RE: a macro for inserting
RE: ADO/VBA
Sending a task from Excel to Outlook
RE: Convert Excel VBA addin to a Protected Format
Character Count?
RE: ADO/VBA
Format Text
Custom Cell Functions
RE: Delete Selected Records
Multicolumns from Access
Check search field is available or not
copying all worksheets into one workbook
Combining several workbooks into one workbook
Searching archives of this newsgroup
interogating a string within a macro - bjy
RE: Easier way of adding new sheets to workbook
addin not working properly
RE: Custom Cell Functions
RE: Totally Stuck...Help Please!
Help adjusting code to examine whole account groups first
Different Dependent Lists, based on value of first list
RE: how can i convert an amount into words.( say for example: 1= one)
RE: how can i convert an amount into words.( say for example: 1= o
RE: Help with what is wrong with code
RE: elseif
multiple choices in drop down boxes
Compile error: End If without block IF
RE: How do I Auto Populate a cell with a chart based on a value
RE: Select next empty row from macro
RE: elseif
click box copy
Does a complex Excel VBA Password provide additional security
drillthrough from excel 2003 pivot tables
RE: Excel
RE: Totally Stuck...Help Please!
Rounding of 1000's
VBA Forms
Change background colour of selected cells
OpenText FieldInfo:= Array
Sendkeys alternative to help with XL Extras - Jim Cone
Macro inhibits Excel Functionality (i.e., No Longer Able to Use Co
RE: Multicolumns from Access
Copying Modules into WORD
RE: Unable to set NumberFormat Property of Range class
Run-time error '380'
RE: click box copy
RE: adding command button to menu
RE: Change background colour of selected cells
RE: OpenText FieldInfo:= Array
I need a function that will trap & manage a change in cell value
RE: Combo box problem
RE: Change background colour of selected cells
RE: Searching archives of this newsgroup
How to call a procedure in program
Twist to eliminating the "Do you want to save..." prompt
SpecialCells - no cells selected
RE: Selecting all records from one text file wright to another
Excel Automation Add-In does not show up in Function Dialog box.
Scripting Dictionary in a class instance
Naming Worksheets - Loop within a loop issue
re : How to delete a time range in the raw datas.
RE: Compile error: End If without block IF
Hiding a Worksheet
RE: Closing Excel from Access
Copy Formula
RE: Change 'Caption' on ToggleButtons with VBA
RE: Totally Stuck...Help Please!
Macro For Stock Control
UserForm Web Browser.
RE: macro to hyperlink individual files in multiple files
Paste row to new workbook
RE: Totally Stuck...Help Please!
before print macro not printing multiple selected worksheets
Setting paper size as variable for printing custom views
RE: Easier way of adding new sheets to workbook
RE: all worksheets into one workbook
Problems migrating from EXcel 97 to Excel 2003
RE: Help with what is wrong with code
RE: Character Count?
Extacting data from Access
Can VBA copy all procedures from one worksheet module to another?
RE: USing Match on 2D array
Object library Invalid
Replacing "Div/0!" errors
RE: Simple CHeck box to view/hide rows
Interogating a string within a Macro
Can't open excel documents
Object works in Excel 2000 but not in 2003
RE: Reset cell after change
RE: Range in Macro error
Extracting Custom Views from a File
Macro not working correctly
Using a Form as a macro toolbox
RE: SpecialCells - no cells selected
Run VB sub from one workbook to another
RE: User defined error
Conditional Formatting with Due Dates, and different colors for da
Deleting Custom Views when Deleting Sheets
RE: Compile error: End If without block IF
RE: How much RAM in system?
RE: Macro For Stock Control
RE: Rounding of 1000's
copying all worksheets into one workbook
Delete rows/collums containing certain values with a Macro
RE: Can't open excel documents
RE: Change 'Caption' on ToggleButtons with VBA
RE: Hiding a Worksheet
Parent Properties in Custom Classes
triogger reset
Convert a string to number
RE: Excel
RE: I need a function that will trap & manage a change in cell value
RE: Format Text
Documenting external query for PivotTables
RE: Combining several workbooks into one workbook
Error Opening Access Table in VBA
RE: SpecialCells - no cells selected
RE: Character Count?
Synchronizing Multiple Pivot Tables
Code to Run PDF Maker
RE: Hiding a Worksheet
RE: Object library Invalid
RE: Sendkeys alternative to help with XL Extras - Jim Cone
Renaming Files Problem Continued
RE: copying all worksheets into one workbook
RE: Delete rows/collums containing certain values with a Macro
RE: Hiding a Worksheet
RE: Naming Worksheets - Loop within a loop issue
sum range of cells using cells, not range
Suppress all PageBreaks of a worksheet
Inserting Pictures MKII
Want to cycle through PivotCharts and Charts continuasly
Check Values/Insert Rows
Opening Closed Worksheets with VBA
count frequency in excel
combo box converts to picture
Choping Up a String
Regression
Concetating Two Columns in Excel VBA
Searching header, then autofilling
Command Button visual delay
Manipulating Ranges Alphabetically, and Deleting Blank Entries
Save picture from worksheet to C drive as an icon
Data Validation not available
inserting and naming range
txt to excel data beyond 256 column restriction
Range returning info from wrong sheet
Arrays and "For" "Next" loops
Getting " into a String
SUMIF of adjacent variable cells
Return value from excel macro
Validating range names
Merging Workbooks
VBA Automation error
How to disable "Refresh Data" using macro or VBA?
Inserting Pictures Help Please
How to control TextBox ?
Out of memory exception
Out of memory exception
Copy sheets with content into same workbook
Cells Relative to a Range
Macros to change Pivot Field
Not able to load excel addin
Re: SOLVER THAT CALL DLL SUB!
Re: Displaying the active power point file
Displaying jpegs.
Print an excel file from command line or "cron" type command ???
Deleting images in Excel document
mismatched data types
calculate balance given varying payments?
Add non-contiguous cells to range?
Unprotect Sheet not working
Does Excel 2003 have CDF feature in its histogram plotting function?
Does plots have interpolations in Excel?
how to make Excel application GUI look better?
Function that replaces Text in cell
Re: Shorten formula
Displaying the active power point file
Need sample code to connect Excel to Mercury Quality Center
ActiveWorkbook.SendMail With No Attachment or Can't Open Attachment
Slow to load contacts!
VBA, Matrix
problem creating a pivot table using a macro
copying sheet from workbook & incorporating into another
Insert dynamic formula
Re: Focus is on wrong sheet after opening.
Parallel ranges
pasting charts to new bookmarks in Word
How to open each file from the folder and save again
Footer code
New to VBA -> Setting Excel Columns to Strings
Change defined name ranges simultaneously
Rounded Rectangle
refer to current file name in PivotCaches.Add
Update cell using vba
Coding for checkbox (SC)
Transferring from sap to excel problem
Selecting the order of ODBC downloads
VBA passing information between differnt User Forms
Installing automation add-in for all users
IIf VBA Problem
Using a single cell value change to alter multiple references.
modify cells from VBA formula context
Positionin charts
Linking Workbooks
Calculating percentile on array with >65536 elements
Information about Microsoft TreeView Control 6.0
Resizing charts
Glorified search function
Additional lines on the chart
conditional MAX associated row data
Code modification help please
Tom Ogilvy -- Center Userform Below Calling Toobar Icon
Simple Form: How to copy a value from one object to another?
populating cells using data from a different worksheet
Why is TreeView updated/refreshed when saving workbook?
Why is TreeView updated/refreshed when saving workbook?
How to Calculate a Weighted Average in a Pivot Table
update interval in excel share
To reduce the speed of circulation in a range of cells
Simple code entering data
Don't understand results of UDF
Newsreader Question
Looking for a quick way.
Re: Select Multiple Sheets from Menu
Re: Select Multiple Sheets from Menu
Upload data from excel to online application
VBA Help file
COPY SHEETS FROM TWO DIFFERENT EXCEL FILES INTO A THIRD
solver.xla problems migrating from Excel'97 to 2003
Re: Focus is on wrong sheet after opening.
A few questions, if somebody could please assist -i've been doing my head in to get my vba project complete
Re: Convert Excel VBA addin to a Protected Format
Insert Row Macro based on contents of two columns
How to trigger one cell change to change another cell using VB in excel? Please help! :)
Selecting From a Choice for Printing Out
need a macro to sort and replace data
Re: Having User Defined functions in their own Insert Function category?
TreeView and RichTextBox don't show correctly (wrong size)?
ActiveWindow size?
naming cells for their content
Using Windows XP Style Components
Excel macro
Help, I have a deadline: Renaming Files in Folder
Export Last Completed Row of Sheet to a New Spreadsheet
Toolbar Button Coordinates
Excel 2007 and over used installation key
Looping through code for every record in a table
RE: Very slow Visual Basic code execution in new Excel 2007
If Then in VBA, check cell, enter data to other cell
RE: Creating a Dynamic Questionaire
Re: Excel 2007 wont import Excel 2003 VBA module
Re: RowSource for Combobox Improvement
worksheet
RE: ((( WARNING ))) Pass it on if you have the courage. â€*
RE: Protecting sheet with update vba script
Re: Exporting Large Array to Access (2003)
macro needed to copy blocks of cells across to list of cells down
Re: Exporting Large Array to Access (2003)
ComboBox.RowSource?
Removing old links
VBA between excel and powerpoint
Passing data between Userforms
Copy Data into Database gives error
Re: Shorten formula
Re: Adding Days not years?
RE: Error Handling
Is there any way to mark all cells referencing another file in XLXP/2003?
RE: Evaluating formulas when a template is brought into a worksheet...
Formatting a Text Box on a UserForm
Are two Saves the same?
VBA code to populate Excel Tab Text
Need to process first row.
Pulling out the highest ten numbers from a list
Clear all textboxes on a page
Delete Row with Protected Cells
List worksheet names in a seperate sheet
VB Add a blank row?
RE: Office 2007 + VSTA
Re: Excel cannot complete this task......
Access or Excel ?
How to make Scroll Bar work on a form
GetOpenFilename help
Placement of variables in called sub causes code to fail
VBA to copy worksheet as an object into an MS Access OLE Field
Excel macro question
Undo c++ macro not found??
Copy a range into an array
Writing to a .txt File
Creating a task in outlook
Copy selected cells
XL2007 Bug: Text Can be Changed in Shape with Linked Text
Padding with 0's overflow
#DIV0!
C# COM in Excel: Avoid using Marshal
Excel Freezes - Something to do with a chart
File Naming
Bob P - Count conditional formatting
Object Error: what am i doing wrong??
Linking a Document in a Messagebox
Turing off warnings
Converting time format in hours mins to minutes
File in use notification
Excel Project - Sharing
Select all rows except header row in one column
Re: My on-going problems with dates
Worksheet Name and Visible... How do I...
Format as text
Strange exception when calling Worksheet.GetOLEObjects using Invokemember!!
Running a macro if a cell contains number 1
Workbook_Close Q
Conditional Dat Validation input
switching between workbooks not allowed in Excel
Duplicate command bar control after opening 2nd workbook
Problem using the INSTR function in VBA
My on-going problems with dates
Fuction related help...?
Code for creating option buttons
Macro to Loop Through Hyperlinks and Print the Files
Download files using MSXML2.XMLHTTP
VBA to check if a URL is working
How to call Macro in UDF
What is the syntax for the open workbook in a Macro?
If range is empty, clear other cells