Excel Programming [Archive] - Page 84

copy several cells if one cell is set
SpecialCells
Developing a reporting package
How can I ignore value from a workbook that are not in my collection?
Is there a non-macro way to do this?
How to format the month of date
delete column sets current cell wrong
importing file using macro and all rows don't appear?
Macro to autofill (copy paste)
Transferring Data to Word
use of morefunc funtions in excel macros
ActiveCell.Offset on filtered data
"LAST SAVED BY".... (Help)
How to automate a import from a webpage
Saving entire sheet to SQL Server 2k: XML? values+formats.
Copy Spreadsheet or listbox
macro reading excel file
Clear Contents Help
Excel Worksheet Copy Search Help
Why can't I access VBA Help topics?
Protect file from being overwritten via "save as"
Enter Command
Dynamic Range for Pivot Table
Subscript out of range error
Combobox to Select Worksheet
Excel VBA Script - need to insert an override
Macro and Count function
Properties of Combo Box in Userform
How to switch off calculation on pivot tables.
is there a way to make dates simply be read as text?
Emailing from Excel
Use of PUBLIC
excel. if g4>h4 i want cell j2 to be 0
I need to sort an active sheet using the col of the active cell
Easy Question
Exceedeing the 7 conditions in a nesting fomula
Charts>Series>Values Error
Excel sheet: resiza rows number??
Selecting a Pattern of Cells
Check Headings
Load data from multiple spreadsheets into one master spreadsheet
Help on inserting rows and formatted content
Re: Error handling question
Error handling question
Error handling question
Strange one
NO RECEIVED ANY REPLY !
Speeding up a part of a procedure
HELP: Displaying a brand depending on the first 4 letters of a catalog.
Formula needs to reference anchored relative cell
Renaming a range
runtime error 6 overflow when running a macro
Validation Using A List Box
Sumproduct in VBA
I am in dire need of macro help!
validation? VBA? Lookup table?
How can I do the equivalent of "filesearch" in Office 2007?
VB for an entire worksheet
delete from 1 list based on another list
Select multiple Shapes
return non matches
Copying Cell data and pasting into word document?
Listbox text color
Run-Time error '91': Object variable of With block variable not set
Macro for printing specific worksheet from a workbook
Password Oddity
How can I put userforms from vba in web page?
Macro to select cells and then new selection from selected cells
VBA Library References - deployment issue
copy formula down and ever change range
Alarm
Named Range - help!
Change optionbutton to true for good
chart with macro
Display Totals In MsgBox
A macro that shows updates - OVER MY HEAD
Formating - Conditional
Pick a Random name from a list.
Naming more than one active workbook
really weird copy macro problem
Multi Select List box in columns
VBA Library References - deployment issue
Auto Fill Column with Date based on rows in other column
optimisation tool for objective function macro
Adding multiple sheets in one go
Unexpected output while populating a combo box
VB Project
Setting true/false questions in excel
Need help in VB6
Insert blank row above populated cell
How to late-bind Excel
Loop to add +1 in cell?
Conditional Hide Rows Macro
Error 2015 with Application.Evaluate
Accessing Macros (VBA)
VBA File Variables - User App directory
[OT] Google spreadsheet
overwriting formulas
Data Move
formula array gives compile error
Change properties of a userform
Add-in
Exporting cobol files to excel
Removing Drawn Object
Please help a newbie to VB!!!
SQL command help
sum program
Deleting rows with a two criteria
Check Digit:- A Real Challenge!
Protection of Objects
Run a macro outside of Excel automatically
Strange problems with setting hidden property of a range when sheet protected with UserInterfaceOnly
Select Case Behaving Oddly
Run a macro outside from EXCEL automatically
How can I open a Cad-drawing after fulfilling questions in excel?
re-execute vba function
VBA File Variables - User App directory
Automatic Unprotect / Protect
comparing sheets
Auto copy/ paste on relevant work sheet when selecting list item
earasing arrays
Self Defined Function Doesn't Update Automatically
Macro launches VB IDE window
Including an input box within a macro
Time and Date
Unlocking VBA project in Excel
Text into one cell
Pivot Table
Quick Excel 2000 VBA question
#NAME
Excel Checkbox and Calendar
Can I use a variable in a Range statement
Worksheet formatting with Macro...
SaveAs CSV file size
Excel Page Setup - Fit To Page option
Conditional format incorrect if not on starting row
evaluation a variable in an expression
How to download information from web using VBA ?
Bolding variable cell
Error I cannot figure out
Import macro
Need to Sum all values above
OpenText method not working
Combo Box Search
Printing a Word Doc
Pivot Table Grouping from OLE DB source
Searchin for dates
Snap to grid in VBA (actually a SendKeys question)
User Form Help Seems Simple
Subscript out of range error
Add comments via a function - please could you ammend my code/ pseudocode to work
Email question for Ron de Bruin?
Solver Maximum adjustable cells & Problem with Binary cells
automatically place the latest entry from a column into a formula
Hide rows that are empty without autofilter between data
Logical test as a variable in a UDF
Insert Column w/ Equation - Fill to bottom
Template - Save As File Name
Do contents of a cell match existing worksheet name?
Copying Data to Last Row
It works when I step through it but it won't run
GetSaveAsFilename Question
Find Last Row + 1
count unique combinations
Looping Question
Hyperlink question
Can't paste picture while Protect Sheet is on...
Deleting A Macro Using VB.NET
Data Move
Difficulty of creating a macro?
Speed Question
Copying modules from Word to Excel
Animated GIF insert - Reference file missing?
Removing <end> from appearing in outlook contacts
List being associated to another
Save As
macro to make named ranges
Search for a specific cell based on two criteria
Trying to SUM up a DATE/TIME field in code...
Deleting multiple items from a list box
Dim and Redim
Pivot Chart Customizing lost on Refresh
Make Values from formulas
Add Sheets
Optional Variables
Links
Need help with If/Then Syntax
create files from a spreadsheet
Getting values in row and advancing
Need help - extracting data from cell
controlling a form drop down based on selection of another drop down
Delete empty rows from a sheet
Setting EDoc Printer Pro in macro
Can't create AutoFiltered Excel worksheet using VB.NET
Selecting Separate Columns in VBA
Input Box Promt
basic template questions (on a network drive)
Default File location
In Excel, how to make a field required so it's not left blank?
One Sheet by email
How to execute a excel subroutine from visual basic
Macro help:replacing figures
Copying Multiple Items
Select case and Last Cell Problem
How to select what I want?
Excel VBA option button question
Tracking changes in Excel using an Event Macro
clear the copy
workbook name
Function help!
Unable to read file !
opposite of XLVeryhidden!!
How to add hyperlink to a string variable?
Macro help
Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions
Want to Hide and/or Unhide one or more sheets by providing Passwor
A macro to color the cells according to the values existing in a c
excell
Shorten up som sheets-kode maby a loop !
Macros across multiple files
Content from Text box to Cell
How get a row number of the controls(sample:optionbutton)
Visualize results of a custom formula array > 1818 rows
Visualize results of a custom formula array > 1818 rows
EssV functions Defination/Meanings
Creating a front end application to sql data set
MS Word question
EssV corresponding
Global Macro
What does this parameter mean?
automatically calculates the standing
Align to the left or to the right (or center)
Save as saves selected worksheet instead of whole workbook
offset?
Countif and and
USEDRANGE
Setting the active printer
ActiveX Controls are disabled
slow Macro speed
Importing data from Access to Excel, but I need to vary the table from Access
Using a macro to import field names into a spreadsheet and place them in different fields
Date conversion
InStr Function
Macros in Toolbar
Help with Looping Code
Named Ranges for Chart
How can I Hide?
DeleteFile Method
Help with code
advanced filter format problem
other options to functions which cannot modify contents?
Save problem with location
Can I find a string with or without a space after the last charact
Copy text from excel and paste in word - Urgent Help
Checking Sequential numbering
Proper code
floating legend
Strings not comparable??
cell value to text box?
Color contents of a cell accessed by a function?
Beginners question: how to stop / abort execution of vba program
need a variation in VBA for subtotals
help for Visual Basic Find
Help with coding error
Test for Hyperlink
Verifying path fails for no apparent reason..Clueless
Tables from web to excel
Help with sebastienm's code - Returning To Previously Selected Worksheet
File already exists. Do I want to replace?
"User-defined type not defined" error when trying to send e-mail
how do i use outlook web access through excel?
advanced filter
Running macro upon opening workbook
How do I Loop through this range and . . .
Leave live cursor in a cell?
close without save silently.
Error trying to close down dbase IV file used for input to excel
If then statement
when press the close button in printpreview
Help Combo Box
#NAME?
copying from a table
Text wrapping on merged cell
Will Excel "compare" two worksheets or files?
Is this possible?
Is there a way to do this?
how to create links to all files in directory
Application.FileDialog(msoFileDialogOpen)
Color text based on value
Is this type of worksheet protection possible?
Copying and Pasting Different Formulas
Reading a cell that a user has clicked on
How to save a output property from MSXML
urgent help
Copy named range from file list to summary workbook
How to backfeed radio buttons?
Run macro which name is cell value
Cell Naming
Display cell range in listbox
Errors 32809 and 57121 :-(
Automatically click "Update Links" & "Continue"
Open workbook in existing Excel session
Exporting Excel Data As Unformatted Text
Conditional formatting
Copy row contents based on contents
The Domain www.bestnewsletter.eu is now for selling. The Domain for OVER 600 Million People in Europe.
The Domain www.bestnewsletter.eu is now for selling. The Domain for OVER 600 Million People in Europe.
Positioning the Calendar on working screen
Copying rows based on date
Generalising sort routine
Interface Design: Drop Down
Icon on the top
copy from table
Interupted Scrollarea
E-Mailing Question
VBA - The Literal "Microsoft Excel" on the Top"
Column Limit
check blocks in loop
Create your own poll for free and share your opinion
Send a frame control to a procedure as a parameter
SEARCH AND REPLACE (in Excel 2007, beta)
Importing multiple text files to worksheets
How Do I Create an Excel 2007 Workbook Programatically
using an IF function for a total
IF
retrived last modified date
quickest way to erase error cells
copy date based on date -refer to date range
Copying multiple sheets into a NEW workbook
get Outlook calcendar appointments
hide PERSONAL.XLS
making hotkey in textbox in userform
Creating a Price Book
Better way for writing IF statement ?
Custom toolbar buttons
Storing User response
Best tutorial for building base/collection classes?
cut data labels in bar charts
dbgrid control into a userform
Copy multiple sheets using a list box
Fill Array from Selected Items in Text Box
Userform with Excel chart sheet
Re: Managing Data in Cells
Copying sheets to a new workbook
Sum with array problem using SRC/BusinessObjects software
Macro not found in Application.Run
Clear cells
Excel: Filling a user form with yesterday's data
Re: Delete Columns with duplicate headers
Re: Delete Columns with duplicate headers
RE: Exce Macros
UDF and superscript
Passing a Reference in VBA
RE: Loading from startup
RE: display a user form
Re: Delete Columns with duplicate headers
RE: Exce Macros
Delete Columns with duplicate headers
select database file path location for excel query
Macros and Windows XP
Counting rows in Excel spreadsheet.
Run macro whenever cell changes
Problems with Word via Excel VBA
Loading list and combo boxes from startup
Relative return to original worksheet in middle of macro
Time to complete code/function
Comparing data between sheets, and copying rows with data
VBA - need to minimize Excel from UserForm
How to dynamically add/change Reference?
How do I replace a carrige control(box) in excel using VB
Cell protection problem
Problem deploying an automation addin (VS2005, Windows XP SP1, Excel XP)
Help Please: Syntax Problem
hide columns macro
Need help saving file with SUMPRODUCT formula
Problems with Word
Problems with Word
Intersecting Data
Excel does'nt reconize SolverOK
Add method of SeriesCollection object clears Windows clipboard
i want 2 coulms in center and 4 columns at top and bottom
Run-once macro
Excel 2000/2003 Secondary Axis issue
MAC encryption from Excel
Assistance required
Excel.EXE remains in memory
Optimatization project
why is it my excel file is always crashing?....
Move cell focus in VBA
Olap Pivot Tables: Multiple calls to AddPageItem and performance
Customer Word form to Excel db
Fill formula from VBA
Tab Order
Copying macro from word to excel
Assigning values to Pivot field
How to select a range that will change in a macro
Chart Adjusting Macro II
Close form...
Verify before proceeding
Get The Length of data type of excel using visual basic
Positioning Worksheet names on Activate
Programmatically query Excel drop-down list ?
Remove all macros and objects in Excel, Save and Quit
July - UK Excel User Conference
copy and paste from text boxes
How to Disable Customize PopUp Window
Variable row data source for combo boxes?
SVG export
ActiveX textBox : value doesn't show after programatically changing the value
Macro for splitting a cell
Subtotal in header
How can I make File->Save , File->SaveAs Menu disabled?
Macro: If(And(...
what are the advantages & disadvantages of using forms in excel?
split cell at first space
store sheets listed in listbox in array
How can I use the " character in a string
Double_byte find problem
Menu bar question
Count down
Drop Down Lists
Outlook Warning Messages
Compile Error
Optimizing memory, speed: Arrays vs. Cells, etc...
Delete all modules and forms from workbook
Excel: = sign keeps coming up when i enter 7/1 for date
Deleting rows after a specific Value
maro to work on one sheet as opposed to all sheets in the workbook
Property Lists
Listing all files in an online directory
Data Validation not working (with a Worksheet_SelectionChange event)
eroro in simple function
How to display the user "locking" a workbook or an addin.
Copied range. Help please!!
Lost Help
how do i make a chart for ranking sales estimates
Creating ranges
Add function at bottom of Spreadsheet
Replace words in Formulas on a DashBoard worksheet
disabling readonly(protect on worksheet) using vba
Wildcards and Acronyms in Excel
Read Only File
Subscript out or Ranger Error 9 - I'm lost here!
Automatically run macros
Adding commandbutton to sheet
copied cell range
Error Opening Excel File in VB.NET
Disable Object buttons, based on value of other object buttons
Clearing a value from a TextBox Automatically??
Possible Combinations of scores
EXCEL 2003 - system.diagnostics
RE: Slowing Down a Macro
Finding files on external drives...
Resize Problem
Slowing Down a Macro
How to avoid deleting of rows
Workbook Variable
Tip on dialogue/combo box
PublishObjects lockup
Help with Break Mode
copying and pasting from source sheet to destination sheet without naming source sht?
Read Undo list in Excel 2003 using Csharp code
Track Changes using Csharp
Detect speech option in Excel 2003
learning excel vba
Know a list of machines on a network running SQL SERVER
web query
Yet another "copy method of worksheet class failed"
Worksheet protection
Registry Keys
Bingo Lottery
boolean (true/false) in Excel
copying data from several files to one excel file
Set Print Area
copying cells from one workbook to another
Get External Data VBA
RE: Kill Syntax
Kill Syntax
Macro To Delete Filtered Pivot Table Data
file manipulation
match function inside if function
Loops to find blanks then loop to find populated
checking if two arrays are equal
Generating a graph using nonadjacent columns
MAC authentication in Excel VBA
Copying a chart to a user form
How to report Excel 2007 problems?
Automatically update graphs and equations
Calling a Program
How to determine links to external files or spreadsheets
I want to treat numbers as text without any complaints
Select worksheet tab at furthest left position
Subtotals by Rows and Columns
Opening all linked workbooks
Cut to EOF
Chart Export Issues
Macros and Goal Seek
Mousedown Macro
auto sort
Re: Macro that runs automatically?
Re: Macro that runs automatically?
Macro that runs automatically?
Formatting the user data for the body of the mail in excel
Macro
creating macro VB in Excel - find and move program
Automatically run a macro at a certain time
Re: Filename array
Re: Filename array
Re: Hide data based on future date
Hide data based on future date
Filename array
Specifying Filename when creating PDf from Excel Workbook
Change Value Active X control
Question on Unicode and string conversions in VBA
1004 error
Strange printing order
Add list as a subchoice to a custom menu
Last friday
Click "Ok" without prompting - Macro
Formula which change color
sending bitmaps through Lotus notes
Excel Patch to Support .NET v2.0
macro deployment - References DLL issue
Caption property
If sheet has no #N/A error then...
run time error 9
wild card with if logical function
Setting autofilter at runtime
wild card with if logical function
Printing an Access Report from Excel
InputBox Query
Lookup fields in Pivot Tables
validation problem
Reference to cell - VBA
Macro that writes Macros
How does Windows recognize the file as Excel's?
Progress Bar & Cell Linking
Data, Validation, List always starts at the bottom?
sumif criteria
Help on following code please?
Real Time Charting
Count Rows
Grouping and moving worksheets problem?
Major Issue - can no longer open my file!!
Major Issue - can no longer open my file!!
Copying by Column "Header Name" macro
Extracting defined names
Macro for excel & msoutlook
Runtime error 1004
External Files
Need open-prompt & ref. formulas
Use META tag to specify the charset on a HTML table, all cells are treated as text in Excel 2003
Need to combine data programatically.
enabling a custom menu at workbook open that is disabled
excel file recovery....urgent please...
UserForm Problem
Text Import Wizard change default selections
column format
Not allow duplicates from listbox to Worksheet
max
Checking a text box to make sure a code exists in our SQL Server
Convert point coordinates -> pixel coordinates
Browse to change current path
Troubles with ActiveSheet.ShowAllData
creating a VBA variabel from multiple named worksheet ranges
Move a value from one range to another - rounding occurs that I do not want....?
easy macro problem
Windows Exporer Shell
Calendar
Two Excel VBA Quezzies
How to locate the end of a recordset
speed up export to text
DDEExecute With Very Long Strings
Help with getting data from a worksheet
Macro to Merge Cells
Custom Toolbar Position
Help on Matching and Copying Values In Two Different Sheets
How to "trick" VBA?
Autofit on Merged Cells.
Application.FileSearch malfunction??????
User-defined type collection in class module
Graphics in ADO Recordsets
copy pasting bitmap into email in lotus notes
Runtime Error Type 13 Mismatch
Transfer single cell information to specific cell based on user criteria
Module naming
sperate from the space, in text, in the same cell
Data Validation: Allow "List" or "Whole number"
Data Validation: Allow "List" or "Whole number"
Finding CellRef for Control+Home
User defined function - adding names
Writing streaming data to txt file
I can't find the solution to my problem...
SumProducts on a spreadsheet with a variable row dataset
merging worksheets
Reference a Column by Number
Prevent users from breaking VBA code execution
chart manipulation
custom menu items not responding after initial save
Displaying series list from each chart sheet in workbook
open worksheet with a macro (combobox)
The Workbook you opened contains automatic links
Find Minimum values in cyclical graph
How to read Excel in a .NET app
Checking for changes on a multi-user worksheet
REMOVE SPECIFIC DATA
<<< State of the art web solution Online>>>
Formatting Variables imported into Word...
Unhide particular rows if a previous criteria is selected
Adding only the filtered results
Inout data into rows
Conditional Formating
Use of CHOOSE? appropriate?
How to print duplex on a HP9000DN with the 'Flip on long edge' opt
Find the 4 parameters in order to design one line
Macro prompts for a number to be used in this macro as a variable
External table is not in the expected format
Variant/Double?!?
Print between two sequences
Home based Internet research Jobs
Any async CDO.Message send?
Excel/MSQuery - Detect when Refresh has occured
Within the same procedure, can such Inputbox be used more than onc
Find???
Type mismatch problem
Get values in a column based on values in two other columns
Get the range of XML Mapping?
rToRange.value = rFromRange.value = always "rounds" the value.....help?
Save As Macro
Pass variable from form to form to form
Date Problem
Getting data from SQL
Which combobox has the focus?
find macro
Active Cell & Data Validation question
Repetative Tasks and Variables
Question Box
Delete rows that do not meet specific criteria
Value entered automatically on lookup of date in column
Active Cell / Data Validation question
Selecting Worksheet Array
Sorting Question
how to determine how many numbers are greater than zero in a range
Activating Sheet from a List
Accessing a variable(a range) and modifying it
Ned to speed up my code
PROBLEM: hide/unhide worksheets based on cell value change
Move data from tab to tab using a macro
Excel 2000 - Pivot Table Show Pages
How to get a chart title from a worksheet cell in c#?
parsing a string for 3 sets of numbers
VLookup / HLookup Wildcard Search ?????
VB question
open workbooks when opening an excel file
Shortcut key
Delete Rows from List Objects based on Conidtion
Use a xla file to look in xls file when opening
End Sub, End complete procedure
Counting only if multiple cells match up
copy row based on color
Moving Sheets To A Different Workbook XL2003
Copying And Renaming Sheets XL2003
Re: Annoying Problem - Subscript out of range
Change color of Tab
Input box no longer accepts input
Ghost Reference
Graps in macros
Excel freeze when ran from server drive
TextBox1.SetFocus not responding
Cell references in macros
Import HTML code into Excel
Saved emails with attachments
Use a Form to Browse Data in a worksheet
Wrap Text in Excel from code
Macro to search for a file and return it's full path
Excel VB help - checking conditionally formatting on one cell, applying it to another
#Name? is Results
If, Then, Else Coding Problem
Are there limits on number of variables / calculations
LoadPicture for a ControlButton help
Changing names into email addresses using Excel/Visual Basic
Blinking Cell
assign value to a cell on next column
Open non MS applications
combobox control how to's?
VBA Code to search and calculate.
Can Clip Art be an Object??
C# Automation problem
Random Numbers
excel and mappoint
Excel macro/function like VLOOKUP that sums eventual multiple matches
Autofit in Merge Cells
Excel, ADO and row number
Highlighting using a macro
Userform
Administrator of Macro
making checkbox into a variable
Re: making checkbox into a variable
How can i get past the overflow error?
I would want protect my sheets of excel from a "password recovery" software... How?
Convert Date
extracting data from a table
Boarders
Keeping calendar in one place
pages break in the 66rd line , 132, etc...
HIghlight cells
help with print button
Userform ComboBox entry disappearance problem
Automating series generation for scatter plots
UserForm locking up
Working with Outlook and Excel from Access
add sheets
Invoking a macro from within another
Run macro <i>if</i> 001.xls exists
How to avoid name conflicts while copying sheets
Shift Rota in Excel or Access
need help with vb menu and such
Adding Rows
indirect formula on VBA
Getting Values From A Closed Workbook
Connecting to a database
Help displayed while hovering over a button
macro for opening all excel files and copying contents
divide cells using macro
vlookup in reverse
Marco print issue!!!
VBA protection & hide
Excel Automation/Immediate Window
How do I hide the worksheet menu bar
Filter Data to another sheet
PREVENTION OF MULTIPLE LISTINGS OF SAME DATA WITH VLOOKUP
Moving a row from one sheet to another
Filtering problem - long question
Data Validation and file size
Sorting Routines
Range always being the right size
number to text
Excel Iterations? Conditional Operations?
How to compare today's date to a cell on VBA?
Referencing Range in UnOpened Workbook
excel automation with IIS weirdness!!
add a footer to excel through VB code
Excel Spreadsheets converted to HTML
Fast then slow performance
Put cell value from another workbook into a variable
Finding the text written in specific color
Copy rows between sheets-conditional
downloaded version excel 2007 will not close normally when shut do
Default Printer
Printing problem
How to run a macro when a specify cell change value
Strange worksheet protection behavior
List of superseded APIs
How to detect use of DSNs?
Userform Focus
Macro to Highlight
Sub to write another result dimension into comments over formula c
Event for CalcState?
highlighted text
QueryTables Error Handling
closing a remote process
Set active sheet
Non-Excel Question
suspend a routine
How do I append data from an excel spreadsheet to a access db
changing the appearance of a cell accessed
Write a number in a cell as text
appending to excel file
"Turn off" an xla add-in at beginning of code
How to "match" partial file name
HELP!! run-time 70 error
Truncating data based on compare
Is there a way to create a spesifig kind of program?
Active cell as range
Change font colour
Listbox Quicky
Test
Pivot Table error (424)
Conditional Colors for Charts
Conditional formatting - on an empty cell condition in _another_ cell?
How to link a chart title to a worksheet cell c#?
Hiden Column
SQL Server (2005 or other) - Permissions on Views Excel Connection
Greek letters in Label caption
Formula to look up values
autostart and "on" and "off" macro
false blanks
Shape/picture name in a worksheet
Re: Maybe a filter?
Maybe a filter?
what is my self?
Test for empty cell
Lookup Query in Excel
Generating a barcode from cell data
COUNTIF with two colunms
Data from Access to Excel
clear column content
real time sorting
Adding Rows
produce calendar date selection vba excel
summing data using VBA
Worksheet Event
Re: Excel Sheet Addition
Subtotal
Why won't this simple VDB script work on Excel 2002.
Adding a value to OptionButtons
Copy rows and count
Find String
Error 400 on running Macro
Freeze panes...sort of
building a formula with non-US country setting
Matrix structure of data
Searching for non-standard Reference Libraries and controls
.CodeModule.Find AND PatternSearch (using Regular Expressions)
Scrollbar not talking to me.
Q about referencing named ranges
VBA to check for existence of a DSN
UserForm Intialization
Macro to copy columns values
Save on closing file
Grouping and moving worksheets by name using VBA?
Displaying -1,0 or 1 depending on cell value?
Selecting First and Last Cells in Ranges
automatically detect excel file in designated directory and convert to pdf
macros 2007
import excel to access table
VBA control vscroll and hscroll in a frame
filedialog selecteditems driving me crazy
Excel limitations
Change source data to all sheets
Shared workbook size.
Type Mismatch
Create Variable Length String Dependent Upon Size List
Dynamic Named Range: Simulating a filtered region
xlFilterCopy Help!!
Are multiple Vlookup's possible?
Populate First Empty Cell In each Row with Text Values
Unzip - multiple zips
Copy and Paste 2 columns from a named range?
change colorIndex, help me write an easy macro
Sorting an Array
Store cell data in a variable
FileDialog
how to count the number of occupied columns in a sheet?
Autoselect data using Macros
How to prevent text turning into date format
How can I programatically change the caption on a button?
Make two colums from one column of data
find identical names in list
start up routine in worksheet
Find and Replace problem
Dynamic Object Attribute
Excel Logo
Multi-dimensional Nearest Neighbor Algorthm: Got one
How to develop a calculator using Excel Macro via VBA
IsNumber is not working
Defining Range with Relative R[1]C[1] notation
Adding data to a cell via VBA
Referencing a Cell in VBA
Move Active Cell after Data Validation List
how i use countif and AND?
Pasting TextBox text
workbook question...
Macro Recording and Saving.
Format / Highlight the Active Cell
Highlight a Date Range
Funksjon for å finne verdier til bruk i kalkulasjoner
Sorting question
Function to look up values
How to call functions of a DLL in Excel and in a .net project
print
Graph between two dates
How to subtract 7 min from 08:55 AM
jumping to a portion of a list box
Optional IsMissing is not working
send parameters to a batch file with the shell command
Importing values from a web page
I have a problem with "Unlaod Me"
DIY Excel Marco Beginner needs help with 'replace'
problem with linked cells
Open workbook without running Macros
Dir
Macro Query -
countif formula
Conditional Cell Locking/Unlocking
Creating a new Object
Keeping Values in Variables
How do I create a new commandbutton in a new workbook?
more than 7 nested IF(AND) statements in formula - VBA? **NEWBIE**
Locking multiple Cell Ranges with TimeStamp
Importing most recent file
printing
printing
printing
Problem about _Application.Quit
VBA to identify last digit in integer
Addins tools
cell edit by user
Excel v10 can't find function in C# .Net managed Automation add-in
greater than but less than operators for VBA
Double Click to run a sub then re-initializes userform?? Why???
building tables in Excel
Copying Hyperlinks that automatically update
Why can't I continue to see ALL the properties?
VBA Protect and NOT be able to selct locked cells
need help with a function
Horse Race Simulation
macro to rearrange numbers in cell?
Appreciation
Find values
Strange vlookup results
Save column J of WorkBook when WorkBook is not saved.
Use VBA to control scrollbars in a Frame
combo box as cell reference? how?
Add to a variable via a function
I need help writing a macro that will correct typing errors?
textbox value
Formula & Macro
Formula & Macro
Error handling
Use Access Database from Excel
referencing another worksheet / passing name from curr. sheet
compare two worksheets and delete rows
IsString
Can't figure out how to open each file
Annoying userform popping up in VBE
Global/Public
message box
Access/Excel Communication
Running a non-microsoft app
pause macro to make changes before printing.
Cursor position issue
Strange TAB behavior
Inserting a function
Command line program use in VBA
Making column C repeat in final printout
visual basic/conditional format problem in Spanish Excel, English VB
IsError and Match function
For Next Loop Question
UDF reclac on move
Spreadsheets with code modules
navigation and re-centering the window
Allowing for variable lines in macros
Three way array function
Three way array function
Conditional Formating
Pivot Tables / Linking Worksheets
Search for worksheet name
Opening an IE window from another IE window
copy columns based on value in a particular row
Finding Same Row Value
Help using Transpose
Charts using Macro
how do i write a macro to change font color with live data?
Converting numeric data into 0 in spreadsheet
Macro help
Text Counter as you type
Can you fill an array from the contents of a single cell
AutoFilter in External Workbook?
Definitive Guide to User Forms
insert row method (?)
VBA Date Format
SHA-512 VBA source
help getting winzip code from RONs de bruin site
Help with Posting to a public Folder
Workbooks Sharing Information
Simple Question......
Export Excel File as a Complete Entity
ListBox chaning size
and another one!!
hopefully easy one to answer !!
Save excel as a complete package
Problem in executing query
ScrollBar Sheet problem
Functions Trigger
Always open in the same place...
Outlook Again
delete all blank rows in a spreadsheet
Possible syntax error
Protect VBA projects
Really Really Stumped!
Identify and count unique values
Looking for a MSDN article.
Finding Column Letters
suppress the message 'refresh operation changed the pivot table'
Compile error: Ambigious name detected: Worksheet_Change **NEWBIE**
Running Total - on a form that clears - No Accumulator!
Increment stopvalue inside a For loop
Split 1 Master Worksheet to Many
Runtime error with vba and checkbox
Copy and paste VBA command - anybody help me?
Extract Only Number From A String
change the file format of a text file.
copy cell to reference contained in another cell
Saving parameters in the Registry?
Help with hiding columns
Need help with code to save/open
Export data into Access Database
Automatically Delete Text at the end of an imported report into Ex
Enable CommandButton1