Excel Programming [Archive] - Page 167

set time limit before closing sheet
How to select rows containing certain date
How to insert a column
Q: How to import data "vertically"
range.calculation with UDF not working when calculation is set to automatic
Making different sheet from the original sheets data
Same VBA code, different run time
Need shortcut to "Data -> Filter -> Show All"
Use of "On Error" within a loop
How to switch data between rows and columns by using programming?
Need VBA code to periodically zero out 10,000 cells
Custom Toolbar Macros
embed <alt><enter> for multiline cell in a CSV file
Comparing old date to now() and writing out text message in column
Reverting User Session to Automatic Calculation
Why can't I record Macros?
Using VBA to Delete a Chart
Anand clique tributes Legendary Chicago lpQ08LOrW
Set volumnwidth and other parameters borders...
Caps lock
Search -Add-Update Data to Access
Selecting a Range
VLOOKUP & variable worksheet names
Bond prices: summarize ranges from different worksheets
Print a PDF File from within Excel
Double Click Copy
Create Custom Control thru Code?
Is this possible???...
LOOKUP function in VB Macro.
Prevent Change in Event when not needed
Menu Options question
name of worksheet
how was this built
Using Target.Row in other Sheets
distributing add-ins
Compare rowsources
tab delimited file
Status Bar...
VBA Macros NOT cross platform?
Deciding on a Reporting Package
Clear Combobox
Format Display in ComboBox
comprehensive list?
Images in Office Web Components spreadsheet
DataForms and dates
Is this possible? with excel
Selecting Multiple Columns
User Option to save to chosen destination
Automatic CC Entry in Sending Mail
Embedding Word Document within Excel
Can this be done??.....
Command vs Control Buttons
Using Excel 97's Conditional Formatting dialog
Control Buttons vs. Command Buttons
Can I start a macro using a # key?
Command Button vs Control Button
OLE Automation - Server busy message
Top urgent for hyperlinks management
IF and Lookup functions
Re: Strange behaviour of default property
Same event procedure for multiple controls
Constant excel lock-ups using Bloomberg add-in/DDE server
Variable Filenames
Jan Karel Pieterse-print preview
print preview-dag johansen
Select range with specified dates
Re: Message to MICROSOFT - URGENT
excel as database
Minimize and Maximize Forms
Possible to relax workbook links??
Possible to relax workbook links??
LogonUser API call...
print previw
List members in Dimension (Pivot table field)
Changing the value in multiple sheets without selecting those sheets
Saving Query definitions in Excel (Office XP pro)
search box
Excel sum function IN VBA
VB6 Form in Foreground for Excel
VBA help!
Problem Copying Header/Footer
What cell am I on ?
How to modify contents of TextFrame?
Scenario result display
Formula Tool, Help Required.
Folder picker default - second attempt...
Do---Loop Error in Complex Code
HOW to show in A2 the formule used in A1 ?
Hyperlink within the TextFrame of Shape Object..?
Data Validation Question
A More Effective Way of Using PasteSpecial?
Scrolling Question.
How do I? Get Excel to do something when I close a workbook
Macro to activate a Batch file !
Are there apis that relate colour index with color?
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqq 7739 [625/5]
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqq 7739 [623/5]
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqq 7739 [622/5]
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqq 7739 [624/5]
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqq 7739 [1/5]
Re: Q: Better syntax to cycle through elements of an array?
test
changing sheet names
Advanced filter
How long can Excel (PC) be expected to run without re-boot?
How to use the Status Bar in a UserForm
Cant get my code work. Find file or create it
Forced Input
Update totals
Current Issues Article Archive
How do I send some cells to an external text file?
A password question
E-Mail form Excel 'selected print area'
Give name of date on a new worksheet
Move selection down one cell
Format columns in a ListBox?
if then vba
Function for calculating workdays?
e-mail from Excel - Outlook warning msg box problem
formulas
listbox rightalign
Condtional Format Problem !
Make a hyperlink, by placing data in a cell inside
Capturing Checkbox Events
Copy and fill automatically
3 years looking!.. and its probably simple.
Sorry. Didnt know that attachment were off limits.
Every second subroutine
Help me with OnTime Method
Re: Help! Code jump to function with out being called???
How do I reset the LastUsed cell reference from code.
Incomplete SaveAs name
VBA code to make a progress tool bar work
xll dependecy question
MS Script Editor
Variable Range
Need help with cell formulas
Addin
2 questions about check boxes
Assigning Macros
List with wages
print # statement infrequently printing 0's
Accessing different versions of Excel VBA from another application
VBAProject unclosed even excel file was closed
Folder picker: default to network share?
Excel Programing / VBE - Good Books?
newbie: stop a FOR NEXT loop
FileSearch Problem
MACRO TO CLEAR CELL CONTENTS
taking one cell and adding text to it
Adding text to a cell from another cell
Dynamically display subset rows from one sheet in another sheet?
Slow-Opening Excel Application
Calling an XLA macro from code
Counting for Minimum Difference Value
need help re send/recieve com port data from excel and auto CR/LF
Application Turned Off
Using Navigation Keys
Excel Autofilter
How to catch mouse/keyboard event in Office addin
Using Excel XLL in Java
XLL decompile
Conflict
choose more than 1 column
Running Code in an XLA from a Worksheet
Help with formula?
Global macro insertion
Need Help with Code - Copy & Paste
Auto-run ONCE macro
Help Please.
Can anyone tell me?
total no of excel sheet
Pop up window
Can I set a page of a Multipage form to active?
On the lack of control arrays.
How to access the 'color pick window'?
Drop to next visible row when filtered?
Export Data to Access Table
Time smaller than a second
Copy information from a specific range; not the entire worksheet.
How? to go to cell when opening file
Formula filling with sequential worksheets
Formatting macro
Generic ComboBox change event
Dimming Controls
Disable Automatic Link Message
Change color of sheet tabs
Change text color in an IF...THEN...ELSE formula
Re: Copy data from Excel to Access
Macro to freeze screen
Use of ANSI codes in Excel Cell
Macro challenge
Project Structure--PrintOut?
Selecting/Activating Control Tools Combobox on Sheet
Dates
macro won't stop
backward compatibility code issues
ISBLANK
ISBLANK function
Where to store standard macros
Disable immediate window (i think)
Another algebra equation needed
help converting text to range object
Problem with Active Cell Refence
excel macro code in registry
Excel data to an Access table
excel/visual basic
Nesting limits in VBA
avoiding dialog boxes in macros
Does Size Matter?
Change Color of Cell Comment Indicator
Representing autofill in macros
add-in
Code referencing the system clock?
Message box that does not interrupt code
write to/read from add-ins
Quick summary?
"Load" statement
WorkbookOpen() Auto macro
Excel.xlb and Custom Menus
Moving row data to another sheet
Use row number in spreadsheet as variable in macro
Text color in cell
ANOVA using Excel Analysis ToolPak
Altered formatting after upgrading Windows 98 to 2000
Selecting a range of cells
distributing a macro
How to program a key, say F4?
FollowHyperlink then Save File
How to save excel from webpage?
Error Checking Tips
Macro code for INI file
link excel to command reflection
print preview
set focus
How to enable sorting and filtering?
Set Security levels via macro
Disabling menu items in VBE
How do I get tool tips with user created functions?
Creating customised new spreadsheets
VLOOKUP Question
Copying non-blank cells in a range - XL97
Worksheet function in VBA - If..Else
Need Help Immediately
Problem converting from PC to Mac
Runtime error 1004
optimum - questions for experts
Pivot table field coding
Changing AM time to PM time
Links in Graph Headings
Improving speed with VBA
MSN Stock Quote Update
VBA Functions for use in Worksheet
using cell values to select range of cells
Dynamic update on ComboBox
Sunrise/Sunset Schedule Help
keydown event
Help with code to add code
macro tts from excel to outlook
Macro from excel to outlook for tts
Multi column combo box
Delete Cells with No Color
Error handler loop?
saludos
Problems from changing from Excel 97 to Excel 2002 (Office 97 to Office XP).
Field validation via control button?
Problems from changing from Excel 97 to Excel 2002 (Office 97 to Office XP)
Check if first character of string is in array
Data validation question
XLapp and Linking an addin ThisWorksheet to run multiple times
Re: Execute macro when chart is created
Hexidecimal dn decmial data
Unique Records by Field
Help in macro
Copy data from Excel to Access
Macro to spread values between start and end date
sumproduct
Re: Formula
Access 2000 - Automation example please
Re: Times question
Default number of worksheets
write 1-dimensional array of integers to text file
Recommendations for VBA Book, manuel
Re: how to start a flash SWF file from within Excel
Making a relative range in VBA
Summing ranges...
Help with a User Input Form
MACRO ATTACHED TO A TOOLBAR BUTTON
go to last record
Help with BeforePrint
Printing A Form
problem with .FindNext
Program not working after upgrade
Access Object causes an error in excel
excel
Urgent questions regarding the code below
Problem copying range and pasting to multiple sheets
Format Row based on Cell Content
can you control SAP with VBA code?
Application Advanced Filter
Highlighting Textbox
Re: Two Questions about the Following Block of Code
What formula do I enter?
Problem changing pivot field
VBA crashes Excel
corrupt formulas
changeNumberFormat macro
Re: looping through worksheets from addin
auto hide unhide
#Name error for VBA function
Accessing AddIn Class Modules from Client Worksheet
vlookup in VBA
Password Protect Workbook via code
Clearing Unprotected Cells
saving information entered onto forms
Excel 97 Conditional Formatting - greater than 3 conditions
help file for custom function
Convert Columns to row variable data
Excel data into Oracle table
Maximum of selection
Issue with Pivot Table Limits
MarkersColor: wrong error behavior
PrintTitleRows
Excel's range Union operator in WORKDAY function gives #VALUE!.
Reduce or Minimize Excel files using PivotTables! Help Please!
Macros to compute Sales figures Differences between Months
ASPX can't change PageSetup property of Chart
Random Numbers
Removing macro buttons from part of a sheet
conditional macros
Re: Max Date
Re: looping through worksheets from addin
Newbie's macro doesn't appear to work!
Function Call
Excel 2000 and filter feature in a protected workbook
List boxes
Freeing memory problem
GetopenFilename default path
ListBox List Code?
Re: conditional macro links
Re: merge cells marco "help"
Re: looping through worksheets from addin
how to change F-BASIC V6.0 source to vba
formula help the sequel
checking office (excel) verion from VB
Re: New workbook - automatically insert header
Re: merge cells marco "help"
Re: looping through worksheets from addin
countif
Re: Custom File Types
VBA: Error displaying special characters
back-end update excel file macro
Compare tabs using Double Lookup, in VB code
Re: Switching to different worksheets during a macro
Re: Can not insert object error
Re: Q: Better syntax to cycle through elements of an array?
Re: Fro Each Next Loop Troubles
Re: > two filter conditions
Listbox
Re: Deleting a shape and the cell contents the shape is in.
How to use Excel C API to load an XLL add-in?
Insert Picture to Excel to specified range
Re: Deleting a shape and the cell contents the shape is in.
Re: using Evaluate on a Name object?
Re: Toggle True/False in a cell
Automatically select range and copy to new sheet
Copy Data (Sheet2 to Sheet1) Updates Web Query
Run Macro from a Control Button and linking to AddIn's
Enabling checkboxes in a listbox control
How to select range of values in pivot table?
In addition to previous question, if opening an Excel file in NON-read-only mode, would the macros on the worksheets work as well?
Macro to input formula in range based on another range
Re: preventing disabling of macros
Clipboard contents
Re: Date Programming
Conditional Formatting in Pivot Tables
How to move worksheet from vbscript
Password / Spreadsheet saved as HTML
e-mailing a file from vba
Time Based Progress Indicator??
Excel graphing
forms
Excel print macro error
file automatically adding hyperlinks
Auto Hide Pivot Table Items
Macro to modify a Macro?
Extracting and Writing
interactive vba
How BEEP on internal speakers, not on sound-card?
No of columns in range
Automation Error with Excel 97 in Windows 2000 with patch blaster
Sheet Position
XLapp and SheetChange
A simple 'If...Then...' code needed?
Killing Excel :)
Macro to add data
Listbox does not support saving
LisBox List
Closing Dataform automatically
Excel Web Automation
Misshapen controls on Tablet PC
macro to sum an unknown range
Select sheet
merge cells and save as .txt file
Access records updating from Excel.
Using a formula to creat a cleared or nul cell
Automatic calculation of user-defined worksheet function
Macro that asks for password
Disable Button
ActiveCell.End(xlDown).Select not working consistently
Excel
Getting active cell address
Display unicode characters in non-English windows
Cancelling Safe Mode Programatically
System Registry
Preventing someone from unhiding a sheet
Disable Macro Problem
Print a Form
Total Newbie Needs Help
Test a String to see if it begins with a Number
Returning Two Values From Each Worksheet
Form Update before ProcRuns
Create Excel sheet in HTML with comments
Limit on number of embedded controls in a workbook?
Project is unviewable
Scrollable list box demo now handles multipage controls
Re: Resetting Menu Bars in Visual Basic
Student Absentee List help please
Help with a formula
Copy Sheets minus Worksheet Change Event code & Macro Buttons
VBA equivalent to "Return/Enter" Key
Rob Bovey's Code Cleaner makes file larger. Why?
vba code needed for date
Advanced Filtering in VBA
Viewing Recordset in SQL help please
range name nonadjacent cells
button to execute macro
dockable form in excel using VBA
Names and References
Custom Function interfering with vba
Protected cell error - Excel XP & Win98
Help with a macro
Resource Monitor
Creating a NUL Cell
VBA project instability
adding a list validation to a cell
Run-time error 424
VBA Memory jog!
A Question on User Defined Functions.
Files in File|New dialog
Return two mid functions as one string.
Need help to finish function....
AddIn Default Path - Moving Spreadsheed between Users/Computers
Active X frame on worksheet
How to pass arguments from ThisWorkbook to a UserForm
Worksheet ComboBox not droping on cue.
Q: Is this vlookup statement efficient?
Pre-pending and post-pending cell data in Excel
Disabling external data refresh using vba
Name a range dynamically
Memorizing current outline
Whose error: mine or Excel's?
Copying text only if the cell is not empty
How to create a Bell Curve chart
Error handling
Summing a column in a macro
Macro Button Not working on Conversion from 97 to 2002
Summing Cells and Formatting
specialcells(xlcelltypeblanks)
Code Tweek Needed
Re: Subscript our of range when activating a worksheet
UserForm not hiding
Toggle subtotals...
Selecing a picture in VBA
How? Macro to copy range to new worksheet, name new worksheet, loop
Adding button dynamically
Selecting drawing objects or shapes in a macro
Q: A faster way to do lookups
Macro name as constant
Sheets Linking
Re: Start a macro from a specific line while editing
page control & sub-totals
Handling Errors from Worksheet Functions
Click on Image Control disables it
Macro for updating links
OLE Container Control in VB.NET
Replacing modules w/password
looping through all checkbox's in a userform
even numbers
Re: Opening text file in Excel through macro
Closing workbooks through macro
Re: Opening text file in Excel through macro
Adding Checkboxes Programmatically
Re: Opening text file in Excel through macro
Worksheets and SQL
TextBox refusal
Changing to Landscape mode automatically
Manage a new instance of a form
Finding Unique Values from Multiple Columns
slow macro execution
minimum # of variables
Selecting x cells to the left of the one you are on
How to show External Data Options form
Event for conditional formatting?
Find nth and nth + 1 values in a column
"Go ahead and replace file" command?
Before and after combo box change
Macro Copy/Paste Help
Excel 97 VBA: Multipage set focus method
Grading System
Formula Syntax
adding strings
Custom button and macro function
Web Form - Excel Linking
many to one
one problem in excel
Detecting Selected WorkSheet
ListBox ColumnHeads
Convert Date to String
AutoExec
Compile Error when loading excel over intranet
sumif
Function to detect if Sheet is protected
Compare tabs using Double Lookup, in VB code
invoke macro from outside excel - auto macros
home delivery db
Class module to detect row deletion or insertion ?
how to make a multipage with many pages all of which can be seen easily.
Inserting Rows Through a Macro
Excel 2000 vs. XP
URGENT - NEED PRO EXCEL PROGRAMMER - TO AUTOMATICALLY CHANGE TITLES IN EXCEL CHARTS
Email from within Excel only 1 sheet of workbook
Populate Userform text boxes in VBA with VLookup data from #2 worksheet
How to terminate a condition (IF) at its first occurance?
A question about decoding, substitute or vlookup of character.
matching random text
Re: Excel programming using VBA
Re: Run Time 31032
VB project locked and unviewable
Excell File to Text File
UserForm with Cell Data
two-condition loop
Cells disappear when I start to enter a formula
RTD Example in C#
Re: Setting worksheet protection password in VBA
inputbox
Inserting data in cells
Code to automatically turn on and turn off Track Changes
Disable Key Events
conditional formater with more then 3 levels?
Help please assigning column and rows
calculate/concert long/integer to date time
Combination of user defined fucntion and row() function, doesn't seem to work?
Dir problems
Find and Copy ?
Deleting Invalid Links
Hiding Rows in Excel with VBA
Printing Envelopes
ODBC Call failed Error 3146 only on some PC's
Macros and Hotkeys
Recover VBA code from corrupted .xls file?
OLAP Cubes
Add rows if a cell meets a certain requirement
copy and delete command button
Serach sequence for referenced files
paint row in MSFlexGrid
Last Password
Excel Hyperlink Macro
A Borders question
Inserting a chart instead of text into comment box
TextBox props
xl97 delete phantom pgBreaks in VBA?
date to text formatting
Using a macro to make selection in a drop down menu
Adding New Woıkbook with a specific name
Inputting data through a VBA input box
I need help index/match
HyperLinks active in a FormControl
Creating macro code in Excel
macro to autofill formula?
Re: Copy and paste in VBA
running a macro by a click
Automatically Enabling Macros
Display many instances of the same form
Send Mail, Excel 2002 VBA ArrrrrrGH
How to hide Excel window when activating a Shape object
calculating two strings
Re: Recalculating block of cells
Re: Pivot Table Refresh VBA Event
Setting form controls focus and enter key
how to open excel using regedit?
Formula Help Needed
Help with Macro for Zooming when cells have Comments?
How to disable macros?
Simple change ?
Re: The XLS file is huge!
Re: The XLS file is huge!
how to programming Excel in C#
y=f(x)
How to move around in the "refers to" box?
How to make an Excell-sheet un-usable!
Worksheetfunction MATCH
open excel file with cell highlighted
Re: Formula for converting currency
Re: Formula for converting currency
Please Help with Excel Sorting Macro!!
Stumped Again
Creating a SPIRAL of stars in Excel
Limit search on visible cells only
Numéro ligne courante
VBA formulas in javascript
Translating Column Addresses into number/integer
event which occurs when a TextBox receives focus
Unique ID number generation
New excel sheet
Export Shape as gif or bmp?
Accessing com ports through Excel97?
Worksheet Exists...
resolving reference - Range of what?
Links to Other Worksheet
Setting Read Only on save.
THANKS
test for key press
Protect data in cell from viewing it
Multi-line cell text content saved in XML
Email from within Excel
avoid div by zero
refreshing custom function
Excel VBA programming book recommendation?
Custom menus and toolbar text and icons
Digital Signature
replacing 0 with blank
URGENT - NEED EXCEL PROGRAMMER - AUTOMATE THE TITLES IN MY EXCEL GRAPHS
Replacing 0 with blank
waiting for data refresh before continuing VBA sub
Excell macro Date help
How to make the data in a cell blink?
Copy and Paste Cells
Controlling image filenames during "Save As Webpage" ...
Clear Empty Strings
AutoFilter - which rows are currently visible?
Web connect very slow in ExcelXP
increase date by month
save as event
help from Tom O
fixed save as name?
Help needed with FIND routine.
Newbie : Autofilter thru code ?
OnKey for Alt f not overriding standard use of Alt-F
opening and write to a text file in excel
Trapping an attempt to use a custom menu
Macros - stepping left in a macro
How to count in between gap?
Input box/form
programmaticly change code
CalculatedFields in Pivots
Plse Help To Reduce
Plse Advice
Defining Range Extent
Comments with text from cells
Set cell formulas using code? how?
saving in CSV format ... every 10 seconds
Multi-columns in a ListBox
CODE TO ADD TWO COLUMNS BASED ON ANOTHER
Excel compare and create
How to replace PivotTable data fields...?
Pivot Table
Change File Name Warning
Logbook generates runtime error 438 on another network computer
How to Monitor a change in a formula's result?
Some Help Please anyone
Tool tips on UDF
How can I format text pased directly from clipboard to appear in correct cells
Is there a way?
creating a SPIRAL of stars in Excel
Can an add-in macro update a worksheets Worksheet_Change function?
Add Comments with Text From Cells
Perform action when cell is clicked
Sheet Update Problem
API Calls - EXAMPLES needed
"NCOMPLETE CALCULATION"message
DATES
Input Cell
Need Help with Code - TimeValue
Batch Files
UserForm Controls References
Protecting merged cells
button gets named range
UserForm Caption
Selecting the end of a range
copy printarea from more than 3 sheet & save in new book.
Compare Generations
Update Master records -- Array question?
Problem with private sub
Cell References and Looping
Array UDF
Combo Box
who can't convert one number y number word
[ANN]: NNTP Server slowdowns
Is a visible workbook open?
Code/Messages for User Control
Slow enter on sheet
Shape connectors
File Searches
Excel Queries Against Multiple Databases
Returning to a previous location
hiding names
Highlight all cells, except top row?
Inserting Lines
Repost - How to save Excel files which have passwords
name of the activesheet
excel spreadsheet has little bits of embedded code in it ? help needed
selecting multiple rows
Import HTML reports into Excel with page formatting options
tabbing through ActiveX controls on worksheet
Macro Coding
Excel chart, right scale
Converting a range to string
Creating a link to a excel CELL
importing data from Access...
call stack question
How to save Excel files which have passwords
Split text in a column to multiple columns
XML problems
How to check cells in a range for a value
How to hide all the actions while a macro is running
Hiding sheets in Excel
Wheeling
automating chart generation from text files
Writing Macro
Need help displaying array contents
help with create spreadsheet programmatically
Dynamic Array as pivot table SourceData..?
Merging Worksheets
combo box selection disappearance
what's wrong with custom function?
default (start-up) window size
Referencing Sheet Names In Formula
Help please on a simple macro to insert rows
Investing in stocks
Columns in Full Outer Joins
match #n/a problem
Extracting Data
Illegal Operation
if statement
excel not being released by vb.net
Error 'Too many different cell format'
Sheet protection
Multidimensional Array problem I can't solve ! Please help me out !
DateTime Format
Find - Sorry - Please see this
Excel 4.0 Macros
Activesheet.Scrollarea
Repost - rank in if loops!
how to copy and paste cell as a value.
Comparing value to list
Find
Populating a lis/combo box in excel with access data
show password like *** while entering it
Sheetname variable
get data in sequence
Copying a range to clipboard
control toolbox elements
Maximim download file size into Excel 2000
remote refrences
call sub
Remove VB Module from workbook
English VBA not working on PC running French Excel
Hopefully simple Select Case error
How to escape this error message
Treeview
Simple INT error?
Automatic startup of an excel macro
Assign Unique Number to an Excel Template
Keypressed?
treeview add nodes
i'm stuck with an excel qujitting problem
ComboBox
.SpecialCells(xlLastCell).Select
Where can similar macro template / sample be found?
placing a pull-down menu at a cell location automatically
Re-Arranging a Block of Data
Error handling
Creating Named Ranges in VBA
Re: "Weighting" sub
Trying to generate mutiple list for one
Auto_add not called, but not found error occurs
Duplex Printing
Multi-sheet linking
Help with formula!!!
A Couple of Macro Questions
Strange problem
Protecting Sheets
Open delimited text file to excel without changing data in that file
Message Window to tell user "Macro Running"
How To Use A Custom Help File With Excel 2000 Forms
How to find what object type is returned from Selection property ?
Re: Custom Cell Formatting
Calendar object in Excel problem - mscal.ocx
Refresh link automatic
HOW TO STORE CURRENT COLUMN & ROW
combo box
Help within user defined function
Flipping Cell Data Horizontal/Vertical
Converting to macro
Bloomberg DDE problem
Add-ins missing
Can't Get data without including Header using ADO
VBA and Regular expressions
Writing values to Web Forms
Tab stopped working
Web page loading
Re: Set intersection on Excel spreadsheet?
Class modules
code to change activecell
HOW DO I GET CURRENT ROW & COL INFO?
Close worksheet with Macro or Code
Pivottable total cloumns
Pass a variable from a class module
Printing a list of all named ranges
Tab delimited or not?
Expert help needed
Parsing values into ranges
XML to Excel 97
PDFing an Excel Workbook
Shortcuts keys sometimes don't work
Cut and paste to Outlook using a macro
Converting CSV text in a single column, into multiple columns
Retaining column formatting
Question on "GetFile" command
Excel open an existing MS Query in edit mode via macro attached to a button.
copy all worksheet data into a new worksheet
default (startup) window size
I need help w/ a formula
Re: Removing/restoring menubar in a macro
Custom Cell Formatting
Adding catagory %'s in a Pivot
Help needed
How would I do the following? A little complicated in detail...but I don't think to difficult...
Re: Removing/restoring menubar in a macro
Save Event - Determine if called by code or user
Best way to add info to a SQL database from Excel
Can I use a User-Defined Funcion in a Conditional Format formula?
Just a question regarding a formula operator.
Formatting a cell in Excel, using pure VB code
Excel to SQl 7
Re: ComboBox with Dates
Show Dialog Box - Edit/Replace
Extracting links from images
Re: Set or not to Set
Adding to a Pivot
Re: print area mising last row
Create Data base
Pivot Values
Re: Set or not to Set
Re: Custom shading colors
Help, there must be a better way!
Formula excluding #N/A
if macro
Best way to get data out of SQL Server
Opening an excel 2000 workbook in C#
Get External Data
Loading data from a huge access database
Auto enter data
Calling macros from another XL Workbook
VBA will invole .net?
Excel VBA code executing a variable as a Sub.
Files visible or not...
Keypressed function
Waiting for app to complete OLE action
Sorting sheets
Sharing Workbook caused error message
Error Msg Deactivating Code
Unable to set the colorIndex Property of the Interior Class Error
Userform shadows
Locking project
Call macros from another XL file
Excel sheet always open up `behind` other sheets.
Password prompt for acessing a workbook
Create ListBox (?) same as Find all Result List
Activeworkbook.sendmail
worksheet Name and (Name) properties
how to rm the "extra row"?
Application Error when running Macro on Workbook open
Perform Lookup and delete non matching rows?
Page Object property
Selective call procedure
Renaming Problems
DOS Command Line
template button network wide
Count to hide
Print excel sheet in one page
Command: Data, Form
text comparision
Msgbox shared workbook
us IF statements
maximum sheets in a book
mscal problem
slow program in a loop
Extracting Data from MS Outlook Mail Messages
Using a macro to perform a TASK on another workbook
Listbox text property not working correctly
when opening a text file....
ASCII value
How to remove an add-in
Define Excel Addin programatically
Run time Error -2147352571 when showing a form
Deleting a row with 0 in column A
Referencing two columns for data
XIRR Add-ins
Disabling Sheet Code
Macro Won't Copy/Paste
Macro Won't Copy/Paste
Print non-XL file
Re: Can't get connection string right
random VBA errors
How can I tell if a worksheet exists?
Re: Dropping lowest 2 values
Nested loop with ranking
Test
combo box error-not enough resources
Looking for Excel VBA Example
insert rows
Delete the code in ThisWorkbook
Tab between Text Boxes no longer working
Blinking Text
Count of non-blank cells.
Variable Control Names
Re: adding button for add-in
Designate a folder as the root of the Browse tree
Looking for Cell_Change Event
Re: Pop up Box
User Forms
Run Time Error 9, Script Out of Range
reference excel in frames?
Excel 2000/VB
Filling a listbox depending on font index
Undo Procedure
define end column in a range
DDE Server
formula
New Excel 2003
select a1 on all sheets
Using Named Ranges in VB
I Tried it, still problem...
VB Script help
2000 to XP VBA problems?
Re: Bi-Directional Cell Linking
Worksheet event for tick box
Re: Bi-Directional Cell Linking
how do I get " 1st" to look proper (superscript the "st")
Re: Search and Replace...
Re: Search and Replace...
Re: Input boxes in Excel
Several comboBoxes on a Userform
VB Code
Is there any opensource lib/tool to convert excel to text ?
error 424 - Object Required
Re: adding button for add-in
Re: Creating a list of found files
PROGRESS INDICATOR
Copy/Paste Problem
Get the integer valure from the current date
Search and Replace...
Persistent Excel toolbar
VBA : A picture from http://.../Image.gif
Getting rid of workbook
auto save-as from external inputs
Copy a value to a range of cells
How to hide and unhide rows
Turning off Screen Refresh
unprotect more than one password in macro
Links
CVErr, Excel and VB .NET
multiple selection problem
Distributing Excel Applications
Copy/Paste Problem
Combobox Change Event when file is saved as
Read variables from external file
autowrite a cell depending on another cell's content
Deleting Calculated Fields from Pivot Tables
Programming a processor
Access Custom outlook Forms from within Excel VBA
Close explorer window from excel VBA
Re: Mergeing two Arrays
Formatting a cell
Re: Select
Formatting a cell
summing up hours
importing data from MySQL
Formatting a cell
Counting rows in AutoFilter mode
Re: How can I delete the end of line (result of shift-enter)
Excel Versions
Re: rng(1,1) syntax doesn't work for set rng = arange.columns(1)
Dr Watson Error on opening file with VBA
macro to input data
Problem with IsEmpty Function
add valuew to new sheet depens on month
Delete rows in Excel file with macros