Excel Programming [Archive] - Page 113

Lookup
Locked form: {End} key with arrows doesn't work as normal
No more new fonts can be applied Excel 2000
Referencing error
VB Project Protection
Cell address from Vlookup
Trying to find Item with in a sheet
Highlight a row without losing background colors
Properties transferring from excel cells to word file properties
Create a pivot table via VBA code
is there any way to avoid displaying alert pop-up in DSOFramer?
Hexidecimal Editting
Open workbook name size
keypress event on a userform
Print array based on menu choice
Printing automatically
Amending Cell formatting with VBA
Problems with .Refresh BackgroundQuery:=False
print area poser
Insert information to multiple similar files
editing the web query through a sub
printing issue
reading the hyperlink
Is filtered property?
RE: FileSystemObject help please.
how can I arrage file in folder into worksheet
Code
copy sheets of cell length is more than 255 char
Need code to copy from "code modules"
mscmctl2.ocx ... calendar and date picker sometimes not available
why the method "show" invalid?
I cannot close a workbook in vba, I think because it odlinked to
how to write macro that filters odd & even numbered data ?
Change the range of a pivot table data source
Test For Macro Security Settings Level
Applying names to ranges of cells for formulas
Calendar Control
Exporting EXCEL Graphs as .gif (image file) using VBA or VB
How to refresh the data in a Pivot Table?
open some txt files ,find text , copy the text before that to a single cell
What are 'cls' files? VB, I know, but how are they used??
UDF user assistance?
Delete all row data EXCEPT
Copy a single cell to a cell in a range
Determining the number of cells with data in a column
Autofill cell to right
Help with code that finds a sheet's name
counting filtered rows ...
Turning points
referencing months
Changing code that set's print area...to active sheet only
Date limited
ByRef Cancel in event module
copying data from one book to another
newbie question. abt cols and rows.
Opening *.txt by code with varible path
how to include special characters in a formula?
copy from unopened workbook
compare TIME in IF statement
test
VLOOKUP from another sheet VBA programming
more sample for illustrator
How to filter out multiple occuring partnumbers?
Formula VS Formula R1C1
Variable within the code
Referencing Libraries through code.
Focus In Modeless Form (spare me the grief)
How to create a toggle button on the menu?
Testing for an open file
filter with special forrmating
how to extend columns pass IV
combo drop down code problem?
Using part of an autofilter?
Copy rows and move on
More help on setting print headers via code
vlookup result
Wrap Text in Merged Cell
is there anyone that has successfully sent a page or a copied range using outlook express?
Software purchase advice
Creating Leading Periods
VBE (visual Basic Editor) variable
mortgage loan spreadsheet
Can a CommandBar Control Caption be Formatted ?
Save As
Global Macro
Trying to set Option button values in macro on protected sheets
Run macro based on cell condition
Setting printer header via code
making list, selecting empty cells
Logging Data Single Input
VBA Excel Solver ValueOf: Reference Problem
a fomula that tracks the highest level a stock reached
multiple file names in macros
Ability to filter comments in Excel
FIND method doesn't work in UDF. What's wrong with this code?
Protect Formatting
editing a dynamic array
Delete (Kill) Active Workbook
Bolding Row from VB6
read all the files after choosing a directory
Inputbox error? 10 divided by 100 equals 0.100000001490116 ???
Visual Basic and VBA Forum
Find troubles
Component not correctly registered
need help with togglebutton
send a outlook template message from excel
Macro based Import Data Inserts Cells, I want Replace
Triggering an excel menu using macros
Adv Filter Formula Criteria
Re: Filter name and copy to another sheet.
Send Userform results to worksheet
Printing in reverse order
macro to save as
nooby here:D
copying some cells
Movve data from rows to columns
refer to a userform in a formula
Export TXT from wksht selected in ComboBox
how do I...
Please help!!! Using code to password-protect and unprotect...
Searching the row that contains the same two columns
Searching the row that contains the same two columns
How to delete a row and the contained <forms> checkbox?
show all columns in a worksheet
How do I use a cell value as the filename in an external link?
Averaging Values from Sheets in Array
Sequential numbers
open another workbook in vb
If cell is checked, then list ondifferent worksheet
Text Box
Hyperlink Delete problem
Last cell in column (with hidden rows)
Excel/Outlook Inconsistent results
Re: Insert Date that Macro runs
Insert Date that Macro runs
Access query to specific cells
SQL syntax in VBA for Access
PERSONAL worksheet problems
Open Batch File For Processing
Dynamic Range for Data Validation
Select Cells in Print Area
Workesheet Calculate - strange behaviour and theoretical question...
Assign a macro to a command button
Identifying Unique Rows
DDE Question
How to aviod Toolbox Items move their position in Excel 2002?
sum if statement
help to change data in cells
Re: [beginner] create macro to insert symbol
Re: Paste works sometimes?
Excel Error
Re: Find & replace
Re: FileSystemObject help please.
Re: FileSystemObject help please.
why do I see this runtime error?
Re: Pausing macro for user Excel input
Re: How do I use CountIf formula to count a within a range of numbers
Re: [beginner] create macro to insert symbol
Re: Find & replace
Re: Pausing macro for user Excel input
Re: Pausing macro for user Excel input
How do I use CountIf formula to count a within a range of numbers
RFT conversion
Old macro breaks!
Taking range as input from the User
"method 'Copy' of object '_Worksheet' failed"
break link problem
Formulas are skipping a row
Exporting to CSV or Text files with variable ranges on a worksheet
Exporting to CSV or Text files with variable ranges on a worksheet
How to reshape data sets between long and short form as in stata?
Search for text, change font color
Currency changer
Type Mismatch when running query on SQL Database
Excel User Conference Update
Macros
Password Protect Indicators
what the problem?
Set buttons to own workbooks, but not to general workbooks.
Set buttons to own workbooks, but not to general workbooks.
SaveAs Issue - different approach
Report number
editing filename
Automatically send e-mail with Lotus Notes
Skipping Auto_Open
find and return fixed value
Cannot change SeriesCollection.Values! Why not?
Help Please
"Unable to get the Pivotfieldsd property of the Pivot Class"
Trig on drag and drop event?
counting number of entries for a date
How to control the UserForm's position?
Executing a macro in another spreadsheet?
Moving Cursor & Sheet back to the Original Location
Save excel file as another format file
Open file with open dialog box
Strange Worksheet Protection
Prevent Paste into a cell
updating a form for next use
doesnt become Hyperlink
Pivot Tables
Cells Program
Confused about ranges and arrays in worksheetfunction.* functions
I only want one checkbox to be allowed at a time
Arrow Keys disabled after Sheet Protection
how to use VB code to define vlookup in two workbook
Positioning
Copy range lead to lost data
mouse macro trouble
Need code to sum a series
Custom function valid in Data Validation/Conditional Format?
Tricky hour calculation (re overtime spreadsheet).
Copy filtered range
Change IP address with macro
reset me
URGENT!! Use macro button to hide empty columns and rows...HELP!!!!
Worksheet_Selection Change code will not allow cell contents to be copied and pasted onto the sheet it's running on
copying from one file pasting in another
unwanted copy
Putting Data & Time in file name
Buying Tips - I am all ears ...
referencing ranges using R1C1 format
referencing ranges using R1C1 format
Call Stack disabled
TextBox calculation
TextBox calculation
Filter name and copy to another sheet.
Filter name and copy to another sheet.
Help: runtime error "method seriescollection object_chart failed"
Setting file names
Help: weild checkbox problem
preference question
Retirement Savings Last
Run Time error 13
Save As "Cell A1"
Change VBE Project Password
Setting more parameters with Print area code
advancedfilter blowing up with runtime error 1004
Help with Excel ActiveX listbox controls
vlookup?? trying to get Excel to tell me a value
Deleting cell borders before file opening error occurs?
filename insertion in cells
When writing a macro in excel workbook, how do I refer to ea cell
Trying to reference ranges in another workbook using index in conjunction with match
Something about the scroll bar
Closing the Print Dialogue box
need some help with selecting a sheet in a loop again
Selective formula pasting
OnAction-property of cbbutton in VBE editor
collection usage/syntax please
Get Install directory for Excel
text conversion problem
is there a before_worksheet_deactive sub
work behind msgbox
Adding Button to Popup Control
Filesearch in Remotely Called Macro
List Box Selections
Looping problem
Saving Files
Re: xlstart .xla automatically opens when starting Excel 2003
VBA for saving a file to a specific location
Reverse the order?
Error when deleting sheets
Read Only
Making a list box of checkboxes
Find Function
Take action after entry in a textbox (or after tabbing out of/into it)
Workbook Change
xlstart .xla automatically opens when starting Excel 2003
Can't seem to get an answer to this problem.
Counting Conditional Formats
what am i doing wrong
Need help with "save as" macro
run a procedure in 1 wkbk from another wkbk
Filesearch 1004 error with XL 2003
Macro assistance
Macros from Add-in?
Exporting Excel Schedule to Outlook Calendar Subfolders
Format row from c6 to ?6
Break Chart Links
Opening a document without adding the path
Pain in the ass macro Part 2
Opening a document without adding the path
Sorting texts and numbers as if it was all numbers
line not accepted ?
Add hyperlink to body of email thru Excel
Formula ?
Shooting a Bullet character in Excel cell.
VBA for tab order/moving cursor to a certain cell
blank value for row and column in msgbox
Horrific news from London
changing result worksheet of macro
a little more secure login
Email from Excel; MS warning "program is trying to send mail on your behalf"
Update
Find firse cell.address that will prin on page 3
Random numbers not using randbetween()
Userforms submit button to clear after it enters data?
How do I retrieve the column names in a ADODB recordset from MS SQ
ADO SQL: Im getting CRAZY
Excel gets slower and slower....
SLOW CODE!!! . ........ help (maybe due to unsound BINDING)
Loops
Forecasting value of an used car in Excel
Starting Point of macro
Conditinal format of cells within a worksheet + woorkbook
Printing Recto/Verso
getting to the web link Excel 2003
Modify sub to swap text phrases in cells
How do i know how many rows has been selected?
Autoformat - customize?
International HTML Import Problem
How to write to a template txt file
Excel & Chr(133)
for each cell in range....direction problem
Populating a main and 'regional' sheets
Split a workbook into several using cell value for filenames
Creating workbook from a "template"
Insert Character in a String
how to increase size of diagram lines?
how to load chart in user form
Compilation error in Excel 97
Can Excel hide a row automatically based on value in a cell?
Closed Excel but Vba project remained
automated file loading and saving
Scope and Lifetime confusion.
VBE( Visual Basic Application)
emailing worksheet
Macro 2 Extract Data 2 Paste in New Wksht
Search Macros in closed file
Flagging duplicates
Need help with code for Excel Macro
Spreadsheet Programming
2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
string concatenate
Can't 'SaveAs' Directly to Network Folder
another chart question
Problems setting Application.DefaultFilePath
Weird clipboard behavior
GetOleDbSchemaTable: Exclude named ranges from Excel
Turning on/off the Hourglass pointer in Excel
copy and paste to another sheet based in cell color
Macro to save Macros
Excel XP SP3 and linked files prompt
NEXT LEVEL OF ScreenUpdating
erroneous "save changes?" message appears
Control Toolbox Controls keep resizing ??
form_unload problem
Exporting embedded OLE objects to file
Event macro firing twice
Update multiple locations when changing a value on one worksheet
Send Email from Macro VBA Excel
Send email from VBA
Pivot table
Delete Non-bolded lines only
Accessing controls in excel using vbscript
I need a text box and can't find one
searching for a better way to hide rows
Simple +formula not reading value from the reference cell
debug.print range "full" address
Excel VBA macros and real time data calculations
Paste Using CommandButton
Excel Error
Trying to search web via macro - possible??
Printing same table on reverse side of all pages
a new error message
How to display an open file?
Re: Incrementing times and dates
Macro Recorder
cant find a macro
Excel 2K3: Opening spreadsheet, also opens book1.xls?
How to use a subroutine stored in an add-in
printing a receipt for eack row
multiple cell conditional formatting
Extracting (copying) modules from one workbook to another.
Multiple Cell Conditional Formatting
help with chart
How to set excel column width from visual C++ using COM automation?
Weather data Sorting with formula
hard coded text
Progress Bar
Extract a hyperlink from cell value
Pain in the ass macro
Search for worksheet
Macro - Modular fill function
Changing Feild Color via value
Exclude cell from average calculation
set a column length
Assign a worksheet name to a variable
Data Manipulation
Keeping Textbox Values After Reopening Userform
Excel 2003 - Update or Don't Update Links Problem
Removing User name at Comment
Scheduling application based on Excel
Submerged text in a sheet
Cannot change part of a merged cell
Copy sheet without Code
Lotus Macro
vba help...ranges in new sheet etc
if numbers match then color row
SLN - Straight Line Depreciation
Best Technique to clone worksheet
Analysis Toolpak Translator - Anyone got it???
Analysis Toolpak Translator - anyone got it?
Please Help
Please Help
Please Help
Excel User Conference - US Location
Copy/paste from Excel to a password protected intranet application
Please help me
Advanced Sorting\VBA Code
forgot password
how to insert a chart in a userform?
forgot password
go
ListtBox
create a discount function in excel
Special cells format
Return to column A
open excel spreadsheet with password
vba excel help
Changing footer programmatically in multiple sheets all at once
error handler not working correctly
How to record macro for Solver in Excel?
Printing an entire workbook
How do I go to a specific column?
Multi-conditional sum with VBA code ??
Text selection macro problem
Help with Mr. Peterson's Code.. Print serially from a Sheet
Copy worksheet excluding defined name ranges
Office 2003 / UpDown Control
Code works for any WBK except the PMW
On Error Resume Next
Chart: Use range name for source data
program drop down menus
Automaion Addin not loading properly!!
How can one open a protected excel sheet whose password is lost?
Copy cell macro
Print data in footer using _BeforePrint
Worksheet_Change Errors
Passing variable to Access
email help please!!
Allow ONE checkbox selected in a group
out of range error for range value
++HELP ME PLEASE++ ComboBoxes as a Variable to Select Sheets
Validating Dates
Excel 97 error: 'Copy method of range class failed'
calculate commission $ based on total sold and commission percent
changing merged cells from code
Worksheets Exists Code...
Dynamically creating formatted tables from raw data
Array formula with AutoFilter
trouble "locking" a portion of a formula..
New Registration Key Generation
Use a macro to create new sheets
Find red cell in macro
Was Delete Key pressed?
Macro code to change tab name
Searching for a variable field
Option Explicit
List boxes
Making a combo box user freindly
Date Range problems
How do I set up a form that narrows a data set w/ each menu select
alert
block variable not set?
automatically copy values of worksheet into new workbook
setting ScrollArea problem
Help (cesar code)
Delete records from 1 list that are in another?
Find exact text?
battleship code
Printing problem with amalgamated cells
How use summation?
selecting a range
Excel CreateObject on server
help
count pages programmatically
exponential growth & Break-even
formatting & programming
Data source for Pivot Table
grouping
command button
Automating data import and separation
Printing differant rows
worksheet calculate - how to run it line by line?
Am I missing something???
What's wrong with this picture??
copying from one file paste in another
exponential increase
clear checkbox
Insert text into filename
Highlight if ?
ODBC/VBA?EXCEL and ORACLE database
Macro Language
User form error when opened
Using excel through vbscript
Date format
Combo Box ListFillRange causing save prompt
updating cells which containing formulae via odbc
Break-Even (or Payoff) with inflation factor
Calculating Non-Constant Values in Cells
More help with setting print area to last entry in columns A thru AA and last entry in row 7
Maximizing a workbook
Using a formula result to reference a row
Why doesn't this work ?
Data validation and application.volatile
Date formatting
publish one (and only one) html file?
Excel Macro mousePointer control
Choosing printer in a printing macro
Choosing printer in a printing macro
last cell plus one
HEEEEEEEELP
Demonstrating mouse clicks with Macro
Problem with List Validation
Path problem
sorting
Message box during data load
Bar of Pie chart - Need Bar creation
Re: Blinking Cell (Worksheet restarts)
Preserve Formating
Copy data from a worksheet
Worksheet_Change and Application.undo
Excel vba script extremely slow
Adding Username and Password facility
Check relative / absolute references
Software Expiration Code Sample
deleting characters
Access query does not work in Excel
Registration Key Sample Code
VBA for charting
VB code + Data Validation query
Running a macro outside of Excel
Copying cells from one sheet to another if document has been saved.
How to check for Bolded character is a text Box?
Select shape leading to Out of memory
private variable: same module, other Sub/Function
Problem with calling .dll from excel VBA
Comment Box Adjustment
How to depress confirmation dailog
exiting excel takes ages if any add-in loaded
Matching
Writing a Procedure to print non-contagious area on the smae page
Problem with playing sound code
need some help combining a variable
Non-blocking calls to Excel Macro using OLE Automation
Listbox Help
Access/Excel data to compare and sum conditionally
In Excel my autofilter? is omitting some data rows from output
Program vb to do something in case of an error.
Problem with File.Search
Changing ListFill in a shared WKB
Adding Time (hours and minutes)
Helo with excel marco
Changing data in footer in VBA
Sorting a single column
Circle Reference
Runtime Error between Terminals
not sure what functions/code to use?
need help with hpagebreak
On Save Procedure Conumrum
overflow-how big a file can Excel handle?
Help with macros
Programmer's Companion
Latitude/Longitude conversions in Excel - Please Help
Asking users to Enable Macro's
Locate and Move Specific Cells
displaying selection data from a listbox
ComboBox Problem
dataset to exel issue
Duplicate Lookup
MsgBox question
OLEDB Error on Excel Macro
prevent change sheet name
How to call a procedure when a cell value changes?
Using VBA to disable macros when opening files
Auto_Open/Workbook_Open subroutines showing SCREENUPDATING
How to compare two columns for a specified string?
Inexpecting slow execution when writing to .PageSetup.Leftfooter
Quit
UserForm/If Help
Efficiently Pausing VBA Execution.
"writing" to a range
Developing custom secure Excel add-ins
Error changing protected cell
Outlook Address Properties > Excel
Clearing references?
lookup functions?
automatically open a spreadsheet for the current day's entry
OnSheetChange or OnSheetCalculate Event Handler
Comparing date to string
Writing saveing date in cell when saveing.
Deleting copies of a spreadsheet
UDFs
Run a dos batch file as soon as I exit/save the spreadsheet
ideas - Query table refresh
Updateing worksheets when openening workbook
What are my variables ... ?
Re-run solver when some inputs change
Adding a Control programatically
Array error
how to calculate Standard deviation of product of numbers?
Simple column moving code needed
Find problem
Z-test using excel
This is easy for you people!
Can I assign a macro to each item in a drop-down list?
Using VBA to find the author of a workbook
Replace application.RTD property by Application.RTDServers collect
Chart Area
No Macros but Macro enabling message
It's not CommandBars("Cell"), right-click menu!
How to remain formating in Pivot Table?
VBAProject
hpagebreak and vpagebreak
Macro to insert formula result into range with zero values in cell
Keypress
Sound Alarm when time expires
Help: Excel 4 macro suddenly no longer working
Message Box
Deactivate Events not Firing
Storing the results of a list box
Searching for files that contain ???
surpress zero-values in specifi columns (not complete workbook/window)
listbox remove Item
Select case
Correct syntax for Active Worksheet
Fast Consolidation
Historical Stock Quotes - Yahoo Finance
Run-time error '13':Type mismatch
Opening files
Is it possible with my chart?
How to compare the contents of two rows is the same?
How do I add a number according to a specific condition ?
does code for this exist? help please
Larger Number
command button()_click
help needed with LOOPS please
MOVE Worksheet to another workbook ?
Bypass an
Populating a listbox from range xl2003
Re: Shade col. up to used cell
Openning a file using the password from VBA
source of good vba examples for newbie
Bypassing File Version Dialog on Save
MultiPage Component Property
Open File Dialog Box
Deleting all buttons in a collection
Help with Error Messages
how to check if range contains particular word
Custom Functions in Personal.XLS
networking
Insert date automatically
Re: Open File or Switch Between Windows if File is Open
Input Box Processing troubles
Re: Open File or Switch Between Windows if File is Open
.find with merged cell not working
Add new vaue to a different sheet
Change cell format based on condition.
vba to edit outlook contacts from cell entry
No duplicates from range to an array
How to make Hyperlink jump accordingly
Simple IF statement
How to prevent deleting certain rows
Macro to Change a Range
Create a dynamic chart with code
Data from web page
Workshoot Menu Bar Hijacked!!
Data from web site
Access to Office
Download .png
"Processing" Pop up box
VBA code disappeared when open workbook in other computer
Retrieving list of worksheets programmatically
Where is the Worksheet_Delete event?
break excel links
loop macro
Print in continous serials from a Sheet
REPEAT SOME ACTION IN MACRO
links question
send email in VBA
VBA Macro to copy an column from one Excel file into another file
Excel as a dabatase, please help
YAQ (Yet another question)
To find number of non-empty cells across columns
digitally signing excel doc
If/Then with Dates
Invalid property value.
UDF argument problem
Not Book.xlt
Macro to Count Rows
Saving Excel VBA code to Personal.xls
refering to a workbook name within vba
Compile Error: Strange happening
Sharing WBs with Macros
global function
Re: How do I seperate a alphabet and number in a cell-in Excel
finding the source location of a result
Using the ENTER key to move between form fields?
Array questions
Subroutine question and public variables
Changing Phone Number Formats
Re: Dynamic arrays and type mismatches
Copying worksheets to remainder of workbook
clearing unlocked fields on a protected sheet
Re: calculation on excel
EnableItemSelction on Page Field in 2003 VBA not working
Using a macro to remove a macro
Interesting Code
Can VBA be used to list macros
Setting Property Values of Text Boxes within Forms
Deleting sheets without confirmation
increment cell reference whilst reading numeric contents
Visual basic unlock "SORT" function in an EXCEL spreadsheet
Location of "My Documents"
Dynamic conditional formatting
when setting Imagelist for ImageCombot, Excel crash
Get the path to the directory that the active workbook is in
Automating Access / Excel with batch file
For Each statement
Worksheet_Change not throwed when adding a row
Re: Running the same macro to multiple workbooks
Opening linked spreadsheet file in Access
Arrggh! If help
click data point in chart and delete
Arrange and Tiled
Re: Database Connection
Re: Big Question?????
VBA Password forget
Web Queries
assign onkey to 1 worksheet
Transpose data
xlVisibleCellsOnly Help to copy only Visible Cells/Rows
SelectionChange event
VBA to rename sheet WITHIN Excel
VBA to hide a column and unhide it
Declare API call to Windows GetFile
Worksheet wide vars
Error Handling
Multiple checkboxes, one macro?
function to return days
Grab name of folder
input box
Image Controls
Re: VLookUp in Macro not compiling
Can anyone help? Please?
Interactive Chart/ "Method Cells of object '_global' failed"
Re: VLookUp in Macro not compiling
Re: scheduled hours total
Re: Screen Res change macro leaves me in VB Editor instead of work
executable to install macro into personal.xls
Removing Smart tags
why merge cells in a blank sheet are look as a new page?
OnAction?
ListFillRange not working
Adding to Multiple Column combo Box
Run time error '429'
Paste Special Values
Set a file's modified date?
Automatic Row insertion code
create new book and copy sheet into..
Shade col. up to used cell
Worksheet Exists? Invisible Worksheets?
Excel Macro or other script
loop through a certain group of worksheets only
info in Excel import into Access to combine multiple records then.
Autofill applying untwanted formats to protected sheet
Worksheet Dimensions
How do I copy cell values in VBA
Noncontiguous Cells or Ranges in a Formula?
VBA code for cursor movement without leaving scroll area
fixing code
Help with copy an array from one workbook to another
I don't want to use Send key
VBA to Concatenate Two Fields of an Array Element
Excel Goal Seek vs. Solver
Excel Making Me Nervous
Data Selection using Vlookup
ActiveX Progress bar initialization in Excel 2003 problem
differentiate between a visible and a hidden userform
2D array to recordset.
Formatting a cell
Coding ? pull information from one Workbook to another
Passing argument to Excel
Short question:Background picture in excel
Complex problem involving VBA in excel
Controlling Access with Excel VBA
Getting error unloading Userform??
CheckBox question
Marco from XP not working in 97
Macro for Graphing Current Sheet?
Formular1c1
Wait time before next command
Do I need a Macro?
export excel plots in to word using a macro
Run Macro after initial cell edit?
I can't insert a Command Button into my spreadsheet
autorow height
How do i find items selected in a list box ?
Next blank line
Visible rows copy to different worksheet
Screen Updating
Calculation of row count
Drawing lines to cells with VBA
Filling in Feilds via a macro
Disable event macro while Auto_open() run
Sheet Name help
msgbox as a progress indicator...
My Sort has Issues
How to delete worksheet with specific criteria
sumproduct error
Create and Rename workbook
MUST BE A SOLUTION OR WORKAROUND FOR THIS FLICKER
Major linking problem
Userform opening
Find and copy across multi-sheet work book
TO Bug or Not TO Bug? That is the question.
Calling sub routines
ComboBox in a Userforn to display a column...
SaveAs defaults...
Drawing lines to cells with VBA
Selecting multiple ranges using 'Cells' notation
Trap a checkbox click
save details to xml
Error 13
Loop/copy rows variable times to new sheet
ROUNDing on a MAC - conversion error
Excel and IE Active Workbook Problem
organizing sheet
Execute a CTRL+ALT+F9 command (Array Formulas)
Office Excel Add-in for SQL Server Analysis Services
FORMAT COMMENT TEXT WITH MACRO
Checking for all blank cells in a range orcolumn.
Checking iorAll blank cells in a column.
Multiple VBA IF/Then Statements
Comparing Two Cells on Two Different Worksheets
VLOOKUP/MACRO using dates for NXT WK
Make Function Public
SumIF and STDEVIF is there a such thing
Creating An Application Event Handler
excel2000 pivottable macro
Send e-mail automatically from excell
forms
Moving a file from one folder to another
Where is file which contains macro List ?
ClearContents does not work...
msoFileDialogSaveAs problem
Date not Saving As Expected
Autofilter criteria based on cell value
Adding a folder
creating sheets with names from cells
Trap New File name before saving
AUTOFILL with specific range
Able to access VB code on a protected workbook
inputbox loop
Best way to manipulate CSV files
define range name, use on VBA selected sheet
Select Folder - Simples Method
Select Folder - Simples Method
Returning custom errors from UDFs
Horizontal black line in VB editor
Macro to set the colomns width
Mehrere Variablen gleichzeitig erfassen
Type mismatch error problem when dealing with Strings
cell position
Easy Print macro needed
Not sure if this can be done in a macro
Managing Modules/Macros - More than one Module FOLDER?
Help with problems
Macro to translate values based upon data in another worksheet?
Re: =FORMULA(CELL(A1)) ?
Program execution prob
code to save the whole folder with a workbook
Save & Execution Problem
code to save the whole folder in which is the workbook
Read txt file for input error handler
running macro step by step different from normal run??
Range - > GIF
=FONCTION(CELLULE(A1)) ?
Check for missing invoice numbers
Macro assignment disappears
Pivot Table - Multiple Worksheets
macro to colour empty cells (cells not recognized as empty)
Copy 1-4 sheets to a new workbook
Linking code to a cell
subroutine to get all of the Named range properties
macro to delete a closed workbook
How To enable the Sort function for a protected Excel sheet
FIND in only one column
How can I identify what cell was clicked on when I click on a butt
Problem in Excel 2002 vs Excel 97
Refer to Ranges using Cells notation
append data to other workbook
Open files
VBA code to itemize range names and associations?
Macro Listing Question
Catching "no cells were found"
Excel Paste Special Link
Looping down a Range to delete entire row
Reading dbf files
Validate social security numebrs
Before RightClick event change
How do I copy an entire worksheet to another instance of excel?
DisplayAlerts (Which Ones?)
Boomarks
quick lil macro
develop a macro to perform calculations and plot graphs based on .
If statement to stop macro
Accessing file properties
SendMail Function in Excel 2003 not working properly
Cell Activate Event
refering to cell data within a macro
Export two overlapping charts to .gif
Collating data from one worksheet to another
Importing/Exporting Blocks of Data
File Save As Using Macro
Interior color based on dates
delete button is grayed out
Writing to a text file
Imported data... the incredible growing/shrinking spreadsheet
Newbie-need menu of names
how do I hard code a variable range for a pivot table in vba?
Run Once Only
Send Email Based on Spreadsheet Criteria
create macro - allow user to scroll down drop down items w/ mouse
Manipulating chartobject while workbook is shared.
Addins causing problems
worktime function
Picture Painting
Macro Exit or Link
Automatic running of Macro for the whole spreadsheet
Array formula and date value
Two problems. HELP
Getsetting and Savesettings
Make a macro run automatically in Excel 03???
Subtotals
Redundant Subtotal Level
'On Error' question
counting folders
Hyperlink HyperTension
can I use GO TO results in a formula?
Can't compile, module empty?
VBA Sum....
Paste Method
VBA Sum?
Accessing Windows clipboard during runtime
Complicated VBA Conditional Formatting
Type Mismatch
macro to save as
For Each - loop doesn't work.
looping thru the worksheet
Change ABC$DEF into two lines in same cell ABC <nl> DEF
Search Cells
Sub Worksheet_Change(ByVal Target As Excel.Range) Questions
Removing concatenates for VBA calculs
Clear contents of unprotected cells in entire workbook with a macr
opening a folder then creating links
writing macro
Send cmd to com1 record result to new cell
Search & Replace Formatting for part of cell
open last modified worksheet
dropping whole numbers
Code for conditional formula
Borders Object
Accessing multiple workbooks through a macro
putting formula in cel gives #NAME error
AutoFill doesn't work when used in Excel com object!
Result from a combo box
VBA Macros that don't steal focus?
Change data range in charts
Save OL Attachments Programatically
Inserting rows in protected sheet
Count
Date Question, not sure which forum
Code to hide and unhide columns, with certain condition?
List to manage employee code
Re: Blinking Cell (Worksheet restarts)
Sort Feature.
VBA Macros that don't steal focus?
How to display all levels in a multilevel dimension when report is refreshed
Query
automate copy and paste whole workbook to new workbook
Finding and Selecting Specific Ranges
automatically insert row
Product of "time" and money
Links a cell to code
Worksheet_Change(ByVal Target As Excel.Range)
toolbars
how can i make an excel calculation engine?
Excel Function Bar
Compound File
active cell
2005 Excel User Conference
active printer
Lost Toolbar
formatting numbers
Hide And Un-hide Excel Toolbars
Getting number of value changes in column with count of each durat
Sales with quarter and annual totals