Excel Programming [Archive] - Page 137

Sizing a window to fit a range
What does Ctrl-r in MS Excel do ?
Format cell or script?
Continuing Question
Finding a particular character in a string using VBA
Can't scroll VBE properly
Clicking on listbox control displays code - why?
Functions in Excel macro
Help on Goal Seek w/VBA
First and Last cell of a named range
need code to open new excel workbook
Loading Sheet Names into Combo Box
need help w/ commission function
Help with SaveAs Macro on Auto_Open
Test for Heading, Delete Column
Number of Different Entries In Column
Most Common Name In Column Using Cell formular
Recalculate cell #2
Sum based off of text -need help
Can't unmerge merged cells programatically
Sorting and grouping list totals
Querytable range name
Global Constants?
differentiate empty and zero
sum of cells
Re: Deleting a Row by If Statement
Abraham Celoyo
Macros in other Excel Files
Re: For Each Next Loop
Trying to open an Excel file from VBA Access
Userforms and Data
Re: how do i open xls file
Resetting Solver Manually to Fix Solver Bug
Detecting the drive letter of a user's CD
Office 2003 SP1 breaks solver?
Problems with a sub getting ahead of itself.
Re: Determine Valid Sample Size from a Population - Any UDFs or Formulas?
Controlling a web page from within excel
Can I add the current date/time to my code when I print it?
Re: Format data entered with User Form
export spreadsheet from excel to access table
Recalculating cell
create a macro to copy/paste cell data
Re: Too many macros
Re: Validate entries
Re: Insert UserName
On Screen Message
assign the sub to the object event
references
Combine non-contiguous data from multiple worksheets
An 400 error msg
Re: Yes to All???
Conditional Formating
Re: Yes to All???
about ARRAY variable
2 questions
Re: Empty cell and a the empty String
Re: Worksheet protection
Select cells by format with VBA
vba pivot tables and hide blank cells
Re: Worksheet protection
timestamp question
Printing Excel as PDF
Check for instance of EXCEL running
excel 2003 Task Pane programming
Re: Deleting comments
if not found, add/insert
Re: 2 comboboxes working 2gether
Re: Deleting comments
How to return #VALUE! from a UDF
Date format is not correct when using OpenText in Excel 2000
Range Name Manager?
In Excel how do I format swimming times - mm.ss.100ths
SpinButton control and focus
Re: In Excel how do I format swimming times - mm.ss.100ths
Re: In Excel how do I format swimming times - mm.ss.100ths
Slow Respones opening non-web applications (i.e.Word)
dynamic chart on multiple worksheets based on named formulas?
Using Activecell.Address when defining name
Re: Trendline in charts
unlock a cell
Open a PDF document
getting puchbuttons aligned
cacatenation code
how to tell if cell value is one of standard set
How can I make cell keypress event?
Re: How can I make cell keypress event?
can it be modified to filter & list *.xls files only?
finding coordinates of cells in an excel worksheet
MS Query automatically fully qualifying SQL Select Statement
excel
Auto fill text boxes in user form by inputting data in another
Multiple areas in named ranges
Can someone explain this code to me
Referencing another workbook in equation
Range of columns
Message Boxes
VB regarding pivot tables
Command buttons disappear
statisitical significance
Patterns
name of object
vba code to filter
Re: copy value to all pages
Deleting rows using key data
Excel VBA to file find in Word
Excel to IExplorer
cut&paste
How to delete a cell using VBA?
how do I buy Excel
Check Dates
Creating a button to open a file
Date's
Importing Access tables to an Excel worksheet.
select data from worksheet depending on criterions
A Whole Lot a Dimming Going On
Masking character
'very hidden' columns
automation timeout
Date
Date problems
how do i increase the number of columns in excel
user form to copy and paste from source to destination
storing financial data in array
Disable printPreview's Print Control! is it possible????
Re: Forms control checkboxes on charts
Re: Forms control checkboxes on charts
Combing an if then statement and an offset cell?
COMPARE 2 Excel files
EXCEL Jump Start CORE Workbook w/Code
Need help to changes a conditional formatting code....
Data Validation Dependant Lists
Average command
loop i think
Disable Cntrl_C and Cntrl_V in VBA
Re: Forms control checkboxes on charts
Disable Right Click In Excel
Copy and paste - two workbooks
check boxes
Data Validation/Macro Problem
email as a group - multiple worksheets from one workbook
Programming Logic
Macro locks me in a single XLS file
Help Please - VBA Macro- Copying rows to new file
THANKS
Combining lists (again)
range to VBA array, and doing this fast
Save only Changes....Not complete workbook!
Replace Protection Warning Pop Up Using VBA
I cannot installed microsoft office 2000 in my computer
Sheets vs worksheet
Populating combobox from another combobox
Multiple Questions - Assistance required.
Set variable = to value of unknown cell
Option Button Accelerator Key
same workbook different paths (home/work)
VBA Script Porting
Buttons Recognizing Rows
Macros in Excel
[VBA] Score expressions and SUM them
fire macro on AutoFilter change
Using VBA to remove leading zeros
WorkBook.Open: Problems with field separation character
Re: How do you say in VBE language to go to the last filled cell?
Too Many Dropdowns???
Redefining a new Range area
Excel Vba - Text Box active by default
Re: populate combobox with sheet names
is this possible?
populate combobox with sheet names
"" is not blank
Running macro when changing data
Excel VBA - Running Access Marco in Excel
It possible to multiply one cell by...?
worksheet_change D.McRitchie
Lost reference to workbook
Datareport - Datafield not found
Copy an exact cell value (text)
Conditional Formatting multiple cells if one cells says "X"...
inserting a row
Transposing a rng selected from a listbox
I want to make locked cells un-clickable
Can't scroll VBE properly
Msg boxes in VBA
Working with a cell in a selected row
Help with code.
Open method used
Close without Saving In VBA
Can you call a macro as in an IF statement
Moving between "row" and "range" formats in VBA
How to copy formatting when moving from cell to variable to another cell on another worksheet
Excel app. lags on opening or closing...possible solutions?
Save and Close Pop Up Box...After Save and Close In VBA
Shortcut not working
Using the popup calendar
ListBox (arrow keys pick each item)
Drowdown menu reset
Worksheet_Change
Random Brand selection from list
Getting rid of personal.xls
Getting rid of personal.xls
Create a report with monthly usage columns
Checkbox1.LinkedCell = ActiveCell "Why wont this work?&
OnAction & Drop Down List
Here is the url
OLE automation - use of .selection
automatically send email from excel
Diactivate shortcut keys
How to delete downloaded posts?
How to get SID of user alongwith the permissions?
removing cells with certain words in it
highlighting a block of data
Hide public procedures in macro window?
Re: Too Many Dropdowns???
Query Into Protected Sheet - Excel 2000 on WinXP Home (SR2)
Name Problem
Vba - Checking if running
Opening an Excel File
Please help restructure this code
Excel WordWrap/AutoFit Problem - the row becomes too tall
Multiple data entry - Dynamic textbox
Calendar
Protect A Pivot Table
Copy VLOOKUP Formular but only change the Lookup_Value.
Copy Formular Without Changing References Within
'Help on this error' does not work?
Date Range Searching
Problem with COM Addin in German OS and German Office.
Return to cell after sort
Disable the Macro Pop up
Drawing shapes on Userform
Macro to set Active Cell
Protection unlocked cells
Select part numbers from a list; calculate statistics from selected records
Excel 97 Left(.....
Excel Query
capture date and data every time data changes
automatic overwrite file
Trying to print without opening the document....
Re: How to set the comment box's font size using VBA?
Double-click event question, part 2 (Excel 97)
Problem transferring text value "S4" from 1 table to another
Re: If found, then copy and paste contents, otherwise move on
Re: copying data from word to excel
Date cell format
Re: Is there such a software as Excel Viewer?
Re: Sheet!cell reference
Re: Is there such a software as Excel Viewer?
automate query parameter refresh and multiple chart print out
Looping
Insert Columns based on cell value
Re: Nested Loop
Re: eliminate duplicate entries in column automatically
Shortcuts created on root
cell problem
US and Indian Date conflict
Insert Formula
how do I compare the value of a cell to a different cell
Excel and Word automation
Parenthesis - to use or not to use?
Protecting Macro's
Is this rounding error?
Control Properties
Open/Close Event and Excel Saving process
Excel Office 2000 error
Button vs Command Button
Re: Code & modules are gone, Macro warning message remains
Creating Toolbar on Word 2000 using built-in Visual Basic Editor
Chart identification
Protect cells IF the cell is not empty
Missing References
or(exact)) function does not work
True False
Changing row colour if text string present in a cell?
Capture texts in one cell
Selecting records
Unsing names to store input from Userforms
Using SpecialCells().EntireRow.Delete on large worksheet - Very slow!
copying rows
disappearing action buttons?
Save as
contents of folder
Help in running this script lower than Excel 2000
.Net ADO, Protect and Track Change
cell validation/format masks???
Copy and Paste at set Row counts
ListBox "dynamic fill range"
Credit Where it's Due
Frame as variable (newbie question)
Excel Security : what is the best I can get?
Formula for B to continue adding C Daily
Run Time Error 438 - Object doesn't support the property or method
Compare two columns in two different workbooks
conditional locked cell?
Formula for Running total
Its posible to insert data...
Only finds first Occurrence
Creating a Pivot Table from a valid SQL statement without MS Query
Finding the Username of a user who has a shared Network file open.
How do I create a "Jeopardy" game for my students as a study tool.
Copying sheets
Hiding Rows with VBA...
Re: how do I set up an auto start macro
Help with #Value error when calling custom functions
Re: how do I set up an auto start macro
Re: how do I autofill within a formula
Run Time Error 75
VBA- Find Errors
Re: Help with Excel Merge problems!
Comparing contents - is it possible
Re: random number in VB
Switch Columns for Rows
Drop down list
Creating an Array from a Range using Offset
Re: Re-Populating Previous Answers into a User Form from the Spreadshe
Help! Out of Stackspace error
Data import gives the wrong values: bad text format?
Re: Checking to see if a sheet is open
Re: variable column widths
"Text to Column" - exceeding maximum number of columns possible
Re: function to delete rows
multiple copy / paste on locked sheet
Re: Format
Adding to Favorites
Sort problem in shared file (2)
Re: Is there any way to change say column B to something other than B?
Flawed Macro
Re: VBA Book Recommendations
Pivot Table Sorting
Sort problem in shared excel file
Need to set up Macro to save/replace existing doc with password
This one has me stumped
Re: VBA Book Recommendations
Range Sum()
Date & Time programming
Lookup
Re: Setup Project
Form.show error in module 3
Re: Excel hanging up
Just wondering
Re: run time error '91'
Saving TIF file question
function Help
Setup Project
Re: Count all page breaks
Please Help with Formula
Get computer name
Doesn't work when moved.
Control Toolbox toolbar
Re: Files to distribute with Excel 11.0?
Open File
Re: Files to distribute with Excel 11.0?
Workbook.Open failure
Excel Pivot Tables, Page Fields, Visible PivotItems, Activation
read value of last cell in column
Hidden Macro
Re: Combination/Permutation Generation
Copying tabs from one workbook to another workbook
Re: Writing to a text file some data
Add to Settings.txt
delete row
Re: Sending a spreadsheet as an attachment
Report Builder Add-In
Re: How do I set up and use e-mail templates in Outlook?
Re: select vs activate
Hiding Rows
Re: select vs activate
Can you stop Macro alert appearing
convert text RC formula in a cell
Print current worksheet excluding a few cells
Re: run time error '91'
=ROW-1 modified coding in filters not working in Excel 2002.
changing cells
Mass Removal of Hyperlinks
Cell References
Re: how do I restore a worksheet
delete rows with criteria
Generating vailid check digits
Finding External File Links
Workbook Events
Graph plotting
Re: Coding
Re: Need to insert value based on Background Color - 8KB Attach
Re: Need to Merge cells and erase original - 9KB Attach
I need to export to text file a column
SQL and EXCEL
Marco worksheet
To Harald Staff (or anyone who knows)
A1 style recording with Excel 2000 (win 2000)
Selecting using autofilter
Re: Alternative to Application.FileDialog (please)?
Convert text to column
Filling 2 column list box with Collection?
how do i set file location path?
Code doesn't work on merged cells
constants
Re: checking a Cells contents
Share workbook accross FTP
Program Print Settings
Clearcontents
Beim Verändern einer Zelle den Inhalt gleichzeitig in eine Zelle einer anderen Tabelle schreiben
Change Empty Cells Font for the Entire Workbook
Check for CAPS LOCK = ON
Select the last record
F4 function key with macros
Range?
text of different colours in a single textbox
Export selected Sheet in a new workbook with old workbook name!
Regression Significance or P factor
How do i change the color of a cell based on the value of anthor c
color
Changing the tab's text
Range - selecting multiple cells
how to autofilter for the remaining values????
How to change the ActiveSheet tab ("Plan1")
How give VBA function more than 29 input arguments?
generate a random list with 3 options
Forcing Evaluation of Functions
Re: checking a Cells contents
Re: Deactivating Multipage Change Event
Re: checking a Cells contents
Re: checking a Cells contents
Step thru
Random Copy and Paste
Deactivating Multipage Change Event
Display Headings???
Excel 2000
FIFO Inventory tracking
Activate an Excel spreadsheet using wildcard name
macro
macro help
worksheet name
combo box and .listindex
Lists and Protection
Simple Macro (I think)
Re: Syntax for Excel variable using a SQL Select/From/Where Command...
Sorting
Text strings recognized as numbers given different regional settin
Ignore other values
Selecting a variable Range
Two odd application issues
Hide Columns based on a Data Validation List
Can't copy ActiveSheet to clipboard
variables in a form
Quiting Gracefully!
sorting
Re: Deleting Rows with Same Values
Find last cell in a specific column
Calculations
changing existing spreadsheet
Table into a form
Update info in a worksheet dinamically when a drop box change its vaules
Variable Chart Width (Embedded)
Copy an excel file to new created folder
Copying rows to a new sheet
How to include the contents of a cell in a filename
Simply select rows
Re: Create Macro to Email worksheet
Re: countif in access?
Task Scheduler
invisible formulae
protecting formulas
Combine the lists problem
Re: passing parameters to OnAction
Copy Cells to new spreadsheet based on Cells(i, 4) value
Re: Importing files into Excel with leading zeros
Excel front end to Access database
IF THEN stuff to search-paste-copy rows Help???
whats wrong with this code
help with vba user form
Outlook From Filtered addresses
Turning Of Calculation
Excel VBA Manual
Web Browswer Control
more than 2 workbooks
VB Help Disappeared
VB Help Disappeared
Re: Use a variable for a worksheet name?
Re: Suppressing output
Re: Suppressing output
macro works in Excel 2k but not in Excel xp
RE: Single User Access
Re: Can't get multiple lines in cell from access table (transfersprea.
Addin loaded but Macro not shown
Excel crash when running macro
Re: Single User Access
Formula too long
VBA Macros in Excel
Custom formula
Re: column sizing using macros
Macro Distribution, updating, run upon entry
Printing
Yesterdays date in a cell?
Excute a Excel worksheet with Task Scheduler
list command
Re: Resetting the activesheet used range
Reporting in Excel
Inputing variables
Deleting Rows where some Cells have same Content
Ignore Error 1004
combobox rowsource
Re: Textbox in userform
Variable for workbook name
Re: Resetting the activesheet used range
Help with time calculations where T=15mins?
change links by a macro
Checkboxes to spreadsheet using a looping macro
folder list
seggregation of rows based on values in column
slide numbers in powerpoint
RE: table of contents
Re: table of contents
Modification
Conversion from Office97 to Office 2003
two procedures in the same sheet one a workbook even procedure
additem performance
how can I open a locked document?
How can I make an excel cell keypress event?
Re: CopyFromRecordset method
condition
Mail Merge Word Document From Excel VBA
macros
Getting data efficiently
i don't seem to have excel how do i get it
Selecting in groups within a sort
Use the Calendar control to fill in dates on de Bruin (last update 19 April 2004)
excel 2000 & importing text files
Advice needed for Pivot table
Clearing a Range
buttons
how do I enable macros in excel?
pictures
Run Excel Macro in a Batch File
Absolute path ??
Listbox "expand range as list grows"
Can Not Get Macro to Break with CTRL-BREAK
Code won't run in a subroutine!
Re: Switching between Worksheets
Re: The Reason for Modules?
I need the equivalent formula for this UDF
Code cancels protection properties
Conditional formatting (Excel 97)
CellValueOfZero
lookup
Create a batch file from a number of Excel File
Listbox Add to list
Distributing an AddIn and Help File
Updating an Excel worksheet with an access database
EXIF information
Display of $ in Msgbox
Re: Use a variable for a worksheet name?
Navigating through filtered cells
do I need ScrollArea and/or??
FORMAT CELL MENU NOT APPEARING
Excel Beginner - Need Help with Looping Operation
Excel Macro
Automate adding code
correct email address
Subroutines vs. modules
"Reading" Excel VBA checkboxes and their captions
Application defined or Object defined error
Re: Copy/Paste Worksheet to last and rename with input box for value.
Parsing imported text file with macro... help!
Tab between ActiveX controls on an Excel worksheet
Fine-tuning selection change event for merged cells & wrap text
relative reference button missing for recording macros
Get Last Unused Cell
Subtotaling within a Macro
waiting for an answer pls excel/vba prob
Ranges between Two Spreadsheets
Lookup Macro Trouble
Mystery Formats
Re: The Reason for Modules?
Re: The Reason for Modules?
Re: Autoformatting
references to command bar buttons
Re: Command buttons in Excel
Skipping cells in a formula
Re: Command buttons in Excel
Checking the value of a radiobutton in Excel VBA
excel/vba combobox problem
Re: Copy/Paste Worksheet to last and rename with input box for value.
Maintenance log
Re: Special macro
Re: Running a macro
Re: adding a number of cells...
Re: Using the results of CELL function ("address" info type)
Re: Find last row; down 2 rows, enter formula
Re: IsEmpty on a range/array
Check for valid SQL server connection
Re: IsEmpty on a range/array
open text file to extract data
Changing Option button values
Saving a TXT file keeping its current location
Re: Calculation Mode
Use of MID
This works but need to extend range
Breaking out of a DO loop in Excel VBA
bug with "CodeModule.DeleteLines"
Re: Recalculation after row resizing
Arguments for a filename
Re: Excel VBA Reserve Words
Is sharing files advisable or not?
Execution Error
twogilvy - yes and no entries
Delete rows
Loss of automated step
I need a macro that will change the color of a cell #1 when a Y o.
using listboxes with excel 2002
I need a macro that will change the color of a cell #1 when a Y o.
Re: I need a macro that will change the color of a cell #1 when a Y o.
Re: I need a macro that will change the color of a cell #1 when a Y o.
Using VBA to delete certain worksheets rows
Enable & Disable Macro popup disappear
Formula too long
Re: Calling DOS commands in VBA
Upgraded to 2003
Help w/ macro to run user form
problems with a multitab form
Using named cells and CELL function
problem with populating a combo box on a userform
WEB Browser Control
Replacing a formula its too slow
ddeinitiate Hangs
Re: How to save a digital certificate?
convert a worksheet with formulas to a macro
Type Mismatch Error
Data Validation Calender Dropdown
Hiding rows by a logic formula
Findlinks.xla - still available?
Border problem with one row but no snag in many rows
Re: get more than 255 characters from text box
Re: get more than 255 characters from text box
Excel VBA - carriage returns
List Boxes in Excel
Time Difference between two events
Label caption on loading a userfform
Vba - opening doc from Excel Vba
colour alternate rows in filtered list
Loop through sheets
copy Sheet and rename it!
Multiple Excel Processes
Is there an update to this?
referring to a range
cell value in edit mode with COM addin
A bug in Excel???
Save a copy of a Workbook without its modules
Fixture Lists
populating a combo box on form inilialization
Assign relative cell reference to variable
Vlookup in VB code
Programatically read & write excel cells
FullScreen Mode Horizontal ScrollBar Missing
Message box to show cell value
Vba - Log in user name
events
excel object event handling
Extracting data from one row across multiple columns
Finding closest value within an array
Time format
Application.ActivePrinter???
drawing
Creating command buttons beside every row to execute each row macro
Please tell me
Input Box Cancel Event
Read from an ascii text file
Can you fix this?? vbreadonly
VBA - Progress Bar
Using VB copy contents of a macro to workbook
Copy & Paste+Offset
Database
Can't see macros with parms in Tools -- Macros
Copying Formated Text
Lat & Long to V&H
Input Box please
Selecting a ListBox range
Translate range name passed as string to a custom function to range addresses!
Yes or No
Type Mismatch when creating a pivottable macro
Listbox multi selection
Trim the last two characters?
New Range resize Question
ç”µå*è¡¨æ*¼åœ¨ä¸*æ–‡è¾“å…¥æ³•æ‰“å¼€çš„æƒ…å†µä¸‹ï¼ Œæ—*æ³•äº’ç›¸åˆ‡æ¢
Auto email
edit data while form open
why can't we use the macros in purchase order template
Qn: Worksheet Open???
Method of Data Member not found
Audit Programme
Print# Statement | Leading zeroes
Posting through Google versus Newsgroup
How to create two validation lists that modify each other's value?
Vba - Password
UserForm OnAction
Re: refedit control in 2003 and managed code add-in?
Re: How do I open a .xls file?
Re: How do I open a .xls file?
Always prompted to save even when not modified
R1C1 in Excel 2003 VB
Range resize
formatting cells
pivot table chart/graphing
Kill variables
macro for coding an id number
A problem with found a value on a column
macro buttons
Getting Selected
Hyperlink to new window
How do i enable a function to change other cells?
worksheet copy method
Excel VBA - Text Boxes
How to access MS property "lastsavedby" for a file
Events for a Protected Worksheet
Excel 2000 Tab Color
Extracting data from one row across multiple columns to form a lis
Track Change, Help!
Very small macro/VBA stuff, deleting rows.
Following Hyperlinks
"The Matrix " effect
vlookupmatch 2 criteria
Excel VBA - Copy cell value
Help w/ Vlookup or similar
Excel Chart Location
Re: Lock cell
Re: Lock cell
there must be a better way - ensuring userforms are closed
Re: Lock cell
How Do I Copy a Website Page To A Sheet?
Re: Lock cell
Re: Lock cell
Serching column/range for specified data
ServicePack 2 and Office 2000 - Deleting OWC
Frequency
Find the first empty column
run time error 91
how to use macros in excel
Compatibility Issue on VBA commands for Excel
Controls in protected sheet
Delete Protection.AllowEditRanges
Help. Excel Printing Macro
Problem with the excel protection....Please help.
Treeview
More than Once
Tally Sheet
Double click to print active range
create form
Finally, a SIMPLE solution for Excel file Consolidation
Add-in loading problem
Vlookup & Find
Re: Creating Non-Contiguous Cell Ranges
Pasting a portion of an array
Double-click Event question
sumproduct issues?
Qn: MousePointer
Qn: .FaceID??
How to distinguish the method Excel was opened?
Creating Non-Contiguous Cell Ranges
Defining a Range
Simple question: How to get web query to NOT overwrite data when it refreshes?
Set Saveas Filename from Cell Contents Using VBA
UserForm Date Validation
Excel Workbook
Re: General Question regarding passing cells, ranges, cell values through subs & functions
Display selections from a listbox in a message box
Set variable to clipboard contents?
Excel drop down menu
share adodb connection in excel
Parse (TRIM) File Name into seperate columns
Re: General Question regarding passing cells, ranges, cell values through subs & functions
How to find out the data type of a variable in VBA ?
Save Selection
Debug Problem
Excel Data drop down menu
looping through and organizing a large amount of data
Forms and Exception occured errors
Filling values to columns
active sheet
Modify this code to paste special, values
How can I program a 'roll' of text, eg ABCD - BCDA.
using Database in EXCEL ?
Using macro to insert a symbol
Use ADO in VB to read excel file problem
Code drag and drop
LISTOBJECT question
Loop through data for conditions and create a new sheet
how do i get an error message if identical data is in two or more.
select merged cells
Wishful Charting?
MACAddress trouble
Detecting Mac Plataform
how can i get rid of dialog box?
Copy large data from Form to Excel
Re: General Question regarding passing cells, ranges, cell values through subs & functions
setting Bold
Is this Possible
2nd Form deselects list box items on main form
Loading in the BODY section of HTML from a web page
How to add cells with yes and no entries
Incremental Cell Movement
Re: General Question regarding passing cells, ranges, cell values through subs & functions
Flashing Cell
Count
Automated Web Query / IQY / organizing results
write one column range to text avoiding final linebreak
How could i enable insert picture from VBA?
Drop Down Boxes (Lists) How to do
Quit UserForm and Procedure
how can I change the language from spanish to english?
Yes/No Button Again
Re: General Question regarding passing cells, ranges, cell values through subs & functions
Excel Problem in detail/updation, deletion
How do I remove a blank space on a set of address labels when u.
Excel VBA - Userform updation/deletion problem
General Question regarding passing cells, ranges, cell values through subs & functions
Help on choosing the right way
immediate help please
Yes/No Button
Shell command and exe file conundrum
Newbie Macro Query - Clearing Variables and Assigning a Variable
i need immediate help in vba/excel
excel file/ address book
Adding a new sheet based on a template
Sum the time for a criteria in a range.
Return to previous worksheet after code pastes in another worksheet?
Creating a read only backup??
Can I have a user form with no Header/Caption Bar ?
Can I get a scroll wheel to work in a list box ?
pasting to a location
Compare List - Get Duplicate Values
It's probably simple, but...
Code assistance please
still having problem with open currently open excel file
toolbar("Task Pane") problem!!!!!!!
Excel's VBA MAPI support
I need a design to handle the following
diference between FORMS & CONTROLS
saveas fixed text for unix
is there any Text component ?
Add Date And Time in a cell.
Cell format and Calculation
Application.ScreenUpdating = False and it still flicker !
Can we disable Excel's default toolbar?
Changing Cell Value
Macro Help
Re: Worksheet_Change Still Not Executing....
Re: Still Having Application.Match trouble
RE: Macro to Move cells
Formula Find Issue
Text seacrh
RE: Macro to Move cells
Printing 3 or more sheets into 1 page
Fill-In Rest Of Column
changing a function script
inserting columns and field headings for years
Re: ActiveCell.Offset w/ VBA
Relative Cell Referencing
Manipulating a checkbox by name dynamically
Manipulating a checkbox by name dynamically
Is there a better way to protect our password?
Can the "Save" process be speeded up?
Re: Range Copy Problem
Record of file access
Web Browser Control
Using Pictograms
Open file when Excel starts
Delete All Rows That Column A value is not in Column A of Sheet2
How to exclude 1st row from printing?
(xlToRight)
True False statements
Is there a Filename property in PrintOut property
Duplicate Checking in Excel
OnTime no workie in Userform
Auto Create WorkBooks from Master File
Re: How do program a prompt in excel 97?
CommandButton Text
Re: How do program a prompt in excel 97?
RE: Dynamic Ranges that do not use COUNTA($A:$A)
text find
Arrays in Excel VBA
Re: How do i comapre 2 columns
Re: Dynamic Ranges that do not use COUNTA($A:$A)
Side-by-Side worksheets
RE: Need help working with Sheet arrays in office 2000.
Update - Include cell contents in filename automatically
This File Name
Conditional Formatting / RTD functions
Turn off the Customize Bar??
Turn OFF Formula Bar???
Row Number
sendkeys "^v" behavior changed with the office 2003 version?
checkbox code makes excel sloowwwww...
Re: find 100% by column and color cells
QN: Userform Name Search
Re: find 100% by column and color cells
VBA code to call the name of current file
Multiple Selections in a Combo Box???
Disable Auto_Open with VBA
FTP Files from Excel
VBA prob-GetOpenFilename with multiselect=true returns string
Syntax error (simple)
Error in Microsoft-Query ORA-000923: FROM keyword ...
counting filtered rows
worksheet functions
Adding a default reference
xlb file compatibility
Automation Error `-2147221080(800401a8)`
excel->word
Referring to an option button in formula...?
Re: Vlookup in VB?
Re: Vlookup in VB?
Launching form
RE: Excel crashes during a module execution
Re: Vlookup in VB?
Re: Vlookup in VB?
Macro to run in same row as selected button
can't find macros in template
programmatically refreshing data
Coverage of a List of Lotto Tickets
Why I got wrong result from nested function?
Add references
formulas in pivot tables
Keyboard command different when protected
VB to automate ID coding
CurrentPageList
Selecting a sheet by codename
DTS: SQLServer to Excel in unattended server environment
Re: Sort problem (one column)
working with grouped rows and columns
Delete Worksheet with VBA
2 Part Question
Excel function help
problem using protected sheets
Type Mismatch
Named range returns 1004 error
Open a workbook listed in a different worksheet (hope this is clearer!)
Unique Macro
Pivot Table & Dynamic data
combination data from Multiple Worksheets into 1 Worksheet
Macro help required for updating old sheet with new entries
Dumping Clipboard Memory
Re: Modeless Userform problem
Adding a new sheet (no focus)
Setting up an alarm in excel
Linking to other applications
Retrieving Registry keys
Reading files according to the web address in the datasheet
Help cleaning up some Strings
tracking changes using worksheet calculate
Generating lognormal distribution
Re: Worksheet_Change Still Not Executing....
Peter Huang, Vasant, Chip Pearson - Close External Application VBA - ZABU
Qn: Password secure a Menu Bar??
Target Cell Problem
Windows Timer crashes Excel
AutoFilter Automation from VB.NET
Re: Worksheet_Change Still Not Executing....
Help: I need a sheet to be opened based on a cell value
If Statement Help
Re: adding columns - having serious difficulties
Re: Worksheet_Change procedure
Worksheet_Change Still Not Executing....
Qn: Column/Row Hide??
Re: Worksheet_Change procedure
Can't figure it out
Re: Worksheet_Change procedure
Worksheet_Change procedure
When to use a stack?
Re: how do I format decimals
Re: how do I format decimals
RE: how do I format decimals
Averaging adjacent Columns
Turning Validation on/off on a series of cells
Deleting the number in the first line of the address in a cell
QN: Refresh???
Chip's ColorIndexOfCF Function
Re: Still Having Application.Match trouble
Re: "Comment" in an "Oval" ?
RE: =Text(cell,"000000000") in VB
How can I download Excel for windows XP?
dynamic sheet copy
Operator syntax - VBA problem
Find and return Multiple Values to a single cell
RE: Data Conversion (Weekly 2 Monthly) ???
Re: entering dates on sheet 2 of workbook
Using code to stop a macro.
Qn: Best way to search a database to match a last name??
ActiveCell.Formula Help
Re: "Comment" in an "Oval" ?
Re: Adding a menu item right click menu when clicking on a single.
Visual Basic Mail Question
Adding New Rows in VBA
Save to Path & Variable file name
Cell Address help
draw borders around deleted duplicate cells
Can't get a value out of a list box
Unselect a Cell??????
delete row programmatically
Newbie - Move Selection one cell to right
Using SUM and getting #Value!
Lookup Value