Excel Programming [Archive] - Page 90

Finding Range of one Workheet used in another
Extracting word from phrase within column
Loop or condition? To check down the rows
Relatively simple problem (I hope)
how to solve this?
Passing arguments to VB Function
Write macro don't ask to save when exit excel
Linking checkboxes between userforms
Protect with "SaveCopyAs"
Can't select field in ADO with Text Driver
Insert Tab Space
Calculating dates based on the current date
Macro code to test for blank row and insert blank row if false
How to replace a text with another
Change the format of a cell Programmatically
pivot tables criteria vba
Compare String in Cell to an Array
Question...
CAN YOU CREATE A PATHWAY OF CELLS LIKE A PROGRAM
Exporting values from many worksheets
Need code to exporting Charts & table
Should I use VB 2005 instead
Calendar Control
Setting several variables at the same time
Automatically updating chart to include new column with VBA
Code Help
Excel 2003 XML mapping question
Office Web Componet
Application Icon
Unable to insert a page break
Command Buttons Location
Checkboxes, AND, OR statements
PasteSpecial and Offset
How do I temporarily turn off messages in Excel
I need to filter and delete rows of information between 2 dates
pivot table based on multiple ptables?
Return to current worksheet
VB to color text
How do I find a blank row and delete it?
Look up
listing objects
Personal.XLS
Help with Selecting Ranges in Pivot Table
opening Excel 2003-Compile error in hidden module: Autoexcel new?
opening Excel 2003-Compile error in hidden module: Autoexcel new?
xl SS to query an Access database query
Formula1 Property of Validation Object to refer to function name
Delete row if no date exist
Event when a user form is loaded
Make the next cell active
LTrim imported text
AppActivate Error
Copy and Paste between Spread Sheets
Excel vba - passing a 3-dimensional array to a subroutine
Userform; text restrictions
Track entries and events spreadsheet,
Quotation template whith automatic increments quote ref
Error - file already exists.
Way keep track of edits and editors
Range.Select
Replace words from ADO recordset
Cell Format to Dialog Box in Chart
Date problem
Explorer Window.
Import partial txt file using VBA
Adding new sheet problem-Macro
Copy test to form
How to use MATCH with a vector in VBA?
Formatting street address's for comparison
how do I set the position to a specific cell location in excel
Referential Copy and Past
Hide and show a group of worksheets
Updating SQL Server via Excel
Using Arrays as source data for charts
Re-Populate User Forms
System Lock Event on excel
A security issue???
Matching duplicate entries between two columns
Analysing a list of dates
Place chart at specific cell location
Problem with MATCH function
open word from excel...file does not exist error
Continue executing code
Can an addin save variables or arrays to a workbook
Help with filename search
Making a macro universal to create multiple worksheets
Copy cells to a txtbox
Download a CSV file from an internet site
Sorting excel sheets
removing old stuff from xls
Using CDO with Outlook
If the Value in S is <> to E round off to its Value
Advice on simple mod Req
XL2003 open .CSV problem
Excel automation
Listing of contents within CHM file
change yes/no buttons
Problem with default file path
refer to same cell in other worksheet
workbook protection
Userform shown in windows other than Excel
Different Path Selection
Best research method
Counting variable ranges and auto-summing variable ranges
Menu Title code is where?
How do I do a VBA comparison to a financial value (i.e. $10000)
Saving File
Need UNIQUE values for Data Validation List
Time Formula
How to open Access recordset via Query in Excel VBA???
loop and delete
Urgent ! CSV double quotation problem ?
Open all Text files in a folder
Rename a worksheet
Addin Name
How do I install a hyperlink to 'My Pictures' to display a pix
Loop printing
solver macros in protected worksheets
Populating combobox in custom toolbar
Disable save box
Moving Data from one tab to another when a check box is checked.
Pivot table - show detail
Range Loop
count of items that results from two "IF" statements
Listbox Cell Selection
Copy cell query
Macro Hangs
Help my little brother
Adding a delimiter when importing a txt file
VBA Code to Return Text Embeded in the VLOOKUP Function
Sort Selection
VLOOKUP in a macro??
Easy question: Have macro ignore #N/A
Microsoft Common Dialog Control
user form - data range
Sorting by two column and bringing third along.
Code to create a Histogram
ActiveControl again
Auto close read-only, question boxes?
How do i insert a picture in merged cels, with autom. resizing ?
Create muliple sheets using querytable
Loop time seems dependent on unrelated workbook - Why?
Excel 97 runtime Issue
Conditional display - IF cell is blank, display next used row!
Transferring Data from Excel to PP
Print
VBA: returning subtotal range of pivot tables?????
Copy, Transpose and Paste Values for a Large Data Set
Compare 2 columns to a 3rd with a twist.
Pasting data from Excel to PP
Copy worksheet colors to every open sheet
How do I assign a toolbar button to a custom number format I creat
How to test to see if a given sheet from is in a workbook from ano
macro to select cells containing specific text and delete all cells but these
Simple Sub review
Pasting data from Excel to PP
Pasting data from Excel to PP
Question from A Newbie
Add picture located in same workbook to background of XY Scatter Chart
Run Macros after a certain action is taken.
Excel Macro Stop Executing
Code not drawing data for printing
Using VBA macro - how to just chart two selected columns
vba select a range of cells
vlookup from excel to access
dates and checkboxes
Copy charts and resize
ControlToolTip
Excel should let me revert to a previous value in a cell
Using the IF formula
Variable Toolbar
Macro needed to delete rows
Attach object (eg image) to worksheet
Finding values within an array
Recalc needed for successive years
conditional compile for LoadPicture?
CountIf function query
How to extract data from Word Form into Excel
Selecting Range in non-active sheet
Swapping columns
Flashing UserForm Label
Flashing TextBox
Proc to measure time intervals
Filtering inputted dates using criteria
Specifying a result for a Drop Down Box
HELP: text keeps on displaying ##############
enable image transfer between a dll and
VBA code to sum
Make a Word event macro fire in active document
Array Ubound
need help with adding visual basics and excel
Help, Ill try to explain my problem.
Luk strings, write values / balance, insert rows : wanted VB help
.ControlSource
Growing file size
creating report from spreadsheet
Put in number of product and auto gives description
Worksheet.PivotTableUpdate event
command Button
How to using Range ?
Is sheet protected
Disable numlock need help
Defining a Dynamic Range using a variable
need help for creating a macro
macro is needed
MATCH AMOUNT FIFO METHOD & INSERT ROWS WHERE EVER REQUIRED.
Macro translate from number to text
Linking Basic Beancounting spreadsheets?
new sheet with same name as previous.
Small runtime error - advice required
London Excel User Conference
Need Code to rename standard modules
Re: Need Code to rename standard modules
How do get a macro to autorun when i change a cell in the spreadsheet?
How this function S=( P*47/7-P) in Exel work
Excel Constants
Getting data from a closed workbook to a master record
How do I lock cells so their values don't get updated
Using VS 2003 .NET structures in VBA application
Need help with Months in header
Dynamic Array with Text to Columns
Lists, Ranges, and Combo Boxes
Sorting problem
sheets in an addin
Copying a range from one workbook to another workbook
Object Required
How to get a picture on a userform?
SQLOLEDB Timeouts; setting from Excel
Re-execute all UDF programmatically
RowSource in Properties Dialog continued......
Why must my footer be so short?
Email form with pop up box function
RE: Object Required
Retrieve data from multiple Excel sessions
print function in excel
RE: How to get a picture on a userform?
Deleting cells using VB (macro)
On Action
RE: Object Required
RE: Deleting cells using VB (macro)
RowSource in Property Dialog
Dynamic Userform problem...
C# in Office .NET
How can I shade every other row with some rows hidden (autofilter
Do not open spreadsheet before a certain time.
Newbee - deleting blank columns
Can I use OR in SUMIF?
RE: Dynamic Userform problem...
Import from spreadsheet
saving file name with the date
RE: On Action
find date
need a macro to lock sheet
Count if in VBA
how do i change the default date to 2006?
RE: C# in Office .NET
RE: Dynamic Userform problem...
RE: How can I shade every other row with some rows hidden (autofilter
RE: RowSource in Property Dialog
Engineering shear/moment
Help with Formula in Code
RE: Help with Formula in Code
RE: RowSource in Property Dialog
Make VBA Class Module Library
RE: Can I use OR in SUMIF?
RE: Object Required
Within VB, how to pass results of a FormulaArray to a variable.
RE: Copying a range from one workbook to another workbook
RE: Import from spreadsheet
RE: Re-execute all UDF programmatically
RE: Count if in VBA
RE: how do i change the default date to 2006?
Email document with pop up box
Save As Macro Script
Embedded Excel in PPT - what is the displayed range?
Network macro not working
Adding in row at bottom of range
2 workbooks
Copy and append macro not working
How do I go about getting a certificate signed?
#Value! Result
Change data in look up table
series of Checkboxes to select worksheet's data
Series of checkbox to call form
VBA code to sum
Copying a formulas answers and not its calculation in VBA
Front End for my workbook
macro for counting access to printer?
how can i send email with attachments paths (3 workbooks) located in the cell a1 to a3
How do I prevent AutoRun Macros when Programmatically Opening Workbook?
Changing trendline color and weight
Counting of Duplicate Values in a column
Selecting range problem
Add-In Question
userform question
Same Range on different worksheets
Deleting rows with blank cells
Add custom property to a listbox?
userform question
connecting to a remote file
userform question
I am so confused! I need help with a check box and a macro.
userform question
Know rowindex after filtering
Transfer data from Excel to Access
userform question
How do I create a new worksheet using a template or xls file
Formula to find average of field for all rows that contain another field
VBA to scan range
Populating one sheet with data from other sheets
Help with retriving data from other closed Workbooks
Example of input or msg box requesting TWO pieces of info?
How to start the Macro when I open Excel
Range question w/VB
Filling dropdown values from remote xml file
Reliability issue with some code
Highlite filtered items
ComboBox WorkSheet Trouble
Past an Excel Selection in PowerPoint using VBA
combo box with sheet names
How to merge columns from excel and how to set customize each columns
Range - copy forumlas
Returning Values From a User-Defined Type
check a range of cells to see if they are empty
Saving an array or class to disk
Excel Macro to Convert indirect function to direct links
Run Time error 1004
Should I use Do-While loop for my record counter?
Is there way to Import PDB file (.pdb format) to excel
Application-defined or object-defined error on simple sort
separate the numerical values in a string
Matching contents of a cell full of text
Simple Macro
Macro to insert named range in each sheet
Test if sheet exists create if not
Scheduled Tasks & Starting Excel in a Minimized Window
Query
Data entry form
first Autofiltering, then subtotal one column, copy value to first row and delete rest
Active X Problem
Syntax and compile error.
Set Chart Axis labels from Access Query?
Copy Values From A Non-Open Workbook?
Test if protected
Copy Values From A Non-Open Workbook
Listbox Clears Itself
Move down one row
C++ automation problem
urgent plz; project/library compile error
Checkboxes and multiple cell values
Need help speeding this up
Cell Movement - Not Working Correctly
HELP! Number length macro
For each Next Loop
copy to a text box
error calculating negativ difference time values
Date Verification & Duplication Error
Help Please. How to save multiple html files (sounds easy but scenario causing confli
workbook calculate
error in code: capitalize first letter of a word
Cell Entry - Strange Behavior
Variable Range
resizing Excel Window from VB.Net
Passing strings as arguments to xll functions.
Named Ranges - Created by system?
Refreshing of =now() not producing what I need
How do I have excel not promt me to save when I close a document?
VBA lookup into large database
Is this an efficient use of named cells?
Combox Box and 3 worksheets
Combox Box and 3 worksheets
Populate xlValidateList; Please Comment
Comparing rows
Very Slow Macro Problem
OnTime Challenge
macros
Please help
Function seems to be late with calculation
IF AND function
IF And function
Keep scrolling until mouse released
closing a workbook
ActiveControl
help! print screen locks up excel
Embedded Excel macro runs 100X slower
Alternative to insert
Add control to right click menu when something is on the clipboard
Custom toolbars (not again!!!)
Capturing Errors in Macros using VB
Entering data into two text boxes using one command button
determine the column where a cell was found
VB macro to load/copy/paste multiple files into one spreadsheet.
How to set the format of a cell in excel through vb6
Saving data from an order into a excel repository?
Resising Columns in vb code.
TextBox Attached to AutoShape
Closing a named workbook?
Digital Sig not working
Updating references
Excel Message Boxes
Import sheet or only data of another workbook
code for autonumbering a column
coding for connection between two sheets
Coding for custom footer
help with macro to delete entries in a table
How do I activate 'Saved Form Information' in Excel?
Check user input
Macro to perform F2
I created a Pivot Table; trying to get more info...
Hide/Unhide 10 consecutive rows down
Microsoft Visual Basic: Compile error: Sum or Function not defined
Error 1004
Multipage: [Me.Controls("Page" & i).Name] does not work
MSFlexgrid in User Form
Using VB to Convert Single Worksheet to PDF then Email?
Copy Range with Additional Rows to New Workbook
Re: excel formula
excel formula
Importing updated data from one workbook to another
Julian dates
keydown, arrow keys problem
Excel Programming and Pocket Excel
Runtime Error 1004 - Help
Get msoLinkedPicture LinkFormat?
reading and modifying file comments
excel xls to xml
excel xls to xml
offset question
HTML / web page processing
Worksheet name problem
PublishoOjects error '1004' trying to publish web page through cod
max in a list
Ontime
Start a .cmd file from a UNC path with a link or button
Finding Unreferenced Subs and Functions
possible if function??
macro help!
How map types when call functions defined in XLL AddIn from VBA
csv summaries in excel
Macro for copying & inserting a row
deleting rows messing up sums
Lookup headache
Stop Do While at Null
setting comment text from VB code
Wow. This is interesting and slow. Any ideas?
Paste All but Hidden Data?
Dim and set
HowTo:Validation Formula = Array of strings
return value from combo box
how to make newline in VB button caption on workshett?
Drag Drop Cells "How-To"
Force particular Excel version loading with CreateObject?
Help with GetSaveAsFilename
Type Mismatch for a formula
LINEST - "Expression too complex"
Assigning a number to each record Found
needing some If Range value
Creating a tab order on vba embedded toolbox controls
Filter all worksheets in workbook
If I were to use breifcase to transmit spreadsheets to a laptop
How run Evaluate on a specified Sheet
Address Entire Worksheet as a range
Parsing a string
exit for next loop
Hide Unhide Group Box
prevent rounding up
Converting list of IP Addresses to list of Hostname
Custom Toolbars Again!!!
CodeModule.AddFromFile problem
NZ function doesn't work!
Limit CPU Usage
How can I hide VBE window appearing when running VB6 app
SaveAs file lost
find
2 dimensional split?
convert 10,000 item column into 1,000 rows by 10 columns
Slight Error in my Simple code
Code for multiple columns and rows
Small Macro
Macro Help
Paste Special in a Variable Column
Help on : comdlg32.ocx
Help With - Compile Error: Sub or Function Not Defined
Cant find Control
Forms, Bound Columns etc
Way to only import new files?
Writing an IF/Then Statement in VB based on entry in a cell
cannot find project or library
Macro to insert a space
Creating C++ DLL for my VBA code
Modify Save As menu item
random mumber array
Window_Open in personal.xls run each time I open subsequent workbooks.
Transposing blocks of cells
nested formula
Summation of the Cells
Auto_Open & Add in
Adding controls to a form at runtime
VBA function modify a range
Array question
Loop through drop down list
e-mail with cdo --> Helo command rejected
Command Button Help
Clear contents with condition
Capturing errors in Macros using VB
Specifing the active cell
No 'paste special'
Add a value to itself
Loop Problem
Update links in my addin
Macro to identify bad dates
Global.xls
Moving into a cell range using Offset and LBound
For Each Loop not working properly
Custom Toolbars?
Registration Opens for UK Excel User Conference - July 19-21
vba codes
Dynamic named ranges not saving
Create Select Case Function
VBA Print code?????
Cross Excel userform update
XML Writer/Excel question
Oject value changing in a loop
Can someone please answer my post.
Multiple Saving
go to far left worksheet
how to find if multiple chart objects are selected?
how to find if multiple chart objects are selected?
Pointer displays Hourglass?
import distance from autoroute
Close button userform
How to alway display a modeless form as top window
Saving Files
Change a comma separated text file and save it
ScreenUpdating=False doesnt stop screen flicker??
Print Array for hidden sheets using VBA
Not creating duplicating worksheets with the same name
Exchanging text between two cells
Moving sheets
Save workbook via Command Button????
Macro Import Text File, File Name
Auto Activate (Window_Open Event) in Personal.xls when another workbook is loaded
could any one please tell me how can i create a macro that runs other macro
Photoshop and Forms
how to use workdays or networkdays in VBA
Open Only the User Form ... or Close Everything !
how to create a macro that runs other macro in the same workbook
Is it there?
If the file exists "Yes should appear"
Loop Difficulty
Query Oracle from Excel
searching for a worksheet name while going through a subdirectory
Program
loading a macro programmatically in excel VBA or perl
Printing Two pages per sheet
Please help with ADO and VBScript!
Run macro on open IF its before 9:00 AM
Floating point number comparison
Help with getting Values
Worksheet Origination HELP!!
Inserting time via DTpicker but per 15 min i/o per min
Cells.Find and text in hiddend column
selecting printer
delete sheet help 2
Can't find project or library
Error sheet when macro's are not activated
Need a formula to link colum cells to row cell in a different sheet
Paste Special--what is this doing
workbook_open option
xllRegister method
what is the best way to do calculation via vba
Arrary with Findcontrol
Multi-Conditional IF Statements
Formatting Buttons
Trim a fat macro recording
Macro to copy data down a column
New to Macro writing
excel print functions
Copy data to sheets by name
Combo box: Viewable Title
set logical test to see if 4 cells have same value
leave sheet event
Save As wk4
shortcut key running wild
Returning arrays from custom worksheet functions in xll files
Use an image behind the cells background
problem breaking macro into 2 subroutines
Macro running halfway only
Interpret code
Pivot table
macros won't work when tabs with data used are hidden
Sort array
Formula help
vba documentation and filefilter property on os x
Minimize pain from relocating an XLA function library
Rounding numbers with CEILING function
combobox problem
UDF Error Handling is ignored. Not for everyone?
combobox problem
Code execution has been interrupted
add time above 24 hours
WorkbookBeforeClose problem
OLAP CUBE ERROR
Assign a Name to a Range in VBA
Help setting the gridlines on a XY Scatter chart with vba
Help with Formula (data validation maybe?)
Help programming new chart into a new worksheet
Macro for: If cell has 4 characters, make cell red
Trying to find averages based on date.
Data from user form to certain cell
txtbox no right click copy menu available?
Need to read external workbook
Shift cells and then wrap text to fit.
Excel locks with Worksheet Change procedure
Help with placing Picture in background of a chart
Search a column and display a value
If Value of active cell
Encryption via WinZip
change cell colour if value in column = x??
Error (empty list box)?
Prevent Save As
Pivot table causing buffer overflow
UDF/VBA Function, trap error, avoid #VALUE!
How to create ComboBox with 3 decimal places, Please Help!
how do i creat a database to track stock
Copy row depending on column value
Deleting Unique Rows
XP Developer Upgrade
Can' find project or library Error
calculate difference of time
help with automating saving spreadsheet on the click of a button
VBA Form problem over an Intranet
ListBox with non contigous columns
Sheets(array(aryMySheets)).Copy problem!!
paste to next free colum on new Worksheet
How to repair an Excel Installation?
Workbook to Open a new excel Window
Passing sheet names to an array
mass data retreival from excel book in different folders
Excel bug?: Graphics won't show after opening 100 Recordsets
array revisited
re: sorting combo list?
For next index
Typing in VB
Array index name
Workbook_BeforeSave: Bypassing prompts for external links
VB Script for Excel Revised Question
VB Script for Excel Revised Question
activating a workbook
Problems with sum + if
Macros and Jet Reports in Excel
asp having problem accessing excel 2002
Simulating Key Presses in Macros
Programmatically unprotect a VBAProject
Export modules from protected projects
best practices question
Macro to Copy Grid Header
RESIZE PROPERTY: is it possible to resize "up" and "to the left"?
Create List in Combo Box
How to skip files which are open?
Options Buttons
Conditional date stamp?
Do while loop
Macros cells.EntireRow.Hidden = True and Range.Sort are stopping
Excel Macros - Grid Converted to Vertical Listing
Copying from variable named sheet...
CommandButton Link to Macro
help with loop
How to get excel vb to ignore the $ symbol in a textbox?
Excel Active Cell
Weird Shortcut Key Problem.
Macro shortcuts
number length limit
comparing a column of cell and then copy info
Moving app from one computer to another
stuck with activecell offset
Open workbook with same worksheet
Update Validation List from cell
Excel Is Max'd Out - Where To From Here?
Use VBA in Excel to Open Word Doc and Create a list of Hyperlinks
Creating a List Within Rows...Not Columns
Change Boarder from VB .net
Calling a DLL in MS-Excel
Need Help with XY Scatter chart
finding min values address and getting value from same column
Refresh image on userform
Adding input box number to range of cells values
spacing issues...
How to refer to the value of a cell containing a VBA function?
MDX Cube Analysis Addin
Need to know who has excel file locked
VBA: Error handling
Setting Cell Value Based on List selection
Seek Charting Tip
static array
Question on SaveCopyAs
list unique substrings
listbox with data coming from another workbook
Deleting Unique Rows
Deleting Unique Rows
I need your help again
problem with pivot table automation using perl
Loop while skipping blanks
macro error
copying rows between a and b
Workbook_BeforeSave question
Macro code to remove a macro after it executes
Read from Named Range?
Using Hyperlinked RSLINX Values in Script
Backing up setting prior to reimage
Excel/VB Job
embedded ss object
If no workbooks are open?
enable macros
Using BeforeRightClick in addins
RE: Using BeforeRightClick in addins
Naming a workbook WITHOUT saving it?
targeting another prg by using DDE in the code
IsMissing Function
RE: Naming a workbook WITHOUT saving it?
Immediate Window not showing up below code window
Breifcase
RE: IsMissing Function
What is a Sub
RE: enable macros
RE: Naming a workbook WITHOUT saving it?
RE: What is a Sub
I want to enter a name and have that person's photo appear. Help?
A question on procedures
Select Case
Run time error-subscript out of range
Shapes.visible = false/true
Opening Files Question
call a DLL within Excel.
WITH .. END WITH question
Format CSV
Export modules from protected projects
Reading Dates
Extract data if it exists & move
custom menu bar mispelled, where is the code for it?
Link cell to Label Caption
Choose from pictures
VB Forms and Userforms
Show respective IDs
How to call a macro in a different file
how do I hide rows in excel based on values input on sheet ?
system time and date
Runtime Error 1004
Web query and special characters
XLS - > frontpage
Advance filter
List PivotTables
ms query promt in vba
Remove keyboard shortcut from Add-In
No Clue...
Deleting rows to a defined point
Select Case within IF-Else statement
re: edit command button
Save As code
Macro moves data and more!!!
i want to know about "beforedoubleclick" event
Restrict Data Entry to only 4 possible entries
Restrict Data Entry to only 4 possible entries
Restrict Data Entry to only 4 possible entries
Printing Macro
Display error msg when cells left blank
Object syntax with a Period ( . )
Using a disclaimer in excel
from XLS -> notepad: incomplete text & UTF-8
Determing Last Row
Office & WebServices Issue
Need helps with a few Macros
auto-numbering help (during inserting rows)
getting the absolute range address from a dynamic named range
mark the last three rows in a names range
ActiveWorkbook.Close True
how to write excel in macros through which mail has to be sent via outlook
Strange Option Button behaviour
hiding Rows and buttons/comboxes, over the rows
Acivecell.Formula Offset End(xlUp)
SheetChange fire UDF unintentionally
Can I get additional diagrams for flow diagrams
Copy Sheet Error/Limit
Sum Multiple Ranges
DatePart Function in VBA
User Defined Function does not appear on Function listing
Class Modules
For each picked entitiy in a list box...
In multiple sheet copy error subscript out of range ?? HELP
Sorting more than 3 columns - is it possible?
VBA bombing out on this line
XML Import too slow
link staad output to excel
OLEControls Optionbuttons
Is is possible to have a macro select a cell and return the address for use as a variable?
importing data to msexcel
listbox, topindex, and an extra click event
Err 1004 from VBA Charts
Multipage - Tab Order
Excel File Saving - not wanted
Removing Chr(10)
Call PRICE function via VBA
Automate Cut/Copy/Paste from Excel Cells
Sum Cells or Range and Insert Value into Cell
distributed sheet model
Auto Generate Table
Trying Excel VBA to get data into a worksheet using Internet Explorer
search for a cell colour and print the cells contents in a new she
Excel to Access
How to write the code for copying 2 or more sheets to a new workbook at the same time?
insert pagenumber in PageSetup in Excel using VB.net
Range.(Cells()) question
How to "Capture" Records Found Number During AutoFilter
VBA Code Activates a workbook only sometimes
Problem getting the value of a Named Range in code
protecting areas of a spreadsheet
Using Index function to pluck cells?
Programmatically Docking Toolbars
Re-Size Form
Select Row in List Box with 2 columns - Col 1 populates form 1 box1,Col 2 pop box2
Cancel Validation and Change Event
Date Format
limiting source ranges when building charts in vba
Change Value outside of Cell
naming two open workbooks
How do I skip a blank cell within macro?
Automatically generate user forms
Fill-in Range from UserForm
if condition true then move a whole row to another sheet
VBA IDE Menus and Toolbars are all disabled
go to next cell after specified # of characters typed
How to fix ### field value programmatically.
characters...
consolidate non-numerical data
preventing code from running
function via vb
protect sheets allow buttons
summary table
Using buttons in Worksheet
Macro works fine on PC; fails on Mac
Using XIRR function in VBA ?
Connection/Import Error msgs
Update a Web Query and be able to change the WebAddress manually from a specific Cell
Waiting for an OLE Action
how to get lighter shade of gray for interior color of a cell?
Custom Function Referancing Cell Value
Spreadsheet Outline/Workbook Map
help required with using cells to generate a filename
formating data once
Excel crashes if project is not compiled (urgent help please!)
dynamic max and min for scroll bar
Importing csv data (with semicolons) into excel
How to change #lines in Immediate Window
Nested with loops
number formatting for time
Import cells from excel into word and create multiple word docs
Need Help with a MACRO
excel search vb
mark just cells containing data in a range
Getting Workgroup ID??
using VB to enter a sumproduct formula in a cell
deleting unneeded rows
Uh oh...Runtime error 1004!!!!
Combo Box mandatory selection
Finding words and neighbors using wildcards
Find words and neighbors using wildcards
END IF
conditional format macro formula
Compare Text/combobox values against cells in spreadsheet
Is there an easy example to create a Pivot Table within a macro
Sorting by 3 columns
SUM total into separate worksheet
Backwards compatibility with Excel 2003 Calendar Control
VBComponents question
Accessing local workstation's TEMP directory
I want to automatically alphabetize my list for my validation.
Using Vlookup wheb value missing
Reregister Com Add-ins via vbs
calling VBA function within a worksheet
Specifying two cnditions or more
compile error
Refreshing pivot tables
Counter for records found during Find
Trouble with OpenText() and Date/Time Values
VBA function returns #NAME?
UDF Help
Interior color
How do you compare 2 list of numbers and highlight the difference
VB ListBox
Cycle Excel Files Linking & Summing
RE: VB ListBox
User form with sliding separator on a list - how to do it?
How to have a 'comment box' on a user form
graphs with macro??
RE: Interior color
RE: graphs with macro??
RE: Cycle Excel Files Linking & Summing
RE: How do you compare 2 list of numbers and highlight the difference
Systematically Close File, Without Saving Changes
The use of the "#" sign in VBA code
In Excel, why does my VB not work when launched from IE ?
Data to column by bold letters
Pivot Chat Macro
VBA and Charts
Excel 2000 to excel 2003 Window's 2003 XP Pro
Looping a range selection
pasting a forumla down for a known dataset
First row in Selection range (first index of a cell) EXCEL VBA
ConvertTextToNumbers
Kill all Task Panes?
How to get an index of cell number in selction range.
Insert rows into a sorted range
Has Delete Key been pressed?
newbie: force paste as text?
delete a row.
first row in array
COMBOBOX VALUES NOT BEING RETAINED
coloring todays date
Ms-Query stopping
worksheet change
Display first cell in the right of range
Whats error messgae '400' mean?
Hiding named ranges depending on a cell value
VBA in Excel 97 and 2003
Collection Key
anyone can help ?
need a progress bar for status bar
VBA Protection
Need Macro!
When true isn't true - help for newbie
problem with SaveAs method of excel in IIS 5
Problem in updating all worksheets of a workbook using a macro that calls another macro
Problem with .navigate method
syntax problem
How do I stop VB Editor window from opening when I run my macro
Window size
Copying from Excel - pasting in Publisher
open an input screen
Delete Cell
Matching one pair of cells with another
Warehouse map in Excel Query
Undo changes in range
find, sort, and copy data
Help Please :) I'm VBA Stumped
run a macro for all sheets
Blank Cell
Attaching a link to a Picture
VBA - DETECT CELL COMMENT IN VBA
Hide Pivot Field Labels?
Converting data to tally format
Problem copying a range to another file
This has me stumped!
How to find out the path to excel.exe thru vb
Application.OnKey during Copy mode
Help please!
Avoid prompts with QueryTables
Links and users
Using function with Arrays
How to? UDF returning nothing
Error Handling question
MAcro to copy and insert a sheet
Sum Cells based on attributes
orientation left to right
PasteSpecial Paste:= xlPasteFormats problem
Help needed to Create Formulae
autonumbering invoices
Excel 2003 - User def. function
Some help with Printing code
If Statement
find number & insert rows
Can I keep the screen from jumping when running a macro?
How to deal with the character ' in a SQL string
Loop until Sum equals Zero ($0.00) - then Insert Row
Deleting Duplicate Columns
Protecting mailed worksheet
ADD-INS showing in Tools Menu
Conditional Formatting Character length
keyboard shortcut hijacked?
Is there a VBA flow control statement that will ...
Implied Circular Reference ... in w/s SelectionChange Event
How to make text data export to excel in text format.
Calling all MVPs! Macro to delete non matches b/t two lists. Thank
help!!!
automatic links displayalert when you open workbook
More insert rows
delete rows based on cells having a floating pix
graphs
fill array
Need a solution!
updating query.
Use "For... Each" to Iterate Through a Cells Collection?
Multiple Colour changes on User Form
PivotTables linked to Access Database
Mailmerge from excel button
pause macro until user selects correct range
Userform show / hide problem
help with copying column between 2 workbooks through vba
need program
VBA Question - Remove keywords from cell text
oh dear - why isn't my simple IF working?