Excel Programming [Archive] - Page 58

Weird Do...Until behavior...
"Case" Problem
Re: How do I stop my mouse roller from zooming in and out?
Re: How do I stop my mouse roller from zooming in and out?
How do I stop my mouse roller from zooming in and out?
Re: Simple If Function Question
Compare 2 Ranges, Copy/Paste Row on Match
Re: Search Columns For Change, Insert Blank Rows, and Sum Differen
Re: Search Columns For Change, Insert Blank Rows, and Sum Differen
Re: Search Columns For Change, Insert Blank Rows, and Sum Differen
Re: Search Columns For Change, Insert Blank Rows, and Sum Differen
PublishObject Images
disable Alt+F11
Trying to test several columns for changes when entering data
Simple If Function Question
Re: Block addition of ranges
validation list from worksheet given by ref
Need to register a UDF (xlfRegister) that takes no param
Need data in cells on one row extracted to multiple rows
assigning a letter in a cell from a range of numbers in another ce
Programmatically Protect/Unprotect Ranges in Excel 2003?
Re: Block addition of ranges
Print job
Re: DCOUNTA function not working right
Re: DCOUNTA function not working right
Re: Last Modified Date
Re: Programming a checkbox in Excel
Conditional STDEV formula
Touble with Dynamix Axis Scales via a Cell Value
Re: Block addition of ranges
Last Modified Date
Re: cell reff
Re: DCOUNTA function not working right
Re: Sumproduct in VBA
Re: Sumproduct in VBA
Re: Sumproduct in VBA
Re: Sumproduct in VBA
Re: Sumproduct in VBA
Re: Sumproduct in VBA
Re: DCOUNTA function not working right
Re: DCOUNTA function not working right
Re: Block addition of ranges
Re: Creating a Wizard with VBA??
Block addition of ranges
Programming a checkbox in Excel
Re: Sumproduct in VBA
Re: Sumproduct in VBA
Re: Sumproduct in VBA
Re: Sumproduct in VBA
Re: DCOUNTA function not working right
Re: DCOUNTA function not working right
Re: cell reff
Re: cell reff
Re: cell reff
In VBA how to select the right format for a range
New to programming Excel from VB 2005
Help with Exiting Sub if Value is Not Found
Sheet Protection Macro
Help with saving an file to an FTP site
Macro Help
Dependency of Excel on btrez.dll
Dependency of Excel on btrez.dll
Dependency of Excel on btrez.dll
Re: Userform combobox dropdown question
Re: Userform combobox dropdown question
Re: a strange button state
Re: a strange button state
Re: a strange button state
a strange button state
Selective Printing of Excel Worksheets using Macro
Creating a Wizard with VBA??
Sort display here by date?
cell reff
Re: Sumproduct in VBA
Re: Sumproduct in VBA
Re: Sumproduct in VBA
How to link a commandbutton in excel sheet to a VB userform?
Userform combobox dropdown question
My Add in Password Lost
Sumproduct in VBA
Simple replace command
Re: refer to cell
Re: refer to cell
Re: refer to cell
Error in entering a formula
refer to cell
Writing Array formula through macro
Highlight highest figures
Problem with Workbook_Open
array instead of replace feature?
Dynamic Array Lbound not working when only one value in array
Formatting Names
getting started on Fluent RibbonUI
Copy Sheet Object Module
Re: DCOUNTA function not working right
Borders
Protected Sheet Pivot Refresh
Question about a tricky Do...While loop
DCOUNTA function not working right
Macro for Filtering
Axes(xlCategory).CategoryNames
Importing data from Web using Excel
Addin not loading
Help with this code please
if statement dealing with numberical numbers and text
ref or tutorial for user forms, listboxes
Copy Range Between Workbooks
VBA & Advanced Autofilter
Send info to other apps from Excel
MS Query 'Invalid pseudocolum "$D$5"
Vista Macros
Multiple Edit Replaces
Re: what is the meaning of this error msg?
RE: what is the meaning of this error msg?
VBA causing "Excel has encountered a problem" message
How do I control the cell reference when naming a cell in a macro
Opening Outlook from Excel VBA
Setting up hashtable class module - tools procedure attributes dialog
change event help
how to find and copy cells between sheets??
how to find and copy cells between sheets??
More XL magic
Debug code in workbook open or activate events
Find problem
Enumerate DSNs
How to protect recorded macro(s) from being edited by other????
Function weirdness - #VALUE, then #NAME, then working fine??
Please Help me Review Code - LOOP doesn't stop
Create New Folder Using Code
Extract Workbook Data to Text File (multiple sheets)
find and copy cells
have button become active
have a button show up
Xml data import weirdness
Conditionally put rows at the top of each page?
Email Not Showing up
Run code when ANY file opens
Macro On Open
Multiple Edit Replaces
Multiple Edit Replaces
Comparing two columns with email addresses
Delete rows and refs
replace based on look up table
If Then VBA statement
Search Columns For Change, Insert Blank Rows, and Sum Different Co
Linked spreadsheets
Format Text in MsgBox
copying a row to new worksheet
Copy formula results and launch application from button
how to find and copy cells between sheets??
Identify Current WS?
sql.request in 2007
Enabling Option Buttons - Control
Save Excel rows that contain specific text
find and copy cells
Microsoft Query - DETAILED documentation????
Is it possible to have in a cell a character that blinks ?
Drop down list
Help with code please its urgent
large DBF file
Controlling ComboBox from VBA-script
Generating an Excel document with a Macro
Script for Retrieving Data
Nextrow in another column
Introducing rows in between every observation for huge panel data sets.
Copy Last Row and Paste as last record
Cannot put control on the form
Record macro doesn't record shape properties
inserting and copying rows over multiple sheets
Link Picture to a cell in Excel 2003
Copy Cells To Another XLS
"Exception in Activating Subscription Cells"
uninstalling an add in
Macros / using on other computers
exporting to access 2007
Please help, its urgent !!
Sorting based on Heirarchy or recursive
How can I programm function in a Macro
Copy all workbooks into one workbook
create email, addresses to be added by user
copy worksheet from inactive workbook
Capture user name
Macro work in Excel 2003 but not Excel 2007
code for conditional formats
Excel won't round, Access will
How to add a leading zero
Problem using Autofilter
Problem Using Auto Filter
Pivottables change datatype in vba
macro for multiple worksheets
Multiselect Listbox/ command button
DSO and Custom Properties
Re-calculate sum after filter is applied.
Copydown
When I select a specific .XLT I want it to populate w/Access Form
Format code no longer works
Exporting data to Excel
Columns and rows display change
set and then select
Macro to find and replace with criteria
XLA and Listbox.rowsource
Combine Worksheets to One new Sheet
Help with KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
Scheduled Task Saving from a Macro
Getting SQL data into Excel
auto-hide & Auto-fit rows?
Debug Messge
How to read text from a non-delimited text file?
Cell Offset User Input
Download SQL sproc to Excel
VBA pop-up message
Download SQL sproc to Excel
Array Randomly Sorted
Conditional Message Box
Debug error with Pop-up Calendars
Troubleshooting Pop-up Calendars
Get Name of Macro Initiator
Loop Formula
Watermarks in Excel
BeforePrint only running once
Web Query Formatting rows -> columns.
Data Query on the Fly
Data Validation and Name Range
Paste Special If Statement
Help In a VBA Code Pleas
Find the cell that is the option button is on it
criteria
geri al
Simple question: copy/paste column
For-each to copy rows to another workbook
How do you create a Set on Excel?
Dialogue Box
Array Maintaining its values after execution
Anyone Know Workbook Openening & Saving Macro Alternatives?
How to compared multiple sheets.
Excel losing focus and non-updating userforms
#Name? Error in place of function result
Copying Excel File Problem
please i need help in VBA
ReferenceStyle:=xlR1C1
need to allow user to input file name to import data
Update Protected links
Running Access VBA from Excel
Connection String
Unable to create VBA code (windows security issue?)
Moving the cursor
Mouse Position
Defining a range in a different open workbook from the active one
Visual Studio
vbCr
Dialog Based Upon Cell Properties
macro to find and change text within a range of cells...
Can I fill a form and archive it? Difficult project need help -
Add 2 rows & format
Can't delete empty but active cells
Check date
Palette colors change when sent as email attachment
creating a list based criteria
Checking a worksheet is present
Unable to access visible property of Pivot Items class
Unable to access visible property of Pivot Items class
Display only rows with data selected from a listbox
Excel 2000 vs 2003
On cancel GoTo
Unpleasant VBA Agility
Method for inserting a check-mark/tick-box in Excel
how to load pictures to image boxes in excel with a command button
In Excel: is there a way of inserting the current time (what time it is right NOW)
Copy from one worksheet to another
Last save data placed in Footer?
VERY SLOW EXCEL 2007
Macro statement when opening file, but no macro
Detect new row event
Dynamic array seems invalid
Generic separator
How to arrange multiple cell value into single column
Help with Excel 2007 new UI
Loop relative rows
email sending
Userform/Textbox Issues
Userform/TextBox Issues
Compare columns, delete the rows that DO match.
Re: Can we define a date format in a cell
Running macros from formula bar
Excell Alphabetizing & Sorting
Error Handling
allow entries only to specific cells
Getting a range that includes alternate rows only
Viewing the result of an sql query in excel.
Const Fails to work
Autofilter to tak on an Inputted Value
Combo box is not listening to its linked cell
What exactly does this do !
UserForms: Clear all Option Buttons
Problem in data export
Do Loop doesn't stop
Excel to Lock Windows User Account?
excel to access
Help to get started with Excel 2007 Fluent UI Customisations
Help needed with difficult programming
macro, VB script or worksheet event code?
external Links not udpated
ActiveWorkbook.SaveAs Returns
Store values in variables based on count
Maximum IF Statements in a Formula
Image.Picture = LoadPicture("http://...")
How to display a picture when a cell value changes
change sheet names...with a twist?
File Directory
only select one cell
Read a table and take action
List Box Problem
insert 2 rows and copy and paste
References and named ranges
Make it positive
Hexadecimal Woes
Find Row from MAX expression
Go To Cell Reference on Worksheet Open
Need Help Troubleshooting
Compare and copy dose nothing
Worksheets("MyName").select
Excel copy after problem
Control checkboxes
Copy Cells from WB to WB
please help with my code below
Prevent "delete" only
Forcing a Calculate Now?
Runtime error using Cell.Find command
Data Entry Mini-Project
Public is not Public
Pasteing values with conditions
Confidence / prediction intervals in multiple linear regression
Merge question
Passing array of strings to excel
Excel OpenXML Readers
ASP.Net Excel WorkBooks
catching "#DIV/0!" in a loop
Problem define range for multiple sheets
Debug Error
Naming Cells
Excel 2007 XML file format
Can we define a date format in a cell
Re-Linking Pivot tables to MS Query
Remove Duplicates in an Array
Inserting tables with macros
Can anyone help me with coding this?
Macro
Clsong Excel
Simple Moving Average with N
Macro to email image of current protected WSheet
Pasting Same Formula
saving data and moving to the next column
saving data and moving to the next column
help required please
Change Cell Value Based on Another Cell Background Color
hide/protext auto_open code so user can't prevent it from running
Challenging
Re : Excel VBA Charting of a Trendline, the Parameters do not Tally with the Calculations obtained by WorkSheetFunctions.
Limit Number Of Characters Allowed In A TextBox
Can one test for Excel cell format patterns?
import existing module
VBA video training
Generating a random movie of genre X
Controls Question
VBA to populate workdat between dates
Conditional Find
Re: Finding Matching Data on Another Sheet
Copy cells from two worksheets into one
commands
Microsoft Query (sql server)/Excell 2007
End Of Life Support Excel 95
Macro only "Works" with F-8
"Save As" Causing a combobox change event to trigger?
A macro to delete other macros?
Performance - autofilter vs loop
Multiple formulas invovling ranges
If it is in any of these...
Macro Help Needed - Added Info
VBA text to columns
CommandButton Focus Question
how to find if a row is grouped /grouplevel? / outlinelevel? / ro.
Help autofilter
re-post
Excel Process Still Running
activesheet.shapes("Group 1...n")
Work-around for lack of " ' " before/after sheet names with no spaces
Delete Range Cell Based on Condition
Excel VBA works fine but not in two workbooks. Help
Allowing Column Ranges in UDF
IF statement --- repost
Autofilter macro issues
adding custom verb to OLE object that changes its appearance
Limitations on UDF's
IF statement
SUM referring to different sheets
Using Excel 2007 as a thin client...
Message Box Position
updating links alert
Creating Pivot Table from a DAO recordset
Renaming Images files from worksheet.
Macro to send email to person in workbook list of users
Excel startup location
Defining a range using defined names
=today() - 1
send email macro not working completely.....
Slow code.... Any thoughts on how to speed it up?
Due Amount
passing array to functions byref
Link Next button to ComboBox
Modifying Ron De Bruin's "Create summary sheet from different workbooks"
Deleting an entire row depending on the colour shading present
Deleting A Selected Macro from within a Module
Use Worksheet Name in a Formula
Testing Range Extent
Excel 2007 - Print Macro with Auto Sort?
Save activeworkbook with a password
Vlookup issue
How do I clear all cells from all rows except the first row in Sheet1?
Wrap xll for non-excel use
Remove ' from the beging of the string
Loop to run macro each tow
Workbook code vs worksheet code
Copy First Character of a cell
Re: loading multiple non-contiguous range into an array
Change Category Cell in vba
testing a string for either "Minutes" and/or hours and extracting the values
Delete all Columns with a certain value
building a formula
Macro to open folder and let you chose file, then continue import
Strange Compile Error...
How to test success of a "Set" command?
issues copying data from one file to another
Private Sub Worksheet_Change(ByVal Target As Range)
Yet another userform combobox question
Copy/Paste Special from Many Files
Userform combobox question
Command Buttons on Worksheet Distorted
Importing Text File into Excel
Macro Speeds in Vista OS vs XP OS
multiple workbooks to sheets
Complex Function in Excel 2007 VBA
Sendkeys, sending variable
Excel as a database
Command Bar Woes
Error help
End and Exit Sub
Accessing Public variable in different modules
Copying cell menu contents
Referencing form controls with a loop
Find holidays
Copy format from another Workshet
About digital certificates for Excel/Word macros
Web Query and table?
Re: Using VBA to create an actual email message in Lotus Notes
selective macro security
SendKeys + Dialog
How to have workbook automatically protect when closed (or opened)
Re: Input Mask
manual vs. automatic calculation
Assigning a Hyperlink to A Cell that References a Worksheet
Find Throws Error 91
autosorting two attached columns
How to look for the Folder Path using macro????
Assign Keybindings to a Userform
VBA Info
Macro Help Needed
Cells.Find Causing Serious Lag
Cells.Find Causing Serious Lag
Sub menu with FaceIDs only in a CommandBar
Runtime error 1004
Opening a document captured by Application.GetOpenFilename with hyperlink
Removing Macro from a shape as it is pasted
Replace(ActiveCell.Formula, "Round(","") not working as expected
Read ".dll" files, the Macro "work flow" and the actual values of the variables when Macro is running
How do I move lines one week up in a weekplan
How to check the decimal point of floating number using macro???
Re: Re : Excel Creation of a New Copy and the Duplication of Namesthereof
Re: Excel 2003
CommandBars & Custom
VBA editor Project item list has changed
msgbox shown twice!
Show Printer Setup Dialog in Excel from Internet Explorer
Printing the same range in a workbook
copy from worksheet
Relacing partial text strings
Opening another workbook file
Command button code
SCripting Border in Excel
Add-In Password...!
Excel Forms on Pocket Excel
Import data with Webquery
Do you manage to make this macro faster??
Excel keeps asking for save when user closes system with "Macros Disabled" logic
VBA interrupts...
Split with consecutive delimiters
Hibernate via VBA
date format changes when I save to CSV via a macro
If worksheet from array exists then not working
Re: Group and SUM
Re: Programmatically reading the excel sheet name-->vbscript
select/group sheets dependent on criteria
Changing Worksheet Names via VBA
writing a macro to delete all rows after a certain value
open an e-mail msg in Excel
Pointing to a new data source
Macro Assistance
Format a column from the last row of data on up
Pivot Table Problem - Use Total Count in Other Formulas
Function or Macro for Variable Formula?
Need help with a macro
Data Validation with lookup function
Links in spreadsheet
Maximunm # of Spreadsheets in any Workbook
VBa Locate Nearest point
Excel 2007 Show Columns Error
Predicting an Intersection of a Linear Trend
Visibility of contents in a merged cell
Delete all data on Worksheet?
Mask date format
Exceeding 65K of defined names within workbook causes workbook to go into repair mode when it is opened
Answer MSGBOX Programatically
How can I run an access macro from excel?
VLOOKUP
Validating dates in a cell
Macro to find specific data in a cell, then delete that row on down
Password Dialogue
Vista blocking macros in Excel
Accessing Excel files within multiple levels of a directory
Rename Worksheet Tabs per Cell Content
Error Checking Limits
make a shape unselectionable
Macro Name
Hyperlink Question
VBA Courses- Excel 2003
address location
Expression too complex
SUMIF Problem
Only Explicit Call of Procedure in another workbook???
Disable the built-in keyboard shortcuts
Finding duplicate values and deleting both rows
Interuption with no explaination :/
Calendar Control - closing out
URL encode a string
File Error Data May Have Been Lost
BookMark on a Worksheet
How to fix/upgrade .sort in Excel 2007
CONCATENATE not working
The Macro "C:\Test\Something.xls!Macro" could not be found
Help with forcing IE to maximise when opening a workbook
Workbook_Open event not called when workbook forced to re-open in read-only mode.
Resetting Hyperlink to Worksheet
Time Delay for Macros
IN A MACRO HOW CAN I INSERT BLANK LINES AFTER EACH PART NUMBER 3RD
Truncate, Insert, or Update SQL command in EXCEL Macro
GROUP NUMBERING
Contents visible in cell
Closing Excel and Events
Identifying the largest number
skipping cells
Pivot cache related--> vbscript code
How many sheets open?
Yes or No Box then run macro
Code Problem
Prevent formula entry
Find Matching Cell and Copy Cell Content in same Row
Using Macros across different office versions
Macro to work both in Excel 2002 and Excel 2003
Formatted cells turning up in column IV
need some advices/ideas
how excel calculates the major units on an axis when MajorUnitIsAuto property set to true
Building a quoting / invoicing system.
On opening a file auto open another
Very wierd problem. Please help
Tab Index Not working?
Userform Listbox highlights wrong line.
How do I use Cell Link in Macro?
Built-In Dialogs and xldialoglistproperties
RE: How do I use Cell Link in Macro?
Excel programming
Excel request for expert.
Run time error 1004 Object defined error
Save As to a particular file location.
is 0 an integer?
Can't insert columns AGAIN
Want to have Data in Data.xls and PivotTable in PT.xls
Join Excel Cell within 1 Worksheet to another
concatenate values of two cells
Gant Chart/Programme Progress Monitoring
VBA help - error message to user
Move text data including detailed formatting
Excel/Acess import question - odd Excel records file
Excel/Acess import question - odd Excel records file
Help with Format cells to display minutes difference
I could use some help on a modification...
conditional sum based on two variables
Add values to particular years
Copy between sheets
QueryTable.add naming problem (web query)
Need VBA to capture who and when
Absolute to Relative
Worksheet_Change/macros not working
Links to a workbook that is password protected
vlookup to select sheet
Problem with ExportAsFixedFormat in Excel 2007
Instruction Block For a Cell
How to load SVG images into excel?
Accessing cells in different files in a folder
User forms
Worksheet level password protection
Radio Buttons require double-click
How to determine the worksheet that a calculate event gets initiated on when the workbook is not active
Excel Macro
dialogue box if cells are not filled
Concatenate UDF help please
Macro Section Skipped
ComboBox Control on Worksheet
Workbooks with links to each other
link cells in master worksheet to other cells in other worksheets
Combinations numbers ecarts(Variation)
Compile error
Split a decimal number
Date Format In Combobox
automation and excel information
Copy Just UnHidden?
searching for words
Selecting cells
How can you get a list of sheetnames?
Pivot table & cell reference
Date difference
finding a tab name
Delete and copy cells to another sheet
Treeview Control Not Taking Focus
Inventory Turnover Curve
count of changed data
Linked Cells
importing alphanumeric columns from excel into SQL-Server or MS-Ac
Hide row & columns with particular cell value
Set Number of Rows in Print Area
Macro
changing and re-setting the default printer
how to use select case
Putting Cursor in Cell A1 of each Worksheet, then ending cursor on smalest sheet name according to VBA Editor
Excel 2007 save compatibility issue
Bold all rows where a cell contains text "X"
Deleting values not formulas
Assembling Data of Many Sheets in one Summary Sheet
VBA convert day and date from text string to Excel date
Two Questions - Need help
Searching for a string and then shading the row
Menu bar reset error
Listbox Select Last Value in range
Where's a VBS reference?
UserForm Print Landscape
Setting name of series - run-time error 1004
No right click on sheet tab
How do I enblae macros in a password protected workbook?
Nested if formula clashes
Workbook_BeforeSave not behaving as expected
Trendline Coeeficients Vba Procedure
Accessing value in a range using Automation in a C# DLL
keep on adding
Loop excel formula
Userform combobox question
Conflict Resolution not working
any ideas?
how can i know the last user who open the workbook
Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it.
Formula for Payment Schedule
Letter recognition
if condition skip to next line of code
Hiding some pages on multi page form
Pasting data and then selecting the cells next to what was pasted.
another combobox question
function call
Can anyone please help with this - 3rd post
Click to Add Image
Select correct worksheet based on data entered into a cell
Sorting rows
Error handling does not work
Excel crash based on this action
Combo Box initial values question
If this is not found look for something else or error handling
Compare text in one column to another and return a value from another.
Multiple checkboxes
VBA Range
Save as troubles
Automation multiversion excel 2003-2007
Unloading userforms
runtime error 91 by passing a value between modules
Data List - Write to another cell with check
Exiting a Textbox
mkdir
HELP: Excel 2007 - 2003 On Same PC
Marking records with mismatched data
VBA - Internet Time Service
Dynamic interior colors
Sorting large numbers of independent data
Macro to control 2 pivot tables
formula array in a macro
Change Error Alert Icon in Data Validation
Stop the Repeating Rows on the last page to print
The lost weekend ('s file)!
PIP
Challenge with conditional find
Convert string from one codepage to another
Range 's top property
On Errror Goto Error handler only works first time through "For Each" cycle
Trusted Publisher in Excel 2003
Hidden Columns won't Unhide
Return cells that contain formulas on a protected sheet
ByRef vs ByVal
Automate unique data to move to unique worksheets
Macro To Automate File Retrieval and Email
run macro for all files in directory - error in my code
Need help
moving files
Transfer data from one workbook to a form in another workbook
Compare Worksheet Names - Truncate?
Autofill
make line visible or transparant
Controling IE after security popup
Compare Worksheet Names - Ignore Case?
Change the row number in macro
Converting Degrees/Minutes/Seconds to Decimal Degrees
Make 2 Pivot Tables in same items
label
disable event
sendkeys string
List Box in User Form filled by Range
Excel macro range problem
MS Query: Search Criteria "Similar to" Cell Reference
Automatically fill in third column depending on data in second column
VBA code ??
Detect if a cell is within a group
Calculating formula ..circular references
vlookup question
HELP!
fill a cell from a c application
Add-In not Recognized
Deleting unwanted rows
Finding problem source causing "Your formula contains an invalid external reference to a worksheet" message
VBA Lookup Help - Please
DataLabels
Type mismatch error
Tick box
Web Query Doesn’t Load Unless I Open It 1st
Cleaning up the screen
Change color of Autoshape in chart
Problems with Digital Signature
Bug when Sheet Protection Activated
Problem - In opening Excel file through shortcut
color of legend
sorting an array of own type
Excel 2003 visual basic help shows nothing
macro to highlight every second row within the current region
copy and paste data to last used row wkbk
Comparing cloumns and write answer in third
Macro for using multiple selected cells
How paint background of hidden pivotcells
Save active sheet as "filename" on a remote server with username and password
For Each ...next..
cannot create a row longer than 256 columns
Re-creating tables in Access from Excel
RE: European Address Data
Delete rows
Issues with Referencing .XLA file on a Server
Re: OFFSET and INDIRECT
Column Hidding Script not working
Advice - Multipage or Tabstrip
Macro triggered by a cell value change
I have a problem with determining if a shape is selected.
Application.Stdev(multiDimensionArray) ?
creating a value for a file name
Help me understanding variable scope
How can I set all Column widths 25?
Show Outlook Calendar
Search range and sort another range
How to remove empty cells from Listbox
VBA to Search, Insert Column and Sum
What is a VBA Cleaner and why using it?
using VBA on protected sheets, is it possible?
Quickly Dimension used variables
Sort with more than 3 keys?
Testing for Month in a cell using VBA
Delete rather than make Invisible
Personal command button like "Borders"
Pasting an excel Chart into a specific area in Powerpoint
Control Tip Alternative?
Command Bar show/hide/delete
Week number in vba
Creating a VBA Range object from Excel HYPERLINK workbook function
Insert a fixed number of characters
Global Array Constant
End Sub if InputBox cancelled (False)
VBA Help in 'Applying a Discount
Stack memory
Run a macro before paste
Spell checking without the POP up ...
Count the #of ISTEXT cells
How can I format all Cells in a XLS File to Right Justified?
removing blank rows taking a long time
Need macro
Creating a detailed log file
Activate Event Before Saving
Reversing Format Changes on Close
labels in activesheet
A way refer to a control itself in an event handler
Format problem
Time Stamp in multiple cells
Unload vs Hide
Excel Autonumber?
Excel saving as web page and scaling the print out to fit one page
Copy/Paste Problem
Links to master sheet.
Loop Problem
Hyperlink results refresh Event
SUMIF in Visual Basic Function
refresh event pivot
SUMIF
is there an Eval() in Excel VBA
Create Workbook That Doesn't Show In Taskbar?
Excel 2007 - Losing VBA in Compatibility Mode
Deleting and copy cells
excel fields - validation
Controlling sheet number during sheet add
lowercase to uppercase
Help needed with large spreedsheet problem
Write code to a new worksheet?
Calling a macro from a closed file
PC to Mac macro format issues
Need help with time
PC to Mac macro speed issues
about frame and screen shot of a frame
Set name fails
Create a new Wb on the Desktop
Running Ontime's procedure while another function is running?
Infomation about the meanning of EXCEL4 command error codes
Macro To Perform "Save As", etc?
Conditional Format
DrawIcon API
Excel matching question
automatically apply formula to new row
Inconsistent Formula
Conditional Formating Copy/Paste
Moving di
count distinct numbers
Rows (i).Insert
Avoid volatile Indirect problem
Insert Date with Check Box
Copy rows to another sheet. Criteria = cells in column H is not em
Run macro from directory folder...?
VBA Copy a range with Formats & Vaues Only
Simple Timer Help
Select Tab on Ribbon at Run Time
how to count distinct values???/
Mega Complex Pivot Table design question
Excel Challenge (or at least it is for me!)
Login Scrfeen
Lookup Help
Puzzle: Route Planner using a World Map in Excel
Manipulating code for reading cell values from workbooks in dir
Copy/Paste dates from CSV file - date format error?
COUNTIF WITH NAME A RANGE OF INFORMATION
Formatting cells - December issue!
COUNTIF to be used with a time range
XL2002 - Cell Reference for Active Button
Update Timecard to new year
deployment
Memory Question
Action depending on cell Value
Proper case using VBA
spaces2
UserForm and .hide: prevent code from further execution
exporting VB files
Send Email depending on Cell Value
How to open a book with parameters
spaces
Delete if find a data format
how to publish my Excel project to sharepoint server or excel serv
implementing help for UDF
File renaming doesn't work
Scan my network for any shared folders
Assembling Data of 100 Sheets in one Summary Sheet
Move the active cell
Array formula with IF
question on Array
How to undo autofilters without removing?
Setting the colour of the legends in chart.
sharing variables between form and module code
Excel challenge, please save a doctor some time!
Lock a custom Userform in toolbar
excel 2003
Capture button name or row # during click?
HELP! PLS!
Border
How to capture Excel Save As dialog box?
Finding Multiple entries for a name
Conditional Format Pivot Range
define a label
Add A Button To The Menu Bar When Opening Workbook
i.Value, i.Text, Or just i?
Pasting within a text entry
Excel 2002 - Getting enable macro prompt with no macros in spreads
Validation of multiple selections
Run a macro by sellecting a cell
Split based on multiple criteria
macros in pivot table
Index in VBA
Office Assistant Balloon no longer available
Perform task on multiple sheets in a folder
hoping for help
Remove Non-Numerics from String
Is This Possible?
most efficient large range summing?
missing data in columns[empty cells]
UserForm image stays when form is dragged to another area
Change a Cell Ref When Clicking in another Cell
java to vba
Macro Examples for prompting info
nested query
Deleting rows within a named range
Sort of sharing a spreadsheet application
Import CSV into Web App
Need help with program locking up
Multi Criteria for Autofilter
button object & imbedded image
Problem in autofilter procedure
RANGE NAMES IN MACRO WITH ADVANCED FILTERING
formula error query
Return to Previous Sheet
Custom UDF
"Picture too large/truncated" error?
Unable to set the xvalues property of the series class for a single row of source data
Get data from Internet? XML? QUERY?
idea anyone?
ProgramEntries.Show 1 causes errors...but no error message given?
How do I stop a macro from running in Excel 2007?
Variables in URL formula help
Data validation of cells using code
Log time against a job
data manipulation quandry
Is it possible to get a date stamp from an Excel file?
hide multiple rows
Referring to a member of the workbooks collection by name.
VBE Project Protection
equal size columns [same no. of rows]
VBA Code Please help!!
How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format
Tab colours
Pass worksheet object name to a class module
Delete cells in column every
Add variant arrays (without loop)
Open a copy of xls file
Read Content From A Website
Last Saturday of each month(check on Monday)
Write from variant array into range
Refresh linked Custom Document Properties before save.
Rename and use toolbar menu name by user entry
Allowing Chart creation in protected worksheets sheets using VB co
Excel VB to make a copy of opened file
repetition cases
Drop down list
Linked workbooks
Arrows for UserForm resizing
Moving data Between Two sheets
need macro to edit formula...
Excel 2007 is a Joke
macro to hide rows
move from sheet1 to sheet2 if criteria is met
View data as a form
Lookup function in code
Determine top row and bottom row
VBA code to "reset" application run and empty preserved arrays
If duplicate found sum column C
Comment instead of Data Validation
Macro Problem
Formula Question
number all entries for each letter that apply to the same column
Conditional Format Code Pivot
Sum Times based on StatusID & EmpID
Can a checkbox be placed 'within a row'?
How to pull a value out of a cell into a macro filter
How do I use VBA to update pivot table formulas
Runtime 13 - type mismatch
Runtime 28 - Out of stack space
Custom Command Bar Options
SUMIF every 2nd cell
automatically using VBA code in Sheet 1
Skip function if data sheet is empty
Setting a collection in a class
Convert text value to numeric value in VBA
Problem with comments overlapping frozen panes
Create an Array that includes every possible combination for 4 gro
Validation ON List of values against by command button
Array write
Connection Cannot Be Used to Perform this Operation
Using VBA to Populate a Calendar Template
ActiveWorkbook.XmlImport?
Alphabetize a combo box list?
Load a ComboBox without triggering another event