Excel Programming [Archive] - Page 96

View Excel Charts on Web Page
Worksheet Lookup Problems
How to see how many lines of code ?
Need help finding text string in an Excel file
Links to another workbook
Strange problem....excel not responding
convert to decimal degree from DMS
Find/replace [Zx] with [Znumber]
Rows to repeat at top Except for the last page
Send email
ORDER IN WHICH LINKS UPDATE
extracting email address from Outlook
Automating Linear Interpolation
Border cells with less code?
Active Range?
Import multiple csv files into current workbook as separate sheets
Testing of a workbook is in read only mode
MOVING A VARIABLE RANGE
HELP! Macro FAILS when I copy the worksheet...
Loop Through textbox in Excel
How do you Lookup data on different worksheets
loop through textbox in Excel
Providing status info during UDF calculations
[URGENT] How to Trap Excel Window Scroll Events in VSTO
Worksheet Change Event With Validation List
Advanced Filter Error
Export to Tab Delimited Text Error
Including blank rows in a series of comments (sugarthebeet)
Named range expansion by date??
Blinking text if....
Delete a range of rows ?
Simple VB code
execute a macro from within an if(,,) function?
Save to hard drive and backup to thumb drive.
weird problem when using MS Query from Excel
Word.Range
Excel Work Sheet Protect
Array Coding
Change cells color & cells contains if formula
bug: Excel cells lose format after a "replace all" function
Filesearch problem
IDE autocomplete
combobox change event is running when enable events is false
Dialogue box check boxes
Run macro when cell is highlighted.
Count equal numbers in beginning of a column
Reffering code to command button on diffrent sheets
help with an IF formula
VB: date format in an Excel file
beforeUpdate event of Web Query
excel protect method
Naming a worksheet as a variable in a Active Chart Series
Problem saving Excel file in HTML format
upper case default in comment box
Count periods in a cell
readystate for an IE window that was not created in Excel
Combo box and Worksheet_Change
Removing non numeric rows
coun problem again
Body message - email
paramete web r query
How to Call a Store Procedure!!!
Increment Macro - Order numbers
Documentation
Appearance of sub Accounts when put curser on main account
IsText VBA Error
Not enough memory ,message
Show FolderNames on a list
VB can't find my For loop???
need to compare between 2 tables
Checking Input box
Moving Parsed Text from Rows to Columns
what takes precedence between change and selectionchange?
copying cells by checking color of the cells
From 1 worksheet to another
A general question about editing current list via UserForm
Addressing Question in Excel Macro
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder?
Finding the first non-blank cell in a row and then applying a calculation
Book request
how to making to project group
Change the path of a Microsoft Query?
if i wanted to learn VBA in excel what would be the best course?
Excel 2000 Code works except in debug mode
ActiveWorkbook.SendMail - Message body
Validate email address
Reference to Libraries
How do you I link a drop down box with a scenario macro?
Data Labels Overrun Each Other
save e mail attachments and remove them
Confused, again! Object variable not set?
Protection
Error Messages
OleObjects and someproperties
Shapes
Printer Tray
Adding Cell Comments from TextBox entry
How parse out characters from long string?
Passing a range to a function
Run Make table query from Excel
loop to insert sequence in column
Cannot find Cell
Custom Function Tips
Loading Excel sheet into Web component
I can't get my macro to run!
Hide/Unhide with passwortd prompt
Copy from active sheet and paste into new sheet using info from cell in active
What's wrong with this macro?
Print duplex
Easy one? Is there a "When" like argument?
Flaging up an alert
forms / text boxes
Move items into weekly calendar
Making records from captured cell data
Set up Universal Macro
REFERENCING cell reference
Need help with Listboxes!
Can you capture worksheet double click event from an Add-In????
Macro Help...
Range Problem #2 (continued)
Protecting Sheet Disables Tab Key
My Macro stops
Range Problem
getting strange error in formatting chart objects
How to write a formula with a user defined function
SUM in VBA
Cycle through worksheets and sum
Macro Forces a Check of Data Validation Before Saving or E-mailing
Mailing from excel
clear data from selected cells
Forms - Verify date format
Sum up all cells that contain a color
need help with hyperlinks
copy paste with key shortcuts
Round function
Server name in Excel file path
Conditional Copy and paste
Copy sheet without macro
making a checkbox appear and disappear based on a cell's value
Reformat changed cell
find the index number for an array element
Preventing people from viewing specific worksheets
Macro just stops in Step Mode
Install personal dig cert on new machine
Why is this a incorrect statement? On the surface it appears corre
Auto size help
Min and Max Values on Chart
Select region
ADO to SQL - smalldatetime problem
List of VBA Data Types
run a macro in a protected sheet
Playing a WAV file in Excel 2002
magic scissors
How to: assign a value to a cell without selecting the cell first
String Parsing : Best Methods : VBA
Delete command button ?
Finding values within text and substituting with alternate values.
VBA loops and subs
Is there a way to type text upside down in excel cells?
Deleting duplicate rows
Nestling of functions
Combo box won't transmit "blank"
Multiple Excel Servers
Input Page
Call external program in Excel Macro
How to take chart and paste into Access form
text to Column and amount from -ve to +ve.
Macro & VBA
Copy from text box
I'm only getting 0
COM Add-in in VB
Changing the way it saves
RollDown ListBox in a macro
Multicolumn combobox
Format Painter in VBA?
Can inserting numbers into a cell display another number elsewhere
exit event
Vlookup in VBA
Cell Value & unchanging Date With Macro run
Is Alaphabetic
How Safe is the Excel Password functionality?
Auto copy and pasting
How call procedure when worksheet opened?
Why doesn't 'Range("A65000").Select' work?
Mod function not working right?
Mass copy of excel docs
Sheet tab color
CommandButton code help
Need help hiding/unhiding column based on autofilter selection in a different column
Hiding an empty row?
Problem getting cell value from range var
Creating functions
Formula problems!!
Using a combobox to select sheets
Immediate window
Various errors
Need more columns in Excel
Scheduling macros in excel to run auto
Is there an example of a DB procedure that adds a col of nums
Spreadsheet updating question
Copying and skipping (adding) rows
Variable Problem.
Select sheet based on userform date input
Dynamic Control addition and Event response
Syntax for "and" and "or"
Can I conditionally delete row in Excel? (if B3=0 delete row B)
advise pls
Percentage of subtotal with Pivot
Right text function
from ranges tables ???
Password protected projects (pdfmaker.xla, etc.)
Formula for the subtotal
Formating excel
Anything wrong with Messagebox API?
Help with Mr. Peterson's Code.. Print serially from a Sheet
how to expand sort function beyond 3 on excel
Add menuitems to custom created menu
export a non defined table as txt or cvs by VBA
Msgbox not center of screen anymore
Hats Off to Dave Peterson
Three userform questions
updating of worksheet against info from another worksheet
Changing Cell Backround from Marco
How to map elements to XML schema by program
Display Elapsed Time like a Stopwatch
best method of bulk move of data?
loop until web page loaded using Netscape Navigator
Type Mismatch
Code cleanup help
Extract last name into a variable using VBA code
Importing Html Source Part 2
check for non-blank cells in Microsoft Excel VBA Programming
Locating cell change event handler
select adjustment tab in cell format dialog
Help with Spreadsheet for Handicap
help w/ generic copy & paste/paste special routine
sub executed as the form loads
Importing Web Page Source Code
Delete Sheet 1
Delete Sheet
LastSavedDate
what is array size limit in VBA?
Put only date (not time too) in variable from FileDateTime function
Excel and word macro -
open print dialog (File ---> Print...)
Combo Box doesn't display text in linked cell
Re : Excel Event Worksheet_Change Shuns SpecialCells(xlCellTypeAllValidation)
BeforeSave
Table sorting questions
Import of Multiple Text Files
Need formula to look up zip codes
Capturing Row of Selection.Find?
Sort Combobox List
Problem in WITH/END WITH code snippet
Cancel on INPUTBOX macro causes error
Do Until with Multiple Conditions
Thanks to LEITH ROSS and to KEN JOHNSON
Copy column A and column D from all sheets into new worksheet
Make Drawing Object Unsizeable
Capturing trendline parameters
about ontime
Help with VB code to compare two columns
Overflow error
Calling a Macro from module
New to VBA..need help with automating GETSAVEAS Macro in Excel 2003
Help with a function
Is it possible to add more than 2 x-axes to a chart?
Copy column B and column E from all sheets into new worksheet
Adding individual cell ref - instead of summation
Compile problem
Macro file save as, saving sheet not workbook
REPOST - Moving Data From Excel into Access
Get ColorIndex Number for Cell in a Range
Why Is The Macro Edit Button Disabled?
Name Range
userform making wizard, where?
I need a simple macro but im a noob.
Picture Hyperlink Path
Is this possible?
I want to use C# instead of VBA
Find name and return records
variables in footers; how to prompt user for input within macro
Need coding to DELETE a line on a spreadsheet.
Worksheet Expiration
Macro for multiple worksheets
Application.Run("MacroName", Args)
Email Attachment Problem
Split "9:00 - 5:30pm" to "9:00" "17:30"
Pivot Table sorting
Working with 2 worksheets
hide/unhide row macro
Grouping & Formula's
UserForm Question
loop replacement of multiple if-then's
Can't activate chart
Get to a new row to add new data
Context Menu, Paste Special From Selected Range
Hyperlinks onto buttons
Use % as variable for user id?
Any way to capture an Autofilter event?
Using Autofilter to prompt for criteria
copy code with spreadsheet
Not cycling through each sheet
Network Username
Formatting Data using a macro
Importing paradox files into excel
Find all Pears and then name the range as Pears
Error processing
Userform Issue
User defined error
Output list based on value in a cell
Macro to get to VBA Project Password
InputBox requesting dates between two predefined dates
Create a Pop up box that prompts for criteria in a macro
How can I mail merge using filtered data from excel
userform in an addin
Converting Text dates into dates
Form Button - Select Row
Cut Drawing Objects within a range
Automate embedding files
Fill Excel Screen with Form
Code to control auto filters
Add 5 blank rows after Word
Copying TextBox entry from one UserForm to another
Stopping Code
ClearContents on 1st sheet from 2nd sheet
Help with date conversion - yyyymmdd to dd/mm/yyyy
Retain colours of figures using vlookup between pages
Proplem copying a Module - Error 50289
Making only selected PivotFields visible via macro
Works every second time
count problem
keep track of last code line before error
Password for workbook
Displaying cell comments.
How do I sum scattered entries on an Excel worksheet?
list property of listbox
validation - error mismatch
Change ComboBox properties in VBA?
Atlantic City - Excel User Conference Early Registration is now Open!!
Menubar Control
Color of the title bar
problem with interior.colorindex
userform - active sheet
Autofiltering with more than 2 criterias
Forms - checking fileds have values
In macros, an instruction that will return the position of the Active Cell
excel-maple
free text box on a protected sheet
re-direct hyperlink event to WebBrowser Object in Excel
Range
code for auto filters
Looping through Labels
Opening a folder
How to split and consolidate sheets into new workbooks
Locked Column
populate array
Indexing of Shapes
How to connect sybase with excel vba?
problem with import files by excel macro
problem with import files by excel macro
Color every second row ?
How to pass arguments to vlookup in VBA
User defined event
Conditional Formatting
How do I determine OS (98 or XP)?
Excel Add-in for better graphics
If/Then/Else formulas in macros
How to close specific workbook not all active workbooks?
Taking out the 'Close Button' in the top right hand corner of dialog boxes
auto fill help needed
Funny! More offers to select a search engine!
set dropdown list width in validation
Autofill to last row
Help with this code
Calculating cell references
Minimising Excel
How do I lock worksheets so only a couple ranges on each allow inp
Can I user input to seek out particular files and copy/move them?
how create library of routines?
Hyperlink to charts
How save active workbook w/o knowing name
Write a macro
first time class module
Breaking the External Data Link
Create new sheet from cell-info and then copy/paste special
Two criteria in using Combox Boxes
VB6/Excel: Opening a workbook off a LAN drive
How Do I Get Custom Captions For MsgBox Buttons
ComboBox with horizontal range on an Excel USERFORM
Want a challenge:Finding entry on sheet then adding data???
syntax for variable
calling a function in a worksheet from a user form
PivotTable with No Source Data
Copy Sheet problem
how do i obtain a file name from a cell contents and use it to sa.
Sort beginning one-line BELOW what should be
Getting Data from closed workbook into userform
Cell Mapping
array probs
getting data from a closed worksheet
Dim SheetName in chart plot
How do you change code in the VBE without opening the target workb
Is there a IsEmptyCell function in VBA?
Header properties in code
Strange data type error
On exclusive open for write
How to get entries into a list box
How do I create a macro to switch sheets
Opening Workbooks / Filling Array
Sheets("Sheet1").Move After:=Sheets(2)
how do u use a cell value for the save to filename
Application OnTime...need some help to schedule.
How to advance one column to right?
Opening Excel In IE
Search & replace in VBE on other workbooks & different directorie
Copy a cell content into a TextBox
Cancel "Save Workbook" popup
Import data from multiple tables
Vlookup in VBA. How can I?
How do I do mail merge using filtered data
My Excel drop-down list eliminates from list options chosen. Help
Removing duplicates from multiple arrays
Commandbutton picture problem
How to change cell color with reference to a formula?
Compile Error: Argument not optional
Picture Hyerlink Path
Format excel data
Bouton inaccessible dans Excel 2002
Open files in order
Turn Off Alert Before Overwriting Message Box
Series.Values vs Chart.SetSourceData
union array
PDF to Excel
Excel VBA - Inserting associated values in a report Please Help :)
VB Code Source
Running Macro's after Refreshing data
Create or change color of a (line with arrow head) with a Macro en
ChangeLink Command Not Working
Macro to evaluate a cell and replace one part of the formula
Hiding Columns
For Each loop
Input Box Related Question
RE: Input Box Related Question
SumProduct If?
Input Box Related Question
Null Operator
Workbook disappeared
Paste formula
Problems calling macros from "ThisWorkbook"
Textbox Format
Unprotect shared worksheet
Zoom and Scroll Form
Unselecting a Reference
How to remove the ' charachter
Open mdb file from another computer
Colour active row but allow copy / paste
Batch Files
Match, Sort unique list
Controlling Chart Views
MsQuery Refresh Message
Commandbar on thisworkbook only
Problem with copying a button in VB
#If #else #endif
Why wont my Pivot table update?
How to create a macro for this?
How to share variable values between 2 Workbooks ?
Timer Code
Refresh Pivot Table: Do you want to replace the destination cells
Question about range values with Set =
Adapt code to show filter
Extracting information from more than 1 text files
Changing pivot table Page
UDFs in worksheets with external data sources
Aggregate function
changing the properties of an excel file
Create macro to paste rows of text cells to lower end of other row
Help With Insert Row Macro
Help
out of range error message
Collection Look Up - By Key in an Excel VBA App.
Creating charts from a .dat file with vba.
Writing Excel Macros in VB.NET/C#
Pivot Range
VB formula referencing other worksheet
Security questions help please
e-mail help
Questions related to Online Quiz
Calling an Excel function from a VBA macro
How to generate dates for a month?
Find with a variable
Use Macro to Run External Program
Issue with Excel Add-in for Analysis Services
Compress column
Conditional formatting based on not null value
checking for a running app
how to know be button in activecell
VBA equivalent of Javascript continue
Moving Data From Excel into Access
Extracting records from an excel list
Risk Issues register
importing Word table data into Excel - solutions for automation
Run macro after save
Need to select/report all rows based on content
Macro Enable/Disable
Question about working with range array
average of the range
Returning an integer from a Function
Ignore workbook_open() when opening workbook next time
Having trouble with a IsNull function
How do I switch openoffice back to excel
Subquery after Left Join
Undo button??
To show the whole text in a tooltip text
select specific records
How to Disable drag and drop of Pictures from Excel
Deleting Columns
Suppress "Disable/Enable Macros" and Query Refresh dialog on open
I dentifying cell and ranges using n as in For n =1 to 600
User Forms - Command Button defines value to be used later
ChangeEvent
Set UserForm's HelpContextID with Designer
Excel rounding bug for input to Variant data type
password popup unneeded
VBA for XL97
range with L C
custom menu 4+ levels deep
VBA Project Properties
ActiveWorkbook.SaveAs FileName;= 'sequential
Unable to record complicated formula in macro
How to pre-select/highlite contents in input window.
Yet another Listbox question...
Insert Picture Name Assignment in Macro
range class error
Excel formula to return a blank cell
Pasting in a range
Open file macro
Subtotal function in VBA
macro to copy range data from another workbook
Inputting data to next blank cell
Excel Format-Cells-Number for Zip Codes
HELP!!! Advanced Filtering to another Worksheet
Linking Excel template and spreadsheet in separate workbooks
Insert Sheet
Cell description/comment/tool tip?
Work in Other Software
How to consolidate workbooks automatically from multiple emails?
Excel sets calculation to Manual automatically
VBA Print Code Is Too Small
How to create blank spaces
how can I cancel a macro in excel?
Remove/suppress Auto_Open macro
How To Use Debug
update Link from protected wb OR prompt for protecting a worksheet
Disabeling key
Changing text to number format using type casting
Function not dividing properly. Please Help!
How do I automatically accept a solver solution in a macro?
Obtain imported file modified date
Program to replace information .... ?
Error Trapping Question
Should Enum create a selection Box?
excel
excel
Groups to Tabs
How do I use absolute references in macros?
Please Explain Two Lines of Code
Variable value not populating
How to check workbook is already opened before passing the workbook obj to a subroutine in Word
procedure continuously being called
Characters before the space
error convert to number macro
Hide/Unhide Rows
Save an excel file in vbscript without user prompt
what is the difference between embedded chart and chart-in-a-sheet
How to get a reverse filter list?
Autofill problems
Checking entire cloumn for values
Comparing cells in workbooks
HELP! saving as xls in current folder
GoalSeek, values to formats? help!
writing to next row in sheet
Print to pdf and save without prompts
Problem with USEDRANGE.ROWS.COUNT reporting one row too many
how to change values to formula in VBA to carry out goal seek?
Extract Time
INNER JOIN problem
Object Movement
Renaming folders and changing links accordingly
Application Defined Error
open dialog box
Copying data at specific positions
Determine if column is within range of columns
How do I get a number to increase by 1 when opening excel
Problem in making Excel.WorkBook from VB.NET
range name as rowsource of listbox?
Unique Idenification Number
csv to xls - data format
How to find a particular work and give the comment in a different cell
Save embedded doc to file
how to lookup one source with alot of table array?
creating a log sheet
Calculating Time Elapsed in Excel
Absolute hyperlink
Saving file with date on it
Invoking macro when a tab is selected
Storing workbook name
urgent please - on checkboxes
Supress display of multiple steps in Macro
Find a cell with date in it
macro to remove worksheet-level passwords
Running times
Application.Dialogs(xlDialogWorkbookCopy)
turning a negative into a positive
Application.Caller syntax for worksheets?
Using Hiden worksheets through a hyperlink.
ListBox Questions
VBA - Translate VBA Line
Using Date() function then adding 1 day to it.
Code cleanup
How do you change the Worksheet Menu Bar "icon"?
Does querytables supprt https (MAC and/or PC)
How would I do this programming problem?
Naming worksheets
Open file with relative reference
Cells Data Validation
Last cell
Bringing Comments with cell contents when using AutoFilter
Representation of optional parameters in Function arguments window
Automatically hiding rows with specific values
Matrices in VBA / Excel
Range.Find abend on XP/Excel 2003
For index = 2 To Source.Rows.Count
auto load personal command bar
Dropdown
Macro
AutoFilter method of Range class failed
Need help unprotecting workbook before importing
Color Range of Cells
auto reminder
combining 2 codes
How can I move and entire row upon cell completion?
Dynamic SQL Query
Command buttons freezing up - help!
error "The macros in this project are disabled"
Sending data from a cell to a blank table
Protecting my project
Continuation of message re: Range Names
Deleting variable web query name
ThisWorkbook.Path not working...
pivot table - works manually not by macro
Execute Macros through Hyperlinks.
How Do You Take Data Off A Sheet and Store It In An Array
Conditional Formatting
Conditional Formatting
email
ideas to case
Control Toolbox does not appear when trying to design a Userform!
Open recently made .csv in notepad
Scale of Graph in Excel97
Help on Macros
Automatically Save
Change formula file reference by changing value in cell
Auto macro in Excel help
Re-protect if originally protected, leave unprotected if not?
Filters and Macros
Send Excel attachment, but wait till Outlook closes
Specifying criteria in Excel for Access Query
Range Find got Subscript out of range
Export UserForm Image for use in Microsoft Word
Reorganising data - macro needed?
Help Please!
Detecting the space character
Date format problem
Modify Macro To LookUp 2 Tables
Array, multiple sheets
Comparing data on two tabs
Why is excel solver saying that there is not a feasible solution?
Coverting a txt file to multiple Workbooks
Cell generation from user input question.
Keep VBA window hidden
Nestling functions
Creating Excel Object in C#
text overlay on image
How to copy cells excel data and paste them under MS Word bookmark
Pasting Error
How do you delete an exported file from a directory
simple macro gives error .. help needed
Counting Comments
How to make a module library.
Saving, Opening Spreadsheets In Array
How stop display of worksheets during macro
set up toggle button to set print area
selection.find help!
Drawing borders with Macro
Defining worksheet specific range names
Define Range Name with variable row value
Calling other programs in Macro
File not opening
my sheet is locked and protected, i want to insert row with autofo
Calculate data from Access and return to Access
can I program currency conversion in real time?
Close userform after 2 seconds
Automation Error
sum in random files.xls how?
Run-Time Error
CommandButton objects move in worksheet
Saving Worksheet from Workbook with Names from Cell Values
run time error
Change the colour of a row depending on the contents of a date cell
Invalid internet address
for figure in Excel
VBA coding
Copy paste code fails
covert only cell references in selected cells into value leaving the existingcell formula
Excel Color Palette problem ...
copy just subtotals ?
easy macro?
Identifying the type of a Worksheet_Change
Sending an email on workbook save
Promptbox value to go in the next empty cell
A curious question
Copy and Paste Macro
HELP: Dir() time-out woes :( .....
Urgent help neede filter data in notepad to excel
Check for repeated input
Email to multiple persons
Compile error automation error
Block inser or delete rows
compile error automation error
VBA Sum
Please help.
selecting random cells
Drop Down Form Number List
Macros for copying the data
Change case on Entry
Module Options
defining number range in textbox
highlighting part of string?
looking for Excel programming help for project
Macro working on my pc but no one else's
VBA Code
SUM function help
Selecting entire rows contents
Macro
Clicking Taskbar Icon will start macro
Move Around Excel While VBA code is running.
VBA
Problems with Protect Method
Fast way to hide all pivot items in VBA?
Method 'Range' of object '_Global' failed
Manipulate Controls added at runtime
Data Extraction from a cell
User form Object corruption
Shared Workbook Saving Problem
MS SQL and Excel
Need help importing data to multple worksheets.
Import Text File w/ VBA
Cancel button to cancel the whole macro
Retrieving Data from a worksheet to auto fill a user form
Preventing FALSE.xls when automating SaveAs
Grouping numbers, disregarding the minimum
Searching for records that end in a specific character
Variable not working as email address
Trouble with Visual Fox Pro Database
Macro enters formula but it won't calculate!
Hvordan legger jeg inn slik at noen fast betsemte ord kommer med f
.Name case sensitive
Compare two sheets and perform action routine
Number of files in a folder
how do insert rows and maintain the hyperlink in Excel?
Can PIVOT tables do this?
Hold down f8
macro -find all occurences of a word-change color of cell of all
Better way to apply formula to multiple cells?
Open a webpage using Javascript in Excel
Remembering Worksheet View after Event Code
Re: Paste by rows and blank cell problems
E-mailing from Excel 2003 problem
TextBox value
need some editing of a template macro.
userform error
howto send host fonts to adobe pdf printer
unexpected result from inputbox
Drawn Object Woes
Track changes
AutoFill Loop
How do I set up a vacation report using hours alloted based on hir
Get the reference from a referenced cell
Range selection
cannot empty clipboard
True/False : 1/0
Excel User form with 4 Combo Boxes
Simple macro problem
Indirect Referencing in a Macro
Create arcTan function
Close workbook problem
Need script for filtering data
Autocomplete
Embedded a .gif animation into a form
Adding Range Names
using saveas twice will be error,savecopyas don't use also,why?
Is there a "Find If" type command?
Length of worksheet name
deactivate macro or LostFocus
Select certain data from a Pivot and copy this into Powerpoint
Consolidating Several Excel Files
Find and Copy
is there a currency conversion function?
Create multiple copies of rows based on a cell value
Help with code
pivot table build using excel macro
Difference in Values for Price function in Excel
Auto fill form with data from worksheet
Prevent error messagebox when refresing querytable from the web fails
report output format
Colour Question
Copying cells...
Until end of array ?
Adding column title
Split code in more than one page ?
display rows that meet two conditions
Reference dialog box
How to open or view VBA project only
amend this routine to use something other than Application.FileSearch
close excel application
Insert Row Macro Help
how to make the formula
Hide/Unhide Sheets
Compile XLS sheet into EXE
String compare doesn't compare?
Drawing Problem
VBA If Statements
Image Click Invokes Picture Toolbar
add a new row once list selected
Trim pace not necceesary
Unload multiple forms
Copy rows from one file to another file
Links from other files
Scroll to top of page code
VBA VLookup
protecting macro code
Reference to solver problem
Reference to solver problem
nested loops
set up a repeating header or footer to entire workbook
CommandButtons
Resizing Userform to screen size
select and print
Identifying complex duplicates
Accessing rows after AutoFilter
This should be simple?
macro slows down
Debugs with Copy / Paste
Copy from another workbook
Really Slow Running of Macro
Macro For Deleting Cells Containing A Number
Run Time Error 9???
Random Number comparison
What does Ctrl+Shift+Enter do? How does it differ from Enter?
Realtime Data Update Sorting
How to? Copy from one location to multiple locations (easy)?
Get RGB color ?
How to update values on cells in visible range only
Updating Querytables and Pivottables
Desperation is Setting in - Date Formats! :-(
Why does SUM not compute, even if the cells display numeric values
Find textboxes on a form ?
VBA
Macro button not appearing when workbook opened?
newbie.... need some code... I HOPE!
are default values possible for "Application.Dialogs(xlDialogSortSpecial).show "?
Modifying Data inside an array
Worksheet Focus
VBA Query again Informix database
Loading Pictures in Image box
query sql database
query sql database
query sql database
Drop down list - display text vs actual value?
VSTO 2003 Excel Command Bars
Run a Macro via a Scheduled Time
how to set 'security level' to low in auto like vba
A challenge for the Excel Experts among us (ActiveX Control & Add-ins)
What's the best solution to accomplish this?
How to limit 'calculate' (F9) to specific cell, range, sheets, workbooks?
Autofill with changes
resize and copy
My problem with char(30)
Clear array ?
Compare workbooks
Any way to do this faster?
Respond at a specific time
Find files and sum a value inside sheets (VBA)
Dim an Array with a variable
Web Query
Set print area problem
Type Error in For Each Worksheet Loop
Date in data imported from MYOB to Excel 2003
varying colors on a graph
A Userform goodie - updating records
Workbook_SheetChange
VBA Help, cant figure out why it dosn't work.
Prevent user from overwriting file
VBA newbie question
how to speed Find/Replace in Excel(Using VB)
Creating a folder
MatchRequired - how to trap the error when a matching entry is not input
Copy and Pasting into new Sheets
Require certain password for sheet1 to save
msg box to clear a sheet
Get Worksheet Name
finding ROW without selecting worksheet
worksheet event macros
Store hyperlink, when filename may have # in the name?
Perform Row Function Using Macro
Copy cell properties from master when user enters a new line.
Excel is multi threaded program? thanks
Combining find with clearcontents on multiple columns
SQL scripts and ODBC
Finding next empty empty cell in a range of columns
Need help writing a filtering routine
class/struct functionality in VBA?
validation
Tweaking a Macro to Count Words
Module vs Class Module
Loading and changing a photo
Validate all cell values against it's list prior to saving the she
Grouping into a Tab
Treeview expanding when saving a workbook
Can I remove prefix apostrophe
rename current file save and delete original
Finding next available empty cell in a row
Hidden Character Find Macro Help
Need macro to generate list
Sort an array
duplicating cells in diffrent sheets
Closing Code
Slightly long winded transposition
MultiPage
Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select
Won't close w/routine
prevent UDF from executing
Disable a Specific Message Box
BeforePrint macro difficulties
Deleting rows before importing
MS query return multiple columns in Excel
Speech Recognition in an Excel Macro
Having a mcro prompt me for manual input in cell
change event
Encryption
macro help please
Macro problem
Delete WB
How to use VBA to update a SQL Server Table from a Spreadsheet
Setting Public Variables Error
Looping through rows and shifting certain contents
Option Button
Locking cells
Too few parameters
Determine begin month date from month end date.
Adding controls to each page in a multipage form
A tricky macro -
populating a dropdown based on choice from a previous dropdown
protect/unprotect all sheets
Populate the Concatenate function using VBA
Excel Scheduling
Hide and/or Unhide Worksheets
Macro Drop Down Box
Easier Way to do it?
Project password
is Excel written with multiple threads?
Help with multiple "IF" functions
Override built-in commands
Indirect reference
change error message when no more for "find" in macro to find
Coping a Worksheet - but Getting an Error
Superscript Button
Convert Excel. xls to .exe
Hiding Zeros
Auto Row Height
ActiveCell = " < "
File Open Check
multi page object from excel vba toolkit
command button to move user to specific spot on different sheet
ifcount evaluates always false
UserForm problem
local security policies
Writing update date and time in a cell on inputs
Require Cell Entry based on condition
Reference
Passing a function from VB with text strings in quotation marks
Get two Values from closed Workbooks
storing of VBA code
control button used to clear a sheet
Checking to see a sheet of the same name exsists
Protecting multiple worksheets
Is this really possible?
organization chart
Populate a combo box from a worksheet with VBA