Excel Programming [Archive] - Page 25

XLA file in project
run-time error dialog
Macro to insert row
run-time error Dialog
run-time error Dialog
Summing only cell that contain numbers
2003: Having trouble with conditional formatting with custom user function
using an email template from macro
Collections vs. ADODB RecordSets - Which is better for in memorydata
can I use an existing outlook template in an email called from exc
can I use a template in an email called from a macro
Can I force my UD Functions to recalculate?
Inputbox Method - cancel Event
C## vs. C++ Excel Add-ins
Newbie Worsheet_Change question
Newbie Worksheet_Change question
Newbie problem with Worksheet_Change
InputBox Cancel event
Find and replace in new row
InputBox Cancel event
Adding HPageBreaks after a Chart
Cell Content Removal
Clearing only cells w/ numbers
tricky find and replace
tricky find and replace
search and replace
Cell content removal
search and replace
Name a Table relative references
works with numbers but not text
Cell Content Removal
Name a range with relative reference
Removal if cell contents does not meet vriteria
Removal of cell contents
Prevent user from sorting a Table
How do I Disable My Buttons in a Customized added Ribbon Tab ?
Help with Range Macro
How do i select an inserted image.
How do i select an inserted image.
How do i select an inserted image.
Works for number but not text
How do i select an inserted image.
code not working
Code not working for text
Macro Required....
Code not working
Windows Operating System
Create Excel to PDF by VBA
Event Reference
geting built in dialog info
queary on how to disable rows with empty values
Problems with the MS Communities Web site
line continuation
Line continuation
Line continuation.
Reset and display scoll bar in text box
Cell copying
A1=name of folder >> B1= Subfolders,seperated by comma(Tricky Problem?)
pivate tables
how do i create all possible combinations from a set of nos. in ex
how do i create all possible combinations from a set of nos. in ex
Code modification help
combobox rows format
First occurance of text in a column
Change the font color based on value of cell
Change the font color based on the value of the cell
Iterate through treeview nodes
How do I display an excel file with toolbar in a web page?
How do I display an excel file with toolbar in a web page?
help with code and array calcs
Add button and code using form
# Value Error
list to populate ComboBox
Date and day formatting
Problems created XLL addins for use on multiple operating systems
Problems creating XLL addin files for use on multiple platforms
copying a formula to another cell
copying a formula to other cells
copying a formula to other cells
copying a formula to other cells
setting cells with formulas
Selecting a text box
Returning the focus to Excel
Can Listfillrange be used with a listbox on a form?
Variable Scope Question
Calculation Problem, Multiple Subroutines
How can I eliminate blinking scrollbars?
Possible a macro dates and grades
Change part of copied formula from relative to absolute.
Formatting formula output
Row vs column size
Drag item in list box
using a variable in the sum function
Is this an Excel bug and how do I report it?
sum a column with a variable
change several cells based upon the value of one cell
changing several cells (both cotent & format) base on value of 1 c
changing several cells (both cotent & format) base on value of 1 c
Errors being displayed when I reply
Run time error 13, type mismatch
Run Time error 13 type mismatch
Deleting bitmap in a form
Delete a bitmap from a form
using Global variable of Userform in module
Need help
I need help
Setup Cells Without Looping
Venn diagram macro in VBA.
Weekly or Bi-weekly dates
Weekly or Bi-Weekly dates
Excel email using Novell Groupwise
Copy and Transpose
Excel 2007 macro conflicts with excel 2003
Clearing the contents of a row
Name a File via Code Q
How do I digitally sign my macros?
Can I overtype a listbox item
MultiSelect & order of choose
ReDim not working as expected. Array expert needed.
Macro not working properly on change in cell value
Macro not running properly on change in cell value
Can I get a popup MsgBox without stopping/pausing VBA program?
Adding a Dropdown Control to a Command Baar
Can Listfillrange be used with a listbox on a form?
Populating Cells With a Macro
time stamp capturing
loop
Addding dropdown to command bar
Adding a Dropdown Control to a Command Bar
Macro To Populate Columns
Application.Match on 2D array - syntax problem?
LOOP
Can Listfillrange be used with a listbox or combobox on a form?
RE: Can Listfillrange be used with a listbox or combobox on a form?
Test for no listbox selection
Listbox no selection
RE: Listbox no selection
Comments
Resetting Find
Missing Table-Drop Down Arrows
Hyperlink
Re: calculations with arrays help
Re: code to stop all running macro's
VBA Regular Expressions & URL Extraction
Re: Autonaming tabs
Autonaming tabs
RE: Importing Data to a Template
Create list of selected criteria in auto-filter range
Importing Data to a Template
Search Files and Report Results in Date Range
Macro to run on Mon and Tues
calculations with arrays help
copying formula
Re: Align picture to the right side of a cell...
code to stop all running macro's
RE: Creating a Search Engine in Excel using a Macro
Last row w/ non-null result of formula
Excel File Suddenly Grew 7X in Size - Very Slow Now
Align picture to the right side of a cell...
Creating a Search Engine in Excel using a Macro
Re: Copy to another workbook - prompt for input
Collections vs. ADODB RecordSets
Copy to another workbook - prompt for input
Converting ISBNs: 13 to 10
Excel
Fighting a date format
Determining cursor position in a named range
Re: Macro to Insert Changes the Formula
Macro to Insert Changes the Formula
Excel 2007 “Lock Drawing Mode”
Excel 2007 “Lock Drawing Mode”
My formula is "running" from me: Please Help
Excel.Range.set_Value causing "Exception from HRESULT: 0x800A03EC"
Macro to find range of cells
Re: "Button Click" Macro
"Button Click" Macro
Summary table for cell comments (updatable)
arrays and labeling
Formula Error
Copy cell backgound color to another cell
Afterupdate problem with setfocus on a txtbox in a form
Error 1004, clean memory?
Error 1004, clean memory?
Incorrect CurrentRegion.SpecialCells(xlVisible).Rows.Count on filt
making a cell a certain font color based on condition
making a cell a certain font color based on condition
Text to Speech
Rowwise data into columnwise data
Using TAPI in Excel VBA
Font.ColorIndex
Legends different when running the macro
Problem with command bar
problem with opening Excel file using c#
ActiveWorkbook.AddToFavorites
Run an external bat file from inside VBA
How to automatically copy new data in an excel sheet
Send mail from excel - Copy/paste unformatted values and error
Simplest way to calculate for a cell which embeds text
Copied Formulas Not Working
2003 created Workbook casuses error when macro runs in 2007
Delete rows with date more than 48 hours with a condition..
Print Area Set for Columns but Not Rows
UDF that checks if a cell contains a period.
Freeze panes
Scoll so taht the active cell is in the first line on the screen
Highight cell with non numeric data
Conditional testing
Macro for printing
Multi-select UserForm to download
Re: Highlight Cell
Highlight Cell
Delete command button
RE: Formula not giving correct answer
Quote in equation causing error
Formula not giving correct answer
Re: #VALUE!
vba error in sql call command
Combine cell info into one cell
Code problem
Placing value in every col of a named range row
Day of the Week in Excel
Select and rows to another cell if one of the cells contains data
show cell value
Add data to the name of a tab
Userform Combobox
Why formula isn't working?
Pivot Table..getting a list of all, sourec odata and sheets locate
Can this be done
Can I customize the Yes/No buttons on a MsgBox?
Inserting code to call a routine when creating a worksheet
Named Range override when copying worksheet
NEED HELP....
Clear contents on change
Macro help. Insert row and copy formulas from row above
Picking out 1st letter of names
what's essbase
populate column of filtered worksheet A with data found in workshe
No Chart Titles
RE: changing font color in named range using vba
changing font color in named range using vba
Worksheet_Calculate() , How to find affected cells?
RE: Where can I download the fix mentioned in KB941423?
Auto filter not working
How can I insert a Workbook event programatically?
Log who last changed a cell in a row...(incl Multi-Cell changes)
Simple button & macro question
Do I need Findnext? Not sure how
loops in a formula
Any code sample to loop through Office Ribbon for OfficeID?
Delete Blank Excel Rows
How to change VBA editor cursor?
link to a workbook on another computer in lan
Accessing a macro created named range
How do you trap the paste event in a worksheet?
finding columns that has data by rows
Change the name of the title bar to the name of the worksheet.
Macro to clean inconsistent data
Ligit macro assignment keys
data from multiple files
Pls help: macro to delete empty rows
If Cell in Column C has a number greater than 0 then do this
Re: Getting around .FormulaArray limits
RE: How do I use icons and pictures with Excel 4 dialog.box function
Macro to convert phone number to time zone
Populate a summary sheet
Slow Macro
RE: Parameter in a web query
RE: Problems with code
RE: Getting around .FormulaArray limits
Pivot Table
Re: Parameter in a web query
Parameter in a web query
How do you add cells from another workbook to a formula?
RE: For...Each loop problem
RE: Quick Question about VLOOK UP
RE: For...Each loop problem
Change worksheet tab colors failing
Getting around .FormulaArray limits
Re: Basic Range Question
Re: For...Each loop problem
Re: For...Each loop problem
RE: Can I Turn PivotCache Refresh (Calc) off & on in VBA?
If Statement to fill in column to last row
For...Each loop problem
Quick Question about VLOOK UP
make fit to page 1 by 1 default for every sheet in an xls
Formula want work
Programming a toggle button
On error goto specified Line
Macro for selecting rows
Basic Range Question
RE: Basic Range Question
extract sheet 2 of 10 for 29 xls and combine
Several AND operators inside an IF...
RE: Macro for selecting rows
Re: Checking for special characters in a string
Checking for special characters in a string
VBA to select cell in column A
RE: performing function on selected rows
Print Preview Delemma, Once More Please
Re: performing function on selected rows
Re: performing function on selected rows
Removing extra spaces in a string
performing function on selected rows
copy workbook to new workbook based on cell value
Solution Needed for print formatting
Re: Date textboxe in userforms
Date textboxe in userforms
Dynamic Range Selection 1,000 rows at a time
Select and Sort by tab color - crashes Excel
Create Folder
separate text into two columns
Re: Ron de Bruin's instructions on Excel 2007 ribbon
Choosing a Formula Based on a Value
Auto savel Excel file at specified time
Saving a file with a variable name
Web Browser Control - Fit Image to Window
Re: VB Macro Menu in two different languages
How to save EXCEL file at specified datetime, say at midnight 00:0
Private vs. Public VB problem in Excel 2007
Can I make a worksheet that can not be copied
Ron de Bruin's instructions on Excel 2007 ribbon
Date formats
Algorithm for form numbers
Adjustable Macro Code????
VB Macro Menu in two different languages
Record at Mark
Circular Reference Problem
Listbox from "Forms" toolbar
What Variable-type should I use
Access Report
Re problem with getting formula in workbook
RE: find last non empty cell in a column and display value in msgb
Re: Can mail alert be generated in Excel?
Mantaining ranges if several sheets are selected
How to determine if the workbook is protected?
Re: VBA Calculation - taking forever
Delete Rows Prior to Last Month
List file names using VBA Dir instruction
Can mail alert be generated in Excel?
VBA Calculation - taking forever
RE: Userform multiple colums and rows
FaceId is recognized in Excel 2003 but not in Excel 2000 and 2002
MsOffice student version question
creating form: I want to limit the tabs
Combinations
Re: VBA Button to save worksheet
RE: Macro to create Index/Match
Message Box with three options
VBA Button to save worksheet
edit query without name (or control name at creation) VBA 2007
Capture values from a web page drop-down list
Insert Formulas and Formats
Delete Sheets
VBA programming in Excel worksheet
Find a string in a cell and pasting it in a new column
Copy Cells Fill Color
Help with my VBA and formula
extract path from FullName
Is it possible to format the text in a message box
Determining whether a workbook is a 2003 or 2007 workbook
Userform VBA Complie Error: Method or data memeber not found
Delete all filtered rows from a macro?
User form with VBA
vba to update columns
RE: Countif/Concatenate
Close specific workbook
Re: Excel VB documentation and coding asistance
Prevent Printing in Print Preview?
Catch a wrong value
Object Variable with Block variable not set message
User Selected Month
Copy Cells Based on Criteria in VBA
Determining current sort
Page setup error after moving sheet tabs
Counting Access recordset to import to Excel using ADO
How much text can be put into a message box
Execute Excel Macro from another workbook_TJ
Select
Delete duplicate rows using macro recorder
class module variable declaration issue
Macro Print Range Problem - Rows Cut Off (Upgraded From Excel 2003 to2007)
simplify code
Insert Row
Active Workbook Path
Clear workbook
select multiple rows using variables
How do I use a default value or allow data entry to a cell
Formula Error
Problem with formula
Deselect / Deactivate a selected picture
"Sendmail" macro to multilpe addresses
Check date upon input
Error on Macro code line change
Change excel file name by macro
workbook saved in different position
saving sheet as type .dbf
The best macro(VB) tutorial???????
The best macro(VB) tutorial???????
ListBox content not saved
Scroll Bar Position in imbedded Text Box
Re: How do I use icons and pictures with Excel 4 dialog.box functi
Workbook_BeforeClose
RunTimeError-438 XL2007-->XL2003 Compatibility Issues
Selective Copying with skipping rows in between Macro help please
Database Connection Password
Macro control question
Autofit custom header top margin to text size
Re: Merge Rows by id
RE: Comparing two List
String Frequency
ListBox Items with Multiple Columns into Excel
Range resizing itself
How do I test for the existance of a worksheet?
Questions about digital certificates
Insert new sheet
loop through looking for value
Personal.xlsb in Excel 2007 stopped being open at start
NETWORKDAY
Excel 2007, changing multiple formulas
Re: Adding a button to Data Mining tab in Excel Add-Ins
Copying variable columns from one worksheet to another
Re: Creating graphs in VBA
replace in a split?
Send mail from excel - Copy/paste unformatted values and error mes
Set Button Caption
Worksheet number??
Following yesterday's discussion of Excel 2003 v 2007
Re: prompt to save when already saved
Re: Excel 2007
Re: finding groups of empty cells in a column
Re: Excel 2007
match vs .find? What's better/preferred?
Re: Saving the Workbook
prompt to save when already saved
Public fixed length string variable
Copy Text into comment box
SeriesCollection(2).Formula returns formula for series 1
open userform when excel opens
Re: Problems with Automaint Excel
Moving data from worksheet to worksheet
Essbase Options
Re: help with some slow code
Check Essbase option and return message
Re: Macro Progress Indicator
Re: Creating graphs in VBA
Refresh all Pivots and delete old background data
Excel embedded in web page
Re: finding groups of empty cells in a column
Named range row copy/paste problem
Remove rows in huge data array
Date wild
Data connections in Excel
Excel Subtotal groupings
How to update all links to other workbooks
Unable to pass a control to a sub
Compare Column Headings and Delete Nonmatch
Saving worksheets to new workbook
Help with code
Last Day of the month
Assign a Hyperlink to a button
How can I access control properties?
insert on date
msgbox weird behaviour
How to Capture right click Delete/Insert on Excel
Re: Excel 2007
RE: Copy a TextBox (shape)
Dormant Worksheet
Colour Index
Aging Report Problem
Re: Excel 2007
Invoice Number Problem
update pivot fields VBA
Re: Add-In Automation Fails in Excel 2000
Re: Excel 2007
Re: help with some slow code
Simple delete macro
Re: Copy a TextBox (shape)
VBA Macro help needed
Re: Excel VB documentation and coding asistance
Re: .TintAndShade under Excel2003
Re: Fill in Effects
Township Range map in Excel
RE: find last non empty cell in a column and display value in msgb
RE: find last non empty cell in a column and display value in msgb
set cell contents to Zero but keep cell formula in VBA
Re: insert row at end of list
RE: find last non empty cell in a column and display value in msgbox
Using Outlook holiday
Number Ratios?
Setting date format for list box
How to get position of mouse via VB in a worksheet
VBA change font color if existing cell value changes
No solution - Macros
button on excel cell
data consolidation using vba
on error
Adding items from Listbox to empty textbox
Error Using Spaces()
save as using cell data but dont replace file
How to setup a list box with multiple selections
Border around problem
batch file replace information
How do I change source data range for an existing Pivot Table?
How do I check Pivot Table existence?
Accessing sub-directories in eRoom
Prevent overwriting a file
How to have 3 options for a cell
programaticaly select YY and XX values and Chart
Find an amont VB Code (maybe?)
Populate combobox with sql from DAO
Application.Screenupdating only on enter or on click, not with arr
Excel 2003 - Color codes
Macros Execute slowly
Macros Execute Slowly
Conditional Format - Two Criteria
creating help files
Can I program to insert current time when an a cell is filled?
Export Excel data in a PDF file
Switching Between Workbooks.
Copying cell text to clipboard (using Putinclipboard)
excel not starting up correctly
Workbook losing focus
Macro to fill to next field with data
filter macro
do while command button property is false
textbox progrramming
Search and Collect Date from Cell Containing a String with a Date
Comparing two lists of Name
Update cell value while dragging UDF
AutoFilter and Sub-total
what function to use
Insert row based on Value in above cell
Prompt to save as Macro
Undo approach
New hard drive and personal.xls
Using ExportAsFixedFormat
Compare two columns and copy data if values are the same.
name each sheet from a list on sheet 1
Program execution slows down as iterations increase
VBA Stops Working
Re: Copy Two Visible Ranges (From Two Sheets) To A New Workbook (AlsoWith Two Sheets)
Clarification of Pivot Table stuff
Disconnecting from an External Workbook Data Source
Macro to Copy and Paste to all worksheets after a point.
Reading Merged Cells
Sharepoint: How do I upload Excel (2003) Reports to Sharepoint?
Cross referencing data from one worksheet to another
Combobox
Webbrowser in userforn
request help with network paths
Shared Workbook
VSTO Add-In not loading and no error message
Synchronization between MS Excel and MS Word file
Workbook.close & beforeclose
Macros and empty cells
Copy Two Visible Ranges (From Two Sheets) To A New Workbook (AlsoWith Two Sheets)
Insert data in multiple rows
Google finance
Menu Item Property
looping macro to test for borders
Using Two Range Criterion in Advanced Filter
Using Two Range Criterion in Advanced Filter
Filter PivotTable Field by VBA
BeforeClose and Workbooks.SaveAs Filename:=
Text Box date format dd/mm/yy not mm/dd/yy
Program execution slows down in as iterations increase
Deleting comments
Query logic concerning dates
synonyms - need help with vlookup
Free Up More Memory or Reduce the amount <emory used in Excel 2003
Recognizing Fall,Spring,Summer
Is it possible to Copy From or Paste To a hidden sheet?
Preventing Multiple Selections
RE: winzip - rondebruin's instructions
Random selection of rows.
If this condition meet, then this text
Conditional Formatting
Combobox selection to fill in textboxes
Question about formulas and ranges.
Want to do a SumProduct formula
Macro needed to highlight a row
Select Random rows and paste it in a different sheet.
Slow Macro - Delete Row Based on Condition-Modified Ron DeBruin Ma
Add the word "and" in my code
Expand/collapse
Javascript
Macro Help
Inserting code in Worksheet.Change
subscript out of range
Deselet first 3 rows in selection
Calendar code error.
I have MS Office 2003 It wont highlight cells to copy & paste
Comparing & Counting Data
How do you trap the worksheet unprotect?
Comparing & Counting Data
Copy from CSV
Delete Module
Programming a function to copy and paste to other worksheets
VBA Dialog Box --
Filter query results with a cell value
Specifying Item number of control on user form
Select specific sheets and copy to new workbook
Fwd: Running Macros in a Shared File
find empty cells in a column then append row that empty cell is in
ersing one letter in a cell
Change PDF properties
macro for deleting cells trought column A
How to make Drop List linking with a worksheet
Can a pivot table be displayed on a user form?
How to control data input useing validation
Source for financial test data
Re: No clue whatsoever, so thought I'd ask the experts Pt II
How to get Ribbon Controls on Context menu in Office Excel 2007
how to add tooltips to excel udfs i created?
how to get the last range address (not the last cell)
How to access a function from a different workbook
show result no formel
Multiple sheet unprotection not working
Programmatic saving of an existing excel file
Excel 2007: Worksheet.Move functions differently to Excel 2003, wh
unresolved post: Add in and the worksheetselectionchange interacti
How to Link drop-down list?
finding numbers in excel
Possible error in VBA Workbooks.Open method for xlsx file
Save As
Missing CommandBarPopup when Moving Vista developed Excel Addin to XP machine
Consolidating data entries across multiple worksheets to one sheet
excel sumproduct formula
copy sort order between worksheets
O% Data Type Problem in C API and Excel12
Can I use VBA to assign Macro to Shape within a Group of Shapes?
textbox disappears using textbox.activate
Kill a opened Excel File
Closing Excel When Using CreateObject to Open It
Excel Sheet on a Userform
Controls in 2003 - trying to edit in 2007
Sort Data in Multiple Columns As Single Data Set
2k7: Setting print titles in VBA - bug or feature ?
Generic file path using vba
Returning a Cell Address
Using Lookup
ShowBrowserBar
Compare Username at Workbook Open
Copy row from one sheet to one of many others
Excel Check if copy envoked
Page 1 to Page 2
VBA cut and paste
User Form
Option Private Module (for Object Modules)
Macros Execute Very Slow Problem
File ID name in Excel
Click Web Page Image
saving PowerPoint in excel vb using cell values
how to select and append a column in VB and excel tia sal2
Removing comments
Freeze Panes
Saving in .xlsm format by default
Check Box in Forms
Creating Contigous Range from two ranges
Set data filter based on user selections
Business Addresses Imported from Outlook
Form Display
Macros tied to Check Boxes in Excel
DATE
Multiple SEARCH/FIND on one cell
List Box not working when used in German Version of Excel
Problems with cell-binded textbox
Project is Unviewable
VBA for InputBox-Like CheckBox
calculate a value on a new cell based on the list
how i use Selection.entirerow.insert on a windows form, excel07???
Age Calculation
No clue whatsoever, so thought I'd ask the experts
Formula Needed : Sum on Conditions
Using range names or ranges between quotes
vlookup - how to put this into VBA
Copy Excel files from sub-folders but restricted to one level
saving a csv file with unicode encoding
Hide menu bar
vlookup from one workbook to another
macro & folders
Rows to Columns - Diff Size Rows of Data
Custom UI Editor - enable functions but shortcut is still available
Divide sheet into groups
Problem with sending messages
formula bar
Refresh pivot - catch 22?
hide columns based on format
Copy and paste data between two workbooks
how to diaplay compare merge dialog box
Problem with MSINET.OCX: instantiation of New Inet
Checkboxes from Control Toolbar
problem running code
Dynamic Object Naming
QueryTable for url works in 2000, but not in xp
Help with writing a macro to select & ID a printer.
help with a text formula
Time is driving me crazy
Extracting values from cells (in one column) and putting in an arr
fastest way to read a large spreadsheet
Running Macros from Excel 2003 in Excel 2007
Get pivot data / V/Hlookup
CustomDocumentProperties
RunTime Error 91 (Leo Asked)
Searching a row one cell after another
Excel 2003 Visual Basic (List Box) in English not running in Germa
function from another workbook
Search multiple text in one string
Sum If
Error coding for access of locked cells...
ThisWorkbook populate with Code Q
Can a test to determine whether a workbook needs to be calculated beperformed?
No Data Lables
Importing new records
emailing from Excel
Formula for Conditional Formatting
Insert picture in email body
Adding a formula that doesn't give a #VALUE! error
Read Matrix via function
Message box
VBA Case statement
Select Case
Create a list of all files in a folder
if cell contains ? delete row
Overriding the calculation state
Weird error code..."400"
Close all open toolbars
How to make Excel 2007 quit automatically
Macro to check 2 lists and copy data
Excel 2003 automation add-in Extensibility.dll deployment
Issue With Jet 4.0... Could Not Find Installable ISAM
refernce header text in code
Combobox selected value initiates action
Assign a Ribbon Control's Label from a Variable in VBA Code
Macro for Email - Sending to email addresses in cell
Range for combobox with IF
Remove duplicates
close calendar control form after selection
Inconsistent error select range?! Driving me crazy.
Need help with macro to format a chart
Can’t perform operation since the project is protected
Sort problem in Excel 2007
Solver programming questions
Loop several sheets - part 4 - Dave Peterson - Goal seek
a macro for conditional sum based on cell color index
Goal seek - column reference - user input message
Msgbox syntax error
Making picture fit into webbrowser
apply next number in newly inserted row
return to xlnormalview problem
Counting hours each day with different values
Page1 to Page2
Goal seek - column reference
How to Run Form Imported from VBA (excel) in VB6 (addin)
Run imported form from VBA into Visual Basic 6
How to count the number of matching text in a column
Loop several sheets - part 3 - Dave Peterson - Goal seek
Range issue
PivotTable
Major bug in Excel
Loop several sheets - part 2 - dave
Grouping Cells???
trying to make a table where one number stays the same
Cell Programing
Error with Range Object
Auto create column with unique values
Lost VBA screen
Loop several sheets - not all worksheets of workbook
Cursor movement
subtotal function
Removing comments
Pivot table consolidation with variable number of worksheets
UPPER function problem
Control button to add copied row below user selection
Saving an Excel File
List of Financial functions
Xl 2007 v 2003 Re Populate ThisWorkbook via VBA
Range Selection
average calculation question
Removing vba code from workbook
Removing vba code from workbook
Autofilter sorting.
IF/SUM Formula
Database update Mk II
Saving Workbook 2007 Format in Send Mail Q
Select Case
Workbooks w macros showing as "locked for editing by"
VLOOKUP return #N/A
SUM/VLOOKUP
Display picture according to active cell
Updating the NOW() function every minute.
Assing a dynamic range to an array
Error from printing to fast
How to incoporate new macros into existing spreadsheet?
implement vlookup formula to VBA code
Waiting for a site in JAVA to finish loading
Send Mail Q
clear cells on open
Allow comments in protected sheet using VB
Read Binary Database File
Unprotected sheet is protected?
Concatenating A Unique Number
Importing one row takes the place of two
Attache Excel Worksheet (Not Workbook) to Email
Totals on Forms
Tanh Function in VBA
with application.filesearch
ThisWorkbook coding problem...
CreateEventProc causes crash
Setting Print Area
Programming Excel to send an e-mail when specific conditions are m
How to use VBA to set WB to Shared Status
urgent help with finding last used cell and looping. Thanks!!!
IF Look Up Formula
Inserting image / setting texture from VSTO resource
restrict size of embedded object
how to categorize dates
Macro for Creating Tables in Excel 2007
Hyperlink error only in template file
Looping thru filtered data in steps of 10
user inputs with Message Boxes
looping code
Save File
48 hour timer
Autofill macro - variable destination cells
Setting ThemeFont and ThemeColor
Find & Replace Multiple State abbreviations
List print quality options for defalut printer
Suppressing dialogs
Excel 2003 help
XL2002 - Help with Points in SeriesCollection
WorksheetFunction
How to get named range value?
Extract text from comments
commands in CommandBars("Object/Plot").
in over my head
Get count of duplicate strings from autofiltered range
Conditional Formatting with more than 3 options
v lookup
I'm trying to graph sunset and sunrise time on a javaApplet. I have my data all set up to read from a file.
Batch print from Lotus 123 to pdf then upload to ftp
variable for Date
and so on OnEntry
Printing Sheet to PDF via Macro Code
Programming Solver
A simpler way
Hyperlink Text
Excel 2007/Style Sheets
Long print ranges in VBA
Can you print a webpage table?
email return
email return
Nested Vlookups
Object variable or With block variable not set
Excel 2007 and VBA
Web Query / Internet Explorer
Macro Running Another Macro
macro that uses column headings as column sort 'buttons'
Search Sample for Oracle-to-Excel extraction with CopyFromRecordset
macro to save file as
Preventing Recursion?
Focus on next blank cell
How to disable items in a listbox?
macro to restrict access
Get cell contents literally through automation
Help in determining age
Hide ROW dependent on value
If #N/A in Col. AB, copy/paste Items in Col C. to New Sheet
Can I SPLIT into bigger array elements
RE: VBA dynamically change width listbox
Re: Stop running macro button, like Ctrl-Break button
Formulas look up question
Using C# to manipulate Excel
VBA dynamically change width listbox
Re: Stop running macro button, like Ctrl-Break button
Stop running macro button, like Ctrl-Break button
The object invoked has disconnected from its clients
Hyperlink in Email Body
Workbook_SheetSelectionChange problem in my add in
Copy and Paste or Change links
Organization tree/diagram on drag&drop basis.
Formula to return column header
Excel Macro error in Add method of object _VBcomponents
Generating a Julian date, but only showing the last two numbers
Combo Box Data Source
How to set the IntendLevel using XLLFunctions (Macro Sheet - XLM)
If function for Current month
how to chek greater then equal numbers
Calculating / Sorting / Printing
Null cells
Update cell
ResetColor/colour
Macro to match / reconcile data : One to Many
transferring data to another sheet
Modifying XLA to show toolbar in XL 2003 and ribbon tab in XL 2007
Inserting last calculated cell's value to text box
does not work when i use 1000
Delay while database updates
How can I export txt(UTF-8 characterset) from Excel?
Re: If statements
How to modify the look of the workbook.
nesting issue
Range with computed column number
teach me how to do range address syntax
Copy problem
Deleting a row as a condition of a formula.
Loop thru range and determine if filename exists in selected folder
Unexpected .Saved=False
Indirect and offset
Help. where's the #@%$&^ userform?
Alert if value is already in listbox
Sorting left to right programatically
default 'sort window' size
Timer macro
Date and Save As Questions
Macro for automatically moving to next column or row
copy paste only value with VBA from pivot table
priority between workbooks
How to use VBA to open the Condtional Format dialog box for the user
Macro to Copy and Paste Cell Contents
VLOOKUP Error using a dynamic named range
Formula for ActiveCell AND others
Password protected workbook
macro to turn pivot table field on and off
Cannot total the results of an "IF" formula
Differences in Excel macro recording from 2003 to 2007! Help!
sorting columns
macro for formatting/colour cells
help with vlookup in macro
Index in place of vlookup
Can I hide tabs?
Subtotal in Autofilter Referencing
how to input formula into selective cells in column ??
test value of yes/no box
Mail worksheet in Body AND Attach File
Summary Sheet
Pivot table Macro help!!!
sorting? do i need a macro....this is not possible!!!
Suppress print messages
Re: How to use VB for multiple conditions
Ignore null value
Re: Error Trapping Issues
chosing cells with a specific colour and taking average value from
Function Description
Read A Text File
How can i call a function on another worksheet
VBA converter pack
RE: IF Function
User Defined Search/Find Dialogue box
Re: Evaluating a named constant
Ask user a file name
Re: Selecting files with file name in Worksheet
Re: Manual Calc in a loop issue
Re: Addendum to question
RE: How to use VB for multiple conditions
Automation
Look up beyond VLOOKUP
Open Folder dialog box
RE: How to combine column data into one row
How to copy the sheet name to a cell
Automate line drawing in Excel
Update cell automatically
Update cell automatically
Can you dimension Range more than 1 way
My Custom Tab does not show up in Excel 2007
Multiple instances of excel process starts
multiple instances of excel process gets created in the task manager
Saving a workbook to an iKnow portal
Controlling Pivotitems.visible
select,copy,paste by color
Wrong password - Why?
Screen size and Window size
Macro1
Automatically Write to Table from a Form
Zeros in blanks
error window hidden in VSTO
Copy conditonal formatting colors
How to fill list box with weekdays
Need NewSearch Method vbcode to use in MS '07.
the post method to the workbook does not work properly
removal of first digit on left in cell
Use any function considering visible cells only
Autofill macro question
How to open multi-workbooks w/ Window Scheduled Task?
Conditional Formatting-If Col A="" then Col C = Red in color
Further Challenges with Footers and automatic text wrapping
pivot table report
pivot table report
Macro to bypass pop-up box
Drag and Drop
Print two ranges on page
Private vs Public Class Modules
Resetting last cell range
Open the Excel Workbooks in Windows Scheduled Task
Saving Lotus Notes in Sent Folder vba excel
disconnect a query table in VB
How to reassign ODBC driver in using VBA macro
Disable items on ribbon using VBA
remove add pivot table fields