Excel Programming [Archive] - Page 71

Getting cell value from other sheets
Appending to a file with run-time error '54' Bad file mode
How to merge worksheets on a key - merge horizontally, that is
useful templates for analyzing bloomberg data
how do i create a button on excel which would send an email / Lotu
How do you include a quotation as part of a string ??
HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE
How do I change the shortcut key for a macro
reading a cells defined name
creating a filtered range/named range
Avoiding goto
XML ERROR in PivotTable on generated XML spreadsheet
cell value not recognised
Landscape printing: userform
How do I alter this AutoSave code?
Remove a reference for an item
running script when workbook opens problems
What am I doing wrong?
Range Name question
CSV Header Information
messagebox help
Help Adding a Column with a formula
Using Filter as a criteria within COUNTIF
Excel Change Focus to Outlook Contacts
HELP on Formula
Executing Code When Cell Is Double Clicked.
Locate a change in Col
I've deleted a file by mistake how would i recover that file?
Issues with VBA
Gradient Fill in a cell
Please help me sort then extract the data to new workbooks
Block a cell depending on the sum of other cells
Compile error in hidden module: USAs
How do I create a loop to merge contents of rows 1-4 across column
Figuring ages and calculating totals on a spread sheet
How to access a downloaded file before VBA ends
Audible alert for cell condition...
Form Question
How do I create a loop to merge rows...
Convert columns to Rows
Need IDEAs For hidding data
Hyperlink from VBA ?
Working with check boxes embedded in worksheets
Excel 2007 Recalculation Bug
Date Time Calculations - Need Some Direction
converting a vba procedure/module to xml or xhtml? (vbhtmlmaker)
help: I need to have an excel worksheet name = a cell in an existi
Excel Error
Userforms and Dates
Run Time Error
take sheet to procedure
Making Queries
Multiplying range: followup for tom
setting the protect option
How to populate a summary page ????????????????????????????????????????
Distance between Forms
resizing listbox columns in excel userform
multiplying range
Selection Question
Copy pictureShape to another Workbook
Is this a bug?
E-mail date from a sheet TEXT only
Import text onto form
DoCmd.SendObject (E-mail)
Macro for finding number of times a word repeats in a cell
Run time Error 380. Could not set the ControlSource property
Command Button & Macro
Loop through range of cells, string search, take action
Problem with Protection
excel to access problems
Set E-Mail Importance with code
Help on a Complicated Formula
Help on a complicated Formula
VB Script for Autofilter
For Next loupe in a worksheetformula
locking excel sheet from vb code
Compare 2 lists and show reconciliing items
Run time Error 380
Can't find project or library
Search engin
Find MatchCase problem
How to index a variable in VBA
Software language version discrepancies
how can I control the mouse pointer by the Excel VBA?
Formula Help...Easy One.
msgbox to display a cell value, HOW, If possible?
delete a file in code
How to Update Price List
format last 20 rows
Code to convert date (xx/xx/xx) to xx xx xx
How to insert color in row or cell?
Setting dropdown menu to default value
Word wrap merged cells in Excel 2003
How to Populate a summary page from the input page???????????????????????
How to calculate the MTBF for time and date.
What's the vba equivalent of search(text1,string,1)?
SQL parameter query - more than cell value
Excel not refreshing data for User Defined Functions
Opening a workbook withAuto-open Macros without transferring control
No events in form displayed from callback routine
How can I get the author of a file using CreateObject("Scripting.FileSystemObject")?
printing macro?
Loop thru cells and find match
Macro in Excel causes problems when spreadsheet is opened in IE
Possible -- a custom format on text, similar to a VLOOKUP() function?
Problems with excel and screen projector
sheet name used ?
Tricky compare formula
Automatically Close Workbook
Printer
How to Question
Excel sheet size as OLEObject in Powerpoint
AutoFilter - How to determine number of records found
Compile error on VBA Function
Add password to querytable command
formatting question
Ranges
Extract text
getpivotdata problem
Excel Colors
Combining related unique (distinct) values from two columns into an array
Reverse Engineer Pivot Table
Picture on Spreadsheet will not print
saving text files and parsing data to spreadsheet
Need help Utilizing Dynamic ranges for creating charts
What is wrong with this code to name a worksheet range
Disable Autosave
How to continue macro if there is an error value
filter combo box based on another
Compare 2 excel files for the cheapest price.
Hyperlink Defaults
VB to AutoSum
Click in ComboBox question.
Application Updating?
Dependent dynamic combobox
Can I use conditional formatting for this neat thing?
please help with syntax in code
NOT changing Date Modified
Multiple Hyperlinks in 1 Cell
Populate multiple worksheets
Calling Excel macro from Access errors
Macro to format text
Update workbook which is an attachment.
Fastest way to access information inside a WorkBook
Trying to get a splash screen to listen to me?
more than two optionbuttons in a group
Select a column using it's number
Excel macro to sort columns, one row at a time
How to backup excel files?
DATA VALIDATION WITH AUTODATE2
Various Version References = Compile Error
Mulitple SUMPRODUCTS?
Excel macro to create directories?
Combo box properties in VBA
Global definitions
Calculate time to do a job
Combining data from multiple rows
Form Combo Box RowSource Question
delete rows that contain ********* ?
About workbook_Open madro
Consolidate sheets automatically
How do I make a cell allow only 24 alpha/num. char.to be entered
Font Size
Cursor Placement
Is there a simple way to check lots of cells for entries?
Runtime error '462'. The remote server doesn't exist
Check whether appointment time is free in Outlook Calendar
Macro inserts a column but dont update formulas in another sheet!
Repost: Userfrom Back Color
assigning random numbers without repetition
Comparing values
Arrays - Lower Bound and Singleline Assignment
function to call an ODBC query...
Excel 2000: Dynamically Generating Data Driven Sheet Columns
Autofit
VBA (excel) quits on workbooks.open
For every new number in Column A - change row colour
Navigate between open workbooks
How to Transfer an Excel Range to an ADO.Net DataSet or DataTable in VB.Net?
print procedural question
Linear Programming(solver ?)
What Causes Automation Error When Excel file on Network?
not excel data source
Insert blank row macro question.
Combo Box Properties
Help with ranges
Excel & Outlook
Merging Col A with Col D
Keeping the formatting Excel to Word
Help with event
Save as !
Delete rows that do not match criteria
Help on Displaying Pictures
Format Entire Sheet Column Widths How?
protection using UserInterfaceOnly
Looking for a better way - Serial to local machine number
make a box with:
VB Delete rows that do not match criteria
How to get Excel to use a custom RGB color in a chart series?
How do I do a cell reference to upload a picture file
Post info to webpage
Cells in a range
How to use/evaluate another Cell Formula in R1C1 style
Need Help Delete Columns Macro PLEASE!
indirect formula help please
MACRO in EXCEL
select and delete certain rows
Disable Move or Copy functionality
Autoscaling a chart
Essbase Add-In Functions
Find & Replace Macro
Date Modified
One print job as oposed to several ?
How do I reverse information in a cell example last name, first n
How do I reverse information in a cell example last name, first n
Subtotals on for selected data fields in Pivot Table
populate 2 column listbox from one named range
Sort Cells?
Need explanation of code please
Get a specific cell value/text inserted in a macro
For Each...won't loop through worksheets
Historical Data - Progress Mesurement - Track changes - Log
Cell Formula
Syntax help for if
TRUE and TRUE or TRUE then......
Closing a workbook
Can excel sum a vlookup value and return the difference?
Printing text from a textbox in a userform using vba code
Getting Shortcut Information ?
Page Setup, Scaling
gathering information from web pages and trasporting to excel
Copy an Excel sheet using VBA
Hiding rows that are included in a named range
Finding Links
How do i reuse a Excel macro on another worksheets, global macro?
How do I setup a spreadsheet to scroll past what is on the screen
eliminate blanks from listbox rowsource
Saving Macro
Combining lines from individual sheets into one summary sheet
Consolidating Lists on Information
Columns by numbers
How to Read File Properties Programmatically
VBA validation & error reporting
Open Word Document and Accept Track Changes - Partial Solution
InputBox with multiple answers
array copy
indicating sheet
running program from userform
updating hyperlink
Verify Input
DATA VALIDATION WITH AUTODATE
Todays date plus 3 months & less 3 months
Help with my VBA Vloopup
change properties on
Drop down missing in cells with validations!
Checking if something is past due
Input box with multiple choices
How to work with NodeList
Change ODBC
active sheet
Formula Errors
how do I write an IF/other statement to capture certain time data?
Macro to merge worksheets
Visible automated Excel: automation crashes if user selects cells, protection?
Running Macro "Logged Off" & Copy/Paste from WORD .rtf into EXCEL .xls
Macro to delete only certain rows
Copy Comments to a cell
Date
Select corresponding row on another worksheet
Automatically installing and running the Analysis ToolPak add-in
Conditional formatting based on formatting
How to count the number of cells highlighted using Conditional Formatting feature present in Format Menu of Excel???
Modifying built in document properties using an excel macro
Complicated Macro - Someone please help.....this will definetly be a challenge!!
Check the value of Password
opening hyperlink with other program not explorer
mail a single excel sheet
Excel remains running due to held references
How to loop (or list) all the criteria in autofilter
Pasteing a list without duplicates
Excel 2002 autoRecover settings
Restricting Pivot Tables
Reading a Cell Value in C++ (with Autowrap)
Need help with setting variables
Running a macro when there is a given cell entry
Call by value(and not be reference)!
Issues with wrapping Excel text macro
check status bar condition
Range Offset
Input filename at start of macro
More than 3 cell highlite colors ?
PASSING PARAMETER FORM DOS script to Excel
.BackColor of CheckBox only extends as far as the text in the caption
how to setup GETFORMULA() in EXCEL 2003?
MATCH does not work on a UDF-generated array
Cell Highlight
Creating Macro Buttons (Any Good Websites)
Deleting worksheet specific range names
Creating a Complex What if in Excel: Beyond Nested Conditionals
Cell Highlighting
extracting numbers from alphanumeric strings
Unable to run VB Editor within Excel
RegExp to Parase File paths
VBA continue
Copy If
Adjusting the range of a script
Simple Macro
Sub Menus disabled
ComboBox_Change Event to Populate another Combox
Permanently Disable Auto Formatting of Cell Content
Getting an error using
Pulling String
Pulling string
Custom Toolbar showing in any and all workbooks opened
How to assign a Category to a custom function?
Looping through a Range and copying to Another Sheet
question on using average function in macro
copy data as string and paste into web form
Step-through works, Run does not?
Formatting Cells
Macro to change file name in Vlookup formula
Revision Number for an Add-In
Unprotecting Workbook
How to add text to this formula?
Excel - Slight edit of the macro below should do the trick! Add filename to cell A1 upon merge.
Fetch Access data from Excel
Automatically close a message box
Linking/embedding worksheets
What cell caused the worksheet change event
Excel VBA - checking a date field for null
Change ODBC
Passing a Control as an Argument
checking value of named range
shared workbook
Add Fill Color to Row
Help with filter code.
Copy Data from Multiple Closed Workbooks to Open Workbook
Object for visualizing processes and plants
Excel to Open Lotus Notes
Fast blinking cell
Return matching names per criteria in table
How to Create a macro from drop down list (Validation List) in excel
Enum Names
Search for text easy macro
Seeking help with MACRO or VBA??? Open all files of type in directory and parse
Count occurences and rows they are on
Add sheet to workbook
Open but not activate
unable to open excel 2007 and interact with it using vc++ code
how to open excel 2007 and interact with it using vc++ code
Excel -> Access Table
String to name
help with loop in autofilter
Print Variables ?
I need some help creating a graph with multiple ranges
Create New Sheet from template sheet
How do I set Printer Paper Source using Visual Basic?
Module still there even after remove and save
Specifying work-path
get data and field name using querytables
Text to rows...at wits end
Changing cell value in a range terminates code execution
toolbar or icon in a add-ins
Could not set the ControlSource property. Invalid property value error
Re: Excel Web Query
Check if any value in a range is equal to 0
VBA / Changing the colour of cell given an input
Loop w/ Public Function as arguement
Array, Range, Lookup - I'm not sure!
Cell Selected to run Macro
msgbox - How to Create a New Line or 2
Time limit restriction.
hide rows
Macro Issue
left or right
Disabling the Red X in Excel
How stable is Excel using timed loops
XML copy from table to table
Automatically executing a macro when A pick list item is selected
Excel Tabs to indvidual PDF Files
Cell Value (Date) + number of days in VB
Please ammend or adivise re this easy print rountine
fonts for if...then statements
Searching for blank cell and populating based on previous data
How to id if range is correct?
Why is this an error?
Security within menus????
Macro to run in Specified Sheet and Column
Simple if statement?
Saving as Sheet as a Tab Delimited Text file
Substitute copy for cut
How to paste non-adiacent cells values inside an email?
sum is represented by a picture?
Bizarre mutation of data upon assignment to cell !!??!!
help
End of Sheet
Adding custom menus to Excel ????
2 problems to solve
Better way to fill a ComboBox ?
Inserting VBA Code Programmatically
Floating commandbar problem -- toolbars destroyed only if sheet first upon opening ... ?
Formula that takes a cell value over another?
Validate Cell Content AfterUpdate
programatically reference controls on spreadsheet
How to create hyperlinks in an Excel Form
Making a matching worksheet allowing drag and drop of protected cells...
Cutting and pasting large variable text into a text box shape usin
Closing a workbook after it has opened another
same row different column
Excel Question Prevention
Web update onchnage macro
Easy question on formatting
Count number of Rows with Value
Delete rows that are visible after applying filter
Compile error in hidden module: This workbook
VBA: List of blank and non-blank cells
spreadsheets should be available to handle groundwater problems
VBA Programming.
Summary sheet for multiple worksheets
Excell cell formatting
conditional displaying of data
step up loan amortization - by annual increase %
Draw words from a list without duplicates
Protecting a Microsoft Query
seggregating email addresses
IWshRuntimeLibrary.WshShell.SpecialFolders requires a variant argument
Listview - SetFocus and Me.Repaint
searching for a specific part of a formula
pareto diagram
Conditional Formatting (two sheets three cells)
Script is bogging down and will not end
Getting to SQL Server without ODBC from VBA
Paste to the right
Creating an Index Sheet that obtains a cell Value using VBA
replacing , with nothing ?
If..statement
Removing extra row from range
entering date, formula for continuing date to contract terms
Script is bogging down and will not end
How to create Singleton Pattern in VBA?
Update links
Excel Chart after paste to MS Word 2000 (URGENT)
Column shading color based on specific cell content
Can I force an entry?
VBA command has stopped functioning
Use of UPPER()
Offset Question
Link cell
embed cell references in macros
Delete all charts on single Worksheet
error - KB article 320369
Help with an formula
Sheet selection help
Updating Access table with a range from Excel,
Pivot table in Xml Spreadsheet
Copy/Export/Transfer charts from Excel to power point with VBA cod
Remove Modules not working
Customizing userforms on button clicks
Error in PasteSpecial ?
Can .xls make itself ReadOnly?
WorksheetFunction.Trend doesn't work?
Macro - settings to protect sheets
Range without Blank values
trouble with macro
calculation
Move Specific Text to new worksheet
recovery loss data
Force TextBox to hold time ("hh:mm")
Range going up the column instead of down
determine if wrap text is set within a range
Email a text file from within a userform
Macro list in Tools - Macro
copy one array formula to an array range
Array
How to know if 2 sheets are identicals
Call Worksheet_Change macro in another worksheet
Closing internet explorer in an excel macro
Where can I download Help on Excel objects.?
Syntax for changing font color in a Shapes object
Writing the result of arithmetic calculation in a cell
Menus in an xla
Telnet from Excel 2000
Opening MS Word template using VBA in excel
determine if there are hidden rows in a column
Update from web
SCREEN UPDATE!
Results no longer currency when adding text to formula / formulas based on resulting cell don't work.
vba to set calendar object auto load to TRUE
verify a shape exists in the sheet
Re: detect ctrl-c was pressed (in copy mode) from vba?
determine if first word of cell is capitalized
Help, Tom Oglivy
Email hyperlink
Bracket Sheet
calendar question
XLL and function tips
Range offset
textbox codes
Need to Export All Worksheets from All Workbooks in Folder to Separate FIles not as CSV Files
exporting multiple ranges to a gif gile
Taskpane turns disappears.
E-mail to a list in worksheet
textbox show correct time in userform
Macro Security Warning
Macro to replace file name many times
Find number of employee's working a Shift
Need help for Date & Time adjacent formula
search, compare, execute based on specified criteria
ListView - Data from the first column can be modify?
Character count
ListView and checkbox (Refresh problem)
Run-time error, why?
Changing function key definition to insert time
Coding a SumProduct formula
How do I display the link location of a hyperlink?
Re: detect ctrl-c was pressed (in copy mode) from vba?
Daylight Savings Time Fuction
Macro's only partly activated?
Formula for cells
Program to insert rows
Limitations of auto-open (xlstart) macro
query question
Macro to run macros
setting up time sheets in excel with total hours
time sheets using hours and totals
Invalid index in foreach(HPageBreak hpb in sheet.HPageBreaks)
Re: ALL;TOTAL reference help
preserving variable from userform
Web query parameter
find cells based on its content's format
A challenge: referencing cell contents in a nested function formu
printing questions
Help on VBA Arrays
Re: How to assign a collection item?
Calendar control
Filtered list code (changing criteria)
remove formula macro
determine if autofilter is on
RE: Excel instance won't unload from memory
Covariance in Excel in biased
RE: detect ctrl-c was pressed (in copy mode) from vba?
ReDim an array of variant - Help
automation
Re: Determine if Excel is running in a browser window
Find
Lookup from External Reference File
Loop until
get range coordinates
replacing built in keyboard shortcuts with my macros?
VBA Script to use any open file when copying and pasting
Display check mark value
Remove data from a cell
VBA: format, Format or FORMAT
Range Formula question
Using the file search object
VBA copy paste sort refresh
set control toolbox- optionbuttons
copying variable range not working
Run-Time Error '380'
specify a specific column to input text based on another cell's content
testing for characters
creating matching lists between sheets for comparison
When importing query from code - password required but not directl
Don't let user close. Use macro button to close?
Microsoft Query
vLOOK UP INTO vba
test do not read
HELP!!
Deleting Rows Problem
help with find value select range and paste to diff sheet, multipl
.xls to array in c++
converting data from table to individual sheets
Line Position Drawing Object
SQL
Macro help
Macro help
comboboxes
menu
Replace characters with symbols
File explorer
Delete entire row based on cell color
VBA: sheet in background
time
help with code please
User Form: Combo Box - filter out repeats.
How to mark an item selected in the Excel VBA Form?
Sum orders in a month from a table
Conditional Formatting Help
Control not showing normal user
Excel2000: Opening *.csv through VBA and International Settings
simulate mouse movement
Copy Charts from Excel worksheet to PowerPoint
Week vs. Week VBA Function
Stop vbTimer
How can I disable linking?
Incorrect Date Returned
How can we change linked numbers to words in Excel?
Loop through values in a combobox
Most efficent code to copy a row on one sheet to a row on another
How to Reference a .Net Assembly from within VBA?
How to get the current cell position in VBA (eq. Row(), col() in F
Create, delete and re-use a range name
Macro warning but no macros
macro to find extract and paste contents from one cell to another
Using ActiveWorkBook.RoutingSlip
Copying Range Based On Certain Criteria? Possible looping through the Range
reset cell.Hyperlinks.Count to 0
delete two columns at a time
VBA date difference
Search for the YTD Actual column, copy and unlink
How do I capture CANCEL on an Inputbox?
How do I capture CANCEL on an Inputbox?
Saving Workbook
Saving a worksheet with a condition
Searching in Excel
Application Defined Error setting a formula via VBA
Excel dropping decimal places
Access Functions & Subprocedures in an Add-In
Merging Tables
throw string
Outlook Express - Importing emails into Excel via VBA
Protect Macros From inadvertent Use
Problem w/code to copy worksheet to new workbook
Using Macro to hide rows that have a "0" quantity value
Copy Paste Special Transpose Skip Cells and start over
Caption on UserForm only setting in Subclass
Naming A Worksheet
Range names in macros - DA
Copy works using A1:L1 Format but Not Cells(..) Format
Passing Arrays to SUBs
How can I Center a Dialog Box each time a user opens it?
Naming Ranges
Excel equivalent of Lotus {?}
Open a file on startup
close UserForm
Cell Formatting
Progress bar freeze while running code
Invoke Outlook Contacts From Within Excel
Send email notice when date reached in an excel spreadsheet
Copying strings and using counters
Answering Message boxes
Auto Archive old file to a folder
refedit won't work
Looping over a worksheet
paste cells with reference
Updating subtotals
copy formulas from horizontal cells into vertical cells.
building a macro that saves a file and converts to pdf
Exit without saving in a macro
Batch Processing macro for excel
Cell Formulas
'Type mismatch' error!
How to goto the next available cell in a column.
ADODB.Connections Error
copy paste loop---new to vba
User Form Help
Text Box
need to create shortcut button in Excel spreadsheet
What's this new sheet?
Microsoft Excel for Windows has encountered a problem....
Running SAME Excel macro with VBScript
Macro to Open Word from Excel
savecopyas saves as file type
counting pivot table subfields
drop down list macro help
User Forms
Set focus on Subject line in Outlook
Activate a Worksheet
Excel
ListBox edit
Check Format
what alternatives do I have to msgbox??
Opening pdf's while embedded into an excel document as a package
How do I write a Macro that
Showing the Address Book window
Formula req
Replace character in string, not document
delete rows when value is within an interval in col 3
Position of the mouse pointer
Date into filename noe I need time also
Can Visual Basic update a Shared workook rather than autoupdate?
Group and Delete
Copy Records from Access Database table(more than 5 lakh records in this table) to Excel Sheet
Calendar control not showing properly???
Copy to bottom of sheet quickly
Visual Basic for Excel
copy down without changing cell numbers to bottom of worksheet
programatically drawing flowchart in excel
Changing cell colours based on a cell value
VBA code to search for a text from a userform
Searching text
How can I create a button, that is linked to a macro (start)?
associate cell format
Dice
Find MatchCase problem
Extracting row data from a range
Format Painter Keyboard Shortcut
Run-time error '1004': Select method of Range class failed
Hiding Columns based on value from another worksheet
Excel File Slowing Down after Macros Added
ListView information
VBA Updates Cell but not the cells that reference it with formulas
Creating a report to send extracted data to
Determine the last non-blank cell in a range
Hiding a sheet
VBA Code - Pasting Pictures from Excel into Word
Excel Macro for creating bar chart
Activate Macro Button Located In Another File
SaveAs closing file without firing event WorkBook_beforeclose
Push Button in Outlook to Change Focus to Outlook Contact List
Getting a clean part number
Error With ADO (Starting to pull my hair out)
Web Query Macro - Mixed content prompt prevents script from loadin
More efficient memory deallocation
Quotation marks and variables within code
Workbook takes a long time to open (calculating), why?
code gone wrong when trying to make an automated form
VBA Code help
parameter and macro driven pivot table filter?
Searching for Saved Files
Suppressing Update Links Warning
Testing if a workbook on the network is open
Excel.ActiveWindow Is Excel.ActiveWindow Returns False
refedit control not seen?
DirectX use in Excel
Variable Printing Procedure
How to create copy & paste loop--rows to new sheets
toolbar macro buttons
Export many sheets to one text file
How to know if a variable has been reset inside other function
Filling a listbox
Find Maximum value in a range via macro
Command Buttons
Date formula in file name
Finding Certain Data in a Worksheet
Filename Problem
System.AccessViolationException on VS2005 and Microsoft.Office.Int
Cannot sort Tables in C#
CallByName in Excel for Fill object
capitalizing first letter of a word in columns
Open the OpenFiles window
Conditional formatting or worksheet change event?
Need some VB script, please
if Stucture help
Trim for Hard Returns
Workbook_BeforeSave - driving me crazy!
Get the name of worksheet behind active worksheet
Copy rows based on a word being found in a cell
Mailing to a distribution group in Excel
Find Hidden rows and delete
Multiple font sizes in a single cell
Changing the value of chart labels
Listbox header inside VBA (Array("Head1", "Head2", ...)
vba. help. reference formula
storing input
Strange glitch
Put Password Protection in Code
How do I change a merged Cells background color
Problems with userform, refercencing code to worksheet
User Form
Change a cell value when another cell changes
Similar to SPLIT
Handling Excel Evens in addins
Overimte Problems
Using ADO to read from ActiveWorkbook
list comparing - vague data
Search for data and bring it up in another worksheet
SUMPRODUCT Problem
How to make Join in VisualBasic
Bring Queries from Access into Excel
Data Lookup Help
If Cell Contents =today() then....
Closing word from excel
With statements
creating a new worksheet from a template using VBA
Programmatically getting a Max value from a PivotTable
Error 1004 + my Pivot Tables
Loading userform problem
BackgroundWorker in Excel 2007 Managed Add-In
Specialized search engine for Excel
distributing each characters on a cell
Runtime 91 error due to cells.find statement !??!
Range Object error
run module in another workbook
Import data into Excel sheet from CSV File
User Forms Multipage Background/Foreground Colors
Run Time Error 1004
Importing VB code and having it password protected
How do i Link SQL data with a Excel Cell.
Number of hours between 2 dates
Controlling Listbox Scroll Bars
SUMPRODUCT in VBA
auto fill-in formula
Find date in column then delete row???
Does AxisTitle Interface totally keep compatibility in Office 2007 beta2?
Simple oversight on my part in this code I'm sure
VB Script to insert row and calculate a range
Compile Error (ADO) Ron De Bruin
Automatically copy macro to multiple workbooks?
Create worksheets and populate
Real Meaning of Apostrophe?
customized toolbar buttons macros to a group of users
Range (variable)
Check if number in Excel
To refedit, or not to refedit, that is the question.
Limit on array when using seriescollection.XValues and .Values met
Read Only Issue
SendMail disable question?
Creating right-click menus
Printing a sheet
Checking HasPassword property without opening
dynamically select sheet
simplify formula
Replace Error with Empty Cell
1004-Applcation-defined or object-defined error
Filename Problems
chek mark in menu item
iam new to programming in excel i require help
Run-Time-Error : -2147417847 (80010108)
Finding a list of tables in Access from VBA in Excel
Transfer data from worksheet to array
Filling menu items
NEW: Macro KB shortcut doesn't work (otherwise Ok)
How do you dynamically load an array?
How to pass file references to a sub in VBA
search or vlookup help
Comment Location
Autosizing a Cell
Change color of moved cell text
Automatically hide rows
Nested Ranges?
Workbook Open?
Settings
Help with populating new combobox with list of ranges
Problem opening Excel 2007 file from OleDbConnection
how to refresh a query table every "x" amount of minutes
Moving Data from Rows to Columns
Mouse Scrolling not working
repeat procedure with new range
Simpl Q about the Workbook Object
HELP Formula
Automation Error: Object Disconnected From Clients
Formula HELP !!
File changing after saving - excel VBA problem
Unhide row based on cell value
Macro not saving properly? Can't see problem
How to make userform work publically with hidden sheets?
vba to click a command button
Excel 2002 - Bloomberg
subtotal/grouping problem
comparing two excel files
Help with Sum formula
Worksheet Code Name question
procedure call error issue
Excel VBA & Arrays
problem :Onclick event occurs after a Setfocus
Connect an image to a cell and row
Defining Loop Ranges
Send named Workbook to Outlook
Need to turn this in to VBA
Have current date display in File Name
Populating Document property values using macro
Need help with MultiSelect List Box
More than one Target.Addresses
Convert UK DateFormat to US
Answering pop-up question
Open Workbook
Maintaining Formatting in a UserForm
pivot table error 1004
need to find highest total
data set for linear regression
Cell changes highlighting
Option Buttons -ActiveX
Hiding/Unhiding protected columns
Run-Time Error 91 for Internet Explorer .elements(name).value
Check for open workbooks
reset control toolbox optionbuttons
look up
Searching for Alphabetical Characters
Parameters and DateTime
how can i get VBA to give rows numbers
fill a listbox with data
Leading zero in hyperlink TextToDisplay
Refresh a pivot table then apply a macro
Running program
How to start a macro with a if statement
Excel / Formatting a Cell / Setting a string range
Help!!!. I am trying to calculate hourly pay mixing hours and dollars
OLE and excel on Windows 2003 server
CountU from an array - SUMPRODUCT, SUM(IF(...)), both?
controltip carriage return
Disable Auto Date Formatting for QueryTables.Add
Extract a percentage from a text
Listbox Looping
Button supposed to be transparent but is not when clicked.
How to export Excel data to Outlook tasks?
Launch Excel from the Web
Dynamic Pivot table range
Number Grouping Formula or Macro
Formula text and decimal place
Tri state macro
Copying Formula into a Dynamic Range
Could This Be Done With VBA?
Count and get position of spaces within a string
Having Trouble deleting a missing reference
ActiveCell.FormulaR1C1 question
Assign Macro to Checkbox
Column Headings in Pivot Tables
First time a WinUser uses Spotlight
Temporary Footer?
Changing the print_area
Conditional Formatting Cells
Macro Question
hotkey in usrform
Select a cell
COMPARE COLUMNS
convert a Word macro to an Excel macro
Need to add a copied line to 1st blank row via a macro
Caution Signal
what is enableselection proprty does?
sorting/no duplicate scripting dictionary in Excel VBA
Excel and MS Query question
difficulty opening userform
Turn off R1C1 reference style via VBA
What's the best way of writting a text file through VBA?
Auto Open file to run Mail macro
hide , unhide colums
Basic If Statement
Force recalcualte on cell format change
Help on Formula for a cell
Change formulas into values based on cell color
Inter data into a cell
How do I make a worksheet name equal to a cell
How do I make a worksheet name equal to a cell
IF (xORy) AND (xORy)...?
suming instances in pivot table
Excel combo box error message "not enough system resoureces to....
Subscript Out of Range Error
Lowest repeatable number in a range
Formula Bar Shortcut Meny Insert
Combining 3 workbooks to one
Need help on Address
Protect Checkboxes
In Excel, how do I make a lookup table that returns a function?
how do i convert selection.end(xldown) to use in Progress
Macro problem when sheet protected
Deleting a Row or Rows
Updating Pivot Tables
FoundFiles
Error Reporting questions
System error &H80004002
Launch a .bat file with VBA
Summarising entries on a Spreadsheet
Conflict with 2003 Office
Open an Excel document in 2007 document using the 2003 office
exit sub
select range for pivot table command
URGENT HELP ON BLINKING/FLASHING CELL
Subtotals
flashing cell in excel
SpecialCells(xlLastCell) selects old data
Set an object variable to the vb editor itself
Resize a range
Tools menu
What is better: Application.FileSearch or Dir ??
Pivot Cells Values
NULL into table
Userforms
Is it possible to recalculate a single workbook?
Desperately Seeking FirstCell Find !
Workbook with UDF needs "recompile" after opening with other Excel version
protecting sheet tabs
Stock control formulas, counting and reporting remaining stock
How to scan directory , list all the file
Formula in Excel for stock control records
VB To Re-Name Worksheet Name
Finding the last cell in a protected sheet
Total Time Problem
How to embed ^{1,2,3} in TREND Function in VBA
Creating NamedRanges with VBA
Assign shortcut to button on userform
Formula for excel worksheet
Problem copying to another sheet with specific criteria
Excel: A document with the name is already open
Open an excel attached to an email
Launch Excel from the Web
Autogenerating a number (Estimate Ledger)
Excel 2000 VBA Reference
Creating a Template for mixed Data
Sort reference is not valid
always the specific control has focus when F3 or Ctrl+q is pressed
scheduling a server-based app
Text to Speech
Text to Speech
Close Workbook If user disables macro's
deploying Custom.xls
working hotkey even if any control has focus in userform
Importing Specific Rows from a text file into Excel
Cannot select single column to the left of freeze
Populate an array using a formula