Excel Programming [Archive] - Page 117

Formula
Need help with macro to move cell data
Access Recordset Rows to Excel
Data Validation
Re: Sheet Protection
Installing .xla add-in via the registry
Opening an add-in hangs when run from scheduled task
concatenating phone number "segments"
SaveAs Method changes Worksheet Name
SaveAs Method changes Worksheet Name
SaveAs Method changes Worksheet Name
Custom Function in Array Formula
Checkbox to hide/unhide named range
Convert Range To JPG (Resized)
suppress the replace-messagebox
Issue with parsing text file into worksheet
Worksheet copy speed
Private Sub Worksheet_Change(ByVal Target As Range)
Corrupted Excel file - but on only one machine?
Hiding the macro
How to avoid Update Links notification?
array for email attachments?
freeze cells
group data
Ensure Addin is loaded properly by user - no double clicking
Combining Data in Multiple Cells
How to hide a column once any cell of that col. is not active any
Re: Files won't open after running a macro
Format of Variable
Don't show sheet switches when running macro
Re: Isolating New Entries
How do I write a macro that hides a row based on data in Excel?
File Linking Problem
Re: protect/unprotect a VBA Project
Forms
Upperbound of Selected Range
protect/unprotect a VBA Project
Macro to strip out certain rows
using Excel with c#
time/timing/breakpoint
Stepping through an autofiltered list
Copy text to specific cell.
PublishObject.Publish Error
adding values in column D where cell in column A contains certain
Find String Excel VBA
Manipulating Access database using Excel Userforms
Macro to update pivot table data range
How To Loop From File0001.xls To File0150.xls
variable length more than 1024 - how to show string complete in excel?
EXCEL
creating folders on hard drive from name field
Re: Creating Custom Face IDs for Add-In Buttons
coloums comparison in excel
Re: BCP Insert Into Excel
Print problem
Assigning Macros to Toolbar buttons
Extract rows with specific text in a column
accesing controls in for each loop
Variables Between Workbooks
get current value of cell containing formula
The Form option
RE: Simple Userform
Re: How to put a button made through Control Toolbox
Data base Book
STARTUP
Selecting Sheets based on Cell Criteria.
Best way to set up worksheets
Macro runs on certain worksheets, not on others
ActiveSheet.Protect
Conditional Numerical Formatting
Howcan I delete blank rows efficiently
sorting time in a column
Re: Creating Custom Face IDs for Add-In Buttons
How do I Address A Worksheet From A Cell Reference?
How to Insert Dashes
top/left cell borders don't show
Show form based on file type
Re: Autofilter problem
adding cell data into a macro to allow specified information filte
Re: How do I get the column of a cell?
pivot table comparison
Copying a userform into a new workbook
How do I
Backward compatibility for VB6 COM Excel Add-In
Password Protecting Macros
Range problem
Conditional Formating
how do i append from several excel tab to another?
Creating XL links in VBA code
Page Setup not selecting
Address List
Worksheet Change event
Workbook_Open event not firing
DisplayAlerts & ScreenUpdating Properties Changing Unexpectedly
A function that separates hours worked in work shifts that overlap
Drawing Arcs
Excel Date Time to Unix Time
faulting module vba332.dll
Auto Running a macro on open
How to Check if a Process is Running
How do you get rid of a link that doesn't exist anymore?
SelfCert and other Cert authorities
Add VBA code to multiple WorkSheets
updating pivot charts with vba
Script out of range error
Save Excel file as HTML - with headers/footers
share excel macros
Convert SQL query Sub to Function
Find numerical values in one cell,within another cell- is it possi
How to stop the user from seeing what's going on
Incremental Numbering in a Column w/ Specified Text
Allow user input into VBA Module?
Inserting Rows into a worksheet
Find first occurence of specific data in a column.
Sort order for graph and not spreadsheet (dynamic)
Print dialog - force it to show up?
Error Handling problem
SAP / Excel
external data
determining a price based on 700 combinations
SaveAs with a twist
Data is on several sheets, i want it on one...?
Mental Block! - Event Change Conditional Formatting
Copy Past with macro
Stop Formatting text as DATES???
Inputting a filename into a cell
Check columns for data match...
Re: How can I "set" a checkbox name like i Set a worksheet?
Hi Bob
How can I run solver add-in in a macro?
Spawning worksheets and a summary per worksheet
comboboxes
Convert Number to Words (Indian Format)
Deleting a 'workbook' macro
How to cancel a calculation in VBA
Place Shortcut On Desktop
Automatic total of more than one invoices
Is there a conditional formula to hide and unhide columns?
is better excel or acess for visual basic
Auto-Open procedure
Macro to export a worksheet and save as new file
Simple Macro Question
menu bar keyboard shortcuts intermittent.
Prevent PageDown
Row Number
Help with Macro or VBA script - Insert current Time/Date for different records
Look for a string in filenames in a folder?
How to find next empty cell within a column?
Advice on formula Please
day of year/week of year script
Corrupt file, please help ??
Excel ActiveX causes lost Class Module reference
SaveAs macro: How do I specify "Replace existing file?"
Batch file to start multiple excel files with auto_open() macro. Delay code needed
Mouse over message
Merge Two Spreadsheets into 1 new sheet...
Can't hide/unhide rows under worksheet change event?
what I need is a first-if formula
Forms? Want floating user-option menu in worksheet.
identify active sheet
Can PrintTitleRows method be restricted to a region instead of the whole worksheet ?
Date formatting
sequential Shell commands?
Understanding Templates
interface with other applications
File Save … Lockup/crash Excel
Free Tool (Add-In) for Improving Your Data Processing Efficiency
PIA distribution
VBA macro in Excel toolbars
Overlapping conditional formats
Differences in the way a .xls file is opened
How to force Excel always show the max/min values on the axis
Extracting Modules to Compressed Windows Folders
Excel, Macros, Database
Using CodeName when Selecting Multi-Tabs
For Each Next woes
Hidden workbook properties/methods
VBA Reference Library ADO 2.7
Excel cell format
Pass variable from user form to macro
Shortcut Key to insert an em-dash?
Maintaining links to cells for database query ranges
Deleting Worksheets in VBA
disappearing ActiveX controls
Pivot Table Drop Down.
Hide/Unhide rows
Formula vs data
macro to transfer info
trying to be clever
RE: macro to transfer info
creating pivot charts from multiple pages
command bar problem
Non embedded chart location
Programatically control picture property of Image control
Mouse pointer position, excel2002
triple state button question
customised sheet
finding the right file
Linking Combo Boxes
Another save as question
Protected worksheet and Outlines
UDF parameter description
How do i reduce the thickness of Border in Excel?
Assign macro to a button problems
Runtime error 1004
Count Number of full rows
Change cell colour for a cell or range within a predefined range
Data Adjustment
Dataforms
Calling the Print Form
Use MS Query in VBA to only get a SQL statement
Convert Normal formula to array formula
Do within an If statement
Macro no longer runs
input of text longer than 5 rows
savin from excel sheet to MSAccess
Help on printing comments
How to run a macro every March
iterating over a filtered list
find word in a cell then change cell format
Dynamic Web Query from VBA
Hyperlink dialog
Having trouble getting sort to work in a macro
Excel formatting and Acrobat Distiller
Activate Form using a macro
Problem adding charts using Do-Loop Until loop
add-ins & events
import tekst >65536 rows
Msgbox to make a choice
how to identify built-in Names
having the same name for a lst, on multiple sheets
how change date format in range?
worksheet tab position--possible to modify it?
Cells.Find , why it DOESN'T search ? help
Count of FIRST Digit
can we color a cell content partly?
Getting cell address from input box
timer
Bordering
Copying a line
Putting plain text string into clipboard in VBA?
Finding Data
excel 2003
How do I insert symbols using VBA?
Timetables - next departure how to find relative to system time
How do you sort 9 digit zip codes in Excel?
Formula NOT working
Formatting a cell to display varying decimal places.
Versions and compatability question
Building Forms (like a command button) into a cell
How to Stop ReEntry
Secondary X Axis - using named ranges
Secondary X Axis - using named ranges
Trim Data in a Query
Missing WrapText from range object in Office Web Components
add event to controls added in runtime
Working application - Now generates error
excel to pdf
Common Dialog Control not properly licensed
Common Dialog Control not properly licensed
Common Dialog Control not properly licensed
Microsoft Common Dialog Control
Choosing from 2 formulas for one cell
Line of code hanging up on one machine???
VBA codes for macro to continue
conditional if then's
Excel Add-In with Command Button Controls
Sequence Part Two
Lookup function
Why does this bring up VB?
OLE text runs together
CreateNewDocument : an small but interesting discovery from office
Batch Modification of Ranges (Optimization)
what a help document in Excel VBA! Should be revised for the sake
Excel Graph Click Problem
Assigning backgroundcolor to button on form
Add Procedure To Module Via VBA
GetSaveAsFilename Command Maximixes Window
Forcing autocomplete to lookup from a range of cells
macro to find and enter
RE: macro to find and enter
external data from multiple sources
Add lookup to for next
Creating a listbox from a column
Opening workbook with OpenEvent
How can we return to default values?
Autofill method of range class failed - sometimes
Not programming , but chart help
Printing Problem
Re: Compile error: Procedure too large
LEFT embedded in SUMPRODUCT
Type Mismatch Problem
Filter & clear cells
Purge Data Based on Cell Color and Time
Auto-generation of pivot table from XSL stylesheet
Using a variable in a range
Sequential barcodes
Determine the size of a range
Excel 2003 graphics are invisible after loading xla
how to avoid merging when pasting multiple ranges
Making hidden graphs visible or removing
How to stop UDF firing when sheets(n).calculate
Detect when a UDF is being edited in the Function Wizard
Combine row insert subs
Set Column width
How can I disable Subtotals?
Saving a Worksheet Shape to disc !
Make macro-button sheet reference relative
How To Fill 2D Arrays Easily
Saving a Worksheet Shape as a Graphic File !
Get names from Access table
ScreenUpdating "peephole"
Skip Autocomplete if need be
Custom Menus Error at Close
How to update a control without screen flashing
BeforeClose VBA Question??
QueryTable Questions
How do I change a cell's background color randomly, continually?
Debra Dalgleish: Pivot Table problem
Long Excel Formula in VBA gives error
Opening a Workbook in the Background
Is this possible ?
Select Method of Sheets
HOW TO FIND SOMETHING IN ANOTHER FILE, WITCH IS NOT OPEN?? HELP ME
Copy/Paste Formulas Without Linking Books
merge excel and word
Error in large file import macro
How to create a Text File ?
Question about XML compatibility in Excel 2000/XP
read serial data
Removing Digital Certificates
formatting question
How do I use Excel for a Univ. level course scheduling tool?
Color lines of a combobox
RE: How do I use Excel for a Univ. level course scheduling tool?
macro to write other macros?
Cursor gone beserk, apparent overdose of steroids!
How to Save As Variable File Name
Sum Formula
Enter formula and fill down
"delete method of range class failed
Trouble with select statement
Insert Column
default date in Excel
exporting data to appear at Bookmarks in a Word Document
Error accessing the system registry
listbox problem
SQL statement slower when refering to cells.
Can an Array formula count unique values and report no. of times for each?
exporting Excel data to Word using Bookmarks
Delete/clear a cell based on another cells contents
Excel forgets Custom VBA Function (#Name error)
Need hlp capturing a certain pattrern from a column
What did I do? (Select Method of Range Class Failed )
Crash attempting to open Excel Add-in using .dll file comprised of VB6 code
Not Enough System Resources
Digital Certificate
VBA to find a value in a list
How can I delete a macro in excel?
Compile error, variable not defined
Using ADO to Query Excel
Where to Place Public Subs and Functions
Formatting cell
Multiple formula entry
accessing controls
Run only part of a macro for testing
a simple macro
removing (All) from Pivot Table
auto count possible?
linear graphical method programming
Getting chunks of 200 items for stock query
Macro button on one sheet only
number of lines of wrapped text
Countif a Name occures in a column
Problems targeting any version of Excel
Tom Ogilvy - More help please
Folder name
Saving file as a date
User Forms
How to make macro available to all workbook w/o opening VBA
pastespecial question
File too large for Excel?
Protecting Password Info within a macro / Workaround
Loop through array of worksheets
Postioning of labels on charts using vba
Compatibility between excel 97, 2000, xp and multilangual user interface pack?!
Programming pasting charts to work problem
MOD problem
CSV files
Help!! Need to retrieve forgotten password...
UserForm Question
How to write a statement about if then
familiar with Oracle Objects for OLE?
Override No Zero Values ?
Dates Format changing when copying data between workbooks
Toolbar buttons are gone
Using macro to do cell matching
How do I create a macro with relative address?
Complex formatting help
Validation List in other file
Validation List in other file
Cracking 'File Open' password
Is there a patch available to go beyond 256 colums. I need 365
Is there a patch available to go beyond 256 colums. I need 365
pasting controls
Inserting pictures/autoshapes to certain cells ?
moving an image in a userform
I want to delete certain rows based on specific criteria
.XLT with user programming not working through Intranet.
csv files
Code for opening another sheet on button click
Downloading Email attachement from Outlook
Delete Entire Row
Cell Format
VBA - Find command
How do I invoke a MS access form from an Excel Macro
copy range and formats to new workbook
For Ron deBruin - Email question
RGB value of cell interior
Is there SQL access to MS-Access MSysObjects?
Object coordinates
Macro Security Level - High Priority
HasFormula protect cell
Macro help - "Save As" when a file already exists
Excel - One column, multiple widths??
Calendar Control
conut rows within a range
copy dynamic ranges in multiple workbooks based on a data in 1 col
excel 2003 source control
Set Column Width
Linking multiple combo boxes
Finding and Hyperlinking to a file
changing "save as" on menu
problem with relative reference
Calendar Control Action
FileSearch, my code is way too slow
PROBLEM MESSAGEWHEN OPENING FILE: Installing Excel Feature
External SQL Data not updating in spreadsheet when loading in OWC
RE: Why is Not not Not?
Save As Change
Highlight / "Selection" of AutoShape Text (Like SelStart for TextBoxes)
how to create help file in UDF
Flipping a name
Excel VB-Copy formula down until adjacent cell (left) is blank?
VBA excel formatting properties not accessable
VBA Coding (?)
copy from a textbox
RE: Flipping a name
Formatting Form Text
RE: Flipping a name
Quick Syntax Question
DocumentPrperties Collection
Strange macro behavior!
txtbox problem
Command_Button?
Count number of rows with actually selecting
Sorted Fixed Length String
Lookup
Using VB to to create named ranges
Inserting html line breaks into excel.
Re: Why is Not not Not?
Outline.ShowLevels rowlevels:=1 is slow
Auto-Layout Shapes in Excel
command bar problem
TEXTBOX QUICKIE
TEXTBOX QUICKIE
TEXTBOX QUICKIE
start excel (excel2003) via OLE-connection - no personal.xls???
Splitting Long Line
how to get a macro to store address of a cell
Copyfolder
Count files in folder
FileCopy
Change Table Name
Reset / Undo
Reading from a excel sheet to an array
Blue Screen of Death Using Dialog Boxes
chinese version of a vb programme
C# Excel Doubt
Userform button
Controlling the movement of a drawing object
Run a batch file from Excel
VBA Bug with conditional formatting/printing?
Populating one cell with the physcial location of a different cell
set up data source of excel spreadsheet
Spelling check in excel
Runtime Error '13': Type mismatch
save file
Multiple Selects
Setting Print Area
Populating a cell with the current value of a variable
creating new workbook macro
Range error
Adding Chart - Methods Fail
Exchange Server Alias
events doesnt work
Seperate data and design-style in Excel
resize rows and column
Find and Replace dialog box in VBA doesn't work suddenly
open excel sheet...
pasting array output to sheet
How to diasble the 'Tools - Options - View - Comments' options?
Formatting Combobox
Count duplicate values in worksheet
BeforePrint Caption = ""
need some help
Want to use standard excel functions in vb
Grabbing Data From Second Combo Box Column
Date Tagging User Entry
Convert decimals to feet / inches in excel
File Origin Japanese when importing textfiles
pivot and vba
Recalculate sheet & Positioning text boxes
Input Message macro
why does this fail?
Help! Need quick answer how to handle no data condition for filter
Return boolean if sheet is currently protected
formatting numbers
Newbie form show prob
Save lookup data in template (.xlt)
proper form
Help for comparing data!
CAN I MODIFY DATA ENTERED INTO A CELL
How can this work?
How do I create Unique headers on every Excel page with VBA?
Number Sequence
Excel-VBA: "1004 - Method 'Range' of object '_Global' failed"
HELP please
HELP!
Template
Change LBound of array
Protect/unprotect worksheets
Probability of dice throws
How to use ADO to change Pivottable sourcedata query
Drop xls ext
public array
On-the-fly determination of object type?
Changing a dial via VBA
Chart Dynamic Range problem
Delete rows
Replaceing destination cell contents with new data in Excell
Pivot table missing columns...
Date Format Problem
diabling save
dropdown list help
Why Am I Getting Links and How to Avoid Them
Trim not working
Problem with an equation.
Macro to copy current cell
named range, conditional formatting
ODBC and VBA
Renaming worksheets
VBA Control over Shape (combo-box) created directly in workbook
Problem of saving sheet name for further use
Dropdown box from another file
Running Macros question
Value to be given to all cells with black background color
Page footer: page one of x, sub page a of 2
MATCH output error #N/A
Inserting pagebreaks into an Excel Worksheet
named ranges and copying sheets to another workbook
Changing a cell's number format
variable cell referencing for simple data points
vloopups
Open Workbook if not already opened
Macro Syntax to copy and paste dynamic data based on one column
Automatically multiplying totals on a userform
run time error 1004
Get data from different worksheet
Option Button as default
Inserting rows in Excel
ending subs
Check on the input in an inputbox
Cost of a solution from Excel to VBA
How to automatically change the referenced worksheet name in all formulas?
Insert Character At start of cell
Change Date format
creating excel doc without office
Retrieving data from a password protected site
give cells the same name
save active sheet
req :Mackro for removal for emplyspaces in cells ?
Object doesn't support current locale setting: 'setlocale'
check number on a form
How can I Crack Excel File Password?
setfocus does not work as expected
Student needs formula
Converting an array of data to a bitmap
Problem sending merge info to printer
Automate copy.paste of standard sections of emails into Excel
Getting Rid of Annoying Prompt
how to increment no on excel spreed sheet
Formatting certain text within a cell
Activate a Worksheet from a Custom Function ??
Renaming sheets from a list in a column
Leftmost part of screen "blued" out when calculating via a macro
Get list of running applications
Deleting all Range Names except Print_Area?
if cell has null value, move data from one cell to another
Adding ToolTips to buttons
ComboBox Issue: Write to WorkSheet
combining worksheets and lookups
Delete row in Excel 2002 worksheet
quick list of directories..
Run-time error '1004': No cells were found
Run-time error '1004': No cells were found
Windows Excel application on Mac
Adjusted R Squared with VBA
Replace text in an XML document
How to declare a variable for several subs
How to Sort/Alphabetize Worksheets by Name
Dynamic Comments/Validation/Text Boxes
"Date" format after CSV import...
running commands from hte shell
Excel VBA: moving folders on the server
Workbook_BeforeSave() 1004 Error
Filesystemobject Help
msgbox button constants
Interactive worksheet
Pivot Table Code
Copy Filter Selection to a Cell ?
First effort
Excel interop versions
Items in disabled items list - unknown excel addins causing probs
Close UserForm despite Exit Event
Getting user's Date from a Form
Question about PERSONAL.XLS
Empty cells in For Loop
Determining if Other Workbooks Are Open
advanced filter question
returning values multi column listbox
How to disengage the F9 key - Workbook_Open?
Excel 2000 VBA - Delete Rows That Meet Criteria
How do I perform a function based on certain criteria?
Transpose into comma-delimited row
Copy Autofilter results macro
listbox not updating
Creating Sequential Numbering Macro for an Quotation template
How do I define a macro that will generate VBA code?
vba help pls - find min based on a condition and return val of an offset cell
Should Be Easy - Relative Macros
Simple Macro Modification
Disable an Autostart module
call a macro in another worksheet?
Insert the value from an input box
Read Excel Spreadsheet Via VB.Net
Help with Macro and cell copy
Thanks to Tom Ogilvy
About list boxes
Auto run a macro to get a table result
Splitting a sheet between multiple new sheets
Saving attachments from Outlook
How do I extract the date from calendarcontrol 11.0 in Excel?
excel calendar years
Copy a range in two different workbooks
naming sheets
Re: The world is really full of spammers these days......
Name look up
It doesn't work in Windows XP?
setfocus on user form
Expiration Notification in Excel
Auto color fill in Excel - help
Macro for Text to Columns - convert to text or general
Problem in Variable Scope
Copy & paste image from UserForm (repost)
Calculating Appreciation for a property from purchase date to pres
Using Varying Range Size in Macro
Polynomoal Regression
Formula for Replacing Text in a String?
Automatically enter password
Capture a part of a screen
Need correct list property for coding a macro
Date/time groupe
object selected on a chart
co jest wybrane na wykresie ?
SaveAs and File Exists
Merge cells with C/C++?
make a pivot out of a selection of pivot
Why does macro speed slow after Excel Print or Print Preview?
Userform Advice/Help
HOW TO RUN MACRO ON ENTIRE COLUMN
Wrap a command line string
Shell command and Notepad
Excel VBA Projects & Visual Source Safe; WinAPI, Code Librarian.
Menu Name
activex controls
Change looping process to ignore certain sheets
Excel FileSaveAs dialog freezes when used via automation from Access
Changing the workbook reference
Maximum number of Name ranges
How to crack "Protect Sheet" Password in Excel?
delete a node in treeview
Personal.xls & Workbook_BeforeClose
Purpose of EntireRow and EntireColumn
Filter Range Not Working, Removes Total Row??
Re: Running web queries, where find data?
code for pictures in comments
Still need some help with nested macro.
Re: Open a pdf file from Excel VB
How can I navigate throw multiple Web pages...
Re: macro runs if I Clear a cell
Re: Filter Command just one Cell, not whole row?
Re: Subtotal by Year, Large Spreadsheet?
Re: macro runs if I Clear a cell
Displaying Combinations of Rows
Re: Object required?
Re: Subtotal by Year, Large Spreadsheet?
Jesus said, "I am the way, the truth and the life: no one can come to the Father(God)(in Heaven), but by me." (John 14:6) This means that if you die without trusting in Jesus Christ as your Lord and Saviour you will die in your sins and be
i want to give more than 6 condition by using if statement
View Zeros
Match Cell content in another workbook question
Importing Text File with more than 65536 rows
change from DialogSheets to Userform
Protecting Multiple Workbooks?
Type Mismatch error & subscript out of range error
fly wheel on a mouse and a userform
Re : Excel Experts E-letter (No. 19) ; POWER FORMULA TECHNIQUES, Re-Visit No. 2
Formula Help - Logic Dependent on Other Columns
Compatible with Office 97
User forms to display data
Countif UDF???
Array function
Find the Page Number
sum formula in a form
Open attachments and run macros?
Copying formulas between workbooks - help needed
TEST
Linked toolbar
need VB list property for file contents
Worksheetfunction.Vlookup
Pilgrim needs help: Effecting keystroks required by a macro nested within a macro.
save from template to worksheet without update commands
If condition
Copy Worksheets Error #1004 Work Around
How to remove 1 bar from bar chart??Thank you!
How can i set up a MONTE CARLO SIMULATION macro in Excel? thx
Date Time Picker custom format property ?
Locked Cells?
2000 vs. 2003: Grand Totals
Restoring Toolbars and Other Things
Query Macro
Won't accept sheet name
Positioning a cell at the top left of the screen
inefficient code?
VBA Help File Locations
Hidden Column
Perform SQL command on Disconnected ADO Recordset
Application.WorksheetFunction._WSFunction
execl to check if another excel file is open...
Reaching the end of the values in the sheet (end of the file value
Hidden Thai functions
SQL.REQUEST Returns Single Cell
Find code behind custom form
What formula will read 2 separate values and give me a 3rd value?
Can I simplify this function
Help with Solver Code
Clear cells range if certain cells are all empty
Copying a worksheet from a different file into existing (VB-6/VBA/
setting object variable
Excel 2003 macros don't work in Excel 2000
Strike out feature
Action on Multiselect Listbox
Using textboxes to get dates
when I copy a worksheet I get message "name already defined"
Validate textbox entry
ADO Returns Only Last Record
Compress data in an excel sheet
How can I display a value from a spreadsheet cell in a column in a document library?
Export To Excel From ASPNET
Apparently Simple Question
Listbox with gridlines
Follow up from Bob Phillips' Answer on Programatically Making Chec
Macro to delete Defined Names
Deleting unused Defined Names in a workbook?
Detect Outlook
Return cell co-ordinates
Add item to sheet right-click menu?
Creating a excel file
Is there a 'WORK' menu in Excel ? (same as WORD)
Re : Excel Experts E-letter (No. 19, Re-Visit) ; POWER FORMULA TECHNIQUES
Re : Excel Experts E-letter (No. 19, Re-Visit) ; POWER FORMULA TECHNIQUES
Re : Excel Experts E-letter (No. 19, Re-Visit) ; POWER FORMULA TECHNIQUES
cell referance
Pivottable
Detect Outlook is running
how to apply button text from macro?
reordering text and numbers in a cell
RE: Lock Column
Re: Lock Column
Re: Lock Column
Help with code?
Draw a chart
Delete same Rows/Columns from two worksheets at a time
Same-sizing multiple axis on number of pivot charts
Where is change history stored in Excel Object Model?
Dialog sheets "control toolbox" not functioning. why?
New line character problem
Leading single quote
Check if a value is found twice in a range
help with named ranges please
How to define variable
sorting named range
How do I code a cell to display the current date on double-click?
Can't read optionbutton values
Microsoft excel macros Programing.
Security Levels in 2003
How do you display a VBA user form when starting excel workbook?
Formating Combo Boxes
Event change freeze my workbook
DT Picker
resize my userform
putting values into cells is slow
Sort Problem
Evaluate error when using 2
This one's more serious
Quick and Easy Part 2
Licensing of TreeView
Opening and Testing Large Text File
Dynamic Ranges?
Checkmark on Menu Item
Add a value from Excel to a form in access
Quick and Easy!
Refresh Data
not sure if this can be done rolling averages
RE: Refresh Data
RE: not sure if this can be done rolling averages
Inserting data from other workbooks
SAFEARRAY [in] and [out]
Strange Values
Strange error on function
optional argument in a function
name of a macro to auto run
Access 2002 VB Module controlling Excel 2002 spreadsheet -Run-time
Cancelling directory dialog box
Problems creating my own ifmacro function
new entry in list
Solve operators within a string...split?
Can't find worksheet?
Listbox Column RightAlign with RowSource.ExcelRange
how to add _underscore to VB button on worksheet?
list box updating itself
How do I initiate a Visual Basic Module in Excel?
custom menu cross contamination between open workbooks.
Date Format problem
listbox query
Returning Outlook email addresses
Looping Through Worksheet
Data Validation If statement moved to userform
function "compile error msg: procedure too large"
Suppress First Page Header
Cell widths when filling a cell using ADO
How do I write a macro to delete all rows from the first empty ro.
Checkbox like inputbox
picture as link in Excel generated html
Populate unique list in combobox
Current Excel Positioning Question
Right-Click Menu Items -- Duplicate Entries
Date values Problem
copy paste (column width prb)
RE: Error in FM20.dll when inserting userform
Not Printing cells
selecting variable rows in a macro that creates a pivot table
On Change (Checkboxes) or something similar.
Problem with the import of a database table into Excel 2003.
Cell Value
Group data by UK financial years
Worksheet Name in Sequence
Converting a link to a value
populate a list box with different data
run a marco automatically
How do I get right use on New Database Query
VBA (Optimization) Help to replace inefficient Do .. Loops ...
File, properties, title
Class group of Textboxes
Adding help context to personal function
calculate days
marco after selection in PV table
HELP 2sht comparision Macro
Help With ADO
Hiding control...
input worksheet name
how to copy font settings
Macro Creation
customer sort order in a marco
LOWESS curve calculations
hide rows with specific contents
Can email be sent when cell value reaches specific value
Cursor not to move when pressing the enter key
how can I update multiple worksheets at the same time
TreeView Image List
Alternative to QueryTables.Add method or Range.CopyFromRecordset???
opentext method of excel workbook object
Update cells at other sheet
Bringing in information from one worksheet to another dependent on the 2nd
Email from excel VBA without Security Warning
how do i create help text to personal function?
identify a word in a string then change the format of that word
Office 2003 Upgrade - statistic function changes?
Stop Save As prompt
App.screenupdating
Setting sheet names as headers with page numbering
Save as txt - extra carriage return
returning values
compile error in hidden module.....
opening file
How to format a range of cells from VB
compiling csv files from multiple PCs
Better way to write this
Running Macro on many files
Can't get it to work
how do I set up a daily average in excel
Check for Duplicates (RP)
Automating Access from Excel
selecting all blanks in multiple columns, then deleting those rows
Check UserForm Values Before Saving
Excel Visual Basic - need help to create a loop of filenames
Help with Pivot Table "BaseItem"
MS Query to read data from SQL server stored procedure
closing userforms
hiding cell values when printing.
DOS command from vba
Why _Change(ByVal Target As Range)
Wait for Pivot Refresh before continuing Code Execution
can't trap overflow error!
ComboBox Filled by Query
using macros to disable excel objects.
Exporting to excel from Access
Can I set a specific excel cell to enter an 'X' when clicked
How do I select specific excel cells to use tab key for?
Check if a cell contains text
synchronisation beetween two excel instances
how to update data on sheet1 and have it auto update on sheet2
Excel Copy Method Failing.
Interface to MS Project
Excell Newbie Question Please Help
FileCopy
Jesus said, "I am the way, the truth and the life: no one can come to the Father(God)(in Heaven), but by me." (John 14:6) This means that if you die without trusting in Jesus Christ as your Lord and Saviour you will die in your sins and be
file properties with cell data?
Disabled Macros
For Each Next
Treeview Control
Excel should allow mirroring of multiple cells
Trapping ScrollBar's Scroll Amount
Error using SaveAs (object disconnected from clients!) then XL Cra
Scrollbar does not work
Help! Find info then copy and paste
Sumproduct formula help
There must be some solution
MACRO Wanted to compare Rows of 2 Shts.
Errors in named formulas after running macros
combo box change event
???
How to make a function accessible for all workbooks
applying rules to Excel Sheets using Macros
program problems with userforms
Clearing Names..
Exporting data from ms-access database to multiple worksheets using ASP
Activate Multiple Ranges
Number of Charachters in a cell
descending subtotals
Please: WHY do I get "Object missing" in line "Do While rng...."
VBA & API - Strange problem using
excel 2003: Module errors
customer quote databases
Open File
On Error Resume Next
Need help to Copy and Paste array using macro
Please Help!!! I sending my post again
How to uniquely identify worksheet
Populating fields based on previous column values
How do I create a new folder using a macro
Web Query Refresh Issues
Macro to paste special value only VLOOKUP formulas
VBA to send to Essbase
Format Concatenated Cell
Transfer data from sheet1 to sheet2
Online Visual Basic Help?
AUTOSHAPE
Returning Values
Spaces and Data Validation
Counting unique items in a list based on a condition
directory browse...
List Arrays of a Certain Size
Automating prodution of test Certificates
killing a sub from within an if statement
Determine if a character is numeric or non-numeric
Determine if a character is numeric or non-numeric
Form Buttons Not Working
ComboBoxOffence reading ComboBoxActivity
Copy From 1 File to Another
WorkbookOpen Event
Format the Default Date
Object doesn't support this property or method
How do I keep the reviewing toolbar from automatically opening?
Copying Down Cells after Unique Filter
compare sheets for added or deleted rows
Call Macro in Add-in
For Next
Insert Rows
Close Excel file without prompting user to save