Excel Programming [Archive] - Page 74

Excel 2007 Problem
Error 429 ActiveX Component can't create object
User input to calculate specific column
Using txtMy_GotFocus or txtMy_LostFocus in MSWord or Excel
For Tom Ogilve re File check
Error Trapping saving file to network drive
Copy formulas from row above...
Checking if active file is correct version
Ignore Blank Cells
Screen update?
Returning a list names from a schedule
Please Help with Combining worksheets
Exel.Exe lingering in Task Manager
Launching solver in new Excel Instance
How do I gray out worksheet tabs in EXCEL
Applying custom data labels to an XY series
List Box
Macro to create charts?
Sheet Selection using a Ranged index
Can I apply automatically the same filter on many pivot table ?
Can I apply automatically the same filter on many pivot table ?
global variables
Spreadsheet ActiveX control help file
Bug in Excel 2003 involving ActiveX Controls on worksheets
Format Cells with date format
Retrieve Text of Data Point
Getting at Windows File Created date with VBA
Returning cellvalue from closed workbook using a function
Averaging Letters and Numbers
import data with microsoft query
2006 West Coast Excel / Access User Conference
Macro's not working
How to make a Macro run after every cell adjustment
how can i calculat time(hh:mm)*(number)...(09:00)*100 $
Writing VBA code in Excel to Print Power point slides, and a PDF r
Excel 2007 beta TR VBA still MUCH slower than Excel 2003
DDE error
cut and paste specific record on same worksheet
how to auto update sum?
publishing semi-PROTECTED excel workbook as a dynamic website
variance array
embedded messaging script in worksheet
User defined function: All
Count value if not Number
Changing Cell Color with macro
how change characres to stars when somebody is writting password
Null Values
XML Spreadsheet Warning in Table - Cell off grid
Creating N worksheets
Detect if font installed- Hiding column
Macro compatibility with Excel 97
Matching Case
ShowDetail on PivotField rather than PivotItem??
Conditional format between two cells
Putting contents of an Array into a Cell
determine range for printed pages
picking the best 5 out of 10
Select control on a form after calling procedure
Reading Data from workbooks without opening them ...
Selecting record to edit using ADO
Timestamp Saved
If a prog is running stop and restart
repeating a macro for a specified range
Code from Acrobat
editting pushbuttons
Ref a Group of Controls
Input programming decision time ??
create hyperlink cell in excel using VB
Picture on Form (VB)
change chart type on pivot refresh
compiler error: public object module
Using a file name to get the path where the file resides
Merging worksheets
Slection of Rows on a Condition
Using data captured by Inputbox
Creating Outlook Appointment
Entering a hyphen
Late Binding with Outlook
Prevent user from copying pasting at run time
All possible Alpha character combonations
ODBC connection question
ListBox Question
linked cells
autofilter question
Printing labels from excel worksheet
Printing labels from excel worksheet
cascading 3 cboboxes
Copy CSV to variables
How to use workbook is a database?
Help with list of values
best way to test a row for 0 values
Hide the spreadsheet
general lookup/vlookup question
Excel 2003 vs Excel 2007 addins
Dave and/or Tom
Sorting Worksheets Numerically
Started something simple - Now really confused ??
data reading/writing question?
Relative Cell Reference [How To]
Building a string
moving cells
Hide row is no cells are bold
How to AutoClose and Save
2000 vs. 2003
How do I show a sheet programmatically?
Excel 2003 book
CheckSpelling
Help using FileDialog with OpenText
Run all web quiries in a worksheet
automatic column width
Pivot Table Autoformatting without collapsing columns
merge 2 columns
Conditional Formatting - Pulling from worksheet to form summary page - only non-null fields/sections pulled
mONTH cOMPARISON
count blank cells in a dynamic range
Pivot Table - data results that equal zero to be hidden
sending parameter of another cell value
Hyperlink focus and default email program ?
Advanced Filter with Non-Contiguous Ranges
Determining if a file is open using VBA
Changeing Collections Indexing
Control Toolbox Button - need to activate
AND if syntax
How to format column 7 ?
Retrive Data from Closed work book
dynamic chart range with VBA
function call paramater question
Combine Multiple Sheets: Complie Error, Expect Array
not allowing users access to spreadsheet without correct names
ADO - recordset find performance slow
Delete Unused (4000) Rows
docking a form in Excel
autofill range class failure
doesn't compile, thinks HPageBreak method is a variable
Variables in a cell reference
Combine Worksheets: Works Well in Test Mode, Locks when running no
How do I move cursor to next empty space??
Data from Access to Excel
VB Works in test mode, but Stops when doing normal run.
Need Help calculating a highlighted range
Detect tabular list in VBA
Choose File To SaveAs
Toggle Read Only
Cell Restrictions still
Hiding a form
Cell Restrictions
This is wierd!
Calling a sub from a different workbook
lookup combined with search to find keywords and then assign a cat
Calculating maximums from data sorted by SKU and date
Programatically increase the size of all named ranges
Variable upper and Lower row selection
Need Help with pivot table
TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS
Data_Forms
remove space
Cell Restrictions
Recorded macro opens, converts comma-del file and saves
number of pages
Excel file security
Generate Excel files with Graphs from ASP
AddressOf limitations 2002 vs. 97
Sum if
macro "text to column" for excel
Looping problem........
Show all formulas on sheet
Right click menu problem
Worksheet Tabs - Names & Numbers
Problem with handling on error when file is already open
stuck in a function
macro that takes data entered in a user form textbox to go to a ra
city st zip cells
group of values with the same
Drawing with loop, loop help!
Grrrrr.... can't access Server object ??!!??
copy specific records to new worksheet
Printing selected Data
Copy and Paste from WEB SITE
auto suming
Looper blooper
Sort worksheets
links on network needs redefine path whenever open
automatic referencing in excel between two spreadsheets
VBA to check if checkbox is toggle-on
Automating Input during a macro....
unit testing
Seek input on a Transposition: Can Excel help do this?
FreezePanes from VBA?
Another Filter Question
UDFs needed I think they're pretty easy but I can't figure them ou
Filter Question
Hiding Rows
ExecuteExcel4Macro ...
Excel SQL and listbox
Filter Question
macro assigned to print command button
Blank Lines
User defined function gives #NAME?
runtime err 76 on some laptops
VBA Help
Formatting Dril Down Reports
Turn off "Do I want to Save"
Macro to format different range of cells each time
Trust access to visual basic project is grayed out
schedule task
vba excel - lien sur onglet
Choosing window to follow hyperlinks within workbook
Text Problem
Excel Paste and VB.NET
[Q] Protecting a formating against Copy Paste
Userform to calculate Distances
Save Changes Prompt before Close, when no changes were made
Form Dropdown: click event macro
number of decimals
cannot click button on sheet
Picking numbers from 2 columns - need help
FILTER USING MULTIPLE CRITERIA
Plz help :)
Sheet Referencing?
add a hit counter to excel files?
How do I build a Soccer position/lineup template?
Sumproduct
aligning data
Small yet annoying
Underline with accounting format
rediming dynamic 2 dimensional array of user defined type
Way to display result at the end of the sub only
Procedure Limit ??
Replace and Substitute Functions
On Error
compile error - expected an array
creating a macro where the values entered in a text box on a user
Database (or the like) from Excel Sheet
How do I delete data,formula,and formating PERMENENTLY?
Events for Enter/Exit Textboxes on Userforms
Triple Criteria Formula
Spell Checker
Need Warning Box before deleting cells
Array Question
Excel Named Range
Identify OWC11 spreadsheets
Application Path
Automating Macros for CSV files
remove duplicates macro ending sub
Template to track employee vacation,sick & funeral leave time?
ODBC query excluding headers
Testing modification time of file
is there a #?
Command Icon
Current Date & Save on close
Comment bug ?
setup for userform printing
Is string
delete row with criteria (vba)
Object required
Command button code
SEARCH function
Excel diagram
SEARCH function
Filter & Print
Hide Sheets
How to change date format in VBA
Excel Access Security Question
Excel to powerpoint
matrix size
Importing TEXT file from web
how do i write an if/and/then statement to compare adjacent cells? TIA greatly
Does not support automation or does not support expected interface
If cell contains any of the following letters, then..
OWC and Chart in UserForm
Current file name in ConsolidationReference FileName
RightClick Range
FaceID not available
Toggle Button in a Toolbar
to display content of worksheet on a user form in visual basic
Previous Sheet
Private Sub Workbook_Open() & Workbook_BeforeClose(cancel As Boolean)
Macro speed decreased now to great extent
Rounding formula question
find a sum number from 300 number in Excel
c xll add-in callback when closing sheet
Keeping Track of Excel RTD Data
Protecting a worksheet which has button controlled macros
Importing text files using macro
ToggleButton Value in a macro
DropDowns and item values
Referring to a worksheet in another file.
copy value
only a portion of my data is being imported to excel from access
Taking an average of ranges
does file exist
help message
Format a cell to give quarternumber from a date in Excell
Series Object and Values Property
Linking Range to Another Spreadsheet
TRANSPOSING
I need help to show the contents of a range in a listbox...
Range refernce question...
Macro Hogging Memory - what to do?
WORKBOOK_OPEN event
emailed content with InDesign or InCopy
SpinButton/TextBox - Large Number
Intersect Function Problem
Excel to Acess transfertext issues
Submitting form variables to Excel sheet
Time Hog
Finding string and color the found string
do until end of list
Step thru Dates
autoupdate ppt embedded in excel file to which it is also linked
Issue with creating a specific macro where two conditions exist
syntax error in case statement?
Assign variable to a worksheet ?
Delete Sheet event?
Defined names in Macros
Defined names in Macros
Chart VBA
Protecting Cells
Msgbox Close Button
Fundamental problem with Indirect function
count of items in columns
Overrule/Replace
how to select a sheet by name
VBA Worksheet Function Question
Cell Format changed from General to number
Macros Excel 2003
count value with filter...
Refreshing ROWSOURCE
conditional statement to return greatest value
web query doesnt copy the essential part.
Add Borders based on ByVal Target As Range
Warnings in Excel
State Map, Mouse Position Question
make a "selection" in a word document from a module in excel
Blank rows at Bottom, over 60,000 of them - how to remove ???
Excel VBA Macro
Highlight text on Mouse over
Open Worksheet
Excel + BBL
Works on my pc but not others
Selecting range programmatically
newsgroup advice re: "selecting"
Array formula
QueryTables.Add and XML
.net, hooking Worksheet_Change event to sheet
C# instead of VBA
Distribute Lengths without loss
Time entry macro (entering times via the keypad)
Evaluate time spent on macro running
label.refresh error
MsgBox taking a long time to clear from screen
using VBA in the function bar
Disappearing Public Variable
Problems with conditonal formatting
After pasting a Chart in Word, excel makes a "restart"
Emailling sheets via VBA
Copy/Paste doesn't trigger macro (again)
% completed box
Text string divided into 4 columns
Macro to load JPG image
WILDCARD CHARACTERS
Need Help With VBA Problem
Load userform & deselect it
*Between*
Rounding
Copy Excel Worksheet to another workbook
Events with diniamically added controls
Macro to Enter Formula in a Cell
>> Picture Compression
syntax error for counting the number of columns end.
Custom Application Code checking
Adding Code to Command Button Added At Run Time
ISTEXT evaluates to 0 ? (not FALSE)
range color formatting
Adding Code to Command Button at Run Time
VBA Help files
error routine
Validation list changes don't fire an event
string conversion problem
European Date does not work from a textbox
determine if value exists
userform printing
fornat UserForm field
Calendar control (mscal.ocx)
Data being saved in error (?)
before right click problem
Hyperlinks(1).Follow then open as .html
Change an empty cell back to a blank cell ...
pop up
C# Visual Studio connect Excel to AS/400
Getting result of formula instead of actual formula
User form to sort data
activex controls?
Sending the current row number as a parameter to a function
VBA Inserting rows conditionally, how to work with shifting range
Shortcuts for a listbox selection
on error resume next
Holding off on screen updates
Fields in recordset from Access with value Null (empty fields)
ODBC connection string Excel to AS/400
VBScript to center Text
INDIRECT Function
xlDialogPrinterSetup
determine selection.Address of cell from inactive sheet?
How to know an alert should have displayed ...
Need Help with Deleting Rows
Checking when target.values are empty. What am I doing wrong?
Refresh Problems
Selection.Find a value Greater Or Equal
user defined function return #value!
Excel, how do I write a macro to convert the date value to text?
Two-Color Gradient Fill?
pause
Open Worddoc from Excel via VBA -> Paste
on paste, go to another worksheet
Using a checkbox to activate/deactivate input option
Grouping Option Buttons
Column location
ControlSource Errors with 2-Column ComboBox
partial search
External Commands?
send data to excel from c#
Isolating words and numbers to a different column
file operations
Split cell info via VB problem
IsEmpty
how do I change a web query's field length?
checkbox with two macros
BreakLinks method works when Stepping Through but not when Running!
vba page breaks
Error with Calendar object and CommandButton
Formula problems
Calendar in Excel
Custom formatted cells
Giving some feedback to user, when waiting on SQL SELECT query to finish
Comment Field
How to import an xml directly in userform ?
Naming worksheet
Font Colour Macro
Formula problems
how do I programatically edit formulae in MS Excel?
Create new worksheet
chats help
charts fucntion help needed
ListObject binding
Excel links break on network
excel links break when access from network
running code when vba project is opened
Connect to MS Access with Password via VBA
Excel Beta 2 Tech Refresh DrawingObject Status
"*BETWEEN*"
CONCATENATE
how do i fill an array? tia
userform Enabled property behavior changes between excel 97 and 2000/3
My code is still not working -- Excel 2000 Worksheet protection
return sheet name
The name of the textbox in userform keeps disappearing
One Cost Divided Among Multiple Date Ranges
Need Help Editing Cells
Merging Files in ListView
Reflecting changes on multiple sheets
Right click menu
Referring to a Worksheet with a variable
Excel 12 and BIFF Format for new .xlsx files
Comment help
redim preserve the second dimension in a two-dim array
Text to Columns in VBA
Sending strings to a webpage
Macro to Create New Date Tabs in Worksheet
Auto saving & closing a file after inactivity
Q: Automated coping of data to other worksheets
stumped
Chart Creation using VBA
Renaming tab name-# of code lines..HELP
Run time error 438
Automatic Updates
Macro to create workbooks and pivot tables
next logical number from list of about 2000 random numbers
save
COUNTIF across multiple worksheets
Change Procedure
Copy values from multiple sheets
XMLSS export format for import to Indesign 2
If .value <> "some text" Then not working. Pls hlp
import XLMSS to Indesign
Enabling the Filter button in a class module/protected worksheet
After Creating New Tab I Hit <Enter>, How Do I Make it Go Immediately to a Given Cell?
Auto Add to WB saved Name
excel help with time sheets, not in military time.
Weekday Function Returns Wrong Number
Error 1004: Application or Object Defined Error
Saving Excel Sql Server Image Field
count filled cells
Subtotals function offset subtotals summary
Macro to copy Excel charts to existing Powerpoint file
workbooks.open
Currency Data Type and automatic cell formatting
Conditional Formatting
Register MSCAL.OCX using Macro
get distinct data from multiple sheets & then consolidate distinct
Stepping through gives different result than running
Virus scanning feature
recalculation of a custom function in excel
Remove leading spaces from excel worksheet
parse cell contents
Prevent typing in a drop-down list to run macro
#1) value vs. formula #2) personal.xls and xlstart pathway
Code to remove external references from range names
Date macro
excel 2007 blog regarding udf authors
Hard line break displaying as rectangle on import from SQL
saving with a date
Autofilter (in a macro) problem
Copying worksheet to all workbooks with fixed references
Export folder/file listings from Windows Explorer to Excel/Word.
Loading dates from spreadsheet into array
Word wrapping merged cells
On Error Goto ... Error
using sum function after offset
VLookup Question
Help with a macro, please
Insert Duplicate Sheet From Closed Workbook
Excel Marco Fill Down Dynamic Range
Program actions on word doc from excel?
A better way to do this?
Sum rows above me matching critiera...
find-record combo box
conditional formatting based on proximity to date
Printing certain pages within Active Sheets only
Restricting values in a cell that already has a dropdown list in i
How to get data from CMD line
How can a hyperlink be inserted upon checking a checkbox?
format autoshape
Conditional Formatting
Can 3D Reference Update to New Position?
Simple flex grid
How do I detect cell mode?
Can I mail merge into Excel?
Unable to fetch values from Excel Worksheet in vb.net
comment positioning
Personal macros not available when workbooks.open
Changing design time properties at runtime
Turn Filters On and Off
External File Paths
listbox help
pass data between workbooks
format cells
Paste Options
Macro Update
How to program FIFO inventory in excel ?
Print in cell
Newbie: how to show the checked symbol in a label control
Changing object properties permanently at runtime
How To Sum
Formatting calculated number appearing in the text in message boxes
Array Formula
Make excel check external file paths
Save a copy of particular sheet minus VBA, CommandButton of parent workbook
code to go to start of line
procedure call
RANDOM HIGHLIGHTER!!
WordWrap in TextBox on a UserForm
Date Problem
Much frustration...
Excel throws -2147417851 (80010105) The server threw an exception. for no apparent reason
User form to comments
find last record in macro and delete all after
searching array for text from array
Dynamically creating Non-Contigous Ranges
creating a dynamic graph
write a macro like the /file copy combine named range in lotus 12
VBA Macro ActiveCell.Offset
Exporting to CSV without text qualifiers
Sum for last calendar month & year
Visible Screen
Sum for last 90 days
Proper way to export custom Toolbars ?
Filtre value from date and filter advanced...
show userform when response = yes
show userform when response = yes
Fill Area Between Lines
Entire Workbook Search
How to Find&Replace with MatchWholeWord?
Excel VBA code for find/replace
Comparing cells
MACRO FOR COMBINATIONS !!
Corresponding Range in another column
match
Sum with Date Span
Newbie Question - Is it possible to run a dll from excell
retain result
Removing duplicate rows
is this an acceptable way to pop up a form?
Sum within date span
convert formula to vba
Late night I guess - makeing a new range from an old rangename
formula copy question
My screen tips boxes donnot contain anything what do i do?
Cursor gone Mad
Password not working on exported Workbook / Worksheet.
loading data into a listbox faster
Making a collection of EntireRows for copying and then deleting
Matrix multiplication of more than 73 X 73 entities in VBA
Including a variable into formatconditions
Userform textbox help
Userform textbox help
address of min or max result
text manipulation in change event
Shell to another program from Excel
how to determine vba wise if a cell has a hyperlink
Excel web applications with VBA
Userform.
Macro call, one workbook to another
CountIF formulas
deleting repeating cell values
How do I use a Macro to define a Named Range
Day and language fomat
How can I create a worksheet in a routine and set the code name at
Mention the Day NOT the date please
How to Autoopen Search/Find dialog box ?
Excel Worksheet not fetching values in vb.net
Excel Worksheet not fetching values using vb.net
Curious - What is Implements used for
Question
merging sheets
Naming range question
Opening the Macro "Stop Recording" tool bar
Is there a way to use VBA to set up a VBA password in another workbook?
Converting text to yy/mm
wildcards with substitute of replace
Trying to use Excel to "program" word doc
check box value
Foolproof way to trap Worksheet Change?
How to delete Excel worksheet using VBA without delete dialog?
just file name no path
permanent/programmatic changes to VBA Project References
Set Range error
Missing OCX or DLL...
Page Setup Not Fitting To One Page Wide
save as text crashes Tom Ogilvy
Delete rows based on value...
Count Empty Cells in Range After Cells with Data
Go to from reference in VBA code to actual cell?
xlSheetVeryHidden vs xlSheetVisible
Restricting files to a single computer
how do i convert from feet/inches to decimal?
Return Sheet# Sheet Name
How to calculate total for a column with not all values filled
Cyclic Error replaced by blank or something ? would Macro help?
Error hiding a combobox with a checkbox
How to deal with no Workbook_Open for add-ins...?
Need macro copy above cell to current
Reformatting text....
ini file 2
programmatically adding a break in a menu bar
save as text crashes
Worksheet_Change from a validated list
Want to displays lists items in separate colors
save as text crashes
Writing to Notepad from VBA
BreakLink
how to get data from cell a1 and paste in cell b2 in another workbook.
Verify protection status within a macro
Joining an Excel spreadsheet to another using Access
function to figure out which procedure
comapring cell values
Macro skipping
Update a range reference change
preventing special character from being entered in cell
Disable save & save as then return message...
Identify unprotected cells in protected sheet and clear their cont
If cell value equals today
End(xlDown) won't work
Cell references when creating charts
Excel, Fullscreen, Taskbar
Setting the category Label source for a Pie chart
Excel UDF Description, Help Keyword, Help File
preferred method for summing
How do I find Control toolbox in Office2007
Select Current Row
filter a matrix
Using found variant within code
Searching for a substring inside another string - there has to be an easier way!
Maintaining relationship between 3 variables
popupmenu
Window Movement
Automatically run a choice of macros based on cell selection
Protecting a Range in a list
Hiding unused columns
Selective linking items between two worksheets
Why "expected function" on such basic VB?
Hi Bob
Delete entire row if two cells are duplicate
Info on xml files
Background color for every other row
Where's the Personal.xls in Excel 2003?
a "cell is renamed" event?
A COM Add In must handle WorkbookOpen event
Major Error
Using known arrays to calculate an array of new values
limit on hyperlinks
how to read dbf file using macro?
Re: Troublesome Code
CONVERT A MICROSOFT EXCEL SPREADSHEET INTO A JPG FILE
Multiple Command button programming
Spreadsheets or workbooks - can they be accessed as a network application?
scope of public variables
macro to move and save all sheets to seperate workbooks
delete workbook if not authorized
Sort by rows...
"cancel" caption doesn't show up on cancel dialog
MacID VBA
combo box problem!
Pivot Table: Locking Certain Features
Microsoft Common Dialog control, version 6.0
Display Cyclic Error as Blank ?
Follow Hyperlink in Excel 2000
textbox to return User Name
runtime 1004 error
2-Column ComboBox Issues
Sort Ascending or Descending using Option Button
Change the range for a recordset?
custom format cells
when encountered Zero/Blank CF issues ...
Control on different sheet than the executable
FORMULAS
How to make a File READ ONLY
Copyright or Secure a workbook
macro to insert function without parameters
runtime 1004 error
Error Message Copy method of worksheet class failed
INI File
Tweaking a current formula
Find / FindNext Methods
How do I remove an old command button from an EXCEL worksheet?
Trying to search a block of text for presence and frequency of terms in Excel
Delete entire row with a positive number
Trying to make Date Range variable in VBA SQL Query
2 nice requests
Updating all graph links in a workbook
Update multiple rows from listbox
Why does this work?
how to copy line above when XXX occurs and move on?
Excel Macro find non zero value in cell and insert row beneath
Clarification in vb excel programming
listbox - How to reset the values
pivot tables
Counting number of rows that are not N/A
Sum values based on Text
Setting external data location for a pivot table
Lotus to Excel
Checking list for contents
Protected Sheet and AutoFilter
combo box
Wrong with macro naming sheets
SUMPRODUCT...with text values within array
Checkbox to Hide/Unhide Columns Based on Value in Cell
View Details in OpenFileDialog
countif formula
how do you create drill-down detail?
Append One Array to Another, and Consolidate
Active X Command Buttons Disappear
Open book, copy and paste from sheet, and then close....
Pivot table programming
How do I add a drop down calander function to excel?
Protecting an Excel List
Function with offset
UPDATELINK problem
Using variable in CopyToRange:=
Selection.Find a formatted date
Closing files by a macro
Sum Formula
SUMPRODUCT (I believe??)
export to a text file
empty cell instead of 0's
Idiot proofing my spreadsheet
Comparing visible values in two arrays
Moving your selection over a couple of columns
Using a marco to update my spreadsheet.
Using a combo or list box to select a statement
VBA searching
Colors Shapes vs Cells (Excel 2007)
Automatically create a chart
sum at each page break
Insert row after a page break
Add Line break to string for Excel (using c#)
Combining Formulas
How to print...
Strange format problem with textbox
sumif statment
Time Stamp
Shapes & Drawing Object Bug Excel 2007 Beta 2
query table macro
Changing Multiple Cell Colours based on Drop Down option Selected
Need help with named ranges in VBA
How to hide certain pages if a page is dispayed
Using Command Button to Hide Columns in another worksheet
ChangeLinks routine stopped by Update Values dialog
Use VB to get group of cells
excel 2002/03 vba changelog
How do I implement if-else functionalilty for a cell in excel?
How to set row color
locked cell issue
How to sum subtotal with blank line
Why it doesn't work
run time error 424
Excel date bug?
Excel crash as the result of file look-up
Create univeral pivot table macro - use with varying lenght data sets
List all (complete) codes from a workbook?
Displaying help for an addin
What is the right function
Counting columns with >1 instance of a specific value
Pastespecial with Late Binding
Countif Function
How to select a font with a strange name?
How can I use Visual Basic to access Solver?
Multipage forms imported in XP
Trouble exporting ado rs to Excel
How can you use data validation for a cell with a formula
formulas derived from cells
cell contents into an array
REPLACE formula
Simple Parsing Question in Excel 2000
disable save and saveas from menubar and save via command button
Dynamically create procedures in a sheet module
Alternative to hardcoded password ?
Help with a macro
Excel setting which prevents printing?
To save a web page
Simple problem with code
run time error 91
Check if Any workbooks are open
Setting a list box to a value
Encryption - Public Key - what the....???
Range does not work
compile error method or data not fount
Data Validation and Filtering
get some user info and store as constant
error "macros disabled, refer to online help?"
Code Usage Question
Check if the first sheet is the selected sheet
"Select" and "Activate" failing?
Range syntax with variables
shape range help
Create a macro to run autofilter based on contents of 2 cells
Disable Auto Refresh Dialog
WORKING WITH COLORINDEX AND MULTIPLE WORKBOOKS
Hide sheet via codename
.FreezePanes
merging 2 spreadsheets
end command not working
Next available row
Linking information in individual cells spanning multiple sheets
"Save" macro problem, still prompted to save when closing workbook (?)
ActiveWorkbook is nothing in Workbook_Open
Turning off merge-warning
Sending email from Excel with a twist
Find and Find Next problem
Macro Not Working
fix worksheet color
Nesting For loops
Need one more thing
How do I track multiple daily individual payments over month/yrs?
userform to search by entering data into a textbox
Multiple range names
initialise declaration
Auto spelled number
Use CDO to send e-mail
How to detech same data in one sheet
Combobox items determined by the selection in another combobox
How to print...
Hide same rows on new sheet as on previous
vlookup
Method or Data Member Not Found error, after connecting to Microsoft SQL Server
Combo text value disappears when wkb opens??!
??? How to get list of Color constants
Basic authentication UI for web-services
Can using If Formula differentiate number with decimal or do not
Upgrading Add-Ins to Excel 2007 -- Compatibility & Bugs
TREND WORKSHEET FUNCTION
Combobox Rowsource
how do i create a template for certificates of completion
Sorting Check Boxes
Toggle Toolbars in Excel2003
CODE Function equivalent in VBA
using VBA in Excel it changes the dot of a number to a comma
hypertext
hypertext
Condition Formatting - Work Sheet Event Code
Merged cells
Dynamically setting Dimensions in a VBA loop
runtime error
Macro to refresh data
split function for Excel 2003
help! pull text info from separate worksheet
Maximum Number of times
Need to link to various websites
macsplit function
2 CONDITIONS FOR CONDITIONAL FORMAT?
smallest
Insert Listbox in Essbase Form
DataLabel Manipulation
macro to save named range as text
Extract email from excel worksheets
Column names for dump of text file to Excel
error in userform?
How to create a disapearing drop down list
Change default button
deleting duplicate entries
Named ranges on other sheets
round number for unknown num_digits
Compile Error: Expected Variable or Procedure, Not Project
How do I swap every two rows in a spreadsheet?
scrolling textbox
Printing with macros
אקסל 2003 תפריט אישי
how do I print a named dynamic range
Getting From UserForm TextBoxes To Lastrow On Active Sheet
Working with Incative Workbooks
Macro to hide rows/colums by value
xl2002 - AutoFilter from Criteria from Other Sheet...
Creating a Fomula in a Pivot Table
Excel 2003 is converting weird to Excel Viewer Version 8?
sort doesn't sort numerically 2nd request
Speed Up Macro
Test Printer for Colour/BW
Add 2nd Column to ComboBox
dynamic charts
increase range programmatically
Prevent Saving From Web
Undo function in Userform
How to activate original workbook?
separate mixed data
Date problem in Pivot Tables when using SQL as a Data Source.
excel "name is not valid" when naming a cell
How to copy a worksheet from one workbook to another in vb6
References to cells in other files
Delete duplicate rows
Querying an Excel Sheet via HTTP????
Consolidate data on different sheets in a changing range
text boxes on forms
Pasting ADODB recordset into unopened workbooks II
Naming and referring to charts
Row of references to same cell in several worksheets
OLEObjects, adding a picture problem.
security warning
update then move down
Creating a total line
conditional formatting
choosing column heading given a criteria?
formatting cells loop
formatting cells loop
Help with my cut and paste code
Automaticall disable Protection menu
Only allow users to enter new data
IF else statement
Split Text
lastrow question
no sheet in workbook
Sub Auto_Open() - Sheet name - error code
MS Office Outlook 2003 & MS Excell 2003
FindFirst
Force Excel to Refresh Screen
Football pool
Changing a Number in a Column Using Arrays
Excel OLEDB reading Chinese characters problem
In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
Show "Go To Special" Dialog Box
Complicated VLOOKUP
Matching CELL text (full word) to full word in string in another
How to sort a list of telephones # by every 10th, 20th number?
command buttons
Pasting ADODB recordset into unopened workbooks
automatically run startup macro in new workbook
Maximize all collumns and rows (evenly distributed) on 1x1 page la
separating info in one column to different fields
WHY DATE FORMAT??
Change Formula
Capture date for =MAX(a1:a250) formula
Popup Comment Box if a Certain Condition is Met
Macro for hiding columns not worling
Excel code convert to Access code - Concat & eliminate duplicates
Import Data From Landscape Format
open an excel file
number not a number?
Allowing user to select a cell in another workbook in VBA
http://jcd.sytes.net/DEMO.HTML
If sheet exists, then...
Problem with worksheet_deactivate code
find an empty cell or null value
Question using the excel find method in vba?
what is the R1C1-style notation in Macro Language?
Question on Find method in vba
Formula Help
VB to copy a sheet to active workbook
Simple VLookup Question
issue running in Excel 2003, not in 97, error 9 subscript out of range
Name ranges based on criteria
How to make "("@")" work with =ROW()-1?