Excel Programming [Archive] - Page 53

Inconsitent Formula Error
Range column and row using variables
Save file with different names
VBA Excel.WorkBooks.Open can't open an XML format xls file
comparing data
Select Case with Nothing
Compile Error: Proceedure too large
Barra de rolagem
Removing Everything behing 3 Spaces
help collecting data!
Transposing data as it is being returned from an query
Value ( Excel 2007 Version )
MS Windows Common Controls-2 6.0 (SP4) using VBA in Excel
How to speed up sheet copy?
Select Window Containing specific text
Copying hyperlinks with VBA in Excel 2003
Pivot Table
Macro to Delete rows on a criteria
Tab through & hit enter through a message box with a macro
drill through to SSAS CUBE
Screenupdating=false not working
Macro for workbook
Data Validation dropdown shows blank choices
Suspend program for data retrieval
how to skip to next instance?
Have the width/height of a autoshape placed in a cell
Add Scroll Bar to CommandBar
Updating pivot items in three pivot tables on one sheet via VBA
how to make merged cells on a new sheet
Filling a Multi-Column Listbox
Align the form to the top left
Programming Comments in Excel 2003
bLANK cELL
Some basic excel skills...
Greg Wilson - XY coordinates of a worksheet
Column headers in CSV file for excel
SUMPRODUCT
Calculation on/off in excel
Looping thru open word documents to find a specific one
Simple i think.... breaking SQL
Create a Macro to Insert a number into a column based on criteria
Excel Problem
Excel Problem
message scroll like stock index screen
Sheets.Copy Error in Excel 2003 - Is this a registry Problem?
VB Question - AutoFilter related - 'Criteria1:' secion of my code
Access variable from form and module?
Auto adjust Y-axis for chart with 2
Cannot open Excel
ChartObjects.Count is incorrect
VBA to sort automatically in a custom order
Excel Hacks - 2nd edition
Progress Bar Query
problem with find and replacing
easy e-mail one
scheduling macros to run automatically
Can this be done?
SUM IF AND
Help with programming Excel User Forms
converting a simple formula into VBA code
creative solutions wanted! No coding involved (yet) ....
Start on select cell
Rename an Pivot Item
passing Nulls to SQL Server 2005
Copying from internet explorer
Select a variable range
Pop up Message box
Macro creating chart gallery giving problem
Divided by zero
OpenXML Excel query
openoffice xlsm query
User Defined Function to run procedure
Change tab colour for active sheet
UPPERCASE, lowercase issue
Getting fields from DAO database and placing them in variables
Loan Amortization in a cell
Toggle common tasks
inserting new row in datatable
link between two differnt sheet
optimizer
label_to_number
google newsgroup
Increment Columns by 1
skip to next from if
I've a problem~
Macro Problem TextToColumns
xl2000 vs. xl2003 RangeFromPoint and Grouped Shape
Calendar Control
ComboBox .List problem
Macro
Sorting Items in a ComboBox (ActiveX Control) in Excel 2003
Add Ins basics
deleting rows in large database (+20k rows)
Macro that names a sheet
C# adding textbox to excel sheet
Multiple vlookup and a little extra.
Compound Sumif
Closing without saving and without asking the user to save...or no
web query as background activity
Dynamically populate spreadsheets in a workbook
Logical Formula
Distance Calculation
Need to create cascading dropdowns in Excel
How to generate code from VBA and... run it !
Moving Cell Values Instead of Formulas to Another Sheet
ADODB.Connection Error
macro dont continue after save as
Syntax for looping through rows and columns in Excel
Toggle buttons
Simple For-Each question ... but not for me ...
Range.select error
Adding a scroll bar to a cell to scroll its contents.
macro dont continue after save as
Advice on Using "xlDialogPatterns"
Hide another Office app from xl vba (PowerPoint)
Access to web tables
For/Next Loop through worksheets
AutoFilter results plus show next row
Auto send spreadsheets as email attachments
Finding named range references in formulae
Is there an "On Break" similar to "On Error"?
deleting a cell based on character length?
copy an offset value when select
Update links without opening other files
Updating numerous Pivot Tables in a Workbook
Need Save As Dialog Box
Merging Question
hide menu bar
Sum new Column Added
Vlookup in VBA
need a complete list of Precedents and Dependents
Call Event as Sub
Return all matching cell values
I need to stop this Loop
Excel macro - truncate cell at X characters (left to right)
Validate an account number
Help with Rounding total off but leaving .00
Excel VBA Wookbook Routines
Bloomberg print
Application.quit
2003-->2007 Mid function
Runnig a macro relative from a form control
Automatic Timeout & exit workbook
column heading
How to prevent a VB dialogue box appear
Worksheets(i).Select - driving me crazy!
UserForm Error 459
data in different work book
Superscript/subscript selected text within a cell
Need to support mutiple Excel versions from C#
Call Search Application
'OR' Condition
Conditions 'or'
Cell formatting not applied
2003-->2007 require variable declaration
Logging to a network folder with username/password
Grouping and summing values based on a condition?
Worksheet change event - Spinner button
texttocolumn, limit the number of used columns to 1
Formula
Input Mask - Credit Cards
Conditional Sum Wizard - 2007
Naming multiple parameters/worksheets
Cells orphaned from update precedence tree - test condition?
printing formula to a particular Count
Splitting Cells
Excel 2007 - Error inserting column
If Then
Excel drop down lists
How do i hide rows if a condition is met
first and last cells of manually selected regions
Insert rows/copy formulas fro above
Check Boxes
Userform Initialize
Sum using r1c1 style
How to trap auto filter?
insert checkbox to modify cell value
getting System.Runtime.InteropServices.COMException
How to avoid getting the IDE window visible?
Find a Specific Column
AutoText for VBE?
Display caption on Mouse Over
Change Interior Cell Color
Paste Special (Values)
Creating a chart that has a variable data ranges?
Activate code by clicking in cell
Starting New Group in Custom CommandBar
Must reduce file size
green arrow for error
How can Relative Cells/Ranges be Cleared when Rows are Inserted?
web query as background activity
Last Row
drop-down populated from external data
Determine Column Number in a function
c# programmatically grouping a range of cells
Query Parameters
Excel 2003 to Excel 97 macros
Change events
Displaying the results of a Search
Can't find String functions.... Missing library
ActiveWorkbook.SaveAs
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007
Consider Posting Replies to the TOP!
Not showing Comments,when using arrow keys.
Vlookup, GetDirectories Question
CommandButton still visible until enter and then exit design mode
Closing a Workbook if Macros aren't enabled.
Text to multiple worksheets?
mscal issue
PickList
calculating weighted average cost of capital in a macro
Setting Last Row
VBA Find function does not work for merged cells. Potential BUG
Check if a column is hidden or visible in VBA
Access picture data
How to Create Main Macro File
Custom button-lock
How to interpret my code
vba code...... on update...........
Security
Clear UsedRange except specific cells?
ComboList Source
Loop back to Case vbNo '#2
Autonew
Preserving date format in VB
Convert Named Ranges to Addresses
NumberFormat not working
Refering to the current workbook in a macro
If-Then, with an OR --- not working!
Obtain Value in sheet from C#
Copy hidden sheet and then make copy visible HELP?
run macro on data validation cell change...
Insert and replace row
Send mail using default client
Maximum amount of usercontrols on excelsheet in Excel XP
Still having Filter/Copy problems
copying named ranges to other sheets
How to Export Excel Data for use in a Database Table
Link a column to another sheeet
summarise multiple worksheets
Inhibit 'Save Changes'
Userform questions -- code included!
2003- to 2007 menu
VBA to make e-mail address in a cell to a hyperlink
Using a macro to protect a sheet after the information update.
adding data to a list
Mulitcolumn listbox - Add Item
noobie question
hyperlink to sheet name where sheet names=cell content
Exporting data to Excel from VB6/VBA
How do you select images progammically
email conditions
Find Last Cell in Range
Goto
Adding custom list and text boxes to the custom tool bar from Excel C API
How can I enable my macro to only open for one particular workbook
Can only open Read-Only Word documents from Excel using VBA
New computer and VBA errors
How to refresh sheet while UserForm is open
Zipping files and using them in a program... Is it possible?
A check box to open and close Columns
Copy Worksheet, Excel 2000 & 2003
Email Upgraded from Office 2000 to Office 2007
Cannot .select
UDF not recognized after conversion to 2007
Copy to Worksheet question
VBA:programmatically invoking menu items from Excel Worksheet menu
Custom Menu Checkbox
Combo boxes
Creating a path to save a file
Using Instr to produce table contents
reading xls file, speed problems
Update Links, Scheduled Tasks and UDFs
Why doesn't this work
Customise Graph Data labels
select case question
Conditional formating for a range of cells
Help - Apply Formatting To Current Row
Copying rows or cells using Java
Importing Web Page with Hyperlinks into Excel
Random
Sorting a Column of Formulas
Graph Macro range question
Old/New Mp3 Free Albums
Function to Sum A Cell Containing Numbers and Text Abbriviations
Humaneyes sucks!
Humaneyes sucks!
Web query: Want to pause macro while Web query completes refreshin
Conditional Formatting if a certain condition is met
Prevent Saving command if data is not validad
Mail Body
TextBox validation before moving to next
How to Protect MACRO with Password
Question about named area
FillColBlanks - two columns?
problem with find in merged cells
"cell selector" control?
Get count of active (non-empty) rows and columns
Coding the Spinner
Query not returning all the rows
Selection_Change?
Worksheet_Change event
Open tab text file method
Excel VBA Window - Problems with the display
People favourite sites
deleteing peoblem
set olap pivot table selection
How many rows?
PasteSpecial question
PivotTable Custom Field - formula for no value, with blank cell displayed?
convert formula to text
Remote Data Validation
Sheets(2) = 2nd tab? = Sheet2 (Sheet2)?
Comparing data, need help.
Memory jam after too many worksheet copy steps?
path syntax
Find and Replace - delete the remainder of the text in the cell after my Find
have a macro recognize added rows
Macro to split and wrap text
Select File names and select a location of file
how make a random draw of teams of 4 golfers from a list of 40
Pause VB Code to Allow User Input on Worksheet
Help with boolean statment for active row
Menus not working in embedded Excel
Autosort multiple columns, Keep records intact.
SQL query across computer domains
over my head- need function help
worksheet_change can reference excel range on other worksheet
Select any row, copy data from specific columns
105,000 line XML to Excel
Loop help
User defined Type
loop to add data in array
#N/A search across multiple worksheets.
Excel datamap question
Autosort but leave header alone
sum only if all are numbers, return 'NA' if non-numbers exist. How?
Save options
replace formula with actual value
Unprotect on open
Use filters from a different sheet
How to save clipboard into emf or wmf file using Excel VBA
Check data item is date not text format
Days of the week's special format (i.e., Mon = Mn, Tue = Tu ... Sat = Sa, Sun = Sn)?
Filter and Copy?
IRTDUpdateEvent - Events
Initializing Option Buttons in Excel 2007
Need to Modify Existing Code
Hide rows via Pulldown
Worksheet_Change not changing
Fast Fourier Transform help..
Pivot table using Cube object - data overflow error
Macro Needed
please help me w/ changing my formula
Custum Menu won't dropdown
Excel 2007 used with Oracle ADI
Can Text be Treated as Values for use in Calculations with Numbers?
Open XLT for edit and set Addin to False
Dante's Inferno: Compile Error: Loop without Do
Search Value If Found transfer Data in same row to specified locat
Conditional DeleteRow, if portion of string found
Macro to hide column based on value on another sheet
Use of 'Text to Columns' within VBA
copy paste flexible with vba
Printing solution
Save workbook not macro
Help With Macro
Format TextBox on UserForm
Join Sheets after Running Macro
Which Shape Ran The Macro?
Moving through worksheets and enacting formatting macro
Do Loop
Userform as mini-worksheet? XL2002 on XP
Copy Hyperlinks to other cells
Truncating trailing Chr(10) in Cell w/ Len() > 256 w/o losing Format ...
Complex Formatting of cell
Count If Range?
Code Problems
Update file
StatPro in Excel
Validation List arrow visibility
Late Binding Help please
Run-time error '1004': Methor 'Range' of object '_Global' failed
Run-time error '1004':
Workbook_Open not working?
Copy Paste a sheet to new workbook
Eliminating bland from Data Validation list?
Export cell data to a template in Word
"Enter" event for text box control?
Selecting columns with column numbers not letters
Preserve the formatting of a cell when pasting into it
Is there any way to search image of my local drive with Image name or Image Title, Description
Exception from HRESULT: 0x800A03EC
Excel height and width of a pictures
Noob Question Probably! :S
Disable close button on all froms & MsgBoxes
Help required on creating names using VBA code
MsgBox Label...
Is CopyFromRecordset a bug of Excel?
Please Help--How can I get a Flag, if I try to schedule someone too many times
Conditional formating wiht complex formula
Determining build date of an Add-in
How to reference a named area
asp.net html export to excel - error
Copy Variable Range to New Worksheet
How to add a macro when Excel window is Restored
Wild Card Search Excel 2003
finding largest value
Search value, if found transfer select data to specific locations.
Sensitivity Table for Financial Model
Dueling events
Install package - registration
taking a .txt email list that are separated with spaces and sort them in to excel cells
"Live" Advanced Filter (for unique records)
defining range is my plot problem
VBA how to copy a cell value and not the formula
excel save as csv quotation mark
Useful code
Call Workbook_BeforeClose
How do I get this Macro to apply to ALL sheets in workbook?
Pop screen to appear when selecting a specific tab in excel works
Populate Userform from Sheet range (XP - XL2002)
(Complex) Creating hyperlinks to sheets
Sub Directories
Building a FormulaArray using VBA - Size Limit?
Calling macro from a different addin
Maintain integrity of Excel instances
how to paste with value and format
ComboBox listwidth to match text in list
Re: issue with ODBC connection to DB2
how do i get the "RefreshAll" method to work in a macro
Programmatically Generating Excel Line Charts using C#
Excel text box VBA
Method Range of Object Failed, Excel 2000 & 2003
RE: ColumnWidths, Characters & Pixels
numbering records on multiple sheets.
Re: Concatenation prob
Copy formula
selecting a named range based on a cell value
Changing Values
Stopping a Macro If a cell is left blank
Need to find the value within a matrix / table based on two other values
Help! Easy Macro - Find and Print
Run-Time Error 1004 When Running Pivot Table Code
Tricky Macro Coding Question
Regression/Forecasting question?
Loop Without Do
Is it possible...lookup macro
Code needed to open files one at a time
DOM Error in internet explorer
max query result size
Excel & Web Browser Embedding
Add columns of data from SQL
Object Error
Delete empty rows with macro by John Walkenbach
strange text format from query
Can xy graph origin be control from a cell?
imbedded picture
Sub to extract uniques from 200k data in xl03
Print Preview and Print
Programmatically open XLT for edit and stop macros
Linking question
Worksheet_Change
Help with Auto Fill Date
Compress picture - VBA
Making a macro loop
Which form control do i need to do this?
Total Common Numbers
Learn Excel Programming
Do References GUID's differ between versions?
Save/exit macro
e-mail subject name changing
Calculating an average using VBA
Named Range in Other workbook - not working in SUMPRODUCT formula?
UDF (user defined functions) how do you get tooltip to work?
AutoFilter Row Count
Point to the content of cell +
Creating a macro that writes to all worksheets
Question on SQL from XL to Access
Userform Textbox Format to fraction
Find and Replace Addin
Calendar queries
Does 2007 Office VBE Editor CommandBarButton .OnAction Property wo
Color Coding Cells that are listed as Dates
Unable to run macro in Excel 2007
How to keep sheet modules collapsed?
Help to modify code
very slow code
Can Formulas use a certain Digit, like the 1st or 2nd Digit, in all Cells in a Range?
Copy cells based on conditions to another workbook
Screen Trails Left Behind Form with Combo Box
How to determine color "name" when mouse is over color selection m
Program for creating buttons?
Multiple Regression Analysis
Code Modification
Help with - Get to last columns - Start next row
dialogs
seperate print and printview
Excel: Tahoma Font on UserForm
filename
How do I remove excel 2003 keyboard shortcuts?
Array Question
if cell colored in red and not between two numbers then highlight the row......
Simple VBA Code written in Excel 2003 not working in Excel 2000
Use of VLOOKUP function in an array formula
Change every 3 columns width with code
Renaming Workbooks
activex controls out of control
Next without For? can't find the problem
Excel's XY Plotting Question?
XL97 - Log use of paste function in workbook
macro to take worksheet names and create dynamic list/range
FORMAT PAINTER KEY REQUIRED
VALUE PASTING MACRO REQUIRED
A Tale of Two Cities- Find and add
Hyperlink and/or Macro
Hide/Show range based
Copy cells based on conditions in one workbook to another workbook
Referring to all pivot tables in a workbook
Reporting add-in build data
Text is contained
(repostX4) Adding hyperlink to macro-generated pivot tables
what loop structure???
An error in some code I did not write
ID multiple column headings
Open Text based on creation date
Date error message (VBA)
permission
Format Cell as Time
Exporting file names to excel
find corresponding OnAction
Reset Find/Replace settings?
save as
named argument not found
excel 2007
Macro syntax: SaveAs Filename=ActiveCell.Text . BUT to a specified folder
How to create a selection list then display the selection in a cell
Add date to cell with open macro
Using Excel to Predict Value?
ComboBox.Clear method calling ComboBox_Change event?
R/T 438 on .HPageBreaks.Add line
Check if ADO connection open
Initialize an excel datasheet
checking the content of a cell if it starts with certain character
Counting visible rows
Adding an Auto Exec macro?
REQ Help with simple Excel macro
Rename all named ranges?
Another 'Sheet Exists' Question...
Can't Paste after Changing Cell Properties
runtime error '1004' application or object defined error. Please help
How to return the cursor back to original cell
Total up values for one month
Automate Open an XLS without running macro
VB Window
Unable to open worksheet when called through a function
query tables
If then else in excel
word mail merge from excel
Calendar Autoupdate
More than 3 conditional formats or a macro?
from 2003 to 2007
Programming the Find Dialog Box
How to Set Rows with Merged Cells so They Adjust Automatically
available printers in a listbox
SUMPRODUCT Error
Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows
Dynamically copying data
Fill down - adjust code
Using split function for a csv file with blank line in between
Excel 2007 - Ribbons - Splitbuttons
Scroll home after Autofilter select
Syntax Fpr Range Command
AUTOMATIC TRANSFER OF DATA
Functions included in add-in
Named range by VBA to another workbook
Cycle through all Checkboxes on a worksheet
How to get the name from a range object variable?
Basic Search with Wildcharacters
Using For...Each...Next with a selection of rows
inserting colon into a value at a specific interval
Save Large Scenarios
formatting
QueryTables.Add - Destination problem
IF statement
Macro "Time formatting" help
Refreshing all pivot tables in workbook
references
Delete Query
Change cell range to Uppercase
Linear Programming
Excel Process Not Closed (C++) only after complete Application Shutdown
VB6 and the Excel.Application Object
Run code from separate workbook
How to automatically show list in a validation list?
Renaming Worksheet Command Buttons
Program a combination chart using VBA
Command Button Image Not Displaying
Catcher in the Rye
Separate data align on same cell
Command Buttons
Help with Macro copy/past sheet to sheet
I need to avaoid an Excel prompt.
More Multi-Dimensional Arrays
More Multi-Dimensional Arrays
find last row in one column and copy + paste data to same row in a
ListWidth and ColumnWidths
Private Declare Function
Sending Updates
COUNTA
Conditional Initialization
SAVE OR SAVE-AS with a file name derived from a cell on the spreadsheet...
vba - printing code
formula for adding quotes to pre-existing data
Passing arguments to Class Initializer
A complex VBA question
copy files (column A) to a certain dir
Excel command bar list
Application.InputBox screen position doesn't work.
Copy Sheet In Same Workbook But Do Not Know how to Change Cell Ref
Sheet tabs - suddenly have navigation buttons...
Unlocked Region within Worksheet
How Do I Sort search results?
Print data based upon date entry
Problems with Excel and Lotus Notes interactivity
Hiding/Showing OptionButtons on a UserForm
Listbox to select cells
Closing workbook without saving changes
Enter values in a column with combo box selections
Can Excel2003 Read An Outlook Express6.0 Email?
TIME
Text box to determine internal format color
How to send variables to textboxes in a web site
Why does my code randomly ignore variable initialisation?
change event doesnt work
Adding cells in data range at random to determine a given number
Visual Basic - Tuesday
data from the spreadsheet into a form
subtotal on page break
Tuesday and filedate
Updating Charts by a VBA code
problem with shared workbook
number format when returning value from odbc connection
look in second worksheet if value not found
selected range has different cell formatting
disable 2003 shortcutkeys
How to set GetOpenFilename to a specific Folder
SQL
Number Cells skip blank cells, Excel 2000 & 2003
Code Execution Interrupted ??
Treeview
What is better Variables or TextBox ?
Add complicated cell formula within a macro
Formatting withing formula?
Freight Calculation
Linking Scrollbar Min and Max values to worksheet cells
unable to read first cell from 2nd row
Save as new file ONLY and do not save changes to existing xls
Get Active Sheet
How to get the path from where an Excel Worksheet has been opened
Copy / Paste macro
How do I add a simple calculator ( Like the one found in accessori
Chart Error when using Chart Line - Column on 2 Axes in vba code
reading data from columns that span rows
using object range to call up worksheets
Vista/Excel 2007 VBA Determine if the Ribbon is minimized?
With Activesheet.PageSetup how to set 1st two visible rows as repeat (in VBA)
ComboBox won't display more than 1000 items in Excel 2007
A basic VB script--help the newbie?
Indirect eq'n to link info from vba-generated worksheet to summary
Automatically add/ delete data from range
(repostX3) Adding hyperlink to macro-generated pivot table
Auto Disable Macros on new sheet
Macro to update all queries
Can I tell what cell I was in last?
Auto Run a Macro
Running Macro Across More Than One Sheet
create a break in the run of code
Joining rows with different data
How to substitute value of stringvariable to ActiveCell.FormulaR1C
close msgbox
Compare text string of a cell in Column A VS another cell in Colum
loop and fine & replace
Hyperlink coding in VBA
dates
Code to determine if data is filtered
Challenging issue on Pivot table
excel - save file - specify path and name
highlight row
Using range to fill in cell values
Interacting with Internet Explorer Problem
Defining location of sheet relative to the screen.
avoiding doubles in a combobox
Inventory compare and copy Script
Change Directory
auto open macro when opening from template
Email Duplicates
-- operator
List of open workbooks
VB Window
Macro syntax "Save As" with filename from cell ref.
Add Cell range based on color of cell to existing formula
"Can't enter break mode at this time" error coming up
Assign Bold Feature to one of the Word in a Cell
VBA to hide headers
autoshape with macro changes colour when clicked
PROGRAMME HELP
Multipage forms
conditional formatting for ratios between rows?
TreeView Drag & Drop
Help required
VBA duplication
SheetActivate/DeActivate events in a common module
Import Worksheet from One Excel to Another
Finding worksheets with Broken Links to other workbooks
Update Data On Sheet From UserForm TextBoxes
copy & paste the column found by Selection.Find
Summing a cell containing numbers and text
Search Active Worksheet
Run a macro from an If statement
Multiple Formats In The Same Cell
Axcessing worksheets in an add-in
Object Lifetime
Bound Test in Variant Array
Copy cell of one excel sheet to other
Excel help
Macro to copy and past a new row when the a row is filled in.
Excel Lookups
Combining Text in Columsn
Excel cannot find file error
Worksheet Protection
Changing Formula References
Manual Autofilter works, but recorded Macro does something else
UNABLE TO PUT IN A LOOP
Dumb Question
Update remote worksheets
finding empty cell and enter data from right to left
Get value in last non-zero value cell in column
Exporting data to EXCEL
ÂI¼Ë¤p¤k¤k
Worksheet Change Event question
highlight locked cells
Excel programming errors for copying and pasting
Histogram Invalid Reference
Macro execution speed in Office XP/2003
Auto fill today's date
find data in another workbook
How to make the first cell in autofiltered list the activecell?
DISABLE FORMULA BAR
Imports Excel = Microsoft.Office.Interop.Excel doesn't work
How to determine whether a protected sheet has a password?
IF STATEMENTS FOR THE FOLLOWING RULES
Input boxes
Absolute reference
Unselect shaperange object after drawing it with VBA?
Can anybody help to fix this please ?
Loop, Compare, Match & Total
Cell Color
Rounding 0.5 to 1
Object Required Error, Excel 2000 & 2003
Hide the X on a user form
Shared Workbook
compile error ADODB connection setup
How can I run an Excel 7 Macro every 15 minutes?
Need to sort text data to consecutive cells (w/ Macro?)
default form behavior
Workbooks Open = different result than actually opening Workbook
Unable to write to a cell
lookup source can vary -- how to code?
Delete a worksheet
If Search that Exits Sub or Ends If
Creating a summary sheet
Worksheet Row/Column Boundaries Question
Union of possibly empty ranges
CHOOSE & VLOOKUP; Weird Behavior
Using a ComboBox Control in Excel
For each File in Folder, open?
CTRL-BREAK Mac
Date Removal
Select Printer Based on Criterea
Copy&Paste variable range based on cell value
Loop backwards through selection?
Setting page length to 60 lines? (How do?)
VB Question re: text box entries
HELP CANNOT MODIFY BUTTON OBJECT OR SEE ITS PROPERTIES....
Find and Replace Question
Getting formulas to stick during sorting
assumption issues....
Hide Rows using a returtn value in a column
number of workbooks less 1
Autoword Select
looking through entire sheet
Excel Pivot Question
Selection.Copy issue
Cell value
Inconsistent results with Query
Please help -Columns Array in SubTotals
VSTO HRESULT
Adapting VBA Code
After Update
Error on ActiveWorkbook.SaveAs method
error 438 on For statement
Password style character masking
Populate Combobox
Help in code Steve G wrote to move data from 4 columns to 21 columns
Union Function
Copy data from Excel to Internet Explorer
Start Up Functions
How to Add or Manipulate Groups of Multiple Rows
macro for adding copy of worksheet
How to check a printer's availability
2 comparison operators in select case at same level without loss in precision
repeating macros
I want to create a Summary Work Sheet...
Late Binding/Object Library Probelms
Import txt file via makro
(repost) Adding hyperlinks to VBA-generated worksheets
How to make Combo Boxes not duplicate options
Highlight blank cells
Back door into locked form
R/T error 40036
security warning
Link Excel with SAP MIS
text Formula
Change "-" from right first character to left first character to make a negative amount
Go back to the cell that I started from
macro to look down cells and if negative in the right of the cell change to left of the cell
Very Unusal Question
UK Floods
VBA to highlight cells
Locking majority of cells on a Worksheet
Generate sheetnames and skip cells?
I think this is difficult - can it be done?
Changing Cell Properties Interfering with Clipboard
Calendar Problem
Error when code runs
Need "Filename Equals" code help.
Goalseek - loop range
compare cell valeus and highlight row
paste values from an array to a range
Pull Out Numbers From String
"Document not saved" error after typing a line of code in Excel VB
macro to highlight rows that meet specific conditions
I need this to copy only the range that has "Yes"
HighlightChangesOptions and HighlightChangesOnScreen not saving?
Problem sorting data
ADODB.Connection not displaying when defining a variable
New Window When Workbook is opened
Calculation Satus for a Sheet
Named Range COUNTA fails when 1st record deleted
searching for slashes "/" in cells
How do I remotely overwrite existing sheet with a new one
Trying to close without the message do you want to save
Permanently Attach Custom Toolbar?
VBA Code needs to check for Shared Workbook
Multiple goalseek - pls pls help
Calling a Stored procedure on SQL Server asynchronously
Concatentating Multiple Worksheets into One
MSForms 2.0 Combobox problem
Macro to autofilter current month
Returning the name of a chart
Save workbook versions
Macro Question
Bring up the "find and replace" window
I wnat to copy several Worksheets, Several Times...
VBA Macro Issues after 2000 to 2003 upgrade
Conditional Formatting Formula propogating incorrectly
Public Variable - not defined?
join/union tables by querytable
Adding hyperlinks to macro-generated sheets from list of sheet nam
Assigning Macros
Unable to run the macros
BeforeSave event problem
Creating a Report
How to run a macro upon a cell click
Excel VBA Range Selection Error
Hide Worksheets, Excel 200 & 2003
Open "Function Argument Window" using a macro
toolbar/ribbon hide/show macro
Sort Worksheet Tabs
Changing chart plot formulae automatically
Excel VBA Drop Down boxes
Userform help needed
Multiple Goalseek - Range
Exercise with Incrementing Years
Macro to change sign on text file imported to Excel
macro to delete spaces doesn't compile
Finding a value in a table based on two drop menu inputs
Replace information based on existing information
programme error
ActiveSheet.OLEObjects.Add resets globals to Nothing
programme error
Calculate Subsets with Specific Criteria
A problem with cells name in a copy/paste process
Automatically Update Delimited/Comma Seperated File .
displaying "week of July 29, 2007"
very hide
VSTO 2005 Excel Addin
Can you "very hide" a workbook?
Manipulate textfile with VBA
Find all possible combinations of unique letters
Retrieving Data Range for Chart
Issue with UDFs in Personal Addin
calculating vacation
Delete duplicates - Problem
Need Help with code to "Paste into next available row"
Another Newsreader Question
Declaring Multi-Dimensional Arrays
Vlookup in Userform - XL2003
Macro works, then doesn't
How to Undo Makros
Get WorkSheet Name fails without a reason
Script problem on excel spanish version
Lost focus of UserForm
Grab Data Validation selection instance without using Worksheet_Selection_Change Event
return filename
More Conditional Formatting Woes
Disappearing Modules
Automatically Update Delimited/Comma Seperated File Options
Runtime error 9 - Subscript out of Range
Excel Save as & Exit macro
How can I check to see if there is a vertical break?
Reading Email from Excel
loop and vlookup
Compile data on multiple sheets.
vba offset program
average and format range
Checking for CR/LF in text file.
macro to find based on multple criteria & perform a calculation
XSLT XML Mapping Excel "Map Each Element" "XML Source"
Run verb, macro with arguments
Urgent! group objects in Excel
Change of table name in access where Excel obtains pivot table inf
cell size to page break
Wildcard in SUM
file losing shapes and format
How all top level elements of XML into a Worksheet
Populating a multi dimensional array
Control how an Excel file is opened
Display "week of July 29" in Excel
Wanting to Learn to Write Simple Queries
Print Causes Sheet Performace to Drop
custom menus
Missing Sheets
multiple pages
Color Cells by macro NOT conditional format
Modify Scroll Bar Control Properties
How can I convert a checked checkbox in a cell to text (True) in E
trying to get out
VPageBreaks.Count Refresh
Export From Bookmarks To Excel
Excel 2007 multiple Web Query problem! URGENT!
Find/Replace XLThin Line with XLHairline
Use Input Box to Name Adjacent Ranges
Find duplicate values in column K then compare cells range of dups
library set up
Can any MVP take this up and help me??
average of array element
Urgent!!!
Help with Right(Me.ListStoreIP.Column(0), 2)
Paste into next blank row in a different worksheet
Loop Macro
Specify a target range in Function arguements
Insert Symbol from Wingdings
Why does this loop only NEARLY work?!
Complex Pivot table formatting
Using Like Statement in Select Case
Error Msg: Can't open anymore databases
How to "clear" all previous ShortcutKey Assignments
How do I use R1C1 Reference Style in a Macro?
Excel 2003 - Weird behaviour in VBA editor
Copy Hyperlink from one cell to another using excel programming
Auto start Function Wizard
trying to use sum with range & offest
problem inserting pictures in excel 2007 using macro.
Excel Alarms
Reversing cells
Help with Arguments
validation for three input fields
Range's Address: How To Change via VBA?
Combobox - MatchRequired does not work?
New to macros
Searching: Many variations of one word
Fastest way to store each word in a cell in a diff variable
Range ("1:7") With Variables?
opening folders within a folder
List Active Macros?
Macro Code Help
Vlookup probelm
LOOKUP Function
Move active cell?
VBA "1004" error when .Refresh BackgroundQuery:=False
Stop a workbook from Opening
Microsoft Tips and Tricks for beginners
Standard Page Layout
Newsreader Set-up Question
Nothing Happens
find next NOT empty cell in column
Excel 2003 - Wizard Template
EXCEL: REMOVING A SPECIAL CHARACTER IN A STRING OF ALPHA/NUMERICS