Excel Programming [Archive] - Page 115

Getting data from a workbook without opening it
sendkeys problem
CountIF on two conditions
Message Box Improvements
Starting macros when cell changes to TRUE
Getting error "Too many cell formats!", how do I correct?
Re: warning/error message
Macro Help
ByRef argument type mismatch error?
Go to another macro
Data import/extraction question
Setting up a List Box
Runing part of the macro
Macro Help
webquery loses format of leading zero and to scientific
need a formua for wages
bar graph colors?
Copying spreadsheets in directory into master spreadsheet
Sending Workbooks via Email
Cell data validation
Getting the row/column number
how to use a macro to copy cell formats from one workbook to anoth
simulate a enter key behaviour?
Correct Syntax for Calling other Subs
PING ... Bob Philips
Setting sheet.xlt for a workbook programatically
clipboard cannot be emptied
Variable not defined compile error
cuting some text from field
Automation Error : The Object Invoked Has Disconnected From Its Clients !!
Pivottable problem
Yahoo Chart Into Excel
copy formatting
code to check a: drive has a disk in
coding help again
error - copy
range = range
Trouble with validation
A VB code for creating count down timer / stopwatch...
find pagebreak
Excel pivot fields and trailing spaces
Excel Process Doesn't End :-(
message without stopping execution?
option group on excel sheet
Command Button Problems Still
userform
Excel 97 vs Excel 2002 coding
Line colour of .SeriesCollection.NewSeries?
active a set of VBA code once the cell have data.
Disable command button
excel 2002 vs.
Binary operations (left/right shift, binary and/or, etc.)
So easy you will probably laugh
Formatting MsgBox Text
Where is the computer's archive?
Enable Command Button 1 & 2
copy then paste a chart as a picture
Delete sheets with "@"
Placing a form inside of a form
Message box when date expires
Find & Delete Rows
Excel in VSTO
Cell lies within range
Userform Objects
"Subscript out of range" error for: Workbooks("Test1.xls").Save
Need coding help.
Access toolpak program from Addins
Summing a whole column
page number middle of sheet
Calling a specific version of Access.
sub call with string
Excel Macro or VB?
EXCEL-VBA, ADO not connecting to a TXT file
Complex formula?
Copy formula
Need to fix the number filed so all numbers are 8 in length
How do I find the number of elements in an Array of Strings?
Referencing a Range
Find the Format Type of a cell
Help me clean this up...
Workbook Copy
How do I create a Macro?
Freeze IDE or other strategy ???
Formula
SaveAs Protection
test
Error: Sub or function not defined
Split Function
Password on Save As
Problem with TRIM function in Excel
Referencing a Range
Find the Format of a cell
Paste Function Value
Referencing a Range
how get value of status bar sum?
disabling right click
Excel 2003 - Error Running Macro
Rename Textbox on Worksheets
how to update a pivot table on shared workbook
SQL question
Split function
MsgBox Display
Problem Running Code in Excel 2003
add form with excel 2003
Fill Down to variable row
vba and conditional totalling ... WorksheetFunction SumIf ?
Protecting a workbook
VBA Recording wrong... whats the deal?
RUNTIME 424 OBJECT REQUIRED???
ofind
Dynamic Array problem
setting up a hopefiully simple macro
Summing Like Element Array Values
Excel linked spreadsheets
Generating Ranges in VBA
Can I autofilter across multiple worksheets?
Turn ON Autofilter Filters
Can I autofilter across multiple worksheets?
Runtime Error 1004 Select method of Range class Failed
Draw a Clickable Button on XL Title Bar !
Save As macro
Favorites.xla
Creating a virtual table in VBA Excel
Creating a virtual table in VBA Excel
Controlling Word from Excel using Mail Merge
slow code needs tuning
Drawing a clickable Button over the App title bar ?
Need help to convert formula
Fill Macro
Copy non-Zero columns to new location macro
Range varying in for loop
Copying cell data without the formula
Problem with Option button control in multiple sheets
paste table from pdf to excel
paste table from pdf to excel
worksheet change event with .NET interop
paste table from pdf to excel
paste table from pdf to excel
getting a cell value from another spreadsheet
When does entering data into cell end?
Specify ScrollArea in a Sheet
In Excel 2000, how can a macro look for the next empty cell?
How to avoid deleteing certain rows?
Help with creating template for users, need to protect cells, but...
Summarizing Data from other spreadsheets
paste special
Running Dialog Sheet when opening Excel File
can't use Application.Run() with apostrophe in file name
List Box Help
EXCEL FORMULA
Variables
pivot field definition in VBA
pivot date/sort show
pivot zero values
pivot zero values
pivot date/sort show
Weird Mouse Problem in VB
pivot zero values
pivot field description in VBA
Get the Excel Filename after a save
Better way of finding last row on sheet
Filtering based on row
VBA Precedence Problem
Find Min value in range with VBA?
Finding the Value (of text and numbers) between N/A's
_Workbook::SaveAs(...)
coding error
Excel on PDA
custom function
Version # in excel
update txt file
Trapping an invalid email error in Excel VBA code
Create Function to display name of variable
original messages in the reply
Missing Numbers from a Range
SaveAs CSV problem
FileSearch FileName using wildcard (?)
Do Until problem
macro code to change file-opening password
Add 0 to the beginning of the cell
Controlling toolbar available
problem passing an argument to a sub
Re: using an if then statement call a caption box to a cell
Default to Read Only
using an if then statement call a caption box to a cell
Help!!! Alerts in Excel!!
Programming Question
using an if then statement call a caption box to a cell
Move the cursor to a cell in button click event
Event of the dropdownbox in a cell
Calling a common XLA Library file, stored on a network drive :)
Calling a common XLA Library file, stored on a network drive :)
Cell has a value of #N/A when the formula refers to nothing
Complicated "what if, then" formulas
Delete the list name from a cell range
Auto sorting multiple ranges on event
Custom Menu Focus
=IF(B3<O;nodisplay(graphA);display(graphA))
Subtotal Truncate
How can I use 2 diff. recordsets without opening another db connec
Excel Worksheet Subtotals Data Truncate
combining tasks
Hide cell range in worksheet
Mysterious " " in SaveAs Dialog Box
Splash Screen Problem
Please take a look at this working code and critque it.
Array Formulas in VB
Formulas
How get sum value in status bar?
Prn file carriage return deletion within notepad
custom function
symbol
Shoving Excel Columns Into Word Table
Outlook Email Reference
Question for dummy
Refresh pivot table on a Shared workbook
RE: Change size of comments?
Batching files through a macro
selection.copy is getting nixed
Conditional Search & Cut and Paste *VBA?
Debug RuntimeError 1004 in Chart
Remove Invalid Phone Numbers
Cell in Header ?
pivot row field definition in VBA
open file from folder save in new folder
Display color (or Format Cells) dialog in a macro?
open in old directory save in new directory
Userform runtime controls & Macs
Error check on sheet
moving columns and selecting for copying
Can I....
Paste Special???
copy but don't overlay
execute code in one worksheet when change occurs in another
class module?
Re: Change size of comments?
Summation with a Condition
How to create a message that appears when opening an excel file
Stuffing a picture into a header
Condition IF problem in Excel VBA
Condition IF problem in Excel VBA
Colours in pivot tables
Extracting choice from a ListBox
How To Delete an Excel Macro by Using Automation
Autofilter & delete lines
Web query against MSN Money
FileCopy Command Giving "Subscript Out of Range" Error Message
How to minimize a userform!
How to determine if a connection is active
Using An Add-in On A Network Drive
multiple pivots updated with selection in one table
pivot field of fields
Hiding Rows and column's
Email Sent or Cancelled
Add/Run macro programatically OLE error
copy one cell to range of cells
Allowing entry only once
Questions with Printout and Close
create autosum macro along with notation
viewing SQL when MSQERY cannot attach to DB
Using sheet names in menus etc
Simple function made difficult
Extract Path From String
Importing data into Excel
active x radio buttons in excel
data grid
serach using a cell value
sequential numbering
Excel2000 VBA: How force the procedure to wait until queries are refreshed?
Help On Pulling Data By Column Headers?! Thanks!
Odd or Even
Can macros/functions interrupt formulas?
Macro to edit a formula.
Finding links
refer to unknown window name
Mail Single sheet as HTML(HTM) file
Changing a pivot table page or data set by using a macro
error when I save workbook to network server in Excel 2003
Office Automation - Capturing Custom Menu Clicks
Radio Buttons in VBA UserForms
Copy selected cell in column and fill in blanks
TextBox BackColor
How to mention a range of validation list in VBA?
Xth Weekday of the Month/Year
How to reference worksheet name with spaces?
return multiple results from stored proc
Auto Set Print Area
Dynamic Data Validation
delete vbcode dynamically
list of linking cells
Coping formula down
macros don't work if opened using IE
Just another error message
How to run a macro in code
Using Loop to create Array
100M = 100,000,000; 100k = 100,000
Assigning cell address components to variables
Master details in 2 dropdownbox
select vs. activate
Solver: 2nd function of SolverSolve
sendkeys problem for telnet
excel cell and data formatting
removing digits from one column to another
compare and extract using a program. i really need help.
Scroll locked in multiple worksheets
Formating Body When Sending Mail
Create a newworksheet with VBA code and put VBA code in the new worksheet module
Closing excel userforms
sum monthly to get quarterly figures
Textbox keeps moving
Application.ScreenUpdating MsgBox
number of rows returned by autofilter?
File listing in excel
Counting unique text/number cells from a range
HOW DO I AUTOMATE CREATION OF JOB SHEETS?
Columns Selected Array
Can you call VBScript code from VBA?
Random error 91
Error 91 - Sometimes happens, sometimes it doesnt.
Autofilter - 3 conditions
Combo Box Filtering
Last column
paste grays out after function performed
Trap SheetBeforeRightClick event from another workbook
"File Now Available" For a Read-Only File
Creating Toolbars
Timed Macros?
Roundup / Rounddown function
Strings
Set Excel Author Option?
Matching data macro in VBA
Function doesn't work correctly with protection on
Using a Variable to Reference Workbooks
Copy Data from External Spreadsheet
Assign Range - Inactive Worksheet
How sort my working sheet not the main sheet?
Stop user selecting more than one sheet at once?
what can classmodules do
capitalization rate mortgage equity analysis formula ellwood metho
taking data at end of column and sending it to cell in another workbook
Referencing a cell, not the value
Another Data Validation question
Invalid "format string" argument in Format fuction
Data Validation question
Matching data rows from two different sheets into a new a new one
Wait for Pivot Refresh to Complete
What is wrong with this code?
I want the calculated date value of a cell to be the TAB value...
ActiveWindow.SelectedSheets.PrintOut
position of inputbox
Re: Use Autofill in a macro to fill blank cells until next text -
Disable macro in excel automation with VC++/Win2k
Excell Newbie Quesion Please Help
Multipage on a userform
Prompt a user during a macro
Pivot Table (same level hierarchy fields)
Pages on userform
Help with the Macro.
SQL syntax
VBA Validation
Formula For Each Row
Linking Workbooks
Truncating Ctrl-shift > Edit > CopyPicture
HELP!! Exporting formatted text file
Two (probably) simple questions, but not for me....
Accesing to excel macros by COM
Importing data from one workbook to another programmically
VBA Trouble with Hiding Rows
Sending fax from Excel
Run excel in visible mode from aspnet
remove duplicates using vba
Calling Macro - Will it take variables?
Hi All - Declare Decimals
Select Text in TextBox
run a macro at a set time
Change column Delimiter programmatically
complex "if" statement
User Intervention Required When Opening Workbooks
variable form control
Search and Analyse
put user and password into a web page
Excel -> Macro -> DTS ??
How to deactivate cells without macro references
1 normal form
Browse Button
Setting spreadsheet defaults
Looping thru columns
PivotItem.Visible
Problems with filtering!!
Help with active X combo box
How to paste without formatting
VBA, Conditional formatting, Days outstanding count
copy sheet without links
Need to Wait for 'Print' or 'Close' (VBA)
can you make a password active after a certain date?
Re: How do you loop NON-SEQUENTIALLY?
calendar language
How do you loop NON-SEQUENTIALLY?
rename worksheet
Run-time error '429'
Event handler in a cell
Dropdown box in a cell
Keep the scrollbar at position
How to 'RUN' a worksheet
Link Problem Can a MAcro do this?
How to make a row unscrollable
Excel2000 VBA: A problem with worksheetfunction MATCH
Add values to a dropdown box
Very newbie
How to make a dropdown look up box
Button to copy sheet, rename sheet sequencially.
RE: How to highlight active row and column?
RE: How to highlight active row and column?
Copying a Value Down a Column for Every Value in An Adjacent Colum
Excel - Find & Replace text in a string
Command Button
Summing columns after insert rows
(in)definite article and leading/trailing space remover needed
I can't remember how to...
Chart.Export failure on certain machines
merge multiple files from text list of file pairs
random list in excel
RE: Recorded macro won't run
Change Background
Insert worksheet
VBA Protection
Inserting a worksheet into an open workbook via VBA code
Chart Macro
Can I embed a WORD document in an EXCEL spreadsheet cell
loop code needed
What's in a (macro) NAME?
Re: finding the number of rows and the first row with a specific value
Re: Length limitation of cell formulas
Re: Look for value in a column and delete
Re: How to get a macro to work in different workbooks ?
Re: Look for value in a column and delete
Re: Time format and various users
Re: Range Names-VBA
Re: finding the number of rows and the first row with a specific value
Re: Further help on delete criteria found
AutoFilter
Re: Time format and various users
Re: AutoFilter
Macro Writing
Re: Flaky combo boxes. Work around?
Re: Printing selected rows
Re: Look for value in a column and delete
Re: Macro Writing
Re: What's in a (macro) NAME?
Re: AutoFilter
Re: Improve code
Re: How to get a macro to work in different workbooks ?
Re: Code problem with text box
Non-adjacent area selection
Problem with a recorded macro to create two pivot tables from same data
Re: AutoFilter
Date Modified from an External Internet Source
Re: Referencing .Net DLLs
RE: Recorded macro won't run
Re: UserName
Re: summing comma separated values in a range
Re: Length limitation of cell formulas
Copy data from Cell to Cell
Re: Improve code
Re: Data>val question
Re: Combining multiple Excel files into one html?
Re: Range Names-VBA
Re: Improve code
Re: Further help on delete criteria found
Re: Non-adjacent area selection
Re: Macro Writing
Re: What's in a (macro) NAME?
delete row if no data, non-contiguous range problem
Re: What's in a (macro) NAME?
Re: Combining multiple Excel files into one html?
passing argument problem ??
Specify Printer and Prompt for Number of Copies?
XP Styles in Excel Form
automatically send email in excel based on value/macro guru stuff
Changing Range in Forms Drop Down Without Selecting
Offsetting Cells
Runtime Error 6 Overflow
averaging N rows in column B which have a certain number in column A
Copy data from one workbook to another
maximum as to the csv data that can be downloaded in to Excel
delete all rows above a selected cell
time-stamping macro
Can use arrows after App.InputBox
Advancing from Cell to Cell on Key Press
I have a kind of complex macro or vb script I want to program but do not know?
selecting a range
Help with Enabling / Disabling Menu Items..!
Data Conversion ?
Highlight Value of Text Box
Not understanding If Not..Then nothing
Fancier Protect Sheets, Workbooks
Help with Macro: summing together/roll over rows (Energy Trading, see example)
How do I change an integer into hh:mm:ss
Ending Looping Macro
Remaining Numbers from a List that are not used
multiple workbooks reference
A Login Macro, (Inputbox & MsgBox)..Need help with a counter.
How to format Series with VBA?
How do I create pop ups in excel?
Why xlAxisCrossesMinimum works as xlAxisCrossesMaximum
overcome from the restriction of number of IF statements
Copy Workbooks and Paste into same spreadsheet
Web Query output, how to format?
How to move cells with VBA?
Update links within a spreadsheet
validation
vba project stopped working in excel 2003
Help with a dropdown list
Selecting a Range from an Offset for deletion - Help please
Exporting data to text file
shortcut to open file in personal.xls blocking file's macros
selfcert.exe
#N/A Shortcut
Programmatic schema mapping, XPath.SetValue question
HOW TO DISABLE ALL MACROS in BeforeClose event handling procedure
"Excel CLOSE" ERROR
Sizing a Chart Sheet to a Word Table Cell
Apple to Orange
PublishObjects To A String?
If page does not exist
Numeric column in Excel
Toolbar with macro
how do I code 'before:' and 'after:' in vbs
be able to edit datalabel position of all series in a protected ch
Be able to edit position of datalabels in a protected chart.
What object is it looking for?
How do you Print with a loop?
menu bar & chart menu bar
If Statement: How to test if a cell is merged or not?
How to if excel is running in a web browser
Pivot Table : How do you know where they are (scanning all sheets)
Need help for Printing Macro.
Help with lookup code
macro help please
Project-Library Error
Re-POST: How to close forms opened from other workbooks...?
Copy and email
Dynamic VLOOKUP from external, closed workbooks
Send V to com port
SQL Results, Totals, Updates, How to glue this all together ?
Excel Range Value issue (Excel 97 Vs Excel 2003)
tearing hair out - Listbox collection
creating a 'routine'
Please HELP!!!
Re: Textboxs as dates
Help with saveas ftp file problem
Time needed for the group function: big diff between Excel2003 and Excel2000
PasteSpecial problem in Excel 2002
Need macro to analyse a column
Ontime procedures
Update sheet after changed Interior.ColorIndex
use excel sheet in a different language
Subscript out of ranges - Friend8899
If Image. . .?
Run Excel Macro from Command Line
How use =now function and how to retrieve data from another shee?
Start Excel Macro upon opening of document
Auto calculation on a userform
Problem with the end of this code
Data Validation Listbox problem
Help w/Protecting a Pivot Table through many unique passwords
Problem cuz of Hidden sheet
Organization Diagrams in Excel 2003
lookup
Can you Import & Export toolbars...?
How to close forms opened from other workbooks...?
MultiColumn ComboBox Value set/display
Workbook_BeforeClose
Can anybody crack this VBA problem?
How do i get VB to reckognise an empty cell when excel thinks it's
Formatting e-mails after creation
Problems with Excel VBA application
Remove all manual page breaks
Strings
how do I write macro to copy the value of a cell to another if va.
Spin Button
Can't protect chartsheets in my workbook
DisplayAlerts = false not working
DisplatAlerts doesn't work
VB code help
Menu Item name
Day of Week and Date in same cell
Taskmgr from VBA
Need Urgent Help!
vba goal seek 2
flash cards
Refresh BackgroundQuery fails
List of available printers form?
Custom Menus & "Begin a Group" option
Write selection
Comment Text Promt
Sheet Offset - is this possible?
before close problem
Trying to switch to a different sheet in a macro?
sorting
Workbook/sheet protection doesn't seem to work
Anyone know why this wont work?
Macro recorder
Workbook opens really small after protected
Create New Workbook - Name book - 4 Sheets - Name Sheets
TEXTBOX - VALIDATE DATE INPUT
Combination: DataValidation auto appear + show all rows
Formula For CTRL+SHIFT+;
form textbox wont word wrap
Zoom event
supressing a message in vba
How to make sheet continuosly re-calc
Adding rows
Name Surname combination
Using ADO With Excel
add text box values
how do I package an application in Excel?
get all sheet names in comboBox of activeworkbook and export when selected
display correct toolbar icon on starting excel application program
cumulative time in excel
simple function question
Custom Function: Detecting the cell the function is used in
How to Make a Loop count by 1% not 1
Save a BackUp of Workbook
Manually Update Listindex
Export to Range from Access with TransferSpreadsheet
find last row, add "Total" in col B & border
Retrieve Index of Activeworkbook?
Possible too - ADD Text While editing a cell
Password Seen as Stars
Divorcing 'referenced' workbooks
Use of Sheet CodeNames to Select Sheet in Different Workbook
How to make values of spreadsheet show in a modeless forms text bo
Using Macro to save form to file
Using a save window with VB that works
Add new inventory list to existing list
Break a long row of code
String converted to date
Paynter Chart
Won't accept range name
Can you help me to improve this macro?
"Clean Me" Macro is giving "#VALUE!" error in the Notes field.
Multiple Choices in a cell with HLOOKUP
busted workaround for 255 character limit in cells
pastin' in my worksheet
inputBox if cell >" ?
How to remove a Java Script
How to Switch the ODBC connection in Excel
Form Input-->Submit
Question on design
What formula to transfer data from yesterdays s/s to todays?
Store Variable with Exported Worksheet
Re: Can VBA determine if a cell/range is in a group?
naming ranges with VBA
BeforePrint Add In
Can VBA determine if a cell/range is in a group?
Excel Addins Not Loading on Start
Linking excel and acces¿¿¿¿
Macro to capture cell value then use it for a relative range selec
Issue with owc11.dll
CTRL+Page Up and CTRL+Page Down
Slooooow PageSetup
Code works intermittantly is there a fault?
Pivot Table Black Down Arrow
ThisWorkbook BeforePrint
Counting Letters
Re: large validation lists
Dependents
Issue Commands To a DOS Window
email sheets 2,3,4,5 ect. to users from a list on sheet1
Wrap text in VBA
Sheet Size
GetSystemTimes
Help in copying range
Dynamic range copy.
merging cells/data using a Macro
How to hide VBA from others
Comment shows on open then deletes itself
Spell Check
parameter has multiple values seperated by value
Unique Dynamic Validated List
Problem with closing workbook in macro
Function that returns worksheet name and updates on rename.
an afternoon with a dot and a commer...
Finding Cell Contents
Drop Down Menu
Comboxes
Code to transfere all cell data in one old file to a new open?
Simple String Conversion - HELP
Direction problem in inserting strings using right to left language
Time Sheet help
Macro to sort worksheets alphabetically
Control Display Area
Pivot table is not refreshing problem
Workbook_AfterSave Event?
Macro to Make a Macro
print dialog box with 2 copies as default?
Using an input box to search for a value ...
Window Error when deleting shapes
Move all files from one directory to another
Need code to compare cell values in a column
How do I convert a selected Cell address in a Range to Values?
Set an Excel generated CDO email's priority or importance to 'high' or'highest'...
Comparing Formulas Between Worksheets
Changing Cells format using VBA
changeing date formats when not intended
Mutiple Instances of Excel - Which one will Windows use to open a file?
reference 2 arrays in a For Loop
Numeric field overflow. (Error 3349)
Advance filter search does not filter an exact match
DROP DOWN LIST
can I add to a defined name in a macro?
can I add to a formula in a macro?
Re: Cell Reference is Worksheet Name in VB Code
userform printing
Cell Reference is Worksheet Name in VB Code
Sub to copy a target sheet from slaves from and paste/overwrite into master
Counting instances of an offset value???
How do I access a variable from another instance of excel?
Predictive Model Needs Macro Timer!
Stop SetLinkOnData
How to compare multiple cell values
Cut and Paste to DataGrid
Footer font formating in Excel
Linking with Outlook
getting filenames from a user selected folder
Limit text length with inputBox
Update Columns based on External Text file
how do you use a variable a rage?
User Form Question
How do I insert a preformated paragraph into a comment?
Displaying a selected value from a combo box
VBA Code for selection rows
Pagebreak function problem
import from web
Excel Com Addin
how do I create a macro to "Go To" a location specified in a cell?
Assining the value of a vlookup to a cell rather than the vlookup
Create Multiple Worksheets from One
Movefile "Permission Denied"
Bitmaps in custom toolbars look awful...
Closing a workbook without saving from Word
Excel MAcro/Printing
Data Parsing
Hide Rows From a Row to Last usedCell.Row
Changing visible (filtered) cells
Insert
getting it to work
Filtering in a macro
import blank lines in excel 2003
Information Box using SaveAs xlHtml
Changing Name Range based on imported data
Find and highlight results macro
Simulate Click Event
how have status bar "Sum=xxxxxx" use commas=>"Sum=xxx,xxx"?
Searching a database in excel
EntireColumn.AutoFit - Slow on Large Files???
VBE Window not working correctly
Auto-prompting to change the links source file
Setting Default of Checkbox based on value of combobox
difficult but supposing not imposible
Me.PrintForm -> landscape
creating new sheets based on specific data
VBA Code help - first timer
Can I move images in Excel forms?
relating to named range in vba
Pivot Table calculated items with dynamic file source
What can cause application.screenupdating=false to not work?
My code does not run on another computer
Call Macro from another WorkBook?
Need Macro1 to call Macro2 stored on Network drive
Programming automatic data entry?
Refreshing Data Pulled Thru a Function
Too Many Line continuations?? VB Macro
Slow Saving
Userform Control Type
FAQ? Searchable archive?
Update Links - Startup options.
filling an aray without looping
ADODB is unable to copy more than 255 chars in excel cell
ADODB is unable to copy more than 255 chars in excel cell
Excel 2003 Pivotchart Macro
More help needed with listboxes
Specific Row Designation
another VBA newbie question
I cant do a search on this forum. Everytime I search, it comes up with zero results
Conditional actions
can I assign a macro to a cell?
Help sending Lotus Notes mail through VBA - one last piece!
'ActiveWorkbook.Names.Add Name:' how to make range variable?
incrementing columns in a loop
Stop running a macro in the middle of a macro
Can I build a sentance from data tables in Excel?
Filling a listbox with transpose of a range from an excel sheet
Copy Macro
remove duplicates
Shapes and VBA in Excel 2000 and 2002
Dynamic input range
range construction
Refreshing Pivot table Pull Downs
Open a specific worksheet in workbook
Cell Ref to identify worksheet
Minimize Form
optionbutton
Vendor Sourcing Tool
Function to return Character Position of Xth character within a string
Comparing charts after cut and paste
inport txt file automatically
Webservices References Tool 2.0 - Error: No Deserializer found ..
count data
Can't load or unload object
Simple, but I don't see it
How can I keep the format of cell content when I copy it to text b
Date format changing on edit > replace
Form
Adding Separator Menu Item - Excel 2003
empty columns
macro compile error
How do I bind a list in Excel to a combo box on a userform
How do I alternate a sort from a text box via macros?
How do I alternate a sort from a text box via macros?
WorkSheet Macro Help!
Excel as an OLE DB consumer
Find a row and a specific cell in that row
Can I create a macro to identify and delete blank rows in a range?
Multiple sheets using single chart
How to get font of particulat word in text inside a cell?
Unable to run Excel addin procedure from Word
Can I fill a spreadsheet thru the Internet
Shared Workbooks
Threading Problem
Dumb Delete Question
Formula result incorrect
Keeping track of code
Validation input message box
How do i open a new instance Excel?
Writing text string with imbedded quotes to a text stream
Sum Formula in Macro
Protecting Spreadsheet
What does this mean?
Jump between sheets
variable for columns(??).property
Shared Workbooks
is there a better alternative to Copy/Paste?
Changing row height conditionally
macro for self destruct
Managing Add-Ins
Value based Text Colors
Excel doesn't have enough rows
Choosing items in a list box
Merge worksheets in "Share Mode" (Excel 2000)
visual basic
Excel2000 VBA: First workday of month
Can I sort a table using a macro in a protected worksheet?
Assigning a macro to a button
Inserting a drawing object into a cell
Accessing "AllowEditRange" without unprotecting sheet
UserForm R1C1 problem
Uppercase a text box
Properties of a jpg
How do I denote values stored in columns in my macro?
remove last part of string
Current User or Author Stamp
On Error and Loops
Excel 2003 Userinterfaceonly Password Protection Problem
Type mismatch on range name
New to Excel + VBA - Need help...
Delete All Files in a folder
Calling an embedded items event procedure from within a normal module
How do I convert peak-peak voltage to rms voltage in Excel?
VBA Excel formula error
Application-defined or object -defined error
Excel VBA macro crash
Changing the year only in a date
Creating an event procedure question
problem with reference
Conditionally format row height
why do white areas in raster images print spotty
page setup with Excel4 & Waiting Form
Dates and Input Page Help!!
Why am I getting this message
I'm a newbie
Compile Error
How do I access an unopened spreadsheet from a program?
How do I Paste thie answer into specific cell using vb...tia sal
Writting to Word using an array
Combo dropdown open
MS Query
clear contents cells of unprotected cells
Goto a dynamic cell address within a macro
Excel 2000 Macro
Solver Error
Email Macro Late Binding
Delete a command button via VBA
how do i change font size in msgbox
Macro doesn't run on new machine
Importing an Image (jpeg) in Excel
excel to html
Excel to Word
Delete Macro from VBA
Application.Interactive=true ignored?
Shrinking Listbox
Freeform shapes
Double Numbers
Supressing the Macro security message programmatically.
Sending Userform data to different sheets
Class Module & Module
Is there a NET-Control in VSTO similar to RefEdit?
Hooking TIB R/V to Excel 2002 RTD
EnableOutlining with shared workbook protected sheet?
Excel crashes after quiting
template 4 proj cost analysis (sales value - expenses=profit)
Creating a toolbar
How can I copy cell content to a text box?
Color of cell.
User Form
Sum a lot of box in different pages
Workbook_BeforeClose event is not canceled
ActiveX Control Events dropped | lost | blocked - Excel / VBA
Send To Mail Recipient
excel conditional formula
Duplication
Renaming sheets from a list
Close Visual Basic
RE: change audit
Summary sheet in a workbook
Running an Excel Macro as a Scheduled Task
Renaming File Statement -How does it work??
Subtotal Column Labels error
Auto Excel workbook close: save= false during an auto subroutine
x in checkbox
Microsoft query issue
Extracting value from Combination drop down-edit box
exporting CSV numbers become text
Days in a month Function
Updating multiple layers of links
Error, Worksheet Will Not Open
How Can I Prevent Data Entry In Same Category on the Same Date?
.PrintTitleRows
How to "show all" items in a Pivot Table via vba
macro in vba to display autoshape
data validation
Macro Question
remove all hyperlinks
Resolving percent and date formats as such in concatenate function and emails
RE: change audit
Using a cell value as the subject line
Clumsy VBA Code for Chart Source Data from Loop
Array loses data type when placed into range
For Each in Range
Checking File Attributes of Excel CSV over Inter/Intra Net
Place code from current workbook to new workbook
In Operator Equivalent
Editing controls after testing
How to Create an Excel file?
How do I synchronize two similar Excel files?
telling VB: if cells(a,b)="any number" then ...
format question
Trouble with VBA data assignment
Overwrite Master sheet when using merge macro
Save As macro
First double-click lost?
Simple Question: Select Text Box from Spreadsheet?
Carriage Return and Splitting Lines to Lotus Notes Msg through VBA
Re: Worksheet feature help
Re: Worksheet feature help
Lookup multiple values on multiple sheets
Fibonacci function/command in excel?...tia sal
Worksheet feature help
Where is the timer activex control in MS Excel VBA?
Password protection
Where to sell custom apps?
Save without VBA code?
Arrays
Range Question
Working with 2 workbooks
Can't get CF to work properly, Active Cell problem?
Language of the local PC
Auto filter and Next Row
Calculating Averages
Comparing double values
I have a VB related question,...
easy question about FaceID
Activecell - Probably very easy question
Supress Query Refresh dialog on opening workbook
last row in ANY column
Forward planning (networkdays without last 2 parameters)
Q. How do I code a column to insert current date, when I double-click?
Application Function
external data (detailed)
store chkbox.caption in array
refer to dynamic range in closed workbook with ADO
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error
Macro to know if Cell is Text or Number
Autofilter including incorrect rows
Changing the Worksheet ScrollBars Color !
VBA Query to Excel, Stuck.
Footers in which number of characters exceeds 255
picture scrolling?
Macro to tell if Cell is Text or Number