Excel Programming [Archive] - Page 116

Macro to tell if Cell is Text or Number
Macro calling another Macro
Comparing sql record to cell value
Custom VBA took 0.0625 sec is it too slow?
Select multiple rows and add a value in a column
Can this be done?
how to "delay" formula's calculations
Worksheet_Activate event clears clipboard?
date/time question
Utility required - probably already invented
Emailing a form from a spreadsheet
Re: Action on sheet Selection
Password in a combo box
Action on sheet Selection
I need 4 condition for condition formatting
Protect sheets
Last Cell Accessed
Sub or function not defined.
Need Code To Print From Code Modules
Need Code To Print From Code Modules
find and delete rows
selecting a range
AUTO FORMATTING WHEN ADDING ADDITIONAL ROWS
Copying Multiple Columns
splitting data in a column
How to Clear all Data on sheet after a given row
How to select checkBoxes as a group in
Excel Charts + VBA: Changing y-axis Format
make a staff rota in excel
Userform lookup date value in database
How to prevent a specific worksheet from being printed !
select sheets
formula construction II
Date Format Changes on Copy
Calender Issues
get rid of mesage boxes
Method 'Display Alerts' of object '_Application' failed
turn off autocalc
How to Pass Control from VBA to user and return
Delete rows with specific text
Assigning a color to a cell
Call Oracle Procedure from Excel macro
How do I write VB to run Macro when sheet selected?
VBA Conditional Formating Problem
clearing array contents
Pasting after Workbook Activate event
get values from one sheet and add to another
Copy Paste from Active cell
Menu customizations affect all workbooks?
Forcing Excel Closed
how do i design/ implement a spread sheet to input live data
how to set a variable to a Chart? not ChartObject
Automation Error
May be Automation AddIn loading problem!!
Application.OnTime -- Unable to Pass Macro with Numeric Parameter
Masking on TextBox
Time capture problem
formula construction w/ vba
Range Copy
Extract 2, 3, 4 or 5-digit number from string
Extract 2, 3, 4 or 5-digit number from string
Cancel Button in Open File Window
check my code - big ask
If...Then Problem - bringing up wrong info!
Macro showing Offset instead of Ranges
Adding a Check Mark commant to the Menu
WindowActivate event wrong
Data Validation Numbers and Text
Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells
GetOpenFileName with F*.txt
From String to Long
Shorter method to "box" some cells
Fixing a Macro-related Crash in Excel
Acknowledgements!
OR statements
Workbook_BeforeSave ActiveWorkbook.Name Error
ranged name without "worksheet"
Changing color conditionally
FollowHyperlink Method
Sub name issue
Call a macro in anothe file
Help! Range("startsum").Value = Application.Sum(Selection)
DeleteDuplicateRows: problem with this macro
Help with scrubing two list of names
Opening Word from Excel
Named Ranges in external Data Sources
xml/Excel column order
Multiple variables
This code won't work, any ideas?
Declaration name
Active cell, row, column, worksheet, etc
Macro won't run
Vba goal seek
inputting text on Word document using excel
Record update date in cell
RE: Record update date in cell
Remove Hyperlink Path Message
Copying data to specific columns
Fill property
Get number of columns and rows
runtime error 1004 paste method of worksheet class failed
Help: Can't write to the right sheet
Using a cell's contents as a reference in Macros
Protecting vba code better
Excel XP Add-in problem with network shares
loading a ocx file
loading ocx file.
XML Source
Scrolling Text In Excel
Selecting Button Just Activated (help!)
Using VBA to create a Networkdays function
Sorting and Summarizing data
Sum of a Range (with a twist)
HyperLink Exception
Balloon button
Re: a way to color the CURRENT row or cell when selected
Pressing a button using a macro
randomize, grouping, copying
Get Addition of each Column in a sheet
find cell location of max value in column
import sheets of name selected
Pulling data from database
Need VBA Help in Copying Range
Increasing Excel stability?
Editing Textbox After Format??
open workbook using wildcard
Countif
Access Query with Password
problem with saving a workbook using VBA with the file is open bef
Merge Worksheets and Keep Format
Problem with Formatting Textboxes
Not Looping Through
variable range
Conditional formatting code wont work
template
Formula in VBA
class modules and array
Importing a large txt file
More File Attributes needed
Can this be simplified?
Aging Calculation
Not going through all Conditions
Pairs, Triplets, Quads...
Excel Macro
result on a new sheet
Excel open an Outlook e-mail?
Help with vba and Headers needed
Create a hyperlink to a hyperlinked cell using Vlookup function
How do I limit Input cells in MS Excel
When using worksheet.hyperlink.follow .NewWindow:=true
Spreadsheet 9.0 Control
run outlook express instead of outlook?
array of userform controls
run a macro ..
After each new dll compilation I have to set the reference to the dll in Excel again.
Using commondialog.showopen
Delete Tab Formula Problem
Accessing FTP through VBA Macro
nembers to text
Cell Protection
Can this be done
Multiple Ranges for Combo Box in Forms
Picture in Body . . .
Automatically enter today's date as a static entry
Outlining -- VBA Macro Package for Excel?
What's wrong with this?
Changing the font color using VBA
Worksheet 'on Change' event
How do I get a macro to ask for a 'range' to go to with a choice of Named ranges?
How to write a macro to open a file read-only?
how do you open a file read-only?
Any good book/Tutorial on COM add-ins for Excel
Scroll wheel in Excel VBA editor
excel, vb arrays and perl
URGENT: switch excel workbooks and display msgbox
populate listbox?
HELP - How can I protected a excel file to specific computer
Message box [how it works??]
Need 'save clipboard' property of 'Open file' function.
% in Filename
CDate and IsDate
Sequencial numbering
How to get list of emails in Inbox with senders name and ID?
Another UserForm Ques.
OLEObjects.Add strange behaviour
cell formatting - apply borders
Assistance in depth on class module for excel vba
object is closed
digital certificate being discarded from a shared workbook
Button using Form, Iteration and Input values
problem: when paste => validations lost => excel corrupted !
How to write a vba loop for Excel
Is there a way to insert a word document into a single excel cell
Locating a user's Program Files
UserForm Title Bar
VB6 form show Minimize button
Carry range names into copy of template
How to insert page number and number of page.....
worksheet protection excel 2000 vrs 2003
AutoFilter
Skip cells with Tab/Shift+Tab
Reference to Word document
Convert Excel sheet to PDF
Selecting a Range using Inputbox Method
Creating Help within functions
How can I create a custom data form in excel?
Unexpected error 1004 when using workbooks.open
Saving an EXCEL spreadsheet in fixed length format
How to assign a variable in a range select
Does querytable work with OWC11.Spreadsheet?
Must Be Missing Something Obvious About ListBoxes
private sub
Excel trendline - get the R2 value by code
Send worksheet to text file
Help with Pivot Table
alternative to TextBox1.Activate
How Do I Use Lotus Notes Stationery?
HELP - How do I determine my computers IP address through VBA in Excel
Excel /vba / computer IP address
Excel /vba / computer IP address
preparing/transferring data to database
Format Text During Function
Re: Run Macro From If Statement
Run Macro From If Statement
Preventing Users From Saving An Excel Workbook
Help with VB Call function from Excel
Form VBA
drop down list
Save as HTML
random number generator
Excel Macro - Help!!!
OnAction - Adding a command bar
Export as HTML Macro and other odds and ends
Control not installed on this Machine error in Excel 2000
autoamtically hiding a column after moving to a next cell outside
Disabling Save Upon Exit
Counting Cell Characters
How do I link Multi Columns list values to different cells in VB?
How to save a wordart as METAFILE?
parameter problem
Setting up a series hierarcy with a pivot table
Update Charts using VBA
Too slow testing
How to split filename from filepath?
can a User Form reference several sheets?
Using a variable to set a Range
Worksheet lookup
shortening a macro
How do I specify certain column to count rows in it?
Call File Browser ?
VBA and #N/A
Re: How do I get the column of a cell?
Read and Write Excel file
International Bug in Excel Solver
MsgBox - place and size?
Printing to PDF format using CutePDF Writer in VBA
Crappy message when using the "recipients" property
select case statement
Catch column width event.
Array output and comment
Macro Filename as Date
syntax difference between vb and vb.net
Extract from subtotals
extracting from excel spreadsheet and creating several files or sh
Copy function with using criteria
Looping thru files extracting data
Email macro
Print button on a msgbox
Import filter and update master
UDF Help/Comment
UDF categorisation
Help with Multipage Events
can v lock column
Copying Sheets Between Workbooks
macro runs counting
On Button Click(Help!)
enable/disable start button on basis of chkbox conditions
Using Classes in .xla
How to add data to ColumnHeads of Listbox
Problem in PasteSpecial function
Excel VBA Beginner Books
52 Bad file name or number - when reading file from FTP
Macro for Excel and Word
Unhandled Exception in Mso9.dll when Using XlCoerce with Excel 200
Activate method of OLEObject failed
Find - VBA
Position To Start At
Changing a Formula Variable
copy sheet
still can't find xlodbc.xla
PDF file creation
Data validation/Formatting input
Limit on Excel 97 file size?
refedits in a userform control class
Date Format Issue
Date Format Issue
SAVEAS OR MOVE VIA VBA
SQL Server Connection Pooling
repeated screen "blinking" problem when running program - please help!
Making writing not print.
Office 12 will be different?
semicolon delimiter in a cell
refresh data command message
PivotTable too big??
Automatically hide or delete empty rows after IF ?
compare sheets (values and formulas), alert it like spellcheckers
Macro with rolling database
VBA Code for Email
Excel 2003 VBA Question
Target As Excel.Range or Target As Range
macro in excel
Display a textbox embedded in the Excel sheet
vb6 form with listbox
Option Buttons and colors
COPY WORKSHEET WITH VALUES IN CELLS BUT WITHOUT LINKS
Automatic date or time in forms
Exiting Multiple Subs?
Extracting Pivot Table Grand Totals
Help with Loop Until
Re: New user help and Excel read question (Interop and OleDb)
Variables
Re: New user help and Excel read question (Interop and OleDb)
Recursion
Macro to populate next empty cell?
Deleting blank rows in a range or another fill approach
Inserting Value from one cell to another
variant and currency decimals
Embedding Images in Excel Workbook
Getting values from a dynamic userform
Re: New user help and Excel read question (Interop and OleDb)
a small question
short version of Index/Table of Contents
Macro code that will look for the most recent workbook
Find Value in Hidden Cells
Connecting to access
Can an image be inseted next to text on a button?
Linear Interpolation
VBA Help Contents Won't Show
Cant use this protectio method in a shared workbook???
VB.NET 2k3 and Excel Add-In
Handling Errors and MessageBox
Need macro to open a variable filename
sumproduct and conditionals
Worksheet name as part of Data Source parameter
What am I doing wrong....!!!
Re: Sending mail from Excel
RE: Navigating between option buttons is not selecting the option
ADO - closed workbook - Named range
RefEdit on Userform to pick up range in another workbook
Sending mail from Excel
R1C1 reference to worksheets?
Search Form
Re: Macro Wait command
Macro Wait command
BeforeClose vs Auto_Close
deleting sequential numbers
Another object defined error!
msgbox appear with error msg
Why doesn't the font color change?
New user help and Excel read question (Interop and OleDb)
unload an add-in from an Macro
specific worksheet can't be constant?
Making pictures global
Having problem adding up column wondering if HLOOKUP is the cause
open 2 files of different signature
want to link excel doc. to pdf.
Record Selection
matrix columns to rows
Long shot - bookmap
Excel Macro workbook_open() BUG with addins?
Insert Image on a form
Offsetting a varible??
Macro to Delete empty columns
RE: Navigating between option buttons is not selecting the option
Msgbox on spreadsheet launch
Linking Textbox and cell
global or local intializing ??
Help with code please?
WorkbookBeforeClose event is not canceled
Variables
Excel, Com, XLL and .Net
get data from other xls
how do I animate clip art in Excel?
Color names
open browser window at my given location
Error message
Colors
Log distribution random number generator
Re: Using SQL to query Excel Data
Getting only value out of a formula
colour palette
Dynamic Ranges/Cells??
IDTExtensibility2
Filtering data to another sheet
How to use VBA to copy this code to "thisworkbook" objects of all opened workbooks ?
strange vba interaction
Create an add-in from a VB module
version compatibility of excel macros
variable replacement help please
How to keep track of opened sheet?
Conflict reporting No of columns
Managing menus via VBA
Stopping User Defined Functions for Recalculating
Load VB Code every time Excel opens
Auto Close Excel Workbook
link to pdf file & menu bar in user form
Read 500 columns of CSV data into a spreadsheet
Read 500 columns of CSV data into a spreadsheet
How to jump between TextBoxes
Can I line up lots of controls on a sheet at once?
Search and Disallow macro in Excel
programatically retrieve selected rows from excel workbook
Copy a workbook
Populating a combo box from a Validation
Merge/Copy Separate Sheets into One Workbook
How can I merge Excel data into MS Word
Re: Psswd protect a sheet automatically upon closing file
People keep doing things they shouldn't on my sheet
Populate a range of cells from a function
Use counter to copy formulas
Need some help with some VBA code...
choosing dates on userform
problem with Paste-Special-Values from a List (range of cells)
import all sheets from a closed workbook
Date/time Stamp?
Excel (and ASP.NET)
Add any activex control to toolbar?
Unhide hidden/protected worksheets
help with a large IF statement.
Programmatically add shapes to a selection
set focus on user form
Need help with series chart, please
Use of Today() and change data type
Sort Each Row seperately
comparing worksheets
Change Olap datasource
Naming multiple sheets in a workbook using cells within the workbo
hide or remove rows
Comunicating with FAX software
Save As with specific format
working with a named range
Lotus Notes Stationery
Print area Macro
Delete blank calls in row, shifting left
how to tell if a named range exists
Variable with no Value inside Macro Equation??
I think this is ridiculous
What format are files saved in when printing to a file from Excel
Merged cells width
How to compose a Leave Table in text & color bar?
Help with VB Excel
How to use automation Add-In to replace Excel macros!!
can you show formulas in selected cells only of a worksheet?
how make a selection like sum function's
Clear contents/keep formula
Referencing Workbook Name
On error resume next? question - problem
Checkbox toggle true/false
Workbook slows down all macros
[HELP] How to use command buttons in cycles
Summary report questions
Subtotals
Adding Cells from Multiple Sheets
Re: HELP on TRANSPOSE related function.
where's my XML?
Auto button numbering
Extract Key word
HELP on TRANSPOSE related function.
XValues with variable end row
Delete a Commandbutton from another Workbook
adding into combo box and removing duplicates
MINIMUM OF POSITIVE VALUES only
Counting Rows Then Counting Values in Columns
How can I insert a picture from a file into a cell?
Relative Cell Reference Resolution Issue
Solver VB interface 'SolverOK' fails
Re: Isolating New Entries
Deleting all worksheets in a workbook except two
fancy forms
How to retrieve autofilter column values
Re: EXCEL, VSTO: Fastest way to access multiple cells
problem: changing a text frame's contents from an outside applicat
Re: consecutive numbers
consecutive numbers
End With Without With
Re: Excel 2003 Workbook Issue
Using COUNTIF with two different criteria
Selection.worksheets
automatically fill in a cell if the adjacent cell has any value
Re: POwerpoint information
macro select next blank cell in a row
Folder Size
Re: Hyperlinks and worksheet protection
Re: load speed
Re: Problem with Excel-VBA - Open Command after SP3
Dropping blank pages from Excel Spreadsheet's Printout
=now() -30 days
solver in macro
RE: Select Activecell in Range
Example of box with more than OK and cancel options?
RE: Sub to list colorindexes and the corresponding fill colours
Re: Flashing Cells (Like stock quotes)
Re: Sub to list colorindexes and the corresponding fill colours
Last Cell
Re: how do I use COUNTIF in excel. using criteria from multiple colums
Re: Locked in
Re: Sub to list colorindexes and the corresponding fill colours
Re: Excel 2003 Workbook Issue
Re: Copy & Paste Unique Cells Values
Tool bars and menus
Capitalize input
Combobox that would select worksheets
How to run EXE program from button?
How do I code VBA to return information from a web site to an excel workbook
What is going on?
Do..Loop
Re: Average based on value, not cell location
Selection_Activate
Regression
Copying and pasting cell contents
Deleting blank values from an array
Re-define a range in cells
Foto Slide Show...
Excel DataForm not shwoing right data
Getting random cells entering date please help
Excel DataForm not picking up correct list
Last Column Macro
How to desactivate the mouse scroll
Deleting rows with no value in column A
Excel Edit Form
RE: Deleting rows with no value in column A
Program compatability - 2002 vs. 2000
Auto Deletion of certain Rows in a spreadsheet
RE: Excel Edit Form
Autofill linked
Web Query -- Timeout Issue
Opening multiple workbooks
Need help to auto delete 4 of every 5 rows
Can you linke a ComboBox in a Form
Value From xlDialog
Random glitch?
RE: How to desactivate the mouse scroll
Autocomplete question
VBA Code to Select Range
searching excel with a form and returning the results
Creating a help file
Distributing an add in
Run time error
excel 2000 vs excel 2003: locking drop down boxes?
Auto Deletion of 4 consecutive rows out of every 5
Smoothing a chart line using VBA
RE: Can you linke a ComboBox in a Form
RE: Auto Deletion of 4 consecutive rows out of every 5
match / lookup
Too Many/No lInes are copied over
Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
Define name automatically
Validate data in userform data entry
How to open file in the background. It is possible?
Macro with =SUM doesn't work
VB Script
How to look at objects in the form
Autofill the formulas and supress the messages
Isnot there anyone who knows this?
Buttons move when printing
create a print menu
How to customize error bars by VB code?
Re: listing the names of files
Runtime Error
Automatic Saving as Web Page
automatically create a spinner and link it when a button is pressed
re: add new row
Cont question
Re: Macro to copy contents in current row to Sheet2
xl Dialog Function Wizard Arguments
Excel.xmlMap not defined
Unstable Code
Is it possible to choose a macro based upon a valve of a variable??
Object Required
Load a range of cells into a dataset with an opened workbook instance.
Help for a combo box
Setting a Range name
GET.CELL(4, What is TYPE?
Set Location and Filename to replace GetOpenFilename
New Workbook through VBA
Find wildcard text within a cell
Re: How to change Button Caption?
Keep leading zeros in a string array
add a new row
After dismissing getsaveasfilename dialog, my userform becomes inactive
Crazy Formula or Macro
I need to control how users sort in a specific excell worksheet
I need to control how users sort in a specific excell worksheet
Opening Excel & Addin
Invalid Next Control Variable Reference
Viewing posts
AutoOpen in excel?
Startup settings for specific workbook
Does excel worksheet have unique ID?
Open workbook with scheduled tasks?
Object Required
Re: Send Email VBA
Call a add_in function in excel vba?
Send Email VBA
Else If Problem
looping question
Formatting text differently within a Msgbox
Need a psswd verification form to open when the file is opened
Starting telnet/ssh from Excel
Multiple lines desired in Msgbox
Double click in cell using VBA
new line character in cell
Menu Item Action Changes with "User" accessing file
Is there an object similar to Matlab vectors/matricies/cells?
referencing hidden sheets
Excel - MS Query - changing location of Access data source
stop a macro if it does not contain
Sheet Lookup
time to calculate (one cycle)
Combining specific ranges from multiple worksheets into one
Passing User Defined Type Array to Listbox
Looping
How can I protect only cells that meet certain conditions?
Auto Deletion of certain Rows in a spreadsheet
Declarations Procedure and Duplicate Declarations
UserForm Help
Subtotal(s) range in Pivot Tables. Is it Missing?
RGB Colors of "Fill Color"
Reading Writing Data from One WorkBook to Another
Programatic Reference to Libraries
Shapes, Userform and Visible
XML in XL
Assign Macro to Command Button doesn't work
Edge Sequence Color
FTP
Add string occurences
how read value from last selected cell? It is possible? how get adress last selected cell?
Copying labels to Userform at runtime.
Transfer Value to another sheet with Macro
webquery with login first
subtracting from total multiple sheets (inventory) help.
Insert Picture in Pivot Table with code VB
Re: Filter by Value
Need to read number of PrintTitleRows currently set
Help with lists
Automating a report
System Error &H8000FFFF (-2147418113). Catastrophic Failure
Userform - where is the cursor ?
default names
microsoft internet transfer control
Programming with msquery
Using Excel 2003 SP1 - Removing a VBA module closes Excel
comparing 2 columns
Need to hide date
VBA for excel 2000 It seems a Microsoft problem?
Appending filename with date
Does a password exist...?
re-ordering areas
Pivot Table No Formula Results on Total
How to copy a worksheep in the same workbook?
Copy to cells based on Row/Column labels in another workbook
running two separate commands in same Shell
'Encounters serious error' on opening with user-defined add-in
Remove unwanted tabs
Excel GGVT To Save but not be Saved
Excel Formulas
Set active worksheet on startup
re:Macro or VBA
Naming list of non blank cells
Populating Rows
Re: How can i assign a marco to a command button
Message that opens when file is opened
Subscript Error
tips for initializing/reusing dynamic arrays
tips for organizing code for distribution
Compiler says "Invalid qualifier" when using Application object
#VALUE error in Excel using Visual C++ DLL
Charts in forms
How add events to a sheet in run-time?
Excel Workbook - Simultaneous Use
Setting a Windows Scheduler Task via VB !
Copying and Pasting
Shape Selection Event !!
Shift columns each click of the button
Input box
I'm sure this has been asked before....
Concatented Numbers Display as Scientific Notation
Copying From Master
Re: Open a closed workbook with VBA
Open a closed workbook with VBA
TurnOff Form Events ?
cut to matching sheet problem
chart.add gives compile error
Blinking text in Excel !
SQL statement in vba
sending email using macros
Editing worksheet while running macros
Shared workbook problem!!!!
Cell Color Code Website
Is there a way to sort columns
How to start a macro when openning Excel
Tfr data from one sheet to another
emailing a sheet
looping through specific worksheets
help with random numbers
Data filter brings in too much data
Different Color
FileDateTime for Internet web page
Convert a formula in a cell to it's result
email a worksheet
How to write a macro to print a dir on my c drive
Adding and Reading a ListBox Item
Add rows
Worksheet Deactivation Event
copy and paste multiple selection
Anyone know why this doesn't work
Value ina listbox from sql
Table of Contents - Data from unhidden sheets only
Excel 2003 Macro Certificate Failure - Help!
Selective Viewing
Server date stamp
Reference the last 13 rows of data
Re: If Statement Problem
charting in vb.net
Re - If Statement Problem
My VBA code in excel does not work on another PC
If Statement problem
insert formula in last cell
How can I set a range can't be selected!
How can i import multiple .csv files into Excel for analysis?
Conditionally Allow input or fill in data for a week.
Sheets or Worksheets
Userform question
Iterate through controls
Macro working in background ie not on activesheet
Determining if workbook is already opened by someone else?
Reading link in VBA?
Help Text for Add-in
PageSetup
locating and copying
Start Macro every X Minutes
From excel connect to SQl
workbooks.open and error handling
removing old data
Moving down one cell
RE: Moving down one cell
How do I call a method in VB from Excel with JUST code?
Can't figure out how to merge columns
RE: Moving down one cell
Add "BeginGroup" to customized shortcut menus
Modify Pivot Table Page Field
RE: How do I call a method in VB from Excel with JUST code?
dialog boxes interrupt macros
Lotus Notes Stationery
RE: Moving down one cell
Help with ThisWorkbook
RE: Help with ThisWorkbook
RE: Help with ThisWorkbook
Can not change Category Names for Axis
Can not change Category Names for Axis
Can not change Category Names for Axis
Capture Col number
Userforms - tabbed pages
Is it possible to ensure Calendar date is in range
Program calling up Excel - Not running Macro
Selecting a listbox item event
Changing specific Listbox value
Sheet1$A1:A1 vs Sheet1$
Words Equal Numbers Question
Macro to change value 2 cols over from search
Excel DIR
macros for end users
Functions to get range properties
Button Shortcut / Key Stroke
Run-time error '1004'
Using a ComboBox for Data Entry into a Cell
read only
Rename existing tabs
Saving over a read only file
Import Data macro
Web Queries
Copying Rows of data
Listbox
Coding for Userforms
macro to sum special to new sheets.
General Message Box Question
Code runs without error but doesn't print output
Please Test
How do I get the percentage of total for a large data set
Re: Encountered another Check Cell Problem
change column format
How do i get only whole numbers for a formula result?
Populate QueryTable Using SQL Server -> Connection Problem
Unable to format font after creating sheet
Storing Excel Data in System Memory
Encountered another Check Cell Problem
Setting the Width of a column
UDF, Change Event and Dropdown boxes
Naming a Sheet with a function
read excel worksheet
How do I move data based on a conditional column search?
I have question.. I have problem with Cells.find
copy table or graph and paste into powerpoint
Change number property for cell on another sheet
Copy/Paste Values
Custom functions using arguments with same name
Checking cell for 2 conditions
Bypass worksheet_change event
hide / unhide names
Copying the Editing in one file to Another opened XLS file
how to install macro?
Excel and Powerpoint
Moving a disk file with VBA
Problem with a search
find changes in a cell range, copy changes to another workbook
Range syntax
Access connection works in Macro, not in user-defined Function
Random Ltters and Numbers
Problem With Date and Time Picker Control 6.0
Is there an excel, public domain, rough cut capacity template?
working with cells numbers
Add-in problem
delete info via userform ?
How can cells be filled in to show quantities?
?? MultiPage Cancel/Next/Previous/Finish Command Buttons ??
Printing question
Navigate in sheet with a button
And...
Excel Communication
static automatic date
AutoFilter removal
checking VBA code
Excel CSV format
I desperately need to know which autoshape is clicked, programmatically
Excel Application for Business Modelling
How to clear a batch of VBA projects' passwords
How to put this formula using VBA
Referencing multidimensional array
Userform Help
Viewing UserForm code in Notepad
Time Format in VBA doesn't match Excel display
Help With Missing References
Macro to cut/paste to last cell
clearing the contents of specified cells
PivotItem positioning...
VBA code using Find to locate text and display the Cell Range.
Auto Filterning with HTML
workbook or worksheets
msgbox based on cell entry
get a sequence number from . . . ?
LEN
Randomlly pick number
TextBox Format/Editing Problem
VBA code to select data from table into combobox
How do I open an Access file with a macro in Excel?
Re: ChangeFileAccess
Re: ChangeFileAccess
Re: Problems with same macro diferent place
RE: transfer data between worksheets
Workbooks.OpenText does not work on XP. HELP !!!
transfer data between worksheets
ChangeFileAccess
Documentation/Reference guide
Close program
Make dynamic reports available over internet?
Re: Easiest Way to have access functionality in Excel or vice-versa?
Why does Outlook.Application.GetNamespace("MAPI") Fail?
Insert a key function in VBA script
Parameter Query not refreshing.
Selecting Rows with Macro
Excel Macro will not allow references
AutoRun Excel Macros
Control Tools
Reading from comma seperated List
URGENT!!!! creating records in a shared workbook
how to preserve data?
Problems with same macro diferent place
drop down menu
scroll listbox with mouse wheel
scollable listbox
Subject: Macro- Copy same rows into own worksheets
trouble with commandbarbutton.state
CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = Fals
Trouble getting the value of a cell
sendmail to variable
Help eliminating a space in concatenate formula
Hide/unhide sheet macro based on cell calculation
How to detect "F2 key" event
hiding rows with checkbox
VBA for sending workbook via Outlook
Move Folders on the Server vs. Local Machine
Excel 4.0 Syntax Conversion
Re: Copying 2nd Sheet
Code assistance needed
Application defined error
Copy on visible cells only ...
Allow entry only once
Macro Revision needed
specfic number formating
Copying 2nd Sheet
Macro Problems
Relative File Link in Macro
What is the maximum length of a URL in a web query?
Can macro create another macro?
how to save to Access
worksheet limit
graphs' source data macro
entering data to table
Update Website from Excel ??!!??
Refresh Pivot Table from other worksheet cell entry
Difference between 2 times and dates
CommandBarButton click vs. double click
hide rows with macro
Syntax Problem : Grouping Buttons On A Multipage
Create cell formula from a relative position
copying pivot table results to a new sheet.
TEXTBOX DROPDOWN
Re: currency and textbox.
Re: currency and textbox.
Re: currency and textbox.
Re: currency and textbox.
Code assistance
Re: currency and textbox.
currency and textbox.
Macro Errors
Unable to call external program/dll
rationalizing date format in column
Combo Box
time/timing/breakpoint (2)
Sumproduct in UDF
Find ranges of rows that contain 1
Updating Links
How to copy a range with same format !!
raltive cell ref conundrum
VBA with Matlab using Excel Link but not Excel Builder
Disable All Cmd Buttons Except Those Meeting Criteria
Do..Loop in multi sheets
MS Access Query
control other applications
Database output page --> Excel
Absolute/Relative Referencing & Buttons!
VBA help
Hide show blanks
Dynamic Cell Names
payroll record help
How to capture user ID in Excel macro?
Checking for missing references
Format & ControlSource
Shared Workbook - Print Settings?
implicit activation
prompt for password only once
Open Non-Excel file
"Could not locate some objects...."
VBA function , IsDate() not available
Re: Custom Function in Array Formula
Can I "park" a UserForm?
Button to open excel file
how to extract XML info with VBA?
vba routine to print a list of documents/worksheets
Opening a browse and load file box in a macro
If A is poplated, so must B
Range R1C1 notation & the problem with my Macro
hide rows from checkbox
how to avoid excels run the antivirus
missing buttons
Character Set 032 vs 160
Context menu on userform
Hiding macros
Newbie Question
Msgbox prompt and tabbing
What needs to be installed on the server for excel automation?
Searching for a root directoty
Transposing a column to several rows
excel VBA for auto open PowerPoint
testing for #NA with VBA
Impossible??? or you can????
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
updating a workbook based on previous values
Write to One Worksheet Only ?
Turn Calculations On without Calculation when Turned on
SendMail
VBA Proper Case Code
ComboBox,Array and Index numbers
Importing a large amount of data using Basic
how do I prevent a file from opening if user has disabled macros?
Programmatically scrolling to top
ADO connection/SQL query in Excel function
SaveAs causes 0x800A03EC error
Modeless userform OLEObject Add problem
Macro help on dynamic sheet
web interface for excel
Cell Reference
Make more info appear when mouse moves over a macro command button
Code to Test Condition and Save Record to Excel
Dialog Boxes: PC and Mac
Application.VBE.Version on Excel XP
Dates
Array max formula?
dropdown list to activate Macro
Simple Division??