Excel Programming [Archive] - Page 148

Templaste SaveAs retains existing name
Re: Replace Space charcter in a string variable
Re: Replace Space charcter in a string variable
quick code question
Adding row Macro
Check box count!
Loop through Worksheet Names
Re: Autofill across columns
Saving worksheets without Auto_Open
Re: Userform Question Posted Again
stuck please help
Re: make my vba/excel program faster
Navigating with keyboard after using offset on merged cells
Please Help
Re: make my vba/excel program faster
Add not compiling
Directory List of Excel Files
Max Function
Call Access 2000 macro in Excel
Comparing Multiple Independent Workbooks
My appreciattion to Olly, X~!
Merge Cells in a column Macro
make my VBA program faster
One more question - Multi Select List
Updated problem
Dymanically add to validation list
Named Range
Problem opening xls files from Explorer when IgnoreRemoteReqests set to True
Compile Error: Procedure too large
Find and Update with User Form
Copy and Paste Overlap
Empty Cell
Open & process multiple worksheets then move them to different folder.
How to find ??? help, pls:)
Cell Data
split window stop scroll in bottom ?
Posting 3rd time as proper response not recd. for earlier postings (Help needed)
FUNCTION TO CALL NAME OF SELF (BUTTON)
Data Input - User Form Drop-Down Box
msg boxes
Excel Macro Basic Help
RE: RPC server unavailable
Programming to make graph work.
Need a Little Help
List of Excel files
Passing Arguments
excel macro
Addressing a group of Named Ranges
Need help - how to shade an offset cell....(simple?)
not use
Simple one? How to shade an offset cell...
MultiPage UserForm Printing Problem
Trim in VBA
VBA - link to website
multiple values in one cell
searching a date range.
Password Protection - Select Unlocked Cells Only
Comparing data on two sheets
Loop until a condition is False
Displaying File in Use By Info with vba
Finding and Extracting new Data
File in Use
Selecting Text and deleting Page
Help for excel webform
Enabled problem on commandbutton
VBA application crashing when linked to frontpage.
Looping through ComboBoxes in a worksheet
Copying and Pasting froma Userform
Copying and Pasting froma Userform
Alter one cell value, in case another cell's value changed
How To: Use Cell("Format") to return MMMM YYYY instead of D3
Sum of duplicate values in a column
Protect - Unprotect from ActiveX Control
Equation object in the form
Debug non opérationnel ?
Lotus Notes - Can't do multiple "Send Tos"
Random Number Generator
How to link a check box from form to a cell?
Inserting the system time
Excel Pivot Table Template thinks it's linked to external data
additional target
Hyperlink
GoTo Loop?
Help with shortcut key code
Split a worksheet?
Reset worksheet
Linking dynamic Cells in Excel to Form
Help with "Run-time error â€˜438â€™:"
Export sheets as JPEG files through a dialog box (Problems)
opening workbooks faster
Chart disappearing when source data hidden?
Priority & Ranking Assignments
Area chart with X-Y chart characteristics?
Keep X-axis numbers horizontal?
Clearing a chart title with less lines of code
Changing plot area under macro
Close Workbook from Macro
File Properties in Macros
Excel Macro Automatic
Help with a Script File
ListBox has 2 rows highlighted
Adding "TOTAL" and summing column
"Object Required" Error in Excel 2000 but Not in Excel 97 (!?)
XL VBA in VB6: "Unable to get SpecialCells"?
Regarding Menu buttons
freeze/lock form position
Userform format question
Modify Text Import Wizard
RE: Determining Column to Use
changing time format
How to link check box to a cell?
Re: Determining Column to Use
Excel VBA - Get data from 2nd workbook
Query results make entire sheet's cells move
excel autofill macro
Please help find the next empty cell
tuntime-error 1004 when trying to rescale a chart
macro find and delete duplicates in a spread sheet.
Counting Checkboxes
Newbie help
V-Lookup question?
toolbars
Keyboard keys to plug in today's date?
Re: Count Checkboxes.
HTML data retrieval
Counting multiple cell values! Please help!
Find Data in a String
Embeddding a macro in Logical IF stmt
Currency in Userform
Excel VBA .... Worksheet_Change(ByVal Target As Range) question
insert amount into first emtpy cell
Macros in a template run from Custom Toolbar attaching to wrong file.
increment date code
Re: how can I find last populated cell in a row (or column)
Excel VBA - VLookup problem referencing another sheet in the same workbook
Error Trapping Still Not Working
Error Trapping Still Not Working
Populating a cell from a picklist selection
Macro Creation
NEED EXCEL MACRO TEXT-PARSING GURU!
concatenate values / convert to csv help
Slow File Search
Embed a function
InsertRowsAndFillFormulas
Delete Worksheet on DeActivate
NEED EXCEL MACRO TEXT-PARSING GURU!
Counting # of Colors in a Column?
Hide Rows If Cell Value = False
Testing for Interior.ColorIndex
MkDir error
Make Command Button visible only in .xlt?
Need help with macro to save selection to csv file!
Error when Open WorkBook
Excel and Video?
VBA & Conditional Formatting help
Can you manipulate text documents using VBA in excel
Converting a number to a date/time
Excel Workbook Invisible
Using Variable Worksheets
how can I find last populated cell in a row (or column)
how can I find last populated cell in a row (or column)
how can I find last populated cell in a row (or column)
how can I find last populated cell in a row (or column)
Re: how can I find last populated cell in a row (or column)
Printing Multiple Invoices
COPY AND PASTE MACRO
Minimize Excel When Running a Macro
On Error Help
Declaring Variables
List Charts in a Worksheet
macro use with hlookup
Cell referencing! help
Save .csv file. English (American) Settings
Array
GetOpenFilename
Problem with dates - export to .csv files
program formular in Excel
Macro & XLA passwords
Edit Get External Data Queries
How to move files from the code
Help
Excel Toolbar
Text Box Control Source
Get the string of the statusbar
prevent user to rename sheet
Control Source on UserForm
Hidden data in cells ... where to put it
help me figure out this buG?
DIV/0 ERROR - How eliminate them in many cells contemporaneously
Changing attributes of PowerPoint chart in vba
open for append
vba code disappearing
Excel doc on a website
Automate Add-In
Use C++ to populate worksheet from a Database
green triangle in date cell
VALUES CORRESPONDING FROM SHEET1 / SHEET2
Naming buttons in Userform on the fly
Re: Error on ActiveWorkbook.SaveAs method
Printing output #### problem!
Counting the number of elements within an array that have data
Return to range
Error on ActiveWorkbook.SaveAs method
how do i paste a range?
Cross updating Excel file and SQL 2000 database
Worksheet on form?
How to open new window in excel webform
Charts in GUIs
Additional column
Saving data in userforms on action
If Workbook not Open Then Open It
User forms
simple code
Auto Date/Time when click on cell
project wide compconditional compile constants
Excel goes real slow
using Switch() to call functions
Text file open and close VBA
renaming worksheet from within macro
Help re: Ofc Excel2003 macro locations
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem?
Active X and Data Grid
Accessing All Sheets in a closed workbook
Hide Macros from Users using workbook!
multiple values in one column?
hyperlinks-changing the filename only!
Selecting a cell from an index
VBA code to perform summation and product summation
application minimized in the traybar (next to the clock).?
Message box display or something in the status area after macro button is pressed?
Simple question envolving VBA
Percentage problems
Month
Deleting data and element in a 1D array
Transfer macro
User Defined type not defined
Select and Copy Range using Offset
AutoFilter VBA help.
If formula
Message for Frank K
opening on same sheet
Re: how can I fit this in 1 row?
how can I fit this in 1 row?
Targeting different worksheets dependant on the date
Complex Fill
How to call COM Add-In functions from a macro
how to unprotect password from VBA macros in excel
Userform question
Increment number by 1
Excel platform
Newbie IF
What is the RGB value of the colour of Excel's scroll bars
Formula to calculate
Button, but no code
Stopwatch/Clock
Button, but now code
automatically update WordArt when calandar year is changed
Entering data into more than one worksheet
Macro to hide Columns
Print Preview Help
Auto Calculation
#NAME when I insert a sheet from a template
PrintToFile param - what's the file format?
Unprotecting the VBProject
Choosing Excel Add-ins when starting excel?
macro with variable rows
Start me in the right direction, please
Auto execute a macro if a cell value=1 ?
Brackets [] possibilities ?
DISC FULL
problem w/ vb -control
formule
Users leaving blanks
Error setting GUID reference
Deleting a row containing a found cell
Formula keeps changing
Format of a number
row numbers
Empty Errors
CommandBarControl, Exists???
Difference between sheets and worksheets?
custom cursor?
Making desired row the first displayed
Urgent ! how to unprotect VB macro password?
Data Validation - Allow List - In-cell Dropdown not showing up
DATA VALIDATION
Duplicating O/P of Input form conditionally
Check Boxes
VBA coding for all capital letters
Need help on Update Button on Userform
Embedded button
is it possible to change this macro to save each sheet seperately?
Disable program
Excel - VBA instructions needed Urgently!
Setting GUID reference error
Kill command not working
Changing Regional Settings from VBA
optimize cycle's speed -> For, Next or DO, UNTIL; IF-THEN, ENDIF or CASE, ENDCASE
VBA doesn't work
Using activex dll from worksheet
Locking a cell with a formula BUT.....
VLOOKUP
Doing a 'countif' but I just want the value not the formula
Pasting Excel To Word and resizing
MS Excel 2000 Formula
Disabling Alt+F11
Copy & Paste Hyperlink address into cell
Open Document Button
Counting in Pivot table
Execution of an externally created VBA code
Print Preview
Unique Items in Drp-down List
Virus - importing excel via adodb connection
use of activecell
Module Names within a Project
Using variable addresses in vba
Declaring Variable as VBConstant
minutes between two times
color formatting based on 12 conditions
When do you need .Value?
macro for running other macro
Refrsh all pivot tables in a workbook automatically
New menu bar item
Simple change event. Need guidance.
Checking the value of the end of a string
Need code for simple change event
Calling .Net Windows services
Macros
Change Event that Loops
Cell Matching Problem ...
Re: How do I get data from an internet page through a macro?
Only step through cells that are "Active"
Re: How do I get data from an internet page through a macro?
Remote List
Pivottable
Populating a Validation List with SQL
Itratie formule
importing data and excel
FOLLOW-UP to PREVENT USERS (PROTECTION)
Calendar
Stop Saving
Finding a button
Sorting Page fields in PivotTable
SlideBar?
Automate PDF file creation in Excel code
Format date and number
Chart Values that change based on Change event
disabling cells
Addressing cells in a NamedRange
diabling the worksheet menu bar?
Set Enable = False without selecting?
Re: Excel Named Range Question
Help Needed: ComboBox to select row and Cut xl 97
Extremely Slow VBA Execution Speed
Re: prevent users from deleting columns
Change Option Button Property Value with VBA
Re: Excel Named Range Question
Do...Loop Macro
remote module
Using a defined formula in multiple sheet
Hyperlinking to a graphic
calling a batch file
how to use some activeX-components in excel?
Autofit and ActiveX controls
Protect/Unprotect Sheet from Macro
Re: Copy Formatting of Cell
Chart Help
Office 2003
If vbYes Then help...
counting items in a range
Run time error 40036
Conditional Formatting using Custom VBA functions
disappearing worksheets
Noob question - Worksheet_Change
Re: MATCH gone Awry....
Sheet Recalculation when using VB functions??
Delete blank style
Can't Find VBA to exit application
Powerpoint charting from excel
wrapping
How to end macro on inital active worksheet containing macro button that was clicked
VBA line to set to Duplex Printing
macro, pivot table and changing number of rows
Date manipulation question
putting data in order(?)
Having Events Run at specified time.
moving cursor, may solve big problem
Slow FileSearch Routine
Excel VBA & ADO - retreiving data from Approach dBase IV .dbf files
Writing merge codes
Disable right click
Cut and Paste gets overwritten, WHY? :)
How to draw a object and erase it programmatically
Valid File Path Format
Disabling the Tools Menu
Saving Takes long time
Limits on Userform textbox
How to find and list duplicate values in a list?
How to find and list duplicate values in a list?
How to use Input cell and or view as a display cell
Hoe kan ik een cell refferen naar een afbeelding(object)
Minimum value in a column
Enable Macros and Linking sheets
Add-In Error
Best way of "mirror" several cell areas on one sheet to others?
Table Formatting by a Macro
Header and footers
removing hard breaks from comments or active cells
How to create an automatic counter
Opening a new PowerPoint chart with excel vba
Filing system
Sometimes Intellisense, sometimes not
Accessing a Hidden and Protected Workbook from a Macro??
Take a screenshot
Re: Auto Formatting Excel Macro
Auto Formatting Excel Macro
Programatically changing picture in UserForm - VBA - Mac OSX
Bill is watching your posts
Can't find mainxl.hlp
Why does a loop start ?
copy font...not formatting
challenge coverting to values
Recording Macro's Across Applications
Autocomplet with no previous values
file extension
simple excel formula
Stepping through VBA code in Excel
simple formlua in excel
Stepping through VBA code in Excel
Can I change ExCels default save path for saving add-ins ?
How set file open path to filepath of file opened with Explorer ?
MsgBox vbmodless - is it possible?
Ammendment to post
Matching database records (addresses) with phone numbers
Dialog Box
cursor keys in a macro
Popup Menu Separator/Dividers
formula for 3 columns
text inclusion
Len()
Changing Pivot Range Programatically
Calendar in UserForm
Chart with Drop Down Box for Pulling mutpile Ranges
Fill an Array with String values
Help with Promting for wooksheet name in macro.
DTPicker1 on a form
HLOOKUP or VLOOKUP help
Open file saved as today's date
Creating/Saving an .xla file
Beginner asking for advice
Window ("****.xls").Activate
Re: Print Links
Loops
Open Access db from Excel
Calculation mode
saveas addin from VBA
Tab control from control to cell
Re: Paste into one cell
Re: Paste into one cell
VBA Code Security
code to ask for password to get access to sheet
cascading combo boxes
Help cell formatting.
Clear/Delete an Array
Excel Bug: Run-time error '-2147417848 (80010108)'
shared workbook see changes quicker
IsError Formula
Last cell determined different in XP/2003 as in 2000
XML and SQL in Excel
Macros
Help needed wtih Vlookup
Code looping when it should not
RE: Err.Number 429
A question of TARGET.VALUE
Control Buttons to VBA
Student need Help with Table of data
Copy multiple entries and paste without duplicates
Date-to-number in Excel
Possible to read data entered in a worksheet's Form object, using a VBA command?
Disabling Keys
Macro to look for blank rows in sheet, delete the row and autofit
Assign Value to OptionBotton then transfer to spreadsheet
HELP! Lost data - need to insert formula but get error!
Problem with my Unique Number Macro...Help?
focus?
.content.move (wdscreen, 2).... error??
Linking
Re: Third Time Posting this Question: Hyperlink Problem
VBA excel paste to word deleting itself
Re: Nested levels of functions
Shared workbook and VBA problem
Re: Window Resize
Excel - VBA guru needed URGENTLY!
Re: Window Resize
Please Help!checkbox relative reference
Re: Nested levels of functions
executing a macro from within a cell
Re: Nested levels of functions
Standards for a code library
using VBA, after pasting cells to word, I keep deleting them if I try anything else
Sharing function in a module
(resending) Merging text in more than 1 cell
Re: Group and Delete
True Or False, no matter what... it still displays the false statement
Question on formulas
Saving a spreadsheet with a protected VBA project
Re: Group and Delete
command to import a file into excel
Need to Select multiple cells based on counter
Select Data in Worksheet 1
How to programmatically make a cell the Active Cell?
Validation.Modify Runtime Error in Protected Worksheet
password protection
Assigning a macro to a worksheet (vs personal.xls)
DDE an Alt-Enter (Newline) character
How to get ID of the Cell on the Left-Top corner of a worksheet
Double clicking on a powerpoint chart from excel vba
ListIndex
Open Excel file as Read Only with code,
Filling an array with integer variable
conditional printing? macro?
Control Radio Buttons to VBA
Changing numbers to characters by using range values
GetOpenFilename
Open Excel from VB using Read-Only switch?
On Error Resume Next
Run-time error
Macro in .xla
Windows Scripting Host/Windows XP
Open File showing only Excel files
macros in multiple worksheets
change event question
Problem with the PrToFileName parameter when using the Printout method on a worksheet
Re: Multiplying matrices in VBA
Compound Document Properties
Current Row?
Tic Tac Toe in Excel
Using excel vba to produce a powerpoint slide
CELL("Format") function and Locale
Summing Proglem
important question !! (stability application)
No replies, so again : How to add Combobox to cell dynamically?
Convert data across in 2 or more cells into single cell
Font in validation drop-downlist
is there any event like worhsheet_change for ranges?
Count IF
Two Counters Limit Total
Cannot Add New Workbook
Re: Help with Excel VB macro...
2-dim array into sheet
My movie list
password problem
Problem while printing a sheet
Locking the view of Excel sheet
Visual Basic and Excel
Imbedding an auto-update Clock in excel
VBA Crashes Outlook Express
Begin and End Dates
Populating combobox/listbox
Excel VBA code required (for.......next loop)
vlookup&inputbox
Cell value rounded to the tenth!
Status bar display when the mouse hovers over a cell with a comment
How to add a Combobox dynamically based on contents of some other cell?
Rolling over Month & Year
How to get the full path name of the open workbook in a macro
I can't use user form!
Excel VBA, won't recognize "Word.Application" object
save to excel file
control many pivot tables
Runtime error 1004
'and' criteria
stopping macro
Customize Form To Display Lists
Specifying activesheets to multiple buttons....possible?
OLE in Excel
Workbook naming probz!
Textbox
Worksheetfunction
Jump out of Do Loop on sheet change
Run through name range
find last column
Setting zoom of a worksheet in macro
how can you do this
insert picture
Select only visible cells in a selected range
Adding rows in a chart
Quick question on a small Macro attached!
Forgot Project Password
Inserting picture in footer with macro
vba code wanted
code asking for password
action on selecting special cells
conditional sums
Athletics Ranking Spreadsheet
How do I refernce a column as I would a field nam in access
Re: Trendline Linear Algorithm
Re: creating Excel with text
How to protect a worksheet such that cell value can be edited ?
Populate Userform from another workbook
Nulling a option button
Comparing two worksheets
SQLRequest to MSSQL server - macro
Re: Exporting Cell Values Only To A Database
Need to triger an event
Function: Two Month Date Spans From Fiscal Period - an example
Problem with assigning values to items in collection
Suppressing rows where a cell is blank
Re: Apply Macro to Specific Column
.PrintErrors = xlPrintErrorsDisplayed
Macro for pasteing to destination based on a cell value
Re: Apply Macro to Specific Column
Help using FileSystemObject CopyFile
email only first page
delete left 8 characters in many cells
bottom row
Programmed ComboBoxes
Change sheet name
Save Excel file at server?
Add field to jet database table in ADO
Declaring Variables
SQL string problem
Delete Rows - adding a second condition
cell = null if conditions apply
Copy Paste
Command Button to Save As Workbook...
Formula
VB Code Naming a Range (range changes each time)
Re: Macro to adjust formulas
Re: Macro to adjust formulas
Automate the Excel VB Editor Find and Replace
Deleting Duplicates
Rename a workbook!
3 Pivot Tables
Launch a sub in MapPoint in Excel
Please help!!
How to call a stored procedure in a macro
MultiPage Control
User Input Form
.dll and GUID
web query with cells reference
For....Next loop code required
counting blanks in a list
Workbook renaming!
Copy Cells with More than 255 Characters
Excel VBA- counting with autofilter
how to get a range
VBA XP to 2000 problems
How do I customise a function?
Browse Dialog Box in VBA?
find row index
Problems while displaying Date
Calculating values with macro between worksheets
List box with 2 columns
wrkbook_Open event, Help??
Re: alternative to hyperlinks
alternative to hyperlinks
Re: alternative to hyperlinks
CELL("Filename")
Re: VLookup function in VBA problem?
Browse For Folder start directory
recording macro to delete sheet
Producing charts from excel vba in Powerpoint
Can I pick the size and position of an avi file?
Stop one sheet from calculating.
Opening a UserForm causes a crash in the Exit procedure (Which is never called)
Sorting of text data different in Excel adn VBA? Office 2K3
Disabling Error Messages
How to calculate the previous day?
Define variable range
Combining several workbooks into one
date format
How to add mutiple hyperlinks to the same cell?
May Day May Day !!
Just having App_WorkbookOpen crashes Excel
urgent vba code wanted
Common format for Labels in Userform
[Q] parameters to drawing objects
radiobuttons switch with space
excel's probem
custom settings per user?
[Q] msoShapeRectangle: variable not defined
[Q] msoShapeRectangle: variable not defined
[Q] msoShapeRectangle: variable not defined
Excel Automation with Security Problems
date/month problem
Adding Custom Property
how to delete all msoFreeForms on a chart
total no of worksheets in the workbook
Find date in another workbook
Sum the last 12 columns ?
Creating a hyperlink in a excel cell programatically
Beware!The post by 'Nela' is a VIRUS
Can Excel Macros and Ranges be streamed ?
Excel Report
Re: Referrring to cells by their column header
Can i do this??
PDF Files
FormatConditions (fails in different Languages)
declaring a msgbox
Re: put large amount of text into merged cell
Worksheet Function VB code error
Staring Lotus notes on cell containing..?
Renaming workbook!
Re: Error
What was that website again?
convert XMLSS to PDF
convert XMLSS to PDF
GetDirectory Function
Run-time Error 1004, Please Help
Unique Identifier Macro
excel 2000 add-in causing delay issues
Convert data and export to a text file
Command Button
Highlight the selection!
Re: VLookup function in VBA problem?
Querying on Data Ranges
Can't Find Value
Excel as database
Code to create Email that includes quotes
Re: Do Until Loop
Help with Novell GroupWise.
Radio Button Group value using VBA
Re: Macro to activate form button
VBComponent Types
opening multiple files using VB and running a mcaro in excel
RE: VLookup function in VBA problem?
Version compability of classes?
Export module
Check Box Values
Excel Programming with VBA
run vba code on more than one xl file
Commandbuttons
If cell = XX then.................
Is it impossible or is not clear the question?
Highlighting a selection!
If cell = XX then.................
"change" event for validation/pick lists
VBA Editor opens by itself?
Excel: How to uninstall a COM add-in built with VB .NET
macro password
Re: DateDiff in Excel
Password Protected & Read Only Access
Creating a new sinus function in VBA Excel
Runtime error only with Office 97 - advice required
Another delete entire row
Get the value from drop down
Programatically nameing ranges
Displaying a status message
Workbook_BeforePrint
Creating image which refer to a section of another sheet
Combo Box Before Update
Re: VB code still runing
Re: VB code still runing
Multiple loops one result
Test
how to hide #N/A ?
binding checkboxes
ActiveX controls rearranged automatically after printing
Macro Needed Please
Unique Identifier?
Replace with result of database query, instead of inserting
VBE Window Docking Problems
Test
closeall
re-enabling the double click
Copy source sheet to end of targeted workbook
HTML Scrapping
Pivot Table and Last Row
Combo Box/Worksheet Protection Conflict
Delete rows.
Simple HexDecimal to Decimal Converter
Copy and paste a chart to another worksheet
EXCEL VBA and HTML
Excel2000: Copy all exept data
extra space
Splitting text in cell with Excel 97 VBA macro
decimal separator
When running workbook.close True Excel generates an error!!!
Programatically deleting Range
X AXIS Graph
Auto Refresh Pivot
Comman Button to open another application
Command button to open another application
Search for anything but
Serach for numbers starting with for example 49****???
Excel 2000 macro runs v.slowly when Excel is not Active Window
Disable Min Max restore buttons
URGENT.....Simple problem...made hard??
Userform question
COM Error Hiding/Showing Excel Toolbars
Who know how setting this print
Chart property Codename???
moving between sheets
Another Solver Problem
Index & Counta formula problem
worksheet won't change visible status
Add files to ZIP using VBA
Linking to a cell in another (closed) workbook
count...
Optimizing an investment portfolio
copy/paste based on colour criteria
OK Golf lovers, a little help here
Trying to return cell formatting?
combo boxes in many sheets
Re: Selecting all sheets
Set Appointment
solver
After checking control checkbox returning focus to the sheet
re:Macro to delete rows
VBA userform with minimize button
Pivot Table Datasource
Why? Re assigning macro's
Re: Protecting linked files...
Querying a CSV file from Excel
Hyperlink on Userform not fully cooperating
Re: Prompting user before saving
Re: Prompting user before saving
Macro Password
Re: Macro to delete rows
CAN'T reference Value on another sheet!
Counting/summing cells based on background color
beforeDoubleClick (target, true)
Re: VBA and file searches
opening worksheet from VB
Re: VBA and file searches
variable as Currency two decimal places
Removing the word "Total" from subtotal cells
VBA Documentation
Importing Access data to Excel
Re: Hyperlinks
linking chart menu bars and worksheet menu bars
Sum Code/Function
Re: Inserting a worksheet based on a template
Can anyone help me with a Formula
changing foreground color of listbox w/o losing selections
Help creating a check box on a form.
Formula Editing Macro
BeforeUpdate and Cancel
Re: rightclick on combobox/commandbuttons in a worksheet
Insert data into a cell
Problem with Worksheet collections... :(
stop programe after trial use
Assistance Needed in Performing Count of different types- Simple SQL, not VBL
matlab and excel conflict - cant use excel anymore
Speed at which Excel opens up
Problem quitting excel when it is used by ASP.NET application
Paste Link is greyed out during Paste Special
how to turn off gridline at the file level?
Re: cell formatting based on combobox
Highlighting ser selected item!
Saving Data
How to send filtered range in email body?
Need an EXPERT in VBA and knowing how to manipulate objects on an excel sheet
Re: Useform ComboBox to Worksheet
Code Consolidation (1)
Code works but I have to run it 4 times
Putting Quotes in for XML
Convert values to strings
Looping through named ranges
How update range after web query?
Change result #VALUE! to "message"
.EnableSelection = xlUnlockedCells
disappearing menu
Autorunning Macros
Searching for matches
Re: Selecting all sheets
Data validation referencing other cells' values
Macros
Re: Selecting all sheets
Using Date Ranges
Constant refresh.
How to call EOMONTH(a, b) function
Unprotect not working
Any ideas... Doesn't work...
code pasting a date changes date format in current month only
automatic sort macro
Macro Question - Variable
save file as addin programatically
Declaring a DLL
Message Box With Cell Refferences
ComboBox - Changing ListFillRange
Running a Macro
Stop Cell Edit when DoubleClick
Re: Loop and Compare
Pop-up message on Desktop
Get Data from Second Workbook "Please Help"
Sending data in certain cells to another worksheet by pressing a button
drop down options (within a single cell)
Syntax Problem with formula code
Dropdown Box On Worksheet
Deleting range names
msbbox
Programmatically printing x pages/sheet
Excel VBA - Data Type Conversion problem
Saving embedded object to disk
Coloring cells with same values using VBA?
LastModified Date of Excel file
Re: Finding Worksheet Name
vba excel 97
Repost for additional information
VBA Button to Send Email
Spin Button and Worksheet_change event
Add-ins
Walk me through this VBA piece please
Referring to a column
Running .avi files
Control Break and Escape for Interrupting Code
Is it possible to update records in an Access table from Excel?
Printing Grouped Sheets
Macro assignations follow new documents
Search for certain string
how to auto change a file name?
InsertRowsAndFillFormulas
How to create a form control over a specific cell
InsertRowsAndFillFormulas Macro
Showing a list of SQL Tables under ODBC
Hi Excel
VBA password / Program Freeze
Actions on certain Worksheets
Re: Range Selection
application.onkey doesn't work
Excel 97 Macro Compile Errors
Range Selection
Help Needed: Please try to answer the following questions.
can't figure out this bug
Maximum Range size?
Excel always starts in Editing mode; i.e. buttons can be edited etc.
Strange error message
Data from Exel into Word
Alert from COM addin
Disable hide for a column
Excel2000: finding last row of used range
menu bars
Releasin Excel From Memory
Macro to show wraped text in merged cells
Return Index of Control Object Clicked!
combobox
Linking to a cell in VBA
navigation between forms
Tool Tips on Excel Cells
Break all links on autoclose
Macro: Prompt user for xls file to add chart
Printing Multiple Sheets to Acrobat Distiller
Full Screen Button
Skip to Next "x" inside of a For Next Loop
Three Dimensional Lookup
Macro to list info on seperate worksheet
Error with protection
Exclude image
summary of multiple workbooks in a directory
Workbook_Open
Open Specific File
ADO Data Control
InputBox or...to allow nubers formulas and Ranges I mean "Type:=0+1+8"
command button colour
setting print
Freeze Certain Panes
Excel - VBA sub routine to get AVG
How to Offset string variable?
macro working very slow
Change Folder Icon
Cell Value as String as Worksheet Name
Porting VBA Libraries
validating datas from an excel
Opening non-Excel Files
Using VB to search for a value within one column
Completely unloading excel from vb6. Is there an answer?
userform
making a backup
To limit Users using shared workbook to their own worksheets!
What range is a cell in?
Function not copying
Excel VBA Function Parameter Overwritten
COM add-in userform minimize button
Condtional formatting in VBA help!
Another question about exporting charts
Saving Customer Records Both New and Changed
Excel on server
How Many Characters In A Formula?
Screenscraping TN3270 Screens with Excel VBA
Show formula in cell
context menu
VBA in Excel
Help Inserting data into a range of cells
macro for merging vertically
Display MS Access data in col B when ID# is entered into col A
want all worksheet tabs visible, starting at left
Getting Data from Adobe pdf file
Lost modules being arranged by type
help with excel macro
Inserting a Comma in Many Cells
Multiple Userforms open at once
RNG translation
Printing in grayscale
Radar Chart?
How to use text value inside a formula
Adding Comment to cell
Meaning of VISUAL Basic in VBA
How to set variable to nothing