Excel Programming [Archive] - Page 89

Calculate Event
Keeping images visible on sheets
How can I get a value from two cells into the new cell.
Create Hyperlink
Getting a Macro to run in a different XLS file
Transpose Row by Row
Finding text in one column that compares to another
Shape instead of Target
Info
Hiding rows based on a column value
form code applied to sheet
GetOpenFilename - Trapping Errors
Excell and Population demographics
copy spreadsheet in new workbook, macro problem
when a cell is empty do not consider it at all
Re: Using Quotation Marks in Arguments
Re: Using Quotation Marks in Arguments
Using Quotation Marks in Arguments
Setting column width if #### appears in column
Controls Toolbox
i'm trying to put a value with a number but its not working.
Importing multiple Text files into Excel
Importing multiple Text files into Excel
Importing multiple Text files into Excel
Need formula or VBA code
Command Button does not re-set once clicked
Printout sheets with a userform
macros
Paste Multiple listbox items starting at ActiveCell
Copy sheets only if condition is satisfied (mat)
finding current row
data in rows to a single column
Dynamic References to Word?
Counting Unique Empty Cells of a Range
Shape names
Extract Email from a Picture
How can I trap this Vlookup error in a VBA macro
Variable Naming Convention
SQL query JOINED Data from which Table?
Delete "+" character in last cell
Protect macro and close VBE programatically
ot -paste command
Application
macro stop and start
Little Help with macro and boldface
GetValue to extract data from closed files
Add a border to pasted cells
Keeping focus on a txtbox 2
workbook_open not being called when I open the excel file
Keeping focus on a txtbox
Excel Functions
Identifying Control type
Problem using names as integer type
Can an Excel Application be written for Mac?
split text into more columns excel
Type Library Reference
Mensa Genius question: sorting worksheets by name
Import an excel spreadsheet in ASP.NET
Trouble setting background color of Worksheet
Working between XL and Word
Delete an entire folders contents (or just Excel files)
Using Lookup function in VBA
Read Registry Keys (and possibly write)
Formulas
Seeking Help with a forumal.
RE: User select printer in print macro
Another Check-box problem
listbox and vertical scrollbar
replace one set of numbers with another
RE: Dynamic Data Labels
Simple macros question
Slow Formula
enable diable macros
Seeking Help with Cell/Range Height and Width Properties
ComboBox index
VBA code and XLL
poplulate cell based on two conditions
RE: Can you load part of a worksheet into a userform
RE: Subtotals with variable total/sum location
Can you load part of a worksheet into a userform
Subtotals with variable total/sum location
Email question for Ron DeBruin
I am not able to rename sheet
Email Body Text & Signature
Loop and Find
Macro calculating incorrectly.. what can cause this?
Shared Workbooks - conflicts
How do I transfer repeating info in a column to 3 rows?
.xls to .htm conversion truncating characters
Running Macro/VBA in multiple worksheets.
Import a CSV file HELP
Hide all sheets but selected sheets - an example
Create Multiple Sheets
Another SaveAs Question
Moving cursor
custom command bar
Naming command buttons on a UserForm
VBS for all xls in a folder
Adding hours and minutes
Required Field
For..Next Question
Bypassing Worksheets when scanning worksheets for data
New to me
macor to create chart/graph for a specific row of data
comparing side-by-side lists
How to insert "&" in a formula using VBA?
When Sheet Is Active, Run Macro, Otherwise Dont
using or in an if
Contours-type Graph Using Excel?
Pivot page fields!
Sort community search results by date
How to reference win.caption, when caption changes
How to prevent error message during macro
UsedRange higher than expected
Update External Links
Using .filesearch for text within a file
Update from TXT file
Formatting the 5 highest values in a range, and copying them to another sheet
Hiding rows when opening workbook
Copying a Range from a Workbook without opening in memory.
How to use selected items from Listbox
How to create a Reference with VBA
OLEDB Datasource for Excel Pivotable
How to write in Word w/o Reference
FORMULA RETURNS #VALUE WHEN PRESCEDENT WORKBOOK CLOSED
formulae to calculate sub totals
Ideas Welcome for finding values in external Workbook
Dialog box on getting data from TXT-file
Re-structuring data
Excel2000: Closing an Excel workbook automatically
Make Excel work faster
Bug when macro tries to open allready opened file
How to extend the data length of FFT analysis in toolpak
Userform without titlebar?
Calendar widgit in control toolbox
Daily Time Record
Need to generate unique serial numbers using algorithm
How to apply Application.OnKey
Excel2003 Macro runs slow???
CRLF in .cvs file
Exchanging an Excel formula with some VB code
Using Analysis ToolPak funcions in VBA
Find last used column
Populate Array Question
message box warning
Listing Printers in Excel
How to pass cell reference to VBA function?
Complicated Save
Complicated Save
add + suppress command buttons in execution time
How to start an application from Excel VBA
Either an "IsEmpty" or a Range issue....
Bitoperations with floating point numbers
stupid cryptic messages
Append Selected Cell in another Cell's Formula
Help !, to find last 'text' date in text string
Remove macros in xls file, but keep macros in xlt file
Moving from Cell to Cell
Re: User select printer in print macro
Spreadsheet Security
How do I search for a .bmp in a worksheet using VBA in Excel
Find method fails in hidden range
Looking for VB macro...
trouble with userforms
Idle timeout
Search for value. replace with formatting
Setting number format for a Chart (bars) from C#
Type mismatch in vlookup
how to find find last file name and increment - XL2000
I'm over my head on this one...
Selecting and deleting named range based on cell value
query with changing parameters ...
Gathering data to a master spreadsheet
Hiding Column Also hiding text
how to create volatility
How to find Used Range and Print Area?
worksheet_change help please
Workbook_open procedure issue when two spreadsheets are opened
How to determine whether Cell is in current view?
Copy Data From Above
Returning last saved by
Help sorting out my code PLEASE
Multiple Users in Userform issue
Shared Workbooks - automatically resolve conficts
Ctrl Shift | Macro Stops | Creating Short Cut Keys
Loop inside a Loop
Visual Basic Color Palette
Pivot Page Items!
Disabling of Cut and Paste commands on CELL
Subscript out of Range
Help With Find
Add in problem
Multiple Combo Box Indices?
need programming help with nested event codes
Re-formatting
How do I read cell value and compare it with other cell in a colum
Dyanamic range - Object Required Error?
Change to a Cell causes action
How to get the window handle of and excel instance using it's process ID
What's the difference between Control Toolbox and Forms widgets?
.Cells(Row,Column) parameters
print specific worksheets in specific order.
compare 2 columns
Calculating Days Between Dates
Need help in macros
Is Excel Security worth anything?
exit all subs? (from embedded sub)
Need macros for activating multiple hyperlinks
Need macros for activating multiple hyperlinks
urgent transpose macro needed -
userform data entry
Chart how to find lastrow?
Macro Filldown only with Formula
Input box to enter worksheet name ??????
Thankyou
Column based cell shading
Error Handling
Pivot Table Data field
identifying the character represented by a square box
arrays again
Transparency for interior color?
Mapping Question
Difficult Loop
Change name of files in a folder
turns it all red, not just if boolean is true -- help with macro
Excel 2000 reading the group names from a pivot table
Fill listbox with data from file text
Grouping and getting faster
Why does not Excel 2003 Replace comand romove spaces from cell contents?
re write
Percentage of a cell
HOW to make sub run more quickly
Office automation problem
errors in Excel 2003
Programmatic updates
Insert columns until a certain number has been reached
how do i program excel to insert a new column monthly
Macro autocode is not working after special paste. Why ??
help with my code please. (Error: Object doesn't support this property or method)
renaming worksheet
Disabling and re-enabling the Cell Shortcut menu
Adding Items To a combo Box
VBE question
Combine 2 columns of numbers (A+B=C)
column command to return letter
Solver: An unexpected internal error occurred, or available memory was...
variable
how to send mail with excel vba
Converting military times to numbers
Excel to txt
combining worksheets
Macro to print web page and close browser
optionbutton question
Loop Problem
Copy my active sheet to a new sheet and open with an input form
Copy Sheet
Opentext array error
Commandbars dynamic menu creation problem
retieving cd title and placing it into excel
VBA Control Tab Index
No Combo Box format control
Outlook & SubFolders coding
Generalized Macro
Selecting a cell doesn't work?????
2 codes in one window
select case question
select entire rows using a contains comparison - an example
Change order in a multi-shape group?
XL range copied into Word
Keypress event???? data validation on a userform in vba for spread
Insert Rows & Paste Link
Clearing rectangles
Code problems
macros vs hyperlinks to open excel sheets
cell's reference value dependent on another cell's value
follow hyperlink?
New Menu
Cell Formatting Conditional On Other Cells Fill Color?
macro name same as module name = problem
Marco program
Populate Array
VBA defined function problem sumbycolor
VBA and SQL
double loop madness - help with macro
Range question
spreadsheet with macro does not work in Excel 2000 opened in Internet Explorer
Saving a workbook as -1 under certain criteria
Application defined or object defined error??
Formatting Excel within ActiveX script
Macro to allow user to "choose" a month from a list
Help with Macro...
Find and Replace across all Spreadsheets
VBA Socket / Winsock control / issues? Demo app provided.
Copy variable rows of data to new sheet
Can't paste when CutCopyMode is false even though clipboard is not
Disallowing a blank text box
ADO parameter object fails with AS400 when used in Windows XP
Counting and totals with formatting
change font using macro
Date criteria in query
using portion of larger list to populate combo box
I think I have an array question...
How to bypass Open macro when launching Excel 2003
Can a macro be written that when you open a workbook the zoom will be set for each sheet?
Date format and Form
using vba to change command button caption
Code For Count on Conditional formatting
Does 2 error handlers mess up excel?
Excel Form - Dependent Combo Boxes Writing To A Cell
Read formatted value of cell
Opening an Access mdb file from Excel VBA
Mouse movement over a worksheet
Data Validation Drop-Down Will Not Appear
Dynamic copying of rows
External Links and Add ins
Concatenating a string and an integer
Quick question RE: Finding a cell by interior color
Save
Auto Print
Hiding URL's in web query?
Detect Whether Workbook Has Pwd Without Opening It
User forms?
copying the exact contents of cells
Is this possible?
ListBox and ListIndex
Check in to Livelink via excel macro
Removing unused reference
Reading a *.csv file from different points
Function Sequence Error
Pivot data problems
Changing entry to Caps
display all possible combinations
Programming in excel
range to string
VBA - Code failing in Excel 97
Open the last file in a folder
Finite element method on excel?
Run-Time error 1004
Pulling Data from a different worksheet (Need Help)
crosstable to column
Is really the default property consistently returned/assigned?
autonumbering cells - yet again
msoShapeRectangle
tab index to move around within unprotected cells
close all open workbooks except the active one
Macro affecting hyperion retreive
Disable the "view code" option
Count/CountIF Formula
UK Excel User Conference - July 19-21, 2006
Menu Equivalent of PivotTable.ShowPages method
Error message on some computers
copy, split and transpose a range of values
Deleting a range of cells.
Excel data sorting
Running a Macro automatically
Auto run dialog box? Please Help!
Insert Formula in Cell with VBA
Convert xls to bmp
To consolidate contents of multiple workbook
Delete Contents of Cells
VBA ADO SQL Query Problem
Problems specifying where "freezepanes" occurs using VBA
Format Cell As You Type
Finding unlocked cells in Excel
VBA toolbar-button programming switch on/off
ot scroll wheel in vb
Add texbox to Multipage on worksheet
Cells() produces reversed date format for double digit dates
Applying vlookup to a range
Worksheet names in macro
Keeping focus on a txtbox
Vista
Make a changing cell visible while still running
how do I get a message to appear on my userform...
Input box cancel produces error
refreshing ComboBox values
Transfer data from one worksheet to another
Finding a value and filling in data
Copy Range and Paste to Array of Sheets
Userform Caption
Pasting data from Excel to external application
Worksheet_SelectionChange
Copy Worksheets
Undismissible Alert
Calendar help
Using VBA to Insert Formula in Copied Sheet
setting an event in an embedded chart from a differnet workbook
print preview range
Finding a value and placing text on the cell to the right
Programatically dim (lighten the color) of a cell.
Complicated formatting, help!
Understanding Menu Items and Building Them
Range.Select Issue
Replace method - cannot find any data to replace
How do I pass parameters into Excel from a URL?
Interesting macro needed
Select If...
I need help.
Select Range in VBA relative to another cell
correct columns
Hide Row If
How do I use a variable in the place of a sheet name
Using countif to recognise dates
Variable Work Book Reference
R1C1 Error with Merged Cells
can you set a default page in a Multipage userform?
Row column intersect
Losing data during transfer
Problem calling macro from a commandbar
How do I detect and commit the current cell edition?
need help with macro for 400 worksheets!
Remove decimal from price to show straight number
Replace all Pivot table data fields using VBA
Excel Pivot tables connecting to sql
Simple If Blank Statement
check cell contents
macro to copy cells that meet criteria (mattour)
macro to copy cells that meet criteria (mattour)
macro to copy cells that meet criteria (mattour)
union with multiple sheets
Row Grouping
How do i grab a table value to fill a cell?
Repetition of Code
New to VBA - Help with Deleting Macro's
Identify a single word amongst many within a cell
Button programming Run-time error '1004' with range
loop Statement
adding a code to a cell?
can I set row/column label as variants?
Two sets of radio buttons on a worksheet?
Automatic Calculation
List items determined by content of previous cell
Searching one cell
Check Box
Look for Errors
Adding Sheets with names from a list.
Macro to import delimeter file
Red X close box
Pasting an unknown range
Else no If
User Name via 1. API, 2. Enviornment, 3. WScript.Network
Can I import/translate a Visual Basic project to Excel?
Blank portions of the worksheet after the data
Workbook Name
using vells that fulfill a certain criteria
how do I put today's date and other dates in macro condition?
How do I Make a macro in exel to just open the "open" screen?
Compare and count
sum numbers is a column
need some code
WorkbookAfterClose Event
Formatting and Worksheet_Change
save Workbook
Simple Macro
Consol
Consolidating Data
Option Private Module
Error with protected cells "Excel 2000 SP2"
ADO Connect Access
How to delete Radio buttons
XLA not opening properly (Repost)
inputbox uk date
Application.OnKey Macro Cannot be found
Update a record in the recordset
Userforms
PDF document with VBA?
BeforeUpdate Event triggers twice
How to create a PDF document with VBA?
Use an entire row as "recordset"
Customised Toolbar Specific to only 1 Worksheet
After printing, macro runs slow???
New to VBA, getting unexpected error 1004
Error problem
show customer based on Weekday
Get data from Access to Excel Combobox
Finding empty cell in list
match some fields & write new file
delete content of one sheet off another sheet
How to restore a Custom menu if a user presses Cancel after selcting exit
Adding - sign(-)
Checks for duplicate entries
Help needed
Disabling old VBA Macro's with .NET
Loading Userform Errors 1004
visual basic .net and excel problem
Create named range
macro activation
Rendered XML
assigning value to option button
Setting an option control
Need macro help
run macro on selection change
Find Last Column??
Re: Repeating columns except a couple
format text in cell
Intialize a checkbook
Stubborn Date Format
insert combination of random letters and numbers - an example
Date Reminders
Help: Javascript to Excel VBA?
Excel problem with dynamic matrix with a name
Help with forumula to change text cell
New to Excel Error 1004 basic chart programming
determinig datatype in excel
Object doesn't support this property or method (Node Function)
DAte problem again
User Form
Catching errors
Copy Values from WorkSheet back to Another Workbook Replacing Values in Worksheet
Newbie needs help!
Default printer selection in Excel macro
Average of last 3 columns
is there a macro I can write to email an Excel document
CSV File with double quotes
almost got it, but need help- pulling data from other workbooks
Surely there's a better way....
Update combobox
ADO and pivot tables
Hide all columns that span a merged cell?
How to tell if Replace() did a replacement?
passing a comboxbox result into sheets.select
call code for all sheets
macro buttons confused
Trouble with 2 range definitions ...
Can you remove redundant date entry?
Save emails using only part of subject line
Creating a new worksheet by checking for blank values in a range
Weird calc behavior - Guru challenge?
Using Cell Ranges
insert random letters into selection - an example procedure
object browser office 2000
FitWidth not working in XML description
Unprotect not working
referring to worksheets by name in a vba fourier transform
VBA Question - Is there a better approach?
Footer-changing page numbers
Refreshing a userform/listbox
Macro stopping for one user out of 14
Runtime Error 1004: Application defined or object defined error
Worksheet_Calculate Running on Every Sheet
Calling another workbook
vlookup macro pasting
Summing Rows With Date Filter
Help with Application.OnTime
How do i keep Leading zeros in .CSV file saved as from .xls file
discover format of Excel Cell using VBA
Form a circle (ie. color specific cells) given specific radius
use an input box to select a range and copy to another worksheet
How to create a PDF document with VBA?
Average Without Zeroes
Sequential number within excel
How to write VBA code to solve this problem
Posible to speed up query update with Apllication.screenupdating?
Save Worksheet at .txt
Find
Unselect Cells
View Locked Cells
How to open up 2 file in excel using macros
Formula or makro help
How can i shorten this macro?
Advance function of excel to get sorted data
concatenate formulas
Export data problem
entering text into organizational charts
listbox
Restore Borders Automatically
Macro to delete certain cells
VBA Availability?
Re: VBA ADO Major error
Copied range from excel to word (but not in table-form)
List wallpapers Windows XP & Vista
copy multiple cells
Min and Max value in TextBox
Personal vba - interaction xls/xlt
Ms query 2000
CommandBars vs CommandBars(1).Controls
Application-defined or object-defined error Please Help
Assigning a macro to a button
Insert calender into a cell
Insert calender into a cell
Re: Error in Excel 2000, but not 2002 and 2003
Strange Pane
Problems using chinese Excel
Hide Zeros
How do I make a macro automatically select Yes when a yes/no box appears?
Problem collecting Range Values
Search Tool
ComboBox Code Problems
Parse string
LisBox Column Width
scrollbar changes size
Macro to enter record number in column A
insert entire row for new data, external data range doesnt work
How can I loop through all Formula in a workbook?
Matching Text
Protect with AllowFiltering
printing a form
Select Case Query??
Selecting a dropdown option to display records
text box for displays of information in excel cells
RIGHT function in VBA
Mandatory cell - display message
Evaluate Custom Expression
Line of Code to set references
Compare Values
Remote module call
Macro template
Cell Value in one sheet using SUM formula in another
What is the connect string between Oracle & Excel?
Works at one place but not another?
workbook.open throws 1004 error
Incrementing Cell Numbers
c# RTD Server, IRTDUpdate Object
Sorting Rows
Split function to get a relative path
How many decimal places can a cell display?
Correct Format for formula
Pop up code not working
Extracting values from a table
Paste value from another workbook and multiply by constant
Full folder path from BrowseForFolder
Sorting Data Colums
return a value from a range
regarding list object
mouse wheel
sort items of listboxes with multiple columns
Merge txt files
help with strange behaviour of macro
Insert function - custom function name preceded by module name
Copy data from above
Use Variable In CheckBox Name
Retaining focus on a textbox / listbox item pair after validation = false.
code to copy a range of cells to another sheet
Macro Query
Listboxes and changing colors
HTTP link in Excel
mouse cursor to a button using api
Macro - Loop or Next
Clear Sheet
Workbook Menu screen tips?
Generate PDF from Excel & Attach to Email
I'm trying to figure out what would work best for data entry and retreval.
error with macro
Set Group and Outline settings...
Printer.Print Not Working?
Setting Range in Graph
Why Is Conditional Format Failing?
Clipboard Event Handler?
go to the same path of the excel file being launched
Delete worksheets and the code sheets remain?
Data validation - error alerts
Update Range from User Form
smoothly linking two presentations
copy and paste
Who can make a chart of this?
Preventing duplicates when adding records to list
Birthdays
adding userform command buttons
Hiding functions in add-in
VBA and VSTO
need a macro for arranging the data
VBA Calender Formatting Date Problems
Re: Help with a closing WB w/o activity!
Merge blank cell with cell above
Detect if file exists
Macro to open another file
Change names of Files in a folder
How to start a Macro when I open Excel
how can I make an exe or dll file out of an excel book?
need help with array
Saving all open workbooks
Copy Files to other folder
A question about data entry on forms and tables.
Need Code
Automatically generating a specified number of new rows (records)
eMoovie - a new company - we need sponsors
Conditional Format Macro fails to set interior color - HELP!!!
Need to program a find only in one column
Copy new data to worksheet
Shape Name and Location Report - an example
Inserting lines into tables
Using Address in Range Definition??
Classes containing Classes
Change Read-Only Recommended Prompt
count rows with data
Interacting with web page
VBA for intersection of two named ranges
VBA ADO Major error
Edit Find
VBA -vs- VB
Pop Up Box for company name
Loop thru lines of text in a cell and extract specific values: please help?
I want to trap an error I get in a macro
Remove Duplicate Pairs(2 Columns)
Do Until Loop Question, for Printing
CurDir
Transferring data between listboxes
Formula question
SaveAs Dialogue Box
Can system variables be used inside Excel
VLOOKUP USING INDEX, MATCH, AND IF PLEASE HELP
Excel Comments
Copy and paste 2 excel sheets in message body of email
lookup finds the next higher number in a range
how do i set column widths
macro recording
Excel 97 - Add-IN - On windows terminal server - Second user is locked
how do I reference data from a Combo Box?
Turn off undo
Data Validation Formula
Run Time Error
Populate Drop-Down Listbox from Query?
Local Directory File Access
What does this mean?
Using Cell Variables to Specify Cell Range
Pivot table problem multiple columns and headers
Combo Box
Telling a website what to do!!
defining a formula
Emphasis of this NG
Find and Paste
Trendline points
Working with cells and images
Progress Bar
Auto exe inserted audio file in word
Fill ComboBox with all dates between two ranges.
Deleting sheets
Re: Hide or Unhide Column Based on Cell Value
Grouping Rows
Convert to Hyperlink
Silly Problem with Variable
ADO assist
Sheet activate method in beforesave event
Sheet Activate method in beforesave event
Sheet Activate method in beforesave event
Remove Comment Indicators
How do I format a sheet using a copy macro?
I have a dream...about userforms and data management.
Deleting contents of cells in non contiguous ranges
insert elemnts from cells into array, create a userform with values checkboxes
Excel Add-in for AS: Named Sets
problems with .EntireRow function
<%><%><%><%>HOW TO BE FUNNY!<%><%><%><%>
Can I program this needed format conversion AFTER pivot table
Mutually exclusive values
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook
>@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
Cell reference in Workbook_BeforeSave macro
Stop Command Button being copied to new Workbook
Re: Need a conditional drop-down list (list contents)
irrelevant msgs
<><><><><><><>The Net's #1 Joke e-Book!<><><><><><><><>
conversion to formula of string contaning IF clause
Capture the range a user selects and put in textbox.
Sharing variables between Excel and Word
check if a file is open
UDF second range-input incorrect
RE: Concatenate problems
Saving Worksheet Picture on desktop using VBA??
count using multiple criteria
move mouse pointer to a default button(Enter) in messagebox
Dates exported as text
filling combox box with same logic in 2 <> forms
Application.FindFile or .GetOpenFileName?
End of Record symbol
How to access date from Oracle Databace to Excel
Cant open a workbook!
pasting data from an array
Macro and probabilities
conditional formatting
Mutliple selection in MSFlexgrid
Userform not displaying correctly
If range F1:K1 are blank, then L1 is "other"
<%><%><%><%>HOW TO BE FUNNY!<%><%><%><%>
Re: Import from Excel
Disguised Password
Re: Run macro when excel workbook gains focus
>@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
Amnesty for illegal immigrants will not happen this time.....................
Compare values
Will illegal immigrants get deported?.........Of course not.....................
Nested IF Formula Evaluation Pls
Illegal Immigration, the Non-Issue of the Week??????????????
Microsoft query won't allow parameters
Look for cells with same value in different columns
copy rows from one spreadsheet to another
Copying an entire row
Excel Macro
Still looking for a solution for renaming worksheets
Add another criteria
Re: How do I determine the Range that was pasted
Coloring a cell if it does not match on another worksheet
Copy the format of a cell reference
Error capture mechanism, then 'End' or 'Exit Sub'?
sorting vertically.
Using dates with autofilter
Insert Row Problem
VBa code to select from worksheet
VBA automatically updating variable names
RE: Reference to a different Sub
Clear contents macro
Re: How do I stop people from saving a workbook as a particular file name?
Re: variable print area?
CAN ANYONE HELP WITH A SPECIFIC FORMULA I NEED?
Re: Reference to a different Sub
Referering sheet name of a named cell
How do I change a numerical value to a string value ?
Detecting cells that have InconsistentFormula error
Restrict Data Entry, data validation
Array to File
Date Filename Save as Dialog Macro Thingy!!!!!!
application.match question
Comment and Tab character
Select Multi in Listbox -> Event Click not working
Code for all workbooks
Scheduling - Automatic Selections..?
Can CheckBox PopUP
Problem running macro across worksheets within workbook
Text Box
Macro to update values on a Microsoft Equation 3.0
Function exists prematurely
Displaying a random image (or control) on a userform?
Timeout Expired
Object vs. New File in beforeSave event
PasteSpecial Method of Range Class Failed Error
delete from text box using command button
Page Breaks
referencing cell address
worksheet_change question
Dancing Gif
multiple if
getting filenames
Auto Upper on certain cells.
Getting Range whilst looping through files in directory
Excel To web
Why do I get prompt 'Not enough system resources to display comple
sum sub levels.
IsCellVisible(range) or VisibleCellRange(wks) needed.
sum sub levels only.
Moving data Based on critera.
Can an addin save an array or UDT's to workbooks
Can I add a new worksheet using a template
Re: Aligment of DropDownList
Aligment of DropDownList
why do i have to click my 2nd command button twice
Macro copying info/data in multiple excel files into one summary file.
Creating an access log
linking pivot tables by page fields
SpecialCells & AddressLocal
a mortage calulator where can I finf one?
does the calendar control differ for the US?
sheet name as variable
Cell is locked but still editable...
Searching for files below current directory
"WinForm Application" to act as "RTD Server" using .Net
Showing Userform Problem
Repetitive IF statement
set cursor position to that last character
CREATE NEW WORKBOOKS BASED ON ACTIVECELL & BUTTON CLICK
VBA Function not refresh
Formula with the last spreadsheet of workbook
Renaming worksheets
Highlighting The Active Cell
conditional calculating
Format the sum cell
Groups of controls
moving data
Loop every 26 rows and if..
I need data to copy to the next available cell in a column from a macro
difference Close and Nothing in query
Number sorting
When I change a cell a macro will autorun BUT..
Sort and filter macro
signal for incoming mails in outlook express
Delete grouped shapes?
Expanding the F9 functionality
How to call a sub from UserForm Module
Alternating Changing Color of Cells (a Range) across a Spreadsheet
Why 'Unprotect' works for 2003 but not 2000?!
Clearing the Values in a Drop - Down List
Copy from one Spreadsheet to existing spreadsheet
Change Event Range Help
Declare a public variabl
vba macro open password protected workbook
creating a list of letters in a column
Converting Numeric Columns to Excel Alpha Notation
finding min with currency
Restricting use of Calendar Control
code to highlight max value in a range
Search routine needs a little work
Print embedded Word docs from Excel
Inhibiting cross spreadsheet custom-menu functionality.
Button to add 1 to selected cell
protect a macro
Setting Print options from a VB6 program
Saving Data In a Macro
Average data from different spreadsheets
Array Formula creates error if too may cell chosen
How to create a new folder using Excel VBA?
Autofill down without range
XLA not loading properly on start-up
How can I get network userid in a cell in excel?
IF Statement in Macro
Overflow error - same code, different sheet
Macro won't run in Excel 2000 when workbook opened via URL
Textbox format question
macro to print the first two pages of every tab in excel?
OLEDB on x64 2.0 framework
Combining data in multiple textboxes
Macro Problem
Protection and Formats
Search Column - Find Multiple Entries - Sum Then Delete to Single Entry
Adding VB code to worksheet programatically
pasting copied cells
Can't Raise Error twice
Runtime error 1004
Manipulation of Selection.Address
Hide rows based on a condition
Two conditions in one IF statement
Saving a spreadsheet without saving the Macro
Auto sort
ForEach statement problem
adding a sheet and renaming
coding for changes....
Open MS Outlook with Message
Have the macro run automatically
Another Problem
Weibull paper in Excel - how?
I lost my customized toolbars!
select range next to activecell
Populate Excel Chart Data from Access
how to find a value in one column that is not in another column in
write a macro that changes format of selected cells
Saving email attachments
Question about Concatenate and IIF
Change Event
Error Won't Debug
programatically entering a CSE formula
AutoFilter on one sheet filters same on other sheets?
how to conver #n/a's to 0
Referencing
Personal.xls and Workbook_BeforeClose
How can I streamline this repetitious piece of code?
limit on cell contents
Counting rows with criteria
Coverting 1 letter codes into a sum value?
Trouble opening embedded Excel in PPT
Protecting Selected Sheets
hiding cells via macro
sort question
Identifying & Selecting an Unknown Range?
Clear cells
Search For Multiple Entries - Combine and Sum
Set Legend of a Chart from VBA?
Copy paste from one worksheet to other.
Pivot Table Page Area selections in a macro
Printing behavoir changed PCL-PS printers
Creating ThisWorkbook Event Procedures
Can I assign a macro to an autoshape using VBA?
Seek ODBC only VBA example
Copying only new data to another worksheet
Calling subroutines and passing variables
External Data Via VBA was working - now not so much
Calling subroutines and passing variables
Selecting first empty row in column
print macro for a list
How to detect if cells text go on other column ?
NETWORKDAYS Calculation Problem
Copy Visible Sheets into one Workbook
Macro - save_file
chaniging a date in a url!!
Copy File into Worksheet
Using vba to generate xy scatter plots in excel
Checkbox arrays
UK Excel User Conference - July 19-21
Module Names11
Move cursor to textbox in a userform
do while, "and function"
GetObject with Password
Running code by clicking on a hyperlink cell
Colour and Pattern Formatting Cells
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?
Does anybody have code to do this?
ListBox/ComboBox Acting as Macro/Hyperlink Tool
Continue executing code while saving file
Can We Do It In Excel ?
CopyFromRecordset text to numeric
preventing Application.EnableEvents = False
prevent page printout
Save as Macro working for one computer but not the other?
Variable value from named cell
How do I suppress user dialog in File Save As?
Wait with calculation of other sheet references after edit a cell?
How do I create a formula that will do YTD calculations?
look up
public function having array passing out to a sub dropdown
reference adjacent cells in formulae
run-time error, method 'paste' of object - worksheet failed.
UK Excel User Conference - July 19-21
Offset concern