Excel Programming [Archive] - Page 80

Search and Delete
How to create a massive find & replace macro
calling next macro
excel filter question
Automating a Printout
find, delete, repeat loop
Macro Interaction on Server
countif problem when using range name
VBA copying & pasting into a different workbook
Comments & Scrolling
Saving Workbooks to web pages
Is there a script that will work?
Formatting Data being extracted from SQL D/B
Combo Box help
IF formula syntax problem
Missing Recording Macro Indicator
How to create a Macro
How to create a Macro
Deleting duplicate data - inc original cell
Pls. Help: Need Macro for Copy and Paste
Copy only Visible cells to another sheet in Macro? Runtime 438 error?
trouble with syntax with fill down in Excel
Compile Error
MS Query help!
Update data from an external Excel spreadsheet
Fill Down
Get Autofit in Excel to format just part of a column?
wildcard
Easy way to plus 10 to each cell in A1:A50?
I need an expert for that!
Run-Time Error'-2147221080(800401a8)': Automation Error
totaling copied columns from multiple pages
Cut instead of Copy
Assigning new values to charts
Saving to PDF Writer
i dont see what the problem is...
Excel is not closing
convexcity funcion
Simple do until question
check box help
Automatically attach Excel spreadsheet to Outlook Email with Macro?
Show cells with formulas without permanently changing the cells
Merging two tables
determine max number of columns in a spreadsheet
(Email code) Strange sned/receive problems Help ??
make the form execute file
Shuffle through sheets in a loop?
how to delete row from the runtime Datatable
Looping thorough records
Automatic 'Save As:' question
How to copy a row with transposing to a column retaining links to input cells?
Repeating code
Range selection
Manipulating a rumba session using VBA
rename files in a folder
Saving each row of an excel file in separate excel files
VBA issue, debug
Filesearch finding the same file twice?
Data series
Why Undo commandbutton is Cleared ?
validation
Spaces in Textbox
print preview
VBA Help required...................!
custom toolbar looses buttons when closed
Auto List Members rarely works
VBA Convert only a particular worksheet to CSV
excel column to word with coma separated!!
application.worksheetfunction
Accidentally close user form_how to open
Is this the correct way to write code
Security Message when emailing
Need Help Filtering Duplicates in Excel
Macro that Deletes All rows except first row
Increase/Decrease Value of variable/cell using scroll bar?
VB code to call a macro......?
The "Do you want to enable Macros?" window does not pop up
trouble with syntax with fill down
Reading Data from a Cell to a text box-user forms
Cmd Buttons directly on a spreadsheet
Split cell data in mutiple rows
SendMail and User Input & OutLook Express
multi line cells
User Form Change
Calling Regression Toolpack in a Macro
Event When the excel opens
Formula, means and non following cells
class module programming?
Application.Dialogs(xlDialogSendMail).Show
Limiting the use of a Macro Procedure.
Unprotecting sheet did not prompt for password
command button
Printing to Adobe Acrobat
Display Program Status
Open Files Macro
Variable range question
Date event macro. Help!
userform combobox treating numbers as text
Referencing Cells without active cell
extract data after sort
Interacting with Forms
Select group of cells and create arrow pointer to elsewhere
VB Syntax for OFFSET statement
function question
Toggle Custom Views
What the F@#% is wrong with this code??
Word Excel automation and the problems I found - Help Needed
Object required error - Still perservering with this code - Ideas
text comparision
Format number as currency in label control ?
Have not a clue how to do this
VBA question
Shell Object Not Working Right In XL2000, But No Errors
Extracting comma seperated data to new sheet
Subtotal row formatting
creating a macro with IsEmpty
Problème avec une boite de message!
Extract part of a Worksheet name.
Formatting columnar data to a monthly matrix
Password Protecting an Attachment sent via VBA
zero filled changed to non-zero filled
print charts from excel using VBA
Web Service Array from VBA
Count if, & Replace
Setting the Chart name as the text from a cell.
Unable to move sheet after inserting it programmatically
How to write a macro to do...
Suddenly Asked for Password on Tools/References
relative versus specific cells in macros/vba
Adding a Comment on a protected sheet
Macro to fill in cell?
calculate sum of range
Sumproduct
Worksheet change event-single column
Find Values in Cell
Color of Commandbars Controls (buttons) when disabled
Automatically moving/copying cells
Simple Problem - Please Help
Find, FindNext and prompt user to delete
Send file in an email
Macro:Vb:elapsed time per day
Activating a workbook
Display the value of an auto filter
Help me please
Evaluate (Variable Function Name)?
Resizing user form in excell
Insert picture in Excel
Closing Workbooks Formula
detecting changes to series of charts
Macro not calculating correctly
Find value in range
Find Copy and Paste
Selection
Pasting data following the last " > " in a cell
Strange Link Appearing Automatically
Need Help, trying to automate excel word and pdf
how do I clear a dialog box option
Data Verification Problem
code for sum of sht with diff # of rows
Bulk Upload
Help emailing worksheet range via Redemption
Dates
compressing folders
Many columns
Transform entities from column of 1 sheet1 to row of another sheet
Replace/substitute
SelectedItems
Sum Columns
why doesnt cancel=true always work?
VBA+API refresh userForm
transforming excel cell contents in word document, with coma separated.
Excel 2007 Beta 2: COM AddIn don't work
Open spreadsheet
Spline approximation
application.sendkeys shift+ctrl+enter
Selecting
workbook macros now run VERY slowly ... ideas please
How to get link file name in vba
DisplayAlert
Worksheet_Change
Pastespecial code
Urgent Please: PasteSpecial not working. Very wierd
Want a muslim match?Want a muslim brother/sister?why not join our site and start your searching?Want a muslim match?Want a muslim brother/sister?why not join our site and start your searching?
mouse cursor for a shape
Quite a complicated problem
Please Help...Date converting to USA from UK when running Macro !!!
Insert row and column headings
Name Box and not picking up the correct value
EXCEL SQL Problem
Web Service Toolkit & using System.Net.NetworkCredential
Named range using offsets
SaveCopyAs
Custom functions or VBA functions for Avg, Std, Min, Max?
Help: Can open a spreadsheet in a folder which contains spaces in the folder name!
Formula protection
NEWBIE: How to sum cells using VBA
Only as the user once.
Almost there... dynamic and conditional set of PivotItems
Excel Library?
How many excel processes can you open?
Copying data into sheet
Putting pagebreaks after objects
Drop Down Menu on the Standard Toolbar
can 1 excel's DROP target change MULTIPLE cells?
link all workbooks to a index page
using match function
simple code hide/show rows with cell = empty, set value or any val
Change text colour of a cell when a different cell is selected
Changing cell format
Checkbox & Combo Box help
Change Screen Resolution Macro
Output param from SQL
Order check in solution
Saving VBA project on workbook close
call macro if cell is selected
Add menu item to right click
Insert user's logon name in to cell in worksheet
Calling an inactive sheet...
Create a Pivot Table with VBA HelP
Suppress Update Links dialog AND don't update links
VB code Required-------!
Add rows between months
Look at Outlook and not Outlook Express
Inconsistent appearance of HTML pages generated by Excel VBA
Inconsistent appearance of HTML pages generated by Excel VBA
disable worksheet tab options
disable tab worksheet options
Create ODBC link Using VBA
Sending a parameter to a Userform
Merged Cells quirky behavior
Accessing Excel data through Outlook 2003
Protect cell - VBA
microsoft email range code. Add to Sent Items folder?
Reference 5 cells offset from another for copying.
Run Time Error "13" Type Mismatch
RE: EXCEL, WORD Automation
how to save a range of cell values
Formula to count words
VBA password protect
Excel: useform and shapes
Fraction of seconds
Excel Problem
Using the enter key
set cell values based on selection from list
Count Form Button Depressions
row to column converter
Form Button Security
Excel StopWatch
how do i add time to see how long my macro takes to run
Previous data in a comment
Excel user form modeless
Related Tables - Access 2000
Word VBA link to Excel
Using a Macro to Reorder Data - tough one
Change Event Problem
How to copy a highlighted row
Macros in Excel 2007 Beta
Comparing cells?
How to pimp my custom menu (want to display FaceIds and shortcuts combo)?
How do I initiate a macro directly in a worksheet?
Current Selected Range
On export option where you want to save
Dumb early binding question
Calling Outlook in Excel runtime error
Animated Gif on worksheet
Complie Error with xlValues
How do I insert Text Box in ActiveCell
Change conditional formatting to coloured alternate rows dependent on a change in date?
searching data & forms
Retaining history data in cells when using a form text box
Workaround for com exe timer?? help
Macro for adding between dates
Run Time Error on Closing UserForm
copy to a sheet
Programming Funk...Any help appreciated
Simple MsgBox question
Place a tick in a drop down menu
Delete Rows
Addin data persistence problem
Add menu item to right-click menu
Enquiry on VB for Excel
Pls Help in code given
Excel 2003 with SharePoint 2003 and Analysis Services 2005
About "EXCEL6" Window Class ?
IS 'RANGE WINDOW CLASS' AVAILABLE ?
IS 'RANGE WINDOW CLASS' AVAILABLE ?
Writing an If Statement for group of cells
Precision in Excle VBA
naming using F5 key
SQL Server in VBA problem
Autosize macro
Copy?import whole sheet from another workbook
Date Functions in Excel
While sheet is protected, allow cmdButton to refresh query.
Macro to enable the analysis toolpak VBA addin on entering a workbook??
Advanced Conditional Formating
Macro to Click Button?
macro and button security
text box?
READING values from a closed workbook
Function with Multiple Criteria...
Wording a macro
autoFill column equal to adjacent column
Macro error
Code for opening Comment box
VBA help â€“ an easy question
Change in code
Copy and Paste
Puting data from an input box in two cells
Listing or Changing all Defined Range Names (using VBA)
Set PivotField to predefined value with check
increase print range 1 column
Find and select all
Record set to array?
Is there a way to vlookup and keep format?
2 questions: if-else & sheet loop
Update Links Automatically
VBA to SQL DB with user input and results to sheet
Cumulative Total
Excel and Internet Explorer (IE) - AutoOpen and Hyperlinks
Repeat error trapping when file is not found.
Copying Sheets
formatting number in a text field
Disable Workbook Summary Info?
popup menu commandbar
Run a procedure when exiting a a textbox within a userform
Oddity with HSI
Change Code in Macro to specify file/folder to look in.
Looping help please
Find New File/Folder
Delete (kill) active workbook on close: Possible?
Button alinement
vb.net & excel properties
setting first empty cell as range
Formatting corrupting the workbook
Random Select one of two or more numbers
How to copy a range
How can I perform multiple search & replace - all data in spreadsheet?
macro: copy multiple workbooks to multiple tabs in single book
Count Keywords in Column through Macro in Excel
checking and copying cells
Help with extracting variable text from a cell
File Change Notification
code need for time stamp
validate a cell value
Font Size in Chart Title
Select Table and Field of Query by Cell value
sheet protection
VBA Script to Print several named ranges to PDF with cell-defined filenames
Excel's Backbone
Jump to Page 2 relatively...
UDFs Worksheet Level
When was data added
Importing Modules From Other Workbooks
Macro for user to select hyperlink file
Microsoft.Office.Interop.Excel SaveAs error when clicking no or ca
Excel 2003 causes error with Excel 2000 VBA code
Visual Basic 2005 Express to make library for VBA (Excel) - How?
Permissions issue that I cannot solve
data reentry for ferification
Copying and storing values
paste special does not work
Inconsistent behaviour Stop Statement
SendKeys Positioning
Help me automate a macro
selct and Copy data from differant rows at the same time
how do I import a CSV file with more than 65536 rows
Selecting a worksheet from a combobox
Color all cells in a row if row is completely filled?
how to use partial (word) search
Information Rights Management
Function code
Update date when changing a cell
Textbox calculation problem...
Sheet names
counting records
Counting the number of Cells with a Particular Background Colour?
close user form
Referencing variable Range in a loop
Error 424
lock excel worksheet when loosing focus
Command Butons in Exel 2004
Excel hangs on 'shtA.Cells(person_row, 1).EntireRow.Insert' comman
Software Engineers - You will like Staffbucks!
Minimize excel user form
range names
Minimize user form
Help with three columns find unique data
usedRange problem
How to add user from to excel
Wildcards
msgbox to NOT display OK Button and to run while saving?
VB Excel syntax for "offset" statement
Help with filling empty cells with string + row()
Check for file before opening
Put current date into a cell when a macro is run
Format colour of cells based on other cell - 34 colours
Charting every 1000 points
Wildcards
Adding to a selection?
Resizing Toolbar Controls Automatically
Resizing Toolbar Controls Automatically
Resizing Toolbar Controls Automatically
Resizing Toolbar Controls Automatically
Resizing Toolbar Controls Automatically
Delete every other line in LARGE worksheet
Auto selection of worksheet
Day of month
Trouble using UsedRange to trigger an event??
Ron De Bruin Code modification needed when naming copied worksheet
COUNTIF statements
Delete a row with a certain phrase?
Automate opening a 2nd xl book and copy ranges to other xlbook
Automatically Changing the Print Area for Pivot Tables
NavigateArrow parameter -- meaning?
OLEObject.GotFocus
The unnamed range selection button
reformatting for labels
Search / Copy / Paste
automatic e-mail sending from excel
Excluding certain rows from Sort
Reference for VB syntax for Excel functions
Search & Copy
Solver in a User-Defined Function
Dim VBComp As VBIDE.VBComponent
using vlookup and sum functions and connecting two worksheets
Variable row to repeat at top of page when printing.
How to create an embedded Excel workbook in Word with cell text >
Data check
Using a PasteSpecial within a Destination:= line
GetObject Error 429 - ActiveX control cannot create object
Excel merging
Programmatically selecting first worksheet
Calling Excel File Save As Dialog
Programmatically selecting first worksheet
HTMLElementCollection Dilemna
Macro/Solver error message question
Getting Username from a file
Paste Special Values but keep formatting and column widths
Macros/VBA help
Find exact match.
OLAP Question
{enter}
Prompts
Solver statements XLM ---> Excel 2003
Can't find newly created userform
Printing a form with a sequential number
Change color of specific text within a cell?
Problem with E-mailing from Excel
a button that will hover
setting up the print area
VBA genius needed... Please help
Scheduling
Checking for existence of worksheet before creating
File,Save run a macro
If worksheet exists delete
Show real time in Userform caption
UserForm got focus
Custom Help File
When will Excel program with .net framework
How to reference variable range in a loop
Unprotect only certain cells after macros runs to unhide range of
Find invalid names via VBA
Excel Combobox with additional selection criteria
macro takes 30+ seconds to do an autofit on only 1 out of the 3 sheets it is autofitting
Running a macro on a specific time
Moving the Cell Selection Within AutoFilter
combobox and workbook_change event
how do you make a macro run automatically when a criteria is met?
Excel-Outlook interfacing
Can I address in autofilter FIELD with a value in a cell?
Shell
Retain Original Date in Page Header
Loop removal or optimization
Adding data to the end
Formatting certain text within a comment
Search for text in multiple excel files
Creating macro button on toolbar
Time format will not exclude seconds!!
vb excel
vb excel
Range existence check
Shell ?
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel
Adding Sum to bottom of Col C for all Sheets in Array
How to calculate market growth and market share?
pick from list
Macro to sort
Changing format of cells
Extracting certain items from each cell
insert image
Problem with RNG Macro
pop-up messages
Buttons in toolbars
Web links
ADO; RELATE vs JOIN.
Search box
Hyperlink problem
no view combo in cell with data validation
Web Query error returns
programmed hyperlinks
Search macro adjustment
Bloomberg connection
Calling customized DLL function fails
Pivot table on Forms
problem in excel
Limit entries to combobox
how to create farmula in excle programming
Remove all rows which do Not contain a particular word
New Worksheet Values Auto Displayed on Sheet 1
separate data from one cell
Error Handling - Did i do it correct
pass worksheet name to a macro
PivotField refreshment
Multiple Workbook sums
Check if sheet name is a number
List Validation selection
Please Help...Multiple web queries and Macro help needed!
How do I format a textbox with time
copy paste sheet name
VBA Macro
Workbook_Open() does not work
Compare two Workbooks and combine data into one workbook
ActiveX Plugin needed in Excel 2000 missing from Excel 2003
Updating a VData List in all sheets by changing a DynRange?
GetOpenFilename With MultiSelect Intermittently Returns String
Document Recovery
Allow Bold & Italic in a textbox
CC number both AmEx and Visa
Open Access from Excel
"For Each" Statement error...
Way to store cell location to variable?
Password Breaker
UDF Using Defined Name
Can I cause Excel to post an appointment to Outlook Calendar
AutoSorting
Is there a VBA PasteSpecial(PasteAllExceptFormats) ?
worksheet grouping, Sheets(Array... property
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA?
How can I look for a sheet in a wkbk and run a macro if not there
Why can't I tab?
Conditional formatting for text to number
"Error in loading DLL", VB6 ActiveX DLL
GetData
Can you convert a PDF to an EXCEL Spreadsheet?
Lelf Columns Turns Grey
Reading and working with a long CSV (more than 100K lines).
Excel Freezes When moving from UserFrom to Excel Spreadsheet
How to select cells in Excel accessed from VB6
always need 32 characters
DYNAMICALLY data source for pivot table
Is a search box possible?
vlookup type mismatch error
Loading Values From Another Sheet Automatically
Thank You
Excel Macro - Create & Run
Creating add-ins from Excel 4 macros
Finding a cell given x and y values
User permissions for ranges
Macro Button Link
data type problem XL9
strings
Overflow error, need help
How do I extract a word from a string?
Exel Code Locks up my Web Server
Open HTM file from Excel
Macro name changes
Sorting an Addin Worksheet
Opening doc in macro
How to loop through PivotTable
inputbox (error if close)
count formulas
Dealing with Shapes in Excel in a VBA sub routine
Quick Question on Code
XLA File Size Decrease
Copy a range using macro
Range Object CopyPicture Method; Paste to MS Word
one less than range filldown statement
Creating new worksheets in a workbook....with a twist
generate form from excel data
Cause Macro to Expire
Update charts
Combine Excel rows - macro needed.
Convert formula to range name that is recognized by vlookup formua
button to expand window over two monitors
Time consumption in macros
creating automatic hyperlinks
List Boxes
Concatenate
Need to make a vbs, but dont know how....
Find / Replace in a string
Dating cells in a worksheet using VBA
Deleting All charts using VB
link to another sheet
summing totals from varied number of workbooks
Searching
Keep IE on top of the form
Paste Data into other row
Inserting a picture macro
ADO Connection vs Recordset objects.
Creating macro in Excel that can add a check mark
Excel Date
Rename combobox with a macro
Need to tailor my macro code.
Parents and looping
calculating textboxes
count colomns
Random Value...
MDX query to filter the cube
How to call macro from other workbook
Populate pivot table with preselected items
copy macro
Maximum length of a pcuture name is 32 characters
Relative Ranges - Multiple Cells
refreshing outout value before tranferring into a matrix
the Parent property
Copy the same column from 50 sheets into a new sheet macro help!
Compare Rows in Sheet 1 & Sheet2
Pivot Table Calculation
Adding a line to a PivotChart
Is there a method by which we can programatically save the workbook?
VBA Reference Book
Text fields with numbers in .csv file
Mesage Box
Message Box if certain value is entered
Getting reference of an excel cell from other sheet
speech recogniition in excel macros
Toolbar event management
VBA to plot graph wiht variable range of data
Application.Goto Reference:="ActiveCell.Value"??? Whats wrong??
Repost - Is there a quicker way to copy paste
Copying more than 255 Characters to the Clipboard
How much memory does VBA code occupy?
Outlook Email
Sending automatic email + Bloomberg
Is 300,000 Named Ranges going to cause problems?
Unhide Columns in certain range
Getting Excel Runtime Error 9: Subscript out of range
Listboxes - populate with all worksheet names
Stop Excel's UPDATE\Don't UPDATE message box from appearing every time I open the work book
set excel <filename> to <filename-date>
Add file name to end of all sheet name
Need to save SQLdatabase userid & password after link has been cre
Copying and validating data from two sheets
How do I get cell possition in screen x y
double click option in listbox outputs to cell in excel 97 !
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct?
fresh learner need help!
NEW DATA
Macro to copy formula to all rows that contain data in columns A:C
moving columns to a new sheet
copy paste for each cell in an array
Count Words in a Textbox
SQL variable exchange
combining spreadsheet tabs
macro to import access data into excell
For Each ... Next loop - need to reference the loop variable
Gathering data from all worksheets for a report
how do I convert an integer to hh:mm (part II)
Find and Replace in mulitple tabs
MSQuery question
Disabling 'Cancel' option when saving work (Yes/No/Cancel)
Import one column of data from multiple Excel worksheets
Print merge file
how do I convert an integer to hh:mm in excel?
Uniqe Records
False message .xla already open
method 'SaveAs' of object '_Workbook' failed
DTPicker
Using Named Range in Worksheet_Change event
Problem with VBA code written in Excel 2002 working in Office 2003
VBA Password problem in excel 97
Closing a possible Workbook
Compare 2 list macro
Pivot Table Automation
Understanding macro statement
If Statement then Calc
if activecell is value
I s there a quicker way to copy paste
How-to create macro?
Please help... Deadline (ADO recordset.filter)
Help needed! How use a Command Button to pop up a text box in Excel?
functions to change color of fonts or cell backgrounds?
Workbook.Save triggers event Workbook_BeforeSave and things don't work!
Lotus Notes doc link not working in Excel
Textbox text into cell as formula
Macro
Wheel on mouse doesn't scroll in VB
macro to open in all files
trouble with website
importing multiple text files into individual worksheets in workbook
NEED HELP with Range command
Value error on closed workbook links
Enter Standard Time for H:MM Formula
Macro to Export Active Cells, Comma Sep to .txt file
FTP Upload
Copying a range based on criteria
Copying a range based on criteria
ERROR WITH MACRO EXCEL
How to permanently change Dialog Caption while in the Dialog
How to permanently change Dialog Caption while in the Dialog
Resize all comments
Macro Error
Simple Excel Ques?
Passing Data to Internet Browser
Help with an error message
excel graph construction
Worksheet Change question
VLOOKUP PROBLEM
TIP: Worksheets vs. Sheets (w/Charts) Count
Inexplicable problem with function
Need some help plzzz
How can I save a worksheet as a jpeg file?
Shape ControlFormat.LinkedCell returns wrong Address for named range - BUG
Scroll bar
Error: Wrong number of argument or invalid property assignment?
Ignoring fields containing text
autcompletion
Format Pages
Sort data
Range question
Series
Question-user defined function
Open another program
Adding a sheet with a specific name
excel add-in refresh
Excel Macro Question?
Macro coding to create a matrix
sound or speech when a cell reach certain value
Font in Userform
Can I copy cell contents to an autoshape as text using a macro?
Macro to compare two list
Macro to compare two list
Change Cell Color
How to display a pop message based on a cell value
Please Help! Object Required suddenly, was working before!
Opening EXCEL with additional Parameters
MS SQL Connection and Retreival
Macro to copy active sheet and email to distribution list
Rename active sheet with current file name
Determine specific range
Piloting excel with vb.net
Send key in an inactive window
Using Modules?
Automatically insert a row
Using PageSetup to copy LeftHeaderPicture in another sheet
Change row in a Visual Basic messagebox
HTML / Excel format problem
Conditional Formatting - Run Time Error '13' Type Mismatch Error
Listing of error codes
re : Help needed on some codes
Delete Blank Row & Put Total
What code do I use to add a user form to Excel worksheet?
locked cells
May be a Chinese Windows problem??
query information
Help with code please
Re-Format Date
Old code in Excel add-in (.xla)?
Help! Run time error 1004, range of object_global failed
Split data and copy surrounding data
Filling in missing data
Re: Getting number of files within a sub-folder and its size
Rate a post as an answer!
Hide "All" option in page fields in Pivot Excel
Shell function for opening windows explorer
Application.DefaultFilePath to open not just save
Recordset Searches
Need Help with Offset
Custom Number Formats
Macro - msgbox vs. enter result in a cell??/
format cells as "Text"
J West: Using Word capabilities in Excel and vv?
Check box
Code VBA 4.0
How do you name a new workbook in VBA
searching names for '*', replacing it with first name
Re: Bloomberg links
Convert Table Formats
Combine two data arks?
File Open Dialog Box
Edit Event from Macro
User Forums
Code to loop through multiple checkboxes
Copy and Paste specific data
Object Arrays
insert current date
RE: Bloomberg links
How to trigger a selection change between a cell and a shape
RE: Adding a Searchable Index
userform problem
arrayname as variable
Import Data From Access! Please Help!!
RE: Odd Tab behavior
Re: Text to columns
RE: Another basic problem
I need Help With Range Command
RE: Lookup or Match
Display Sheet Tabs in Two Rows
Looping through valid inputs (VBA)
setting numberformat for -ve numbers
Auto Refresh Time
Auto Refresh Time
Auto Refresh Time
how to use a IF(AND) formulae for more than seven conditions
Protecting VBA source code
Extracting/Exporting HTML Tables or PDF Tables into Excel
Page setup and formatting possiblities
ReDim Array
Cell Range Values with VBA
Dimention & manipulation of Variant array
MSGBOX not working
Complete list of Excel Command line switches/parameters
addin not running correctly
Alternative to FileSearch for Finding Directories
ComboBox only shows single value for horiz dynamic ranges
Runing Excel macros from a Bat file.
Date validation
Reference problem / advice
Looping and searching
Copy Value Of Last Cell
Setting chart size in macro
VBA Project Deleted
Setting chart size
RGB for cell interior
Userform TextBox TextAlign Problem-Bug?
Making macros loop
Wildcards in workbook name
Add a button to a macro
excel namespace import problem
Split a 2gb csv file into two files
Setting Excel Ready property
changing values in one column based on values in another?
switching between 2 arrays in one form
Using Macro
Sending Excel data to Access.
Refedit copy paste problem?
Finding specific data and moving it to a new sheet
Exchange rate function
Checking contents of arrays
PLEASE HELP! Copy sheet with password protected cells debug error
How to acess form elements values in the Workbook_newsheet event??
Delete Commandbutton?
toggle button text
Controlling user environment
Refedit copy paste problem?
Refedit copy paste problem?
Hide or Unhide certain columns based on a cell value
sharing and protecting incompatible?
Drop Down List
Reading Word TextBoxes and Transferring Contents to Excel
Help! Single cell owning > 1024 chars caused exception
Locking panes in macro
Getting the particular value on the basis of given criteria ?
Mass Creation of Named Ranges?
IF functions
Copy info to new sheet
Subform in excel or Frozen Panes (Top & Bottom)
Lotus Notes Doc link in Excel??
How to create a chart that it's datasource coming from a chartspre
Code to look at all sheets not just specified sheet ?
Recalculating Array Formulas
>> Listbox OldValue
Delete all sheets after sheet1, but not by sheet name
ifs
VBA Code to Group Rows Based on Cell Contents
open an external file
wanting to save HTML format in one sheet
Multiplying 2 cells based on the value of one of the cells and...
TransitionEffect
Prevent control taking focus when accelerator key is used?
Subaddress for a chart in Excel
VBA vs Functions
Counting Clicks
filtered pasting
Macro Help!!!
Programming using date
Run time error 424 Object required ?
filter date excel2000
Verify if sheet name still exist
VBA Code to Group Rows Based on Cell Contents
keeping a range a range object
Error Message
Lock and password protect only cells with formulas on all sheets in a workbook
Can this be done- Spin button attatched to message box?
need help on pasting link if certain cells blank
need help on pasting link if certain cells blank
Sort/Duplicate Help
Urgent Help! Ms Query
Prevent control taking focus when accelerator key is used?
Passing a range to a function
Get distinct rows from different worksheets into another worksheet
for i...next i over images in a sheet
Setting printing properties
automatic shape property settings
Method Add of object Sheet failed
COM interop XL2000 vs 2003
VBA: providing CustomerID for IP-Addresses in external logfile.txt
Help With Vba Code
Lock sheet tabs option in a specific workbook
How do I avoid copying data into blank cells
Vlookup in VBA will only find first match???
How to add one column to a range VBA
PrintToFile - PDF Issue
Finding if Excel Sheet exists
NEED HELP : In Macro
Inconsistant formatting of Userform Textbox and Spreadsheet storage format
Upper, Lower & Proper case
Userform load problem...please help!
Test if cell.validation is set
Method 'SeriesCollection' of object '_Chart'failed
monitoring range change
Get values from a closed workbook
Worksheet List, Dropdown List Excel 2000!
=SUMIF PROBLEM
copy method of worksheet class failed
Possible ? Search all closed workbooks in a folder
Macro log
activate VB code for any WS in a single WB
Path/file access error
Testing for Named Ranges
Retrieving Data from Excel Pivot tables into Datatable
Loading Multiple TextBoxes
OptionButton quandary
Search /Filter vertical Numeric pattern (down single column)
docking a custom toolbar
Click events not working when added during runtime
Add-In
Determining repeated cells between two workbooks
Character Locations in Strings
File number not available on entering in a module in an excel add-in
Cell Format Problem
export CSV file with semicolon
Minimize Maximize buttons
Prompt to calculate the date formula
Possible to create 300+ hyperlinks to run the same VBA code?
Depreciation Formula
Macro to rearrange/add columns based on column header?
Exporting and Importing Data into a preexisting Workbook
Open workbook macro- find correct month to open?
Change Microsoft Scheduler?
Replace blank cells with NONE
Minimize data (as a section) on a sheet
macro
VBA Excel PivotTable Drop Down Help
Macro hardcoding issue
addin not running correctly
Form Command Button Problem..
Run a macro when validation field is activated
UserForm TextBox validation and focus
Help on Add-in for switching between sheets
Include file
column headings for a list box from a recordset
I want a macro that will upload a number of excel files at once.
contains formula
Deleting Rows with Too Many of the Same Number
Difference among Module, SheetX, ThisWorkbook?
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell
loop macros until reach blank in adjacent column
Macro to automatically add amounts
Comments in CSV
Excel MSN Money Stock Quote plugin should return Dividend Info.
Alpha sort, but some cells sorted by phantom term?
ADD-IN will not appear in MENU BAR
Counting cells with Invalid Data
Prompt to say complete when macro hasd completed task
Page Setup from VBA prints half wide
Frustrating Problem with VBA Help in Office2003
Need Help with Deleting Duplicate rows
More Pivot Table Hullaballoo... text value grouping
Formating excel value to numeric or currency with interop
Editing Word Document within Excel
Copying text from comments to cells with line feed
Worksheets that refuse to go away
Open workbook properties on save.
Attendance database programming
Help with dropdown boxes and preset selections
error in code to format only a few sheets in workbook
Using Sheet names & Workbook names in VBA coding
Quirky Problem With Links & Excel Versions
reading pivot cache
Excel 4.0 Macro Help --> Excel 2003
easy (?) subtraction problem
Custom List to Define Sheet Tab Names
Insert macro name in code on call statement.
Benefits of using template in generated word document?
Is there a easy way (no macro) to switch between sheets?
read receipts from Outlook Mail
new window event
looping through items in a dictionary
run-time error '1004'
Automation Error using xlDialogSaveAs
How to define
sql stored procedure results in a recordset questions
Alan Beban's Column Vector Routine
vba code line number
Looping Range
sql.request question
open other excel application by vba
Using VBA to track workbook changes