Excel Programming [Archive] - Page 88

Halt or Pause a Macro
VB Sort Help
SQL Stored proc - passing parameters
Change a Macro commands reference to file locations
IF, OR, CHOOSE, TRUNC Help with formula please
changing password to ****
Selecting multiple items on Listbox
Set up a hyperlink to open a web object in excel?
Selected Sort
Opening and deleting File with only partial Filename
Opening and deleting File with only partial Filename
Spreadsheet sharing and VBA
update links
Search, Find, and Fill in Offset
Copy and paste new records only
3+ Dynamic Dependent dropdowns?
Help with VBA code - passing references to sheets?
Send mail via VBA through a proxy address?
Extract data to the right of a hyphen in a cell
Move Rows
set up a macro to copy/ move sheets to individual files
My list is too long for my drop down box
Conditional Formating another cell
Accessing a Forms Properties
Connecting to FTP
Using a dll in vba
Relative context in a Macro
learning to use macros
Environment Variable Names
Runtime error when closing the sheetHi all,
Help with ActiveCell.HasFormula
Need ADO Recordset Help
Not quite there.
Difference between Excel 2002 and 2003?
conditional sum issue
Removing unwanted space at end of text cell
De-concatenate
Help: Menu Region has gone Black
Office 2000 - Office 2003
Help please I cannot get an answer to this question
Any Ideas?
StatusBar Progress
Regarding Excel Status Bar
command 'IF'
comand 'IF"
Macro to Delete Row based on <3
Detect Delete Column/Row vs Insert
putting count of the number of rows at the bottom
Looking for a column heading and using the column position
HELP Needed, Word mail merge breaks when saved as.. from an Excel Macro
Delete cell data in a row
Put a formula to a cell with macro and it doesent calculate. (Excel localisation problem?)
Match dates and prices
Trouble Adding VBA Code to Module; Bug in Excel/VBE?
Compress file
VBA data from Closed workbook Question
how to identify the control that ran a macro?
Transpose > out of range error
Password protection
Textbox
Select a macro button with a macro
how to get specific strings out of a cell ?
database form
Selecting only certain characters from a cell value?
Find and replace in excel
Automatically registering ADD-IN COM DLL - Some help required.
change the name of an excel module
Moving around cell by cell in VBA?
date format
file size too big!
inserting rows at bottom
**Link 2 sheets based on particular field**
Get subtotal by two criteria programmatically
Looping through excel files to add to a new workbook
Referring to cells on other drives
sumif function on multiple sheets
Generating a numbered document
Convert from vba to vb?
Finding a word, then deleting every row above that?
Generating a numbered document
Showing Excel within the MFC application
Forms ComboBox
Using Excel to start a merge session in Word
Loop through ".DAT" files, open run code, close next
How to apply the custom chart type: "Line - Column on 2 Axes"
Event procedures: who is calling?
problem with code. past link instead of copy
Getting an Excel::* pointer from a com component
average of values >0
inputbox help
Performance issue
"Invalid Property" msg when Property Valid???
adding data to a chart
allow edit ranges protection
To be safe - how to check macro before run it?
Running a macro in a predetermine range if not them msgBox
Excel's Spec?
PivotTable: string data ittem filed?
Clear Form results in INCORRECT "Invalid Property" message....
enable menubar
Can I tell my Macro to stop running for 10sec?
Copy cells in another worksheet without activating
CalculationAutomatic is changing to manual
copy method of object failing
Combo List Circ Error?
Rename Userform and Insert animation
blank rows filling (Urgent)
How do I set up a default zip code that correspondes to a town?
Using one spreadsheet to create another tidier one.
Merge rows depending on the value of the first column
Filldown Formula
Secure Log In
Count contents in a column
left and right function
Relative movements within macros
Changing the activation of a sheet that is unactive and undefined
Determining User's Windows Login Name
add-in thru an "on screen Button"
Combine items from two lists with a key field.
Event: Workbook_SheetDelete
Excel-hyperlinking between workbooks- close visited file when ret
data linked to new form
How to initialize the column width from pixels. Pixel to Char conversion
Reference an individual row within a Column
Onclick 2 events
Window Message for not value found
Macro help to rearrange excel table
To define the workbook name which is changed for every running ?
Changing Directory for GetOpenFileName
Require a password to execute a macro
User Form will not scroll to Match Entry First Letter?
How to initialize the column width from pixels. Pixel to Char conversion
select toolbar button from macro
Defining a named range for a dynamic result set
Help:Programmatically Adding Checkboxes with Captions
Getting data for a workbook from another workbook conditionally
variable amount truncated regardless of # of decimals
Print certain data based upon input box
Incremental Progess Indicator
Open recordset using ODBC
Top 3 Records
input box
Using autofilter to ADD data not delete data
Joining identical items to show as one????
2 Urgent Questions
Sum a quantity once for multiple entries
vlookup>= or <=?
Sorting and page setup in a filtered list
FSo tutorial for Excel VBA
create blank rows
Similar PDF generation Problem
school project ..please help
Extracting from Outlook Calendar to Excel
How to create module wide 'constant'?
How to know if a text is displayed on an empty cell
Close Explorer Instance
very large text and CONTINUE records
Automatically closing workbook
placing an embedded file on a sheet in a fixed position
Moving a workbook
Sum the items in a column whish match a certain value
change event for multiple cells
Control Command Button Font Size Expands
Searching within VBA module
Solved it
Formula that does nothing
IF,Then and else??
Autofit doesn't work when column not enough width
prompt user to specify a directory
Excel VBA - help with selecting
Formula with excel range
Login to Web Page and the Search Page for Text
SST and CONTINUE records
recycling list
New Collection add trim
Condensing a macro
Tracking changes of login & time
include VBA macros as text file
Resize a variant array
window size/scroll
forcing cell format type in excel using com?
Changing shading based on a row above
ColorIndex Mystery
Mod(number;divisor)
Mod(number;divisor)
Format for Leading Zeros
Problem Deleting all rows from List Object
0's to blank cells
Date in YY/MM/DD format
Excel controls vs vba controls
Collection tries to open /.xls
save file by DDE
Storage of a serie of dates
Out of stack space problem
Out of stack space problem
'On change' property
Copy and paste columns
Web Query using ADO(?) connection
selecting a cell
Loop Until Clustering?
Pivot Selection
Horizontal filter
Execute a macro from command line: possible or not ?
URGENT: ManagedXLL v.s XLL Plus
getting data from all files from a folder.
Different Styles within a single Cell
Opening Microsoft Outlook attachments from saved .msg files
Macros running slow on Excel 2003 but not on Excel 2002
Is it possible to disable a tab/page on a multipage Userform?
Compile error: Can't find project or library
DataList not fill
How can i extract some text data.....
Listbox doubleclick launch
VBA Copy, Paste and Format
The case of the moving image
ranking values
VBA EXCEL IFSTRING HELP
User Form to Modify Row
Macro to remove
Run time error 13 with new Collection
Network folder list
Auto Update Range of a Pivot Table
Row Hiding doesn't Seems to Work
ass Auto Quick Info to UDF
Copying certain criteria from one worksheet to another
Microsoft Jet Error VBA Excel
ActiveRange not resetting
"Invalid property" after "Clear Form"
Error 70
images caching
Refreshing the data in a shared workbook with VSTO
use a variable to name an object in a loop
Capitalize the last character of a cell.
Deleting items as they are used from a drop down menu
Showing length of active cell in real time
Need To save a spreadsheet multiple times through a macro
Recording numbers in a new file
browse for a .xls file then open in visual studio 2005 express edi
Can't see cursor or selected text in textbox even though it has fo
Find and Then Loop
Switch between unknown wbk name grab a value and go back
Dynamic Data Validation in VBA. I s it possible?
Label in Excel... change caption from VB
auto resizing of cells or rows
Class Collection Add Items keep repeating
Error 459 on callup of UserForm with ActiveX control
printing text in autoshapes
Sending tasks from Excel 2000 to Outlook 2000
If a file exists then do this...
column width > 255
Conditional Discount formula
Unable to pass variable between Userforms
Trying to Combine Workbooks
this is weird
counting rows
Reference to an Embedded Word Object
FileFormat:=xlTextPrinter saves only 240 characters of cell
Open and Save CSV File
baffling: method or datamember not found
CAN I REPLACE NON-PRINTING CHAR(127) WITH A SYMBOL?
How do you change the default alignment of merged cells?
concatenate
dynamic colouring of fields
help with looping dates
resetting Public Arrays in VBASIC
Move to the cell to the right
Password option for spreadsheets
Macro compatibiltiy between XL versions
Find/replace
Opening/saving a web page via VBA
General Question on Range
Work on a hidden worksheet
How to run a macro on all sheets?
InputBox Code
Multipage question
Autofilter toggle problem
create a loop
Change excel file icon
Listbox with text & input row
Extract numbers from text
Select Range found by Vlookup
Need help -- a Macro that searches for string in a cell range?
Help
Can't insert a String Variable of Long Date into Page Header
export sheet
Picture name is changin as worksheet is copied
Problem when Excel Not Maximized
create blank rows
Find specific text from a list of possiblities
Get subtotal by two criteria
Append Columns to another column
How to retrieve the value within the table from Access into Excel?
compile error... ADODB connection
How to trigger code in Excel add-in after double-click or right-cl
Can't select range. Why the error?
Data-input pop-up box?
Format - Add space between number and symbol (%)
hi, i need help , i want to create a macro that take snapshots
Setting the print area
Select values from spreadsheet and use as strings
auto populate
Please Help!!
Excel user access rights
How do I count the instances of numbers in a list?
Catch Error in macro
row (i:j).select
Problem with scroll area
Set up a macro in one row and then return to fill in next row?
Date Format
EXCEL hangs on PIVOT table!!
Link to a specific sheet
Help Me!!!Excel opening File Maker
Tickboxes and the macro's behind them
Find/Replace text with formula
Compare values in multiple sheets
if statement problem
Command Button for Printing
How to test if an object exist really
Automatically sum a filter
Userform to load when Workbook is opened
Print dialog : problem when user click printpreview
disable the Tool menu in toolbar
Cell cropping with a Macro or VB
Help: Import text > transpose > append to new worksheet
IF(OR) function with text
PasteSpecial of range class failed in Excel 2003
Save Value after run
disable Tool menu
mileage cap using vlookup
Conditional Concatenate
Some Macro Help Please
i need to publish an EXCEL workbook with VB macros on my web site
Excel User Conference - Registration winners
Combo box help
English to VBA translator needed
cell formatting
Storing selection & using the saved selection adress later
How do I log user changes to excel workbook?
auto filter in merged cells
Automatically rearranging text in a cell
RE: Automatically rearranging text in a cell
disable the Tool menu in toolbar
RE: Automatically rearranging text in a cell
Solver Add-in
Tick Box Macro
Can I select whole rows of non-continuous range data?
custom menu not showing in template file
MultiPage tab
It 'd be nice to 've dynamic labeling of sheets (ie.based on cell
How do I write If then statements?
Pivot table input selection criteria
Where to get "Microsoft Smart Tags 2.0 Type Libary" ?
how do I set up an employee time in/out login
How to run fla file using VBA
Macro CPU Utilization Issue
Embetting Vlookup in IF statement
Excel VBA Programming...How to Trigger an Event WhenYou Move Off a Cell
Autofill missing numbers
VBA References
Help. It should be simple, but it is not.
How can I repeat a macro?
Hide range
Why do command buttons shift when i am printing my files?
RE: Why do command buttons shift when i am printing my files?
Select Case
RE: Hide range
Help!: Converting "1,253-" to "-1,253"
Moving row data to columns in a one to many
Required Sheet and fields
Force condition on all Rows
File Not Found: LINK.EXE
Emailing selective sheets within a workbook.
How can I repeat a macro, and how can make it without any message?
Extracting content based on criteria and creating new workbook
Find and select LastRow Minus 1
copy any clicked cell address like A1 or B4 to the clipboard
HTML parsing with VBA
how to reference a worksheet with a variable vs a name
macro for parsing text
How do I set text alignment in code.
Disabling BeforeSave event
Listbox Select items with Keyboard.
Parsing the file name
Programming with events
Macro to combine cells
Inputbox to pull cell location
math wizard needed.
sendkey method for forms
Pulling Info From Cell To Form Label
MS Excel 2003 Combo Boxes
Runtime Errror 1004 No more new fonts may be applied in this workb
In VBA, make IE Browser object always in foreground
Lock a cell format to dollars only
Problem Copying book
How can I call a JavaScript Function from Excel VBA
How can I call a JavaScript Function from Excel VBA
How to automatically clear cells upon changing/making selection?
Excel 2000 Templates
Excel Macro Question
Combobox to select date
Find function
elapsed time format
Ranking based on two columns
Append DateTime to Fiename, saveCopy
How many series does this code create???
Opening a list of workbooks with vba, similar to going through sheets in a workbook?
printing macro problem
Bold Font
Setting the page index in a mulipage user form
How are excel function names in dlls/xlas resolved ?
update excel files using a vba script
Are Macros Safe as a solution to Excel sheet problems
How to use SUMPRODUCT in VBA (further query)
Is it possible to display worksheets cells in a userform
Pull information based on a range of numbers
Creating xls file via xml getting Run-time error '1004'
Can you run a macro on a worksheet from a module in an XLA?
vb cancel button
Error 1004 - unable to set the hastitle property of the axis class
Pausing in Excel VBA
If then else
Mouse X-Y Coordinates
show XML data horizontally
Countif using the same cell on every sheet
xll worksheet function
How do I add to the list of function categories?
DropBox w/out user override through paste
Measure length of an AutoShape Line?
commas missing at copy and past in excel
How to move to 1st cell in next row after exit a particular cell.
Excel VBA Paste Special - replace contents of destination cells
Excel to Access export using VBA in Excel
Function/Sub to change cell properties
With End using multiple ranges
Holiday form
External References to Libraries
translate ws formula to vba code
Setup Chart name
help with loops in code,
How to select one of three lists for a combo box?
Range reference problem placing charts
Cell Event Only Affects One Column
Displaying the size of the dataset currently in memory
Resetting VBA Windows
excel sheet with visual basic doesn't open
To do list management spreadsheet
msgbox function
Need Help with Inserting in SQL
emailing a single worksheet from an Excel VB form?
User form OK command automate
How can i split some symbol into many cells ?
Open (website) for Input?
Userform shadows...
Differentiate between 'Print' and 'Print Preview' in VBA code
make checkboxes bigger
Getting the current row for excel sum product function
Find text String and select cell address where it is found?
Esc Key Closes Workbook
Data Modification
How to create pick list in VBA
removing the file extension while listing files via foundfiles
Drag and drop Web services in Excel
Using FoundFiles to list by path and filename
hijri shamsi calendar
variables in excel solver for vba
Web Qery Based On Form Field Input
save/export custom button image for toolbars
xl copy cell content to NotePad
Sheet names in a macro
help with error in code
Actual Saved FileName begins with Space
Need to get contents of one cell to populate into other(s).
Unable to trace dependents and file shows "Calculate" all the time
Add-ins
Modify Pivot Table SourceData range
Help with Hyperlink...Mr. Dave Peterson's Code
Copy value from next cell in a row if cell value is NaN
Macro to delete row if row blank but cells do have formulas in the
How to use SUMPRODUCT in VBA
In Drawing toolbar, All Characters and Symbols of the keybord sho.
How can I insert a run macro command in the IF function?
find value in one sheet use this as the row to copy the value in c
Knockout draw
Open Browser Maximized
Setting varible to equal values of a # of cells
SheetName Function
oledb connection string problem in vb.net
inverting a chart
checkbox in runtime
Allow grouping / ungrouping while protecting the sheet
userform listbox columnheads
Error writing value to cell - continued
want to show a picture based on a value
"lst" file does not work
Lost Visual basic modules
Working with one Column in a Named Range
Here is fix for Windows file problems
problem copying workbook
Data mining
Selection a row while within a "FOR Each"
Open a workbook with a name that was recorded in a cell
Some basic (pun intended) info needed on VBA please
Extract data by skipping blanks into a summarized form
Populate sheet from userform
CountIf by month
find the total
easy way to fill out a range with formulas?
Find and Replace Macro
Userform problem
Skip blank cells; Run-time error 380
kill old versions of workbook
How to run XLS Macros from inside a VB script
excel vba input boxes
Macro taking longer every run
Clearing a textbox in userform
iterate through a row to find a match
Referencing a different workbook.
Reference different workbook
How to change closed file name - Error: file not found
Textbox Problem
how to automatically download info from yahoo finance into excel
Pivot Tables in Macros
Is there a way to have an Excel Macro fill out a IE web form repeatedly?
Macro help
FileDialog(msoFileDialogOpen)
working with multiple ranges
Reading binary file
Help unhide sheets
VBA shell command - issues...
Hyperlink on vba form
Module error?
Macro to copy formula if cell has value
Running code before any file is opened/saved
Printing specific excel worksheets in VB.NET
"program shortcut keys in Excel"
Help with Emptying a Collection
Code to bold names within a cell- With a twist
Pasting Charts from Excel to PowerPoint
Creating a commission function
Pause Macro
Compare Cell
i need to record a macro to....
macro to copy/paste range for printing
Macro Which Highlights Rows That Contain Identical First Cells
Excel path problem with UDFs stored at different locations
Hide/lock cells?
Fill combobox from DLL
Excel 2003/ Excel 97
Name cell after worksheet Tab
errorcode if somebody is trying to change ...
Auto Execution
How can I detect .xls closing? Not BeforeClose , Like AfterClose?
Autofilter question
use selected value from one combobox to populate another combobox
Text boxes missing in Excel publish to HTM
add to a dynamic list
add to a dynamic list
Creating a form with option buttons
Open an Excel File from Selected Cell
renaming VBA "modules"
TextToColumns prompt
exception to MsgBox
Can i change a fill color in vba?
VBA function to xll function
Can one use Excel (or write a macro) to solve differential equatio
Type Mismatch
Using Find and Replace to replace " in a macro
Please solve this VBA mystery!
Removing last 2 digits on a number in Excel
Playing a embedded wav file when excel opens
interior.colorindex causing problems
Add row and text between each row
Deleting HPageBreaks returns...
Unconcatenate and Replace Text
Trying to loop through all shapes on multiple worksheets and change color
TYPE MISMATCH
passing variables between 2 forms
need to make a macro to sum the highest 3 values from 10 coluns
How check if workbook open?
Sumif or sumproduct
date update in VBA
How to d/load & save web pages w/VBA?
name of checkbox that was clicked in a userform
Run-Time Error
Another Question regarding ranges
Combine a range with a constant number
macro for parsing text
Named Range Issue
How to get actual rows number in Excel using VBA?
=now()
Trouble selecting chart in macro
Changing number of input boxes???
copy cell contents if "x" is present in cell.
Vb.net and Office 2003.
when select cell in range checkbox value is true_but how?
add to a dynamic list
How to get actual rows number in Excel using VBA?
Is there a break statement in VBA
Control Objects missing when opened on one pc.
using, referencing bmp in spreadsheets
Strange values
Array Formulas in VBA
IF - THEN question
Need VBA code to dtermine how many rows have data in them
RE: UserForm_Initialize
ChangeLink - What's wrong with the following?
list index problem
Re: UserForm_Initialize
Navigate to specific cell on specific worksheet
Defining string using InStr function help
please help Need VBA code that searches for partial text in a cell
Charts.add error
Error connecting to OLAP 2000 through Analysis Services addin Exce
Find() method help
Moving a file using excel vba
Font.Color - syntax error ?
Finding the Format of a Cell
Shading cells in a row based on another cell
looping through controls
Problem formatting series in VBA
Populating form with data from worksheet
Simple but I can't remember
Help with Date Macro/Function
Private Function Code Change
run-time error '9': Subscript out of range - WHY??
clip art
How "memorize/save" sort in ExcelXP
Time calculations
how to do for each worksheet in workbook exept one sheet??
passwords
VB Macro for concatenating data...
Executing macro on cell change.
Excel returns @name? error when using a custom written function in
Total values per colour
Opening CSV in excel from VB
Onkey doesn't work
ComboBox Code Error
telling range when to stop.
Copy Cells to variant array
Restore the Context menu Delete option
Calendar Control
Problem saving sequential numbers order book
find and replace in vba
Search words in array?
Data Valadation Formula Needed
Excel automation problem
Looping thru Workbooks problem
Finding matching rows on two worksheets
Macro to sort through data
Copy paste VBA
Excel Auto Zoom Module
Excel Programming
how to subtract whole #s but not fractions..
Drag value not format?!
How can I add a table from a different DB to excel Query 2002?
Re: help needed with excel macro program
Hyperlink Vanish after if been Copy????
The macros in this file do not match the digital signature.
Starting and stopping Ontime
Specifying the size (in cm) of a chart ?
Sort in 2003 not working in 2000
Clear Contants in a Range Based on a Value
Rowsource referenced to a hidden workbook
Trim does not work
EnableCancelKey traps ctrlBreak once, but not twice
a question about "Application.GetSaveAsFileName"
Refer to picture stored in workbook
How to change alphanumeric to numeric
Read through Range and copy Cell data to Array
Help, need advice
"This edit requires a reset!" Error in the VBE
Unattended Import to an excel spreadsheet
Printing from EXCEL using a macro
Cant query a web page
data rearrangement...???
Copy contents of Cell to array based on Col1 value not null
How do I locate cells who have conditional formats activated?
Show date last time modified
Read through Range and copy Cell data to Array
Loop to acces various rows
Finding criteria and removing matching rows (Range issue?)
Splashscreen
Using Object model to start an instance of excel on another computer?
Hyperlink fails to open a PDF file
A troubling issue with external links update and workboon_open macro
option button dependant micro
Application.EnableEvents ... Is Local or Global ?
MMULT( )
With Analysis TookPak activated, Workbook_Open Event Not working at all
Oprning a User Form
Stopping error messages from popping up - part 2
Excessive database access time?
changing cell color if cell has text
update range in For loop
Validate non-blank fields in Excel workbook
Showing or Hiding rows based on data validation list
SeriesCollection(i) and XValues= Array() error
Help Consolidate method
comments in Excel
Compressing Photos usng VBA
Need formula or code
deleting certain numbers of characters in a cell in a column
How to stop error messages from showing
RE: problem with links
Extended search macro
Searching for info in excel
Run Time error 424 Object Required
Generate permutations but delete double entries
cell bar always lit
"acessor flags" creating pivot table from recordset
ComboBox help.
Automated Popup on Opening of a Spreadsheet
Import Errors
Excel Macro
Split workbook
Progress Bar ?
Disabling the Key board shortcuts
Disable ability to Protect
Protect Pivot table queries
Share a custom macro toolbar
Hyperlink function and copy the cells without the function
Fetch parameters from web into Excel
Calling command button from another sheet
object variable error message
What's the proper syntax for "Windows..Actvate"
Digital Signature
Using Macros to create pivot tables - query re last row
Amount in words
Excel Viewer as automation server
free cell
Adding up filtered list..........only what is shown on screen?.....
converting lowercase to uppercase in userform
Can't paste as merge cells aren't identical
embedding a pdf document dependent on whats selected from a drop down box
Linking to an individual worksheet from Sharepoint
For each sheet in workbook
London Excel User Conference - July 19-21
Array function ouput
Workbooks are getting damaged in network environment
do events? background events
ComboBox
Using IF statements to insert text
Change file names in a folder
Web Query
Excel American dates
How to Remove Workbook_Open macro?
Max
Using double quotes in a macro
Worksheet Tabs
Macro Code for closing excel...
HELP!
Drop Down list that enables multiple selection..
Find by date range
Finding a cell, selecting the one down
New to VBA
Using pictures in Userforms
Adding PivotItems
if then or statement in a macro
How do I see the amount in words (I will enter amount in numbers)
VBA references
Personal.xls
Boundaries Excel Worksheet
get week day of a date
marco problem in excel 97
Sum at end of data?
macros
Essbase
Using .FoundFiles to list files by path and file name
Essbase
pivot table Commandtext causes runtime error 1004 in excel 2000
Fortune 40 analyst seeks explanation for Excel/VBA quirk
returning Access data to Excel
SpecialCells
pasting into Word...
Macro Help
Excel Merge Cells
Displaying filtered results in a form
For next loop and paste special Help please
Sorting Multiple Columns Repeatedly
Sum varying number of rows
Don't show the steps in a macro
Nested IF statements
chart series data corrupted when chart has no data
inserted copied range into different worksheets
Comparing columns
splashscreen?
VBA Formula with variable s/b simple
Future of DDE?
Option Base error...
Find from just certain sheets in a workbook
Excel spreadsheet to SQL Server 2000?
Passing info from macro to UserForm
Selecting area of unfixed size, creating borders
I need a conditional formula
Calendar Control 11 - Month/Year Only
How can I get VBA to create a table or run a query in MS SQL?
Missing Type Library
formatting inputbox
match range of axes from one plot to another
vb help
Please correct for me this code
Please correct for me this code
passing commandbars to a procedure
Delete all but 1 sheet in workbook
Hide or Highlight Row or Range based on changing cell value
Comparison - Strings and Arrays
Last 3 rounds Average
protect/unprotect & display flicker
Excel Help - Match column in one worksheet to all worksheets in different workbook
Chart object effect on Dim sht As Worksheet
AutoFilter
Application.OnEntry
Trouble Condensing Code
Missing Chart Text Boxes in XL2003 Html Publish
Counting Colored Rows
email help
setting search range from VBA
Importing last 10 entries of a .csv file
VBA Variable as userform
How do I automatically "enable Macros" when opening a workbook
Missing Text Boxes in XL2003 Html Publish
Missing Text Boxes in XL2003 Html Publish
Duplicate rows Elimination- change rows accordingly
Saving as Web Page
Sub-total questions
Exception from HRESULT: 0x800A03EC. at Microsoft.Office.Interop.Excel.WorkbookClass.get_V BProject()
Dollar signs in VBA
compiling doubles file size
Showing help for Excel User Defined Functions ( Com Add-In )
web query returns no data
Can I create an Excel User Form without VB install on my PC?
Reference to a library
moving cells in Excel
setting permissions programatically
Trouble with VB since adding a macro
Problem with User form VBA
trying to automatically populate database from intake form
ad button for different rows after searcing in database
Re: adding a code to a cell?
How do i copy a active sheet to a new sheet with code and everything
open without link update
Tab Key Inconsistency with User Form
"Looking Up" Access from Excel using SQL.REQUEST
Results of a 'find'
Why is Sheet deleted when Macro runs...
User prompt -> Open file -> Perform action
? Encryption function
Comm Add-ins
? Get Worksheet Codename List
? Disable "Ctl+C" & "Ctl+V"
how do I automatically run a macro from the result of a cell
Scrolling
workbook name with and without extension
cant change numbers back to general format wont let me
All selected listbox values to a cell?
How to pull values from the pivot table fields, through the code/.
Quick fix
Stop Capture Event
Add custom tool tip to a Point in Scatter chart using VBA
Instantiating a .Net object in MS Excel Macro
How to Open a Word template
Workbook_BeforeClose
Textbox margin
disabling printing fields
this macro runs, but not with a filter on the sheets?
Help with code
Compile error: Can't find project or library
Code for "program evaluation period"?
Cell change to trigger Macro
Lookup Values in different sheets
bye...
How do I reference a directory for a file in VBA that is different
Open an excel file
Need help with a easy programming question
rewriting macro to only clear contents
Seeking Book Recommendation
Creating formula
Starting Excel from a file
inputbox and helpfile
transfer of columns from one sheet to another
adding 1 hour to input box
Scheduling
Populating data on Forms from spreadsheet data
Connecting to an existing IE instance.
Adding additional rows with formula
Loop to the next row
Select all data in column and list in form combo box
ColumnWidths property
How do I set up a form to select files from
Reporting conundrum with fixed data
pivot tables: changing 'sum of' to 'average of' & cycling through pages
changing label caption by user input
How to build linked spreadsheets that add new rows when done in ma
Obtaining Active Document Name from WORD for Excel procedure
Printing Headers using Criteria chosen from AutoFilter
Print Preview & Custom Menu Bars
Calling Save
concatenate formulas
Tab indexing
Problem w/OCX
combo box in a user form
Turning Tabs Colors on the input into a cell
Date Format
Force Worksheet_Change event
Format Date
Reporting conundrum
LOOPs problem
How can I get a row to display the date of the last friday, and every friday before that?
How to get a macro to work in all workbooks
How do I remove rows that are empty
Getting data from a closed workbook
Finding all matches in column B with datalist in column A
Run time error 1004 - unable to get the chartObjects property of the worksheet class
Accesing a second workbook
Deleting multiple sheets
Macro turning colums w/headers into list on multiple sheets
Pivottable references and values
Old Projects in Project Window
Save Excel workbook to Desktop Using a Macro
using .resize or an offset
Pivot Table column widths
Too many modules?
How to disable the right click on the worksheet tab?
Date and time field
Sum by Color Array Formula
Delete every 2nd column from fixed starting point
Reorganizing Data in Excel from Rows to Columns
Getting a cell value from many workbooks
Making macros Wait
Dynamic named ranges
Adding Rows To Update A Formula
Inserting VBA code...
Unexplained "Bad Record Length" error / bug?
help with making a directory and saving the spreadsheet
Pivot table help
Why errors occur in wrkbook w/ vba when saved on Shared folder?
GetSaveFileName
Reset VB Code Not Working on Close
Inputbox to enter a %
macros!!
Need help
Delete Insert Worksheet on Open/Reset on Close
Error 424 - Object Requried
Formula references
Update cell value from anohter worksheet
Can the delay associated with the VB sendmail method be disabled?
help!? trail report
Aplication to import and Convert Data
Make date entered in an InputBox UK format
variable range in a COUNTIF statment
open external workbook keep hidden
How to count the cells in a table row ?
Referencing .Net Remoting Services project in MS Excel Macro
[Macro excel] How to create and export a sheet into a *.inp (or *.txt) file
trouble comparing a value in a text box with a variable
Improving Workbook_SheetSelectionChange for enhanced Autofiltering
pivottable name in a macro
Exponential Smoothing Macro
Matching list
Matching list
Refresh XML Data programmatically.
insert picture problem
vba events across projects
progress bar
Edit PivotTable SQL datasource
Using a macro to create multiple PivotTables
Re: Keeping images visible on sheets
Opening Linked Workbooks from Summary
Reading data from an Excel cell
Frequency of time range in two columns?
Inserting Pictures
Adding/Subtracting Dates and Conditional Formatting
Excel Combobox Box Control
Remove picture from Image Control?
New to Events
Link to a Stored Web Page in Excel
How to detect last row of Selection?
How to continue loop after deleting row?
question about prime numbers and font sizes
events across vba projects
vba events across projects?
Launch IE Browser and manage vertical scroll bars
VBA draw and erase lines (crosshairs) on form
excel macro to extract data from one worksheet to many spreadsheets
excel macro to extract data from one worksheet to many spreadsheets
Excel - Extract data from one worksheet to many spreadsheets ...
How do I force only one entry in a range?
Copy sheet and clear cells on new sheet at sametime.
absolute references etc in VBA
i want to download tif files one after the other links in excel
IMPORTING 100 TEXT FILES INTO EXCEL AT ONCE, WITH LABELLING
"box-select" mode
Missing dates
Dynamic reference to Word
How can i insert data into sheet without going thruogh the undo buffer ?
Error writing value to cell
macro for filling in dates
Paste values macro
Incrementing row number
compiling data from one book to another...too many "ifs"