Excel Programming [Archive] - Page 114

VBA help please !
Problems closing Excel correctly by code
How to Capture Edit Cell Event?
Linking Data
Opening a file without the macro start menu
Override excel's printing dpi setting
autosave
Worksheet Custom Properties
Using VBA Replace function for single quote
Protect multiple sheets in one time
setting format plot area in charts to white(automatic)
Exporting data from Crystal Report to Excel - Need soln
seprate and store string in arrays
Changing Chart Colors
Insert Rows
Break all links in the workbook
Declaring Constants that can be used throughout the Workbook :)
VBA
How do you add 1 to an invoice number in Excel. Formula for this?
Can I disable Worksheet_activate???
Best Way To Install Add-Ins
clock control
How do I use an Intellimouse to scroll listbox enteries in ExceL?
creating function with multiple arrays in arguments
sumif / countif question
How do make it a connection of Access Database from Excel?
Timing Issue??
Need Help with copying and pasting with var.
Need Help With Export Code
Passwords
can't update chart series unless its activated
Looping Through Charts / ChartObjects
Runtime Error on Simple Sort
More used range Q's
Delete Rows based on an external list
Dealing with old higher versions in registry
help again function >vector>function
run-time error ‘13’
Abort recursion
How do I set a comment in a cell with VBA?
Duplicate a picture image into multiple cells
Suppress sub totals on pivot table
How do I generate a list of 5-digit numbers in Excel?
Copy data from 3rd worksheets and pasting to active worksheet
advanced filter
Printing
Help with Macro
Combinations
Concatenate VBA results and an * in a cell
IsNumeric("121d1") = True ??
Help needed - seriously (looping? macros? formulas?)
Yet another error
Combinations
Disable Paste Special
array formula help please
writing information from a userform to an excel sheet
Macros with hidden sheets!
I need Help - Importing name files to datasheet
Creating First UDF
Data Entered in Multiple Rows to One Column
Error message for Imporint External Data
Inputbox Question
Microsoft Script Editor?
VLOOKUP statement too long
Create Microsoft Outlook CalenderEvents from data in Excel Spreads
Copy Worksheet to specific row in another workbook
Using LEFT in a Conditional Format
Worksheet specific code
Creating a hyperlink shortcut in the spreadsheet.
Macro Error
Export from Access to Excel
ActiveX button on sheet too big
Referring to Values in a seperate Worksheet
Cut, Paste and Move to next Row
NOVICE :!! PLS help calling function!!!!
Declare at application level
find next? urgent
deleting rows, endless loop maybe ?
Macros Written in Excel 2000
Userforms Question
Having troubles using visual basic to paste info from one workbook to another
HLookUp
Comments
msg box
Re: Blinking Cell (Worksheet restarts)
Excel 2000 : Error 1004
Financial Quarter from dd/mm/yyyy
auto expand row hieght of merged cells
During filling Excel Sheet copy/paste in Explorer does not work
Else without if?
create named range specific to worksheet
while macro is running...
Invalid watch expression
Howto prevent automatic calculation when open a CSV file
How to "update" SpecialCells(xlLastCell)
Problem in compiling code containing "$" char
Setting zoom of 2 sheets equal
Working on interactive worksheet (need help with highlighting and blinking cell)
Re: Blinking Cell (Worksheet restarts)
Macro updates
Enumerate form items
Controlling dialog programatically
Replacing Formulae With Values.....Continuation
Print Selectd Rows
how to run macro after changes in a cell?
Late Binding to Word Variables
Workbook/Macro/Worksheet Protection...
Possible to see which user is editting/using file?
InStr function question
referencing a checkbox cell address in a worksheet
Hide columns in a group on after VBA-procedure
declaring a certain value
If find is true then.....
lock cells for editing-pawan
Filtering by Cell Background Color
Open Lotus 123 file
Listbox navigation
Module 1 - Subscript out of range error
Linking files with variable directory path
Last row as value
Windows NT - Templates - UDF - Links
Module1 vs Thisworkbook for Macro
Detect if a file is in use or being modified
Database
Tabular to CSV style layout
Creating a function call from from
Problem of Crystal Reports in .NET 2002
can we shrink images to fit?
Passing Worksheet Names as Variables
Difference between XIRR and YIELD
Put items in combobox using VBA and toolbox
send msg same as netsend
Flashing command button
What type of Array is this?
Run macro from an excel file from another one
Need help for a loop
AutoFilter
Using a custom format on the clipboard
Menu-Item and worksheet deletion questions
switching from one window to another
vlookup for an approximat lookup value
Problem with Remove Subtotal in Macro
type mismatch
Clearing a userform
extract information from a spreadsheet
How do i set up a rank function on a list of results?
Union, intersection, join
copy used range across books
Speeding up a Data Validation macro
COM and threading in VBA
Activating the last active worksheet
Do loop skipping
F keys don't work, help
calander control and copy command problem
writing a formula to a cell
Consultant In Atlanta
Compare between String and Value using VBA
Addding a combobox to a workbook?
End Of Month Data Only
Hide/Show Shapes on Worksheet??
How do I run a macro program for multiple workbooks at one time?
Something wrong in one line of VBA code
Replacing VBA code strings by using VBA code?
Align Right footer text to Left
Print only desired rows
Marco for Picuture
Now()
Confirming a deletion
delete record based on a value
SELECT CASE - Which Row am I on?
Excel macro to name ranges.
Trap a checkbox click
prevent event procedure under condition
TOC in Excel
iValue Stops after 10 cells of data
Intptr & Int32
Download image in Source.xls and save it as result.xls
Macro Still Won't Run in Excel 2003
macros or code
Switch names in cell
After Save Event help
Save and Save as Function gone
Combo box problem
I Know I'm Missing Something...but what?
Home Stretch! *
Max numbers of characters in userform textbox and cell
ClearContent & 'Cannot change part of a merged cell' error
keyboard event in user form
More effective code
Object Browser does what?
Code Help ^
Nesting problem?
How to return rangename of selection with VBA
If then and 2 cell values
Converting String numbers into real numbers
Converting String numbers into real numbers
Count number of times a specific number is displayed in cells
Count if with multiple criteria
Macro Help
automatically go to last worksheet inserted in a workbook.
I need help with combo box
Copying
command button to calculate two cell values?
paste in next availible column?
SELECT CASE "Jan-03" confusion
About NUM to CHAR
How do I enable the spellchecker in a protected worksheet?
press button "entra" in web page
active cell in row
Use of Interior.ColorIndex
Cell contain default value of cell above it
How to handle error 8007000e Memory Error
Another way with cell comments.
Removal of standard Delete msg from within VBA
Re: Blinking Cell (Worksheet restarts)
2005 Excel User Conference
Copy to next blank row
Check for existing sheet in book
Disable Copy
Strange Cell Behaviour...?
Create/Update Excel Objects in Power Point
how entries in a column can be put into a row
how entries in a column can be put into a row
How to supply your own web query
Keeping Prying eyes out
"counting" through the alphabet
CountIF on Filtered data
how entries in a column can be put into a row
renaming text in cell
How not number ?
To Display a figure while excel is ready to GO!
Re: Checking if not equal
Checking if not equal
Naming worksheets
Text replacement with VBA Excel in several files
Tekst in een tekstfile wijzigen met VBA Excel
Num convert to Char.
selecting values form multiple excel files into an excel worksheet
Controls on form disappear
Default Printer
adjust range size??
Adding new columns from one sheet to another
copying data
Please help: Coding Problem
Restrictoin of xp windows feature
columnshead with listbox
completely Locked Out
Vary formula based on what another cell contains
Search a Range for a phrase and Format cell if found
treeview node tag hold array?
RE: Create Macro using VBA / Macro
return colmn number + index
Copy web query across sheets
Addin Issue
Duplicates?
Phone Dialer in XP
Button that creates a back up in Excel
time error
Cell Value
textbox character limits
Page Selection
Off Topic a bit... but to this newsgroup
AddressOf Nightmare
Runtime Error
How to do it...
Print - Userform Multipage selection
Sum Columns
How do I stop a macro from running within a macro?
ActiveWorkbook.Protect password:=range("rangename") does not work
MSCAL.Calendar Excel Cannot change Properties Using Macro
Load data into a listbox
Can you print user forms
Re: Another error message
Limit the Loop to 500 Rows
Is there a way to cross data types?
Dim mySheet As New Worksheet
Create scenarios using macro and data in cells
Memory In Excel?
Can one use excel like a chat
message scroll bar in excel
make pivottable dropdown work like the filter.
Insert cell anywhere
On Cell change call
Anyone know of a way, or have a script, to read a TOC from CD's?
incrementing rows for matching debits/credits
Input box and carriage return for chart title
Variables- Multiple forms
Drop list affected by previous choice
looking for a way to make a form Txtbox only visable on Mondays
EnableEvents=False doesn't work? or does it?
Need to identify a column within a range that meets criteria
Don't understand why this formula is not working - Help Please!
How to get a return value from a user defined function
treeView -- multiple selection
row location....hopefully simple answer :-)
How can I Write this to a CSV File Please
Save As "something" then date
Excel-Form to file.txt
Another Error Message
Combining Modules
Control disappears from form
need some formula help please
Pivot Table Macro
form in excel to be attached to the emails address in the form upon sumission
Find Within Workbook using VBA
Excel Dialog Box/Sheet
I get #VALUE in the cell - sometimes
Toggle change control button face id & caption
Reference to ActiveX control on worksheet requires full worksheet name
incrementing every two rows--the sequel
-Help- Sigh...
Enter current time into cell hh:mm:ss
incrementing every two rows
New to Excel Programming
Convert '6/23/2005' to '062305'
VBA code for IF statement with OR?
Copying Chart with Chart Series from Worksheet Name
Code Problem
Recording Changes Made to Worksheet
sendkeys and the "+"
Open Specific Sheet in Workbook
How can you update an array formula using VBA?
Message Box
Lacking in Macro Building Skill...
Extracting parts of a cell
Transfer data from XL into Access: best practice
Getting excel to show mm/yy in Funcation bar like it does in the c
vba for hiding rows
formating military time
deleting rows
Capturing a file path
Re: working with two sheets
Re: Static variable
Problem with running macro on Mac computer
Adding to acurrent Excel menu
numeric calculation in logical formula
active cell issue...
Deleting all dropdowns...
Re: Linking a Summary Workbook
Skipping cells in a Do Until loop
Find & Replace / Loop & Vlookup
export cell value - Date Format
Re: Linking a Summary Workbook
Re: working with two sheets
"Object Variable or With Block Variable Not Set" error help request
Blinking Cell (Worksheet restarts)
Changing Windows Registry from Excel
Removing cell borders on any cell
Sum ? / Numbers with Text
Step 1: EOMONTH Function
VBA Function results in #NAME?
VBA to proctect locked cells in sheet
open pdf files with a certain bookmark or page number
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE
copying row information in a table to another location w/criteria
Run-time error -2147319784 (80028018) when executing a simple macr
If Then Statement in VBA
dynamic pull down menu
removing word for column
Link Increments
SendKeys in VBA
Error 91 on Second Error
Size a check box
Excel seems to hang and cause asp script to timeout.
Efficient Code
Excel not updating
Redirecting macros ...
locking check boxes using a macro
Transfering data to external application
Show / Hide Columns in multiple sheets
IDing cells in one worksheet, find them in another, and copying respective data
C++ to Excel
Hiding Tabs
Cope worksheets and save to location
Time Stamp for specific macro..
Activating / Closing workbook using part name and a wild character
Continue line of VBA code on the next line
Macro for hyperlink -pawan
Date format problem on export to CSV
Pivot Table Selections
calculatedfields
Excel Queries
Macros available to several workbooks
Control Word through Excel
Currency Formating
Moving range to array
can not restor FormulaBar when i close yhe file
wrong date returned on ws.Cells(r,c).value
I'm loosing it: rows in filter
Excel limitation or bug or what?
Show/Hide Columns
Select Case on different worksheet?
printing vba code in color
removal of circular reference error on excel workbook load
Another Question Concerning Replacing Formulae With Values !
Macro-pawan
Multi Sheet select and hiderows
Macro which finds data? help?
Incremental number field with User ID
How to search a value with two criteria from a database?
Custom save as pathname and filename
Getting series name
2 if statements
loading com addins with automation
VBA Error setting Font.ColorIndex
Pivot table autoformat info
Validation from list in different worksheet/workbook
getting rows out of a data base
commands button
colour text in validation lists
Progress Bar in Cell
Adding a Trendline or similar to a 3D Column Graph
Merged cells text > 255 chars causes "#" to be displayed
Graphs
Combobox Change On Save As
Deactivating all events in ThisWorkbook
Data Validation from a database query ?
copy and paste graphics into comment boxes
Bundling Solver with Excel File
outline...hide levels
macro security
macro works differently when using the Step Into (F8) feature
HELP!!! I give up!!! Help with formula
Sumif problem
vlookup relative reference?!!??!!
How to set range
dee
scrolling in VBA Edotor
VB worksheet function parms
Running an external Macro
XMLSS href attribute
Copy data from excel to a defined table in another spreadsheet
Macro Copy and Pasting
Conditional Formatting Not showing without editing cell
Want row to stay hidden
Help files
VBA acting weird, advice plse.
Hidden Row in seperate worksheet.
Retrieving Active Directory "Full Names"
How to Kill a vba macro from a Function//
Userform always visible
Need VBA code to terminate a find loop
Writing Single Dimension Array to Active Sheet
Creating a search button
Help with a macro
How to Open txt File and Import it to excel
Connection with SQL Server generate "Timeout expired"
Working on the wrong sheet
opposite of IsNumeric
range property of range object
Connection with SQL Server - "time exceed"
While ... Wend
A Simply ComboBox Selection returns value to TextBox
Run-Time error 57121
Retrieving Web Data
Need Help for Help!
Need Help for Help!
maintaining a link
Copying range from another file
Private Sub - Hot key?
Getting Month Name
Macro with manual file selection?
What does "\" do in VBA
making cells bold
time format
VB Help does not display Excel information
Page Break Automation
Working with data from several worksheets
Excel command line
How many hyperlinks can be in collection?
Autofill Function
Msgbox if Inputbox entry contains character
Help with totaling a columns in VBA
Adobe to Excel
Blank lines
Toggle command buttons
Microsoft Office Web Components 9.0
sorting worksheets and charts together
Hidden Row
format partial formula
How to get Autocorrect Listing out of Excel
Open excel and workbook with VB6
Format portion of formula
command button for vba module
Tranferring Text from Excel to a Header in Word
Create and write XLS using OleDB
Open a VBA Macro when Excel Opens
how error-trap "no cells were found error"
Enable - Disable Macro Dialog Box
Control disappears from form
Inserting a Row after a name
Email Single WorkSheets from a Workbook
Variable List Box Range
Loadin ADD-IN programarically
Schedule a Macro To Run on cartain day
printing excel worksheet
Calls from sheet module to ThisWorkbook module
Lookup from multiple columns....pls help...urgent...thanx
List of Unique Values
XML Files
Saving excel files as jpeg
Open a file with a macro
Selecting text
Return Current Column Letter and Row Number
Creating a PivotTable with VBA
Import grafic
Working with XML Files
fill cells with colour if content of another cell has CR
ADO Connection Help
How to scroll data in a chart?
Excel 2002
form in fullscreen v.s Screen resolution
how do I remove quotation marks from .CSV file
vba for lookup and autofill
Cut - Paste in xls file (c++ code)
onAction with parameters
Another coping and pasting macro
text is deleted when cell is edited
worksheets feeding to other worksheets
How to represent an empty cell in excel formulae?
Using Dialog to select a Workbook, Worksheet and Range
Code Help
Listbox Help
Stopwatch query
Indirect and Offset argument
Autoexec Macro
Can you use worksheet names in macros
Spreadsheet Performance
AutoFilter: Loop Thru Visible Rows?
Help with code...
Help needed on program
Controls auto resizing with scree resolution
Worksheet Change code not running when you just delete data in cells.
I need to return the name of a worksheet in another worksheet cell?
Storing column references in a variable
Find a Value Pass Row 99
Loop
scroll bars in comment boxes
Please help / Named range help
Data Validation Drop-down List Limt?
Can this be done? If bn=b(n+1) and cn=c(n+1) then delete row (n+1)?
VBA Program to Email-able Toolbar
VBA Excel Macro - One File Auto Create Multiple Excel Worksheets!
Autofilter and Listbox how to acomplish?
Re: VBA/XP/2000 On Error Resume Next problem.
Controls on form disappear
Help with find and replace macro
set up a command button or macro for open file to "save as"
13 type mismatch help
Web publishing question
How 2 Execute Sheet1 Button_Click Code from a module function
Textbox question
Range value cells with Sumif
Newbie
how to Detect paragraph in cell in string?
Ojbect required error msg
Printing a Report
autofilter
Safely automating any language version of Excel
Parameter in Macro Call?
Publish method failing, can't understand why
Text to Value
Re: Splitting fields from commas
Macro problem
Splitting fields from commas
On Error GoTo If
move down 23 lines and make the 23rd line height 92.25
Highlighter
Solver GUI works fine, but the VBA macro won't return any results
Query on Date range does not qualify the Year
Excel in VB.Net code
Microsoft Excel Expert ????
Slow Performance Hiding Rows
objectos
Closing Excel from Script
ScreenUpdating Question
The case of the missing buttons
Sheet / Hide & Unhide for editing only
Virtual Memory Macro
Memory Management
Disallow Paste
Coding problem
Page Breaks when data is NOT on column "A"
Modify VB for a Runnning Total
Programming to delet padded spaces
Changing the Colour of an Auto Shape (Line)
Display "Does not exist" upon search no results
form
Problem adding a range in Sumif function.
Password
Insert column
macro problem
Make a button disappear
Totals
workbooks.open without triggering event
Comparing 2 workbooks
How do I add help info to a user defined function?
refer to cell using the value in Row 1 and column A
Help required to run simple macro...
deleting objects
Hiding and unhiding columns
vba help
AdvancedFilter in VB
Skip blank cells on transpose in a macro
Using excel as a database
Reg: Incorrect RecordCount when opened a Excel sheet in ADO Recordset
i have problim with my excel VBA
close excel without saving
Launching Excel wb from Lotus Notes document
How do I get the address of the cell that is being calculated right now?
Have Excel VB Read from two sheets
Cutcopymode problem
Delete Sheets
Self destructing code
Searching 1 column for data
Filter Excel bases on the current user
Omit page with no data when use "show page"
Copy command
Screen Positioning of a Dialogue Box !
Assign a macro to create a pivot table
Worksheet SelectionChange event
Formula for timecode duration
Code to list users that have changed a spreadsheet
Input two cells with one selection
Problem programming the Sort command
Get Range, that user marked
Pointers??
Accessing Menu Options from VB Code
how to filter first column only in range
good book
Send Email from Excel
Way to Link Tab Names
VB Code Location; sheet, workbook, module
Quit without saving
How to search a range for a suburb in a large range
Excel Function Help
How do I use the ActiveCell's contents as a string for a web query
VBA Security
copy cell after resize method in VBA
Bad File error: Need Help
In search of VBA script
excel problem...help!!!
Copy Code needed
Activating/De-activating buttons
Help with named ranges
Help with Named ranges
C# worksheet function poor performance
2005 Excel User Conference
SaveAs Crashes
Combo Box to return a value
copy data to each worksheet
Header Font size
Creating an Autoexpand in Excel Combo Box
How to delete cells ?
Could You Explain the difference?
VBA newbie needs a little help
remove Worksheet using Sh.Delete without prompt
Re: base formula calculation on whether different cell has formula
Creating Excel Addin
Selecting more than one sheet
MAX in conditional formatting
Table Help
Use Excel Macro in Access
Help with following code creating chart
Macro to move text from one field to another
Trouble with ActiveControls and Forms
macro to find if the Excel file is using by other user
Count If, criteria is greater than
Simple Cut & Paste Macro needed :)
Row Selection or Column Selection or other ?
export excel spreasheet into a text file
changing variables?
Screen size
Copy information down specific cells
How do I use the AutoSum?
Delete PivotCache
Determining Which Page of MultiPage Initially Shows
lock and unlock cells programatically
GroupWise integration
Send Mail Script Help
Hyperlinks
Screen size
Copy from two files
Delete a workbook
How do I track frequency of occurance in data table?
Can an Array Formula Solve This?
VLOOKUP
How to make user forms FULL SCREEN?
selecting cell range in other worksheet without switching to worksheet
VBScripting syntax for Autoformat
Information about ATL functions
Code that can't be seen/modified by users
Userform - ComboBox fills TextBox not working
Inconsistent macro behavior
Max value in 1 column when all values format are text
Re: Close file without saving
Re: Macro to delete sheets and saves remaining file does not properly delete module
Hiding Tabs
Re: Macro to delete sheets and saves remaining file does not properly delete module
Is there a way to programatically resort the sheets in a workbook
Auto Adjust the Width of a Column
Re: Macro to delete sheets and saves remaining file does not properly delete module
Re: Macro to delete sheets and saves remaining file does not properly delete module
Re: Macro to delete sheets and saves remaining file does not properly delete module
Re: Macro to delete sheets and saves remaining file does not properly delete module
Linking List Boxes and Textboxes
Re: Macro to delete sheets and saves remaining file does not properly delete module
Read Only Problem
Auto-Enable Macro's
Re: Macro to delete sheets and saves remaining file does not properly delete module
Visual Basic Tool Bar
Summing a range depending on cell background colour
Having difficulties with For If Next loops
Re: Accessing personal macro's all the time
Macro to delete sheets and saves remaining file does not properly delete module
command to show top of worksheet?
Saving Multiple Sheets to Another Spreadsheet Without Leaving the Initial Workbook
Formula Help
Help for ATL functions
Select the last Cell of a selected Cellarea
Problem with xlCenterAcrossSelection
Excel 2002 Workbooks.Open failed.
Need vb application to print first Worksheet in excel files
Does some one has a golfscore in excel sheet format
Select range -- convert formulas to values
Alignment
how to stop a macro
Determine last row in columns 1-4 to copy a formula in column 5
trying to get a row to break....
searching on more than one field in VB
searching on more than one column in VB code
i losst my VBA excel Passwerd
How to add an entry in the Excel Right-Click Menu
Combo box control Drop down list moving
Print splitting...
Populating List Box from SQL Server
forget my passwerd
Workbook Bigger and Bigger
how tot open VBA Protectoin
wrong positioning of data in sheet after clearcontents()
Why!!!!!!!
Object variable error
Drawing Objects with duplicate names problem
problem when inserting or deleting cells
Find the last row
Dating Problem
Formatting Y axis values based on other chart
after clearcontents() new data is positioned below the cleared ran
Re: return text not index for property
Page Setup Macro
How to open new instance of excel if excel is already open?
Summing a range if a certain background colour
Copy/Paste charts
Flexgrid Control
Macro to copy columns from 1st sheet to 2nd according to mapping-p
Merging Pivot Table Data
return text not index for property
Sort and Specify that you have a header row
Print 3 Worksheets
Textbox Format
Max number of worksheets in a workbook?
Report for Conditionally Formatted Cells
Anyone in a really good mood?
Macro to find text in all worksheets -pawan
reliability of macro results
Excel VBA: Move Userform Based on Active Cell?
Find and change external links to point to the same workbook instead
Help me migrate
How can I use values in two separate cells to select a new cell?
excluding text entries in calculations
Code for Conditional Formatting with Five Conditions
Timed loop
Save to sheet 2 in workbook
Re: Accessing personal macro's all the time
savings files with the use of variables
protection
Search a text file for a string
Have chart lines take up full area of chart from left to right
Using List Boxes and returning Value to cells
Deleting Pictures
Help w/Insert
How to force Excel to complete one statement before executing othe
Worksheet has to set to visible as it is not visible after saving and closing Excel by VB.
Opening item from Listbox... Need Help :P
functions
names of areas
how do i chk is sheet exists my attempt included
opening a file
A math/algorithm puzzle!
Importing Data from the Web
Personal file slows navigation
problem with text from macro?
Countif for a string
Maximum value of two variable
ADO connection retrieving data to Excel using EXCEL-VBA
How reference columns numerically (not Cells() )
Help with If/then macro in VBA
Wrong result returned by UsedRange.Rows.Count
Mouse-over content in bubblecharts
Throwing an error ... on purpose!
Loading array into list box
Automatically transfer selected data to another sheet on print
Inclusive/Exclusive List
Worksheet too big
Subtracting Dates VBA
Subtracting Dates VBA
Invalid qualifer
ms query - from statement
multiple line two accumulators
How to check for an open network connection?
Help using a cell ref. to go to another page for data
textbox scrollbars disappear
macro for formatting
Group cells and sort
Looking for a 'Contains' Formula in Excel
XL 2003 TOOLS/Macro/security level inactive
can i use formulas in calendars in excel?
If condition
Userform retain data after closing and reopening
how do i convert a number stored as text to a numb in a vba loop
Macro works for me but not user group
notify drop event of excel/word in C# add-in
Which control is the one selected?
Excel Application Level Global Variable
Delete Row if text or empty
delete row base the value of certain column
SAVE AS MACRO
Unprotect workbook without password
Split() method
Macros problem with XP
incomplete code
MyRow error
Link cell show zero when source cell is blank
Static variables
offset function
Application.Mode
HYPERLINK link problem in Excel sheet using VC++
Executing a macro in a closed workbook
What formula can I use to compare items in two columns
Read Only
Data extraction... (Pls Help)
searching cells for a string of text
help with code
time line
RowSourceProperty
normal distribution of random no.'s
Textbox values
fao patrick molloy
MACRO
"Can't find project or library" error message
Autofill formula to last row with data when rows will be dynamic
import fixed width text file
how to attach macros to excel permanently - pawan
How do you generate random numbers in a normal distribution?
macros
How to use Tools, Data Analysis, Regression in Macros
Automatically starting a macro
send email from button
macro to paste data in alternate cells-pawan
Restricting access to ceratian cells
Steam Leaf Plot in Excel
TextBox Color Change
telnet without sendkeys
X and Y Screen Coordinates of a Range !!!
help again, last line required
fast range copy (without clipboard and with formatting)
Out of Memory Error 7
Checking for empty cells in a range
Checking for empty cells in a range
&quot... whats this??? am puzzled
Word Mail Merge and Personal.xls problem
Automatic Printing
Macro for delete row with "vlookup"
PictureBox in Excel VBA
Passing a Sub's name as parameter
Data copy from a seperate sheet to data sheet
Re: eliminate header&footer for spesific pace
Reading mail attachements
Get value from combobox
Very Basic Excel Object Questions
how to create chart by VBA coding?
Macro Won't Run in Excel 2003
Coping numbers only in cells to other worksheets.
Solver rounding
Re: vlookup with closed workbook
Do Until
In desperate need of assistance
international excel issues
copy a worksheet - but not the value (text)
Variance formula - is this correct?
Re: Problem with Pearson Code
base formula calculation on whether different cell has formula
Pushing results HELP!
Histogram Bins Created From Sum Of Two Cells
Sending email from Excel vba problem
Re: Simple Moves
Re: Combining data from multiple workboods into one
Re: Combining data from multiple workboods into one
Advanced Filter
Save File with Date and Time Stamp
Macro ?
works in Xl2000 but notXl97 - help required
Named ranges and variables
working with data from several worksheets.
copy equation to new row
command button question
Removing & Importing a macro module
I refuse to be let down by the experts
Running macros from shortcut keys
command button
Advice on three dimensional array (difficult?)
How can I query the 'indent' level of text in a cell?
ToolTipText
2 values in 1 cell
Help needed to consolidate variable ranges in excel vba
hyperlink a cell to an email message
Re: Matching values in 1 column to data in another
Matching values in 1 column to data in another
Find specific cells
excel in the foreground
Switch board
Ping - Bernie (or any other sage)
List Box or combo box into a cell
cell locking via VBA
Named ranges and variables
Repeat Entries
Finding the last non bank cell in a column
Looping with Excel Forms
copy the drop down list value and paste to next column
excel auto-formatting - help
XP Styles on Excel Form
Update on Worksheet_change with data from other sheets?
Capturing Excel Copy/Paste/Cut events
How to check for an open Network connection in Excel VBA?
Excel and .NET
vb dummy - two routines
Comparing values in 2 columns - Help needed
How do I call this function?
can I compile excel as a stand alone programme like access
can't copy a sheet within same workbook
Automatically run macro on sheet change
Auto Row Height for Merged Cells
Problem with Named Cells
is there any way to create a formula in excel for amortizing
.NET, CAS and Excel Development
stop web query
Vlookup in VBA - Driving me crazy
Making Cells Automatically Add #'s Instead of being written over
Data Validation Listbox and the Worksheet Change Event
I'm trying to disable a clip board
Print Macro..
specifying ranges using cells
Add a Range to an existing Range in a loop?
HELP-- Filtering and copying data to a new sheet (w/ macro)
Print Macro..
redo CommandBar("cell")
Publishing Workbook or Worksheet (HTML)
Copy columns to free space in diff wrkbk
Removing Duplicates
Event to trigger when form is scrolled
Referencing an opened Workbook
Validation help
Range for a single cell
Excel -> Word: Problems copying/pasting shapes
get data from one sheet list in another
Run Access Macro from within Excel
Extract Data From Multiple Excel Files -> One File
percent of total with partial items
Procedure not working, and I do not know why
Rounding Ranges
Selecting cols and doing a formula using variable offsets
SheetActivate
where put code for automatic execution upon opening workbook?
Saved seems not to work
Buttons Moving around page or shrink in size on Excel Worksheets
ExecuteExcel4Macro Problem
displaying times in combo boxes
Excel 2003 - Error Running Macro
count a value in cell if the cell to the left has a certain Value
Numerical Breakdown
Save from a template to XLS only visible sheets
displaying time in a combo box
How can i get autoformat name of range in excelsheet?
Copy columns to last populated rows
Chart Objects
Multiple line, two cell accumulators
EZ Formula Syntax Question
formulas are not working on my spreadsheet
How can I disable the save function depending on one cell?
Deleting Shapes in a worksheet
Finding a value
data entry to next blank TextBox
User form and text boxes on charts
saving to two folders by selecting one
formulas and colorindex don't work after opentext
Macro copying macro code
saving to two places by selecting one (VBA)
Quick Formula question..
Fixing SSN's with a macro
change query path