Excel Programming [Archive] - Page 121

MVP help
VBA Compile Error on Deployment
Adding a Menu Item into a sheet as a button
Retrieving the SQL query of the external data range
Excel crash closing ADO connection object
programmatic generation of Enum To String functions
Moved code from worksheet to module
Last Cell
UserForms:listbox display problems
deleting cells in a range
How do I make a change in time into a number I can use to calcula.
Searching for "not blank"
Extracting filename
Open File Dialog Filter
Batch Replace function for Large strings
Importing .bas files
Help: formula=auto copy from sheet1, A1 only if data in field E1 .
Application.GetOpenFilename
Setting "DisplayGridlines" Programmatically
Select Case Statement does not evaluate
Define Names / RefersToRange
Setting the Sheet on Woorkbook Open
Can't Change Font Colour
Widening Names Dropdown (Bob)
Copy & Paste visible cells only
filtering data with a macro
Re: CheckBox
Cell Watermark
Excel VBA - CopyFromRecordset (ADO) Problems with 107000 records
Manipulating Data in a row
Re: Check Box
Write a code with another code
Finding data
Forensic Spreadsheet Review
More than 24 hours
ID 860 PLEASE HELP
ID: 860 Please help!
Error 1004 Method 'Add'of Object Sheets failed
VBA Addin
Two-dimensional Named Ranges
Setting a variable using COUNTA
Selecting worksheets into groups?
option button-if else?
autofit row code
Dictionary - Add method parameters
Require draggable visual object in Excel VBA
Require draggable control within Excel
VBA code to Autofill one cell to many rows below where row count will change
merge two worksheets with different columns and data
Can I use a defined integer in an OFFSET method?
how do you generate a report every 5 mins automatically and delete
Moving section of cells clears instead!?
Printing formating/range problem
UserForm_QueryClose questions
Code Halt - prevents reset of the AutomationSecurity level
Macro to Paste Special Row Heights
modeling offset of losses against profits
selection bug treeview
Print preview?
Excel2002 - use sql statements?
Deleting rows from a combobox
How Can I make excel go faster
Email a Userform
Macro for workbooks
append two worksheets with excel macro
Execute Events Based Upon Selected Cell
value to range
How do I pass an array to a listbox?
Unprotecting VBE Project to Make Code Changes
one very, very bad line of code? Trim and chr(10)
excel: external data "data range properties" button dosent work
Total Field Count
Userform Scrollbar
Range Cut and Paste
How do I reference my current file in saveas function?
Fixed sized printout XY-diagram
populate multicolumn listbox?
VLOOKUP formula not updating automatically
automation server/add-in installation
How to: User Form to assign a user defined range to a macro variab
enable macro message not appearing
Create way to change data in list from another page
Set Print Area programatically
byte order reversal in spreadsheet
Control Panel
How to Count String occurences
sumif criteria
Userforms
Chart source data range
Opening CSV file with 69000 + rows in Excel using VBA
column
How do you create formulas using the date on the computer?
click event on listbox
Deletion of cells by next blank cell command??
Code to select 'Disable Macro' when opening an EXTERNAL FILE
Open files in different folders
Update header BeforePrint
linking two workbooks with ODBC & the Excel Driver
Import VBA Code in Excel-File ? (Export VBA Code to file)
COUNTIF Multiple Criteria
Sheet name problem
copy destination values
Useful Comment Concerning Memory Read/Write Errors
Passing Back Color to Interior Color
Comple Error Cannot Find Project or Library
Save file -prompt
VBA routine (101)
Array Function help
How to Capture if Spreadsheet is open in IE and not Excel
Linking a several workbooks and worksheets
Import a printable gantt chart from MsProject to Excel
RE: Sheets - Limited acces
Linking Excel to PowerPoint
Send SQL to Access from Excel using ADO
Clearing Interior Colours or all sheets
Linking cells to several other workbooks and worksheets
Linking cells to several other workbooks and worksheets
Like Command Question
Need help on an issue related with code management & data dimension
Use of Format function in Excel marco
Addins from Excel 95 won't work with Excel 2003
Disable warning on macros
getpath in a template
Version difference when opening text files?
QueryInterface for interface Excel._Application failed.
Macro
Excel8.h
Create a macro to launch notepad while in Excel.
Autonumber Newbie Assistance... Please
Conditional formatting and weekdays
Prioritising on dates
How do I select a range to print if I have different numbers of ro
Help with Count Please
compare data evolution
MACROS
Range and SUM of 3 cells
How can i change the text color in a cell automaticly if i write.
adding a module to several different workbooks
Append a column with the text "Remarks"
Array & variable
can i reverse the data of cells?
Trouble increasing the array number and capacity?
Macro to change Macro code?
auto fit row heigth
using worksheet name to find cell in table of contents.
Excel Macro's use on several tabs?
time till finished
Userform Question
Re: Moving in the worksheet during an evaluating function
capture WEEKNUM & place in page setup
Re: Need help matching Numbers
allow user to change workbook while in Msgbox or InputBox
worksheet referencing
Re: Macro to insert extra rows in a table
Object required?
break links
Re: Inconsistent formula problem Excel 2002?
Re: How to use Macro throughout Department
Re: Dynamic folder??
Re: change folder
screen flicker
compare values in 2 ranges
Re: Select All Sheets and clear Interior Cell colours
unable to set hidden property
Re: Is it a way to schedule an excel spreadsheet to update automat
Inconsistent formula problem Excel 2002?
Finding Cell Interior Colour of First Cell in Column
If Then statement in a userform sub
dynamic named range
Clearing Conditional Formatting
Data Validation - Dynamic
Need exit Sub modification
Function Delcarations
I think I'm missing something very simple
button display
single button on a custom toolbar
VBA equivalent of VLookup on an array
user input and concatenate
customizing chart column color formats in code
customizing chart column color formats in code
range and sum?
Subracting times and dates
permissions needed for excel programming on asp web page
How do I sort numbers based on last two digits?
Error opening file
Turn off printing status dialog with Excel automation
New record in table in Access from VBA in Excel
macro with a macro
Copy an array into an ADO recordset?
Automate Finding Values/Copy to Different Sheet
Call Names
Sum IF
Remove/disable event macros in SavedAs wkbk?
Button on Userform calling GetOpenFilename
its coach again......
Remove the last letter from a string!
Sheets - Limited acces
enable macros accross the network
UserDefined Functions
Font/CellInteriorColour
Copy, Paste then delete
vb help
Find Protected Cells
Working with Hidden worksheets
Suspend macro while others are running
Open HTML as Text
Worksheet_Change on Excel 97
Find
To Tom Ogilvy
hiding worksheets
Change Macro?
Prevent loading Add-in ...
Calling EXE After Calculation Complete
Button colour
excel functions in macros
DDE real time and time dispay conflict
Access VBA: Problem at saving an Excel file
UDF that can populate the sheet with data?
check the cell format by function or vba code
Progressive search
Limit access to certain worksheets (tabs)
Textbox format
Mimic Undo actions
How to unload Excel Addin Application?
ActiveX need help
Re: Running a macro by changing a cell value
Code to show blank instead of 0 when there is no value in linked cell?
Auto open and add spreadsheet
Copy and paste spread sheet
line chart? add a series?
Colors in cells depending on a value?
Password protection custom tool bar
Object required error
Testing a string array for any values
Getting data to Microsoft Word
Digital Certificate
open word doc from within excel with VBA
John Walkenbach Colour Palette
For Each
Auto update Invoice
Moving Cell up, down, left or right thru Macros
Just a code check please...
worksheet change event doesn't work
retrieve the last value in a column - JulieD
Issues with ThisWorkbook.Name
Easy one... If and or
find missing dates
Table to sort via VBA but row&column size variable!
auslesen aus eines dsf Datei
copying pasting
change the 8th column in a not contiguous array
Assign Value to Module Level Variable
FFT usage in Macro
SLOW Code...
Open a specific Word document from an Excel Macro
MultiColumn ListBox, linked to a range - select cells
Making an open workbook active
Macro Copying To Another Workbook??
programatically creating dialog box
Re: Counting Values in a different column
sort macro
copy, find next blank row, paste special location
SendKeys and Application.ScreenUpdating
Unprotect worksheet method in VBA
Counting rows and naming columns
Cell Reference Question
Calculations in Excel
Help - Type mismatch when running loop with strings from arrays
html
Vlookup help
Defining Categories for Custom Functions
Poking data from Excel into Access
Keeping a Variables value alive.
MICROSOFT AND PETITIONS
Re: File Error: Data May Have Been Lost
How to take over the value of a userform-controle to a cell
How do I get the name of a Cell
Move msgbox out of loop
Text box formatting
Focus
Objects in cells
macros - navigating
linking to multiple password protected workbooks
Automatic Refresh in Addin
Dynamically insert a picture.
Don't run if entire column is selected
excel macro to copy data to second sheet
Range Question
How to clock a procedure
Count A's
modifying code using addfromfile method
dynamic range defined in VBA for use in formulas
cell formula manipulation
Calculate workbook in VBA
Changing the columns from letters to numbers
Paste Event
Remove 255 character limit from OLE DB .NET and Fix Data Corruptio
Alphabetizing array items
Word "Image" into Excel
DDE help
CheckSpelling a Textbox
userform
Run macro in another file
OpenText failed in Internet Explorer
March 2005 Actual Info vs March 2006 Plan Info
Capturing the column number and # of columns in a selection
VBA code to define nbr of text character a a cell/column
Date grouping in Pivot Table
identify green triangle in cell programatically?
Deleting Unwanted Files
Help Printing
Add a Chart as the last sheet
Help on error...
Loop help
Pivot Table Dynamically Creating on Query
Generic sheet selection in a macro
Frustrated with VBA so-called help
declaring public variables
Can I do this?
Looping worksheets in workbook
Array Problem
How to Find(...) in different worksheets with VBA?
Want to launch Excel from C# app
Display Msg box on open "before" MS Macro Security warning display
PageSetup.PaperSize
loop non adjacent cells
Find Method
protected spell check for Excel 97
Number of different items in an entire column without knowing if some of the cells are blank
Before Close workbook?
Export DataSet to Excel
Msg Box Timer
Spanish/English Formulas
ado vba help
Tough one, for me anyway....
Loading / Unloading Add-ins mystery
MATCH, INDEX and VLOOKUP with Arrays
Formula for neg and pos values
Blocking VBA Project
ColorIndex property XL2000 vs 2003
Sharing with Newsgroup
Alphanumeric formula
Run Macro When Select Cell
calculating transactions per second and per hour
Transaction on Budget Planner
Date manipulation within text entries
Popup input-form on focus
Formatting Postcodes in VBA (Bob Philips, Myrna Larson + Jamie Collins?)
So many greater than and less than values to calculate
Can't write to Tag property on Tabstrip
Referring to file no's from within an add-in gives problems
help creating labour program
can I pull only data from a sheet greater then 0
Problem saving with VBA project protected.
Can I include noncontiguous worksheet in array of worksheets?
opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY
Can I use array to simplify this code.
Can I reset Client cache size in excel 2003?
Need Excel to read a text field(part#) and assign a number(commiss
How to change this into array ?
How to change this into array ?
convert a number to text
Excel 2003: Can the same range be used for a querytable and a list
Compare 3 columns
NEED FORMULA HELP
Set a 30 day limit for Excel worksheet formulas?
Is Excel the right choice for project
turn off green triangles in Excel 2002?
Delete Rows in VB
Need help with my looping macro
concatenating line decided not to work
Max Length
XMLHTTP.OPEN + PASSWORD + USERNAME
Comparitor
Exporting data
Excel schedule chart - 'reverse' conditional formatting
Incrementing Variable shortcut
Excel 2003 Programming - Outlook.Application and Char(10)
Store the Spreadsheets filename in a variable?
Search An Array in VBA
How can we classify referring to grades?
VB Code
trying to create a blow-up sheet by writing a VBA macro
Ho do I determine the Active Cell location of the data being sele.
Populating a ComboBox
Format textbox on exit
GetSaveAsFileName questions
Private Sub CommandButton1_Click()
MEDICAL/HOSPITAL
Unique entries in textbox
CAN ANYONE SOVLE THIS PROBLEM!!!
Handle password for open workbook?
Inhibiting Moving Cells without loosing Autofill
ADO connection problem when using server
Offset problem
Determing first row in VBA when subtotaling
embedding links in cells
Activate an activex control on a sheet in excel 97?
Hlep with code referencing an addin file.
Displaying the filename in a cell
Re: XL5 Macro function - getting worksheet status
How to zip a file before sending it out by macro?
Interrupting an endless loop
Won't insert value
Selecting answers from a list and displaying them
How to write a macro in Excel which can .....?
Unable to Insert new Worksheet
Saving XL ranges as Fixed Field Length Text - Leading spaces
How do I get to cell to insert a tab (worksheet) name on the same.
Double Click for all Sheets
VB code to generate an e-mail with an EXCEL attachment, but not se
Event Management
Asking for the connectivity of excel
VBA: Find and adress cell
Non -Modal form disappears
Covert Column Numbers to Column Letters in Excel VB
Can I import raw HTML source code into Excel?
Automatically EMailing a Spreadhsheet Upon Opening
Workbook not recognising named ranges
Event triggered by cell data change/entry
Monthly average calculations
excel net worth file
excel net worth file
Web query results in a recordset?
Before close and workbook open!
Delete with command button?
How do I show Row and Column where I want them
Formatting data
Conditional Formatting work automatically
How to get Excell to jump to Date?
Planning future programming environment: office.net problems?
How to set ActiveCell to a new column?
change macro
Multiple Control Event Classes
Explanation of SUMPRODUCT
Get / Extract Data from an Excel Field
Hiding a range of cells
VBA help sought
loading txt files with more than 256 columns
Derivation of min and max values
Excel Macros do not work with Outlook Web Access
activate/deactivate button with macro at given condition
Insert Rows (3) VBA help soght
Two beginner's question (:)
Valeria, Did you find your answer?
Instantiate a Class via Automation
sorting an array
I have an issue during retrieving data from DB
Identifiying a Worksheets VBComponent
String manipulation
Chnaging Case
Userform Textboxes and Looping
Worksheet Change "code"
Forcing Excel to update, or recalculate.
Capital Letters
performing least squares
Next not incrementing
If resulting in False when it is actually true
Finding Duplicate values within a single column
Saving 2 windows
How can I hide-Unhide pivotfield using VBA?
If not found get a message
Form questions
Dsiabling All Keys
Sorting in VBA
How can I convert Text into Date? (See inside)
automatically insert each image to its own sheet
reset Workbook_SheetChange event?
How to zero out cells with formulas in them but no precedents?
on error goto
ADO cloned recordset doesn't return field names
Clear Cell
F5 to solve freezing
Catch _AfterSave Event & Saved Property Problem ...
Data from excel to MS Access
using the if statement with data validation
Extracting 'exact' local references from formula
Help with Code..or Solution
What happened to "favorites"?
VBE bookmark
SpinButton control spins forever when calling COM function from Excel
Event procedures for controls added with CreateEventProc
SpinButton control loops infinitly when calling a ATL COM server
Select a Range and Format
LOOP BETWEEN "FRONT" AND "END" SHEETS?
How to restrict scroll area
How to distribute a workbook as a stand-alone application?
Hyperlinks Inserted in Design Mode inactive once Exited Design Mod
Cant Select temp Sheet
macro associated with shape object, useful approach if can be solv
Kill Excel Process
How do I just update values on several cells (not the entire works
Issue with line wrap in source txt file when importing- please help
how do i release an access database after importing into excell w.
How do I write a macro in XL that will delete 1st row and save th.
how to dragDrop objects from other applications in 1 cell in excel
how to dragDrop objects from other applications in 1 cell in excel
Change font if item above is not hidden
Opening and Saving Groups of Files
Positioning of figures
Setting Sheet Display Zoom Magnification in VBA
Paste data with a macro?
Cancelling a macro
MS Query
Using Find Function with Macros
Passing Cell Address (String or Range)
User Defined Functions - Help Text - Make it Easy for the User
ConvertFormula Problem
VBA IF statements
Userform height not consistent?
Reading a text file line by line
Re: Formating Text in a combobox
How do I determine when a cell's formatting changes?
Skipping sections of code
Circular Cell Find
Still need help with Access DB Query!!
Workbook_Open Problem ... Worksheets not loaded yet!?
IDTExtensibility2.OnConnection Event
Parameters for Office COM Add-Ins
Sum cells until a value X is reaced and then start again
PB import with MSQUERY from Access ton Excel
Number zero and the Letter O formatting
See digital signature timestamp for workbook with trusted cert
formatting a worksheet
Named ranges
print two sheets
Compiling error! VBA Help needed
workbook dont run macro under a lower version
Copy/Paste using hyperlinks
macro that promt user for input
ASP.NET Vb calling webservice
Scroll thru multiple spreadsheets
Insert a blank row (2)
WHy does it only work on Menu SHeet
Copy Worksheet plus ranges
Execute problems
Can't see error
I want to create a "Insert Row" button to insert a new row at the.
Why is Excel appending numbers to querytables.
VBA Editor Disappearing
Create a menu of sheets in a shared workbook
Programmatically finding out if Excel macros are enabled.
Hi
Deleting Blank Rows
Matching values & returning on the same row
Loop through PivotItems of PageField - including "(All)"
Date Formatting
Change even rows to a predefined colour
Modify to delete row
What's the easiest way to set up a client pipline w COE dates and.
Default SaveAs type...
applying standard formatting to a worksheet
Limit find range
Memory problem or Excel limitation
disable close if conditions are not met
Enable Macros
Formatting a Blank Row
Pasting to Excel sheet (getting desperate!)
formating
Insert A blank Row
Help with Access Database Query!!
Showing activecell in view
Setting up 30, 60, and 90 days delinquency
Counting numbers in a table
copying and pasting Cell reference names
Macro getting stuck
Case Select
Workbook Collection
Column of a defined name (office 2000 vs XP)?
Can't get out of my loop
Add a New Worksheet
Automate Run Rate Formula
How to populate a combobox with the name of all the sheets in work
range names
Trace Dependents
Fast Find possibly replacing .xls files
Passing a named range into a user defined function
Add a Button with code
Strange Character
Colum heads in multcolumn listbox
VBE Windows
Find a part of a string
ON Error goto fails on 2nd error
add footer page name in word using excel
calculate Min and Max Values of selection
How to read part of a text string only?
Formatting Comments
change lots of formulae all at once - how?
VB code changed Excel settings for all worksheets
Can't get ActiveWorkbook.Container to work
Convert cell data into a worksheet name via a formula
Counting Formulas in Spreadsheet
Message box before save
Is it possible to make a cell flash in a normal excel document?
Need a bit of help on comparing cells
sharing an add-in function for multiple users
OLEObject question
Insert a blank Column Every 9 Columns
Determine procedure name at cursor?
Convert XLS to TIF
Looking Up Numbers in a Table Using VBA
Programmatically Controlling Excel Viewer
Japanese Excel 2002 crashes because of CoTaskMemFree, why?
Change Cell Color dependent on Cell Contents
Rename Module
Excel document building
Get / extract a button name
Strange error if another Excel book is opened
Error Trap
Thorough deletion of cell contents
Error handling with a handling routine
Move to end of textfile
Opening Files from a folder in sorted order.
Workbooks.Add and SaveAs don't occur
Looping through controls on form
"Querytables.add" in a loop; result is insert in a new row each t
CALCULATING WORKSHEETS (INCLUDING AGE CALCULATING SHEETS) FOR DOWNLOADING, GREAT FOR PENSIONS/LIFE INSURANCE CALCULATIONS!
Excel trucates contents of cell
Conditional Formatting Bug w/ relative formula?
Open Files via InputBox
How to force a paste of values only?
Applying a macro to all Excel-files in a folder
Zero Length Dynamic Range
rollover
Counting Strings in an Array
Copy & Paste
posting archives
Another problem with export to TXT
Unloading Cell Value in Textbox...?
Sheet turns into a "ThisWorkbook" module
Userform.Hide not working
Default Value formatting... UK Postcodes
Userform Shown while macro runs
call a function from VBA
Setting page breaks (another)
VBE, change default path for file import
Copy range from closed file
How to fill range with formula using VBA?
End(xlUp)
Barcode fonts
ADO programming and Excel
PointsToScreenPixels for Excel97
RE: Excel's main windows does not redraw
Excel file will NOT save
Trigger a Macro in MS Access from an Excel Macro?
find text in a sheet
ActiveWorkbook.SendMail
Difference of Control toolbox / Forms ?
Pivot Table Select Range of Value
Standard Modules in VBA
Insert Blank Column every 9 Columns
Border Mystery?
How to format a cell with VBA to return a value from a database?
Macro that prints after recalc is finished
Named Ranges
Disable Addin Menu when file not open
Macro to step to next open workbook
load several ASCII files in different worksheets
Testing for a cell being dependat on others?
select all cells in sheet
Pasting formula as text
Excel to Access using ASP
Macro
Isblank Function not working in VBA
Populating a listbox will a certain cell on multiple worksheets in the activeworkbook
Float a window over sheet
multiple worksheets in a workbook, each saved on its own.
How can I programatically change the language in the language bar?
Deactivate a cell
error handling not working
Bit manipulation
Check last digit in cell
Insert Spaces
Protect a column by disabling mouse pointer
How do I set up a cell in Excel to choose a date from a pop-up ca.
late binding examples of excel
Late Binding examples of binding excel application
Altering code to reference the worksheet before the active worksheet
Hyperlink i listebox?
No Visible Workbook
Workbook container - can't get it to work
need help for several issues
Command buttons moving in Excel
Help w/ macro to zero hard keyed numbers
static var/function question
Number of rows used
File Search
Insert Function wizard for User Defined Functions
Automating the XML Data Mapping in Excel 2003 using C#
Auto duplicating a sheet
RE: Auto duplicating a sheet
is there a way I can modify the save as dialong box?
re: Object libraries and different ones with different versions
Go to cell 65000
RE: Auto duplicating a sheet
Delete Every Column After
Boolean to advance loop
Can anyone help with a sorting solution?
script converting list data to summary table
range variable across sheets
Average Question
TXT format
How can I get the value of a cell in a un-opened workbook ?
Further Form Questions
multiple queries in Excel
Urgent,! Need help with this Macro
Re: More than 65,000 lines and ACCESS
Excel Icon
Code to create a right click short cut menu
Cell reference from previous index function
Common Dialog Box
Same Name Range for different spreadhseets in a workbook
Change Whole Column Cell Color
Copy data from textfile, paste and transpose to sheet2
Entering military time into a userform
type mismatch here!
Add space.
Passing array from 2nd sub back to first sub
copy sheet with buttons
Pivot Chart Value Axis Scaling Question
number of non-empty rows on a worksheet
Userform options and macro
pdf hyperlinks
Enabled Property of Shapes?
How do I send single worksheets in a workbook to different recipi.
How can I "Select a range"
Find a cell with a special value and activate it
Copy sheets.
Error Generated from Array formula
Loading Number Formats into Combo Box
Urgent - Macro Programming Help Need
i want excel to read the amount (no. format-20,000.00) and print .
Declaring Objects
Automate compacting database
How to run the SQL statement in Excel VBA
How open excel file with microsoft spreadsheet control in ASP.Net
How do I make my other Microsoft Applications like Outlook access.
how to disable automatic query refresh in excel?
Scan range of rows and export to 2nd worksheet
How do I reference "DataObject"?
how to position a listbox???
How to publish VBA and UserForms on the web?
How To Link To An ACCESS Table
Where do you put the 'Else'?
complex functions with scenarios and relative addresses
Search for #'s in range
Classes Excel and Access - off topic
ADD SPACES
Finding NExt Blank Cell in Range
deactivate fullscreen
Info button
Excel 2000 vs 2003
Total a Variable
Option Buttons separate from each other
sorry...I'm a terrible idiot and still can't do anything...:-(((
one for the guru's
help with mail
Macro to delete Macro
Combo Box loaded with Excel Number Formats
Disable Label in a Form
Protecting a cell based on another cell
data linked to files in shared computer
Identify selected chart
Help ID's
Strange offset fault
why doesn't macro work?
Userform - Printing
Re: How do I open an application and run a file using visual basic
Complex programming task
Deleting an element in the middle of an array
Need to convert temperature from Farenheit to Celsius
have macros complete and enter passwords for sheet protection.
Printing Userforms
Heartbeat code
sumproduct problem
dave or someone, quick question
ActiveCell.Top question
go to cell
Help with changing code
lower and upper case equal on spreadsheet but not equal in VB
how can I import Fortran output to Excel?
macro to remove spaces at the end of a cell
calculating roots greater than 2
Event procedures for controls added with CreateEventProc
how do we achive the default view settings?
Problems with Google
inserting sheets in excel
Detect corrupt database
disappearing controls
formatting text
function explanation
Using Excel Macros & Outlook Web Access
Can't change name of querytable.
count 1 cell in column based on value in another cell
Filter
IF
Simple Programming Function??
Excel Range Variables
Further simple Form questions
vlookup to return cell position as to where result was found
vlookup to return the cell positioning where the criteria is found
Macro attaching itself to spreadsheet
Simple form question
Ranges and Arrays
Printing
Dock a custom toolbar
Copy, calc and repeat
Dock a custom toolbar
How to column length into a formula
SUMIF in VBA on VBA variables?
Help with Conditional Formatting Please
Display multicolumn box
vb combo box
Determining if values in a column range are of same value.
use macro on a protected sheet
datediff in excel 2003.. Agecalculation
Max Question
How to get the Create DDL statement from SQL server through excel.
How to get the Create DDL statement from SQL server through excel.
Arrow key operation among multiple TextBoxes in a UserForm
need help. page breaks
Hot to get the create DDL statement from SQL Server through excel.
How to get the DDL statement from SQL server through Excel VB.
im so close, someone please help
How do I?
User Form Text Box
vlookup and sum of multiple lines
comparing text with macro
sumproduct in code
FileDialog - Not available in 2k?
Select Range - Fill Down
please explain this syntax
How to set up an phone dialer with Excel?
debug error: object variable not set
Calculating days between dates and leap years
Calculating days between dates and leap years
Locking Inserting of Rows at certain rows?
macro to extract info and paste to a new sheet
VBA- Contains any element
could someone help me witht his macro please.
Customizing popup menus
How do I enter research data in an excel worksheet?
programmatically create a macro
What is the purpose of a Macro Sheet ?
Setting a range that varies
Retrieving Current Excel Instance from Automation Add-IN
setting a range using a named list in vba
Problems building Excel Addin from Command Line LoadBehavior changes
How to add reference for Personal.xls?
Tab/Enter
finding a value in a list
Chart vanishes!
How can I sum only amounts that are formated as B O L D?
Adding a scrollbar in a single cell on worksheet
EXCEL command or syntax
format date7time in vb.net
Using AND function, how do I sum the remaining data?
list box item highlight
avoid to show the cursor movement during the Macro
Mersenne Twister
Macro to create format painter
How can you startup an Excel Spreadsheet with a formatted templat.
copy cells with a macro...
Updating formatting without taking each cell to edit mode
color coding cells
Format Date in Chart Title
setting range from activecell in macro
Must Click Full Screen to See Worksheet
display multicolumn box
Merge data from 2 Excel worksheets
Range object global failure
Add QueryTable in code
Changing Dim?
How to get out of BeforeClose event without closing?
Freezes chart position with scrolling
Userform interaction with the VBA code
Exit-quit sub
combo box comparison loop
Filesearch no longer functions
Parsing cell formula to return associated value
help creating dynamic forms
Pivot Table for Consolidated Reporting
text in shape group
Links not updating unless the source is open...
Creating a pick list
Code for current sheet selected...
run-time error 1004 & comment extraction
Newbie question.. what does [somedata] represent? Constants??
generate sub dynamically
VBA Code to sum shaded cells
Date Management
Cell borders print default rather than custom setting.
looping alarm message, running in the background
check how many in a range from another range...
Reformat a worksheet using a macro
Help with compiler error
Web Query
Which is the best installation target folder for Add-ins ?
Excel does not redraw iteself
Protecting my VBA based query programming
Is runnig.
Hyperlinks in VBA
resize row and colomn height
String to code
Excel Formula Conversion, I need help please
Union/Range/Cells
opening html table in Excel makes preceding 0's disappear??!!
Change copy function for Ctrl-C, Ctr-X, right click...
Forcing A Line To Execute Prior To Continuing
Choose a printer
Examples of VBA code to scan all rows and perform a function conditionally?
Insert page break btw Sat and Mon dates
Can DB connection retain throughout the Excel working session ?
menus & Commandbars disable when double click on cell/formula bar
Get data from a word document
named range / offset
One thing I miss: double right click
comparing data
Duplicating Rows
How Can I Update the database file from "Excel" and Built the ent.
Project Locking Woes
Excel 2000 VBA App Now Works in Excel 2003, but not Excel 2002
PivotTable Problem
I need a macro to copy
EnableEvent On Change
Excel vba pivot table programming
Excel SmartDocument with ActiveX problem
Perplexed...
Converting words to numbers
Creating Buttons
Problems with ReplaceLine
calculating dates
Looking for documentation/reference to write Excel Macro
creating range
another data validation / ifisblank question
Emailing A single worksheet wit a email address
activecell.address problem
Working with Text
ASP: Open Excel File with Macro, Allow Macro to run, and then save
ActiveX HELP!!
data validation across sheets
Dictionary Object in Windows XP
Compress picture with macro in Excel
Excel Automation Add-In, Accessing the application object
Pause a macro?
change of cell upon cell change
Another Array Question (Sotra)
Sheet Name???
Adjust position of a commandbar
check boxes and VBA code
Supress SaveAs dialog box?
BeforeFileOpen Event
Page Break based on Dates
How to update Macros from Master Macro?
Grouping
naming fields
Solution for conditional formatting issue
Creating a macro that pulls rows by the color
Position of a UserForm
Union method for Range Object
Display sheet from loaded Addin
linking workbook data
Enforce Paste Special - values only
Excel vx Application
Opeations on xlSheetVeryHidden worksheet
Retaining Selected area
Combine deletion Criteria
Array Question
Delete all entries in selection except activecell
duplicate spreadsheets with different names
VBA control of zoomed chart sheet
I am trying to change hh:mm:ss into a percent of one hour, using .
AutoSave function
Display cursor position in cell
InputBox including list of items
Transposing columns and rows
run macros in background
LotusNotes DB extraction onto sheets
Good Book On XML and Excel 2003?
Excel ADO-Bad Field in Access
retaining cell address
Retaining cell address
How can I allow only cell contents to be copied but not formatting
Fill column with dates of month depending on month in A1
macro sets Application.Calculation = xlManual , disables Tools Opt
duplicate spreadsheets with different names
References.
menu select worksheet
Version problem?
Delete rows where cells contain various criteria
Forcing A Line To Execute Prior To Continuing
Excel Solver with Macro doesn't work
How to copy Validation?
Forcing a postcode in Excel 2003
macro to browse for workbook, pick up data and looping
Printing to PDF Goes to Wrong Drive/Folder
How to insert formula to a range of cells from VBA?
Selecting & formating worksheets
How can I extract the Text from a GIF Image? Please help!
listbox problem