Excel Programming [Archive] - Page 108

VBA Code works in Excel 2003 but won't work in Excel 2000
** 60 GIG Photo iPod, Why Pay for it? When u can get it FREE! 100%Legally! ** Super Easy Proof inside!
Doh!!
Transparent picture background
How do I exclude zero's from an average of five non-adjacent cells
Custom menus in chart sheets
Flashing Cells
Prevent "XYZ.doc is locked for editing" message
Protect Help!
Baby steps
SUMIF
Select a string without knowing position
protecting formulas with named ranges
Multiplication problem
Still working and still so much to learn
Retrieve individual cells from a range changed between a range
Workbook_BeforeClose event and OnTime method
copy file to other
For... Next
select last 3 rows of variable length coloumn in excel 2003?
Date to Text
Automatically duplicating and updating info
Still adding to Complex Macro...1 step at a time.
Digits in textbox's
select copy rows where a cell contains a known
Menue
Lines in cell?
retrieval of data from web to excel
Retrieval of details in excel sheet
Sending Email From Excel Help!
Clearing of textboxes
Delete blank rows
pivot table
For Each x in Range
Definite mind-twister for an Excel MVP
assistance with code completion
Modify the last active row
RTrim as a variable
Code logic error
AutoSum macro that doesn't include headings
Find Duplicate Entries by Column
Make a cell value include number formats
Enter date in column L if value is entered in column B
importing external data
linked workbook issue
e-mailing a single worksheet of a multiple worksheet (4) workbook
Radio Buttons
Last time modified timestamp
Remove Blank Cells in a Selection
Consolidate ...problem
Selection.Sort error
character changed event
How do I copy a new module to 200 workbooks with a macro?
edit macro to mathc entire cell contents
Cursor cell in colour
VBA - Base 34 Conversion
Cannot see info from other computer
Copy formating from above row if value is entered
Row ID generation
Split function problems
Enter timestamp when column is modified
How to reset macro to run again after error ?
Prevent Sheet Deletion
Select the same cell in different sheets in the same workbook?
sub or fuction not defined
Group Method failed in macro
Problem with Hidden Worksheet
help me write this table retaining table spacing and formatting
File Exists
Merge Data into a excel spredshee
Rearranging data in a text cell
How do i read Selection.Shapes.Range(Array(i)?
excel autocalculate result in status bar
Matching and copying problem
How to seperate lastname and firstname?
Error when opening recordset of SQL Server via ADO
Copy macros to another PC
How to avoid saving over an excisting Workbook.?.?
Little more advice on this code
End and Sort methods adding blanks
How to write a function or macro to copy
Deselecting sheets after the PrintOut method
Type Mismatch now, not before
Code help
3 cases scenario questionnaire
Why "object doesn't suppor this property or method"?
Call recorded macro from VBA code
Security setting on Low, but Macro will not run?
Name a worksheet using a cell
Copy Cell Simplification
What is msoCanvas?
Macro to save Excel file
Problems with VB 6.0
Freezing the top line of a sheet with visual basic
personal.xls
Calcualte APRs for ARMs and Balloon payment mortgages
Add item to listbox, but only if it is not already there.
Calling Programs in other sheets
Need Help with Script
Protecting a worksheet but still allowing Outlining/Grouping?
Macro function needed for varied searches using a data filter
Adding to a Collection
Cancel QueryTables.Refresh Process After 10 Seconds
vertical axis
Excel throws exception if cell being edited
Printing from Multiple Worksheets
Creating a Macro
Radio Button Nightmare
VB 6.0 Problem
PLEASE PLEASE HELP Application.Screenupdating
move to a new book
How to write a function or macro to copy
Still working on complex code
Macro to save a snapshot of data?
"Loop until" syntax question
Text quantity in Excel form
Capture te first n digits of a range
Count every 5 row that contains text or data
How to prevent hyperlinks?
MultiPage Form data not displaying when Value property changed
If then several times
Dynamic Hyperlink
Sort a row of strings, some containing blanks
Find Links
Macro or formula to copy data based on criteria
Changing a range in a formula with VB.
Running a macro in a open as read-o Workbook
Query Refresh capturing rows returned to display progress
Open specific version of Excel
Running a macro in a open as read-o Workbook
MsgBox in new instance of Excel?
Sorting changes totals!?!?
Running a macro in a open as read-o Workbook
Listbox query
Find Files
Data Validation Programming
Change linkedcell color for a minute only when value changes
Formula to find text on a page and return that cells name.
X button query
datepicker on 1904 date spreadsheet
Generate table of combinations
Why doesn't this recursive function return the right value?
Problem using arrays in Excel Charts from VBA
help with a "drop down" in a macro
Scroll through Userform1 Records
"As of" & "July 31, 2005"
Format excel to revised date automatically when revised
Trouble getting Unique Dates from Range
changing numbers
Run-time error '9' ---- Code to fix included.
How can I assign a varable to equal an array? (it allready has a name)
What is the name of this function...
How to compile the macro
Invoking New Workbook in Excel Task Pane
Password protected project
HELP!! can't write necessary macro...
Clearing the clipboard
Can't run codes linked with Userform
Disabling the red X on the top right of a form.
Printrange function help?
muliple users - issue unique session number
Calculations
Group Action of CheckBox Control in Excel 2000
Possible to hide column headers???
Display Chinese in Excel VBE for English Version Office 2003
How to execute a macro automatically at startup of Excel?
How do I run Spanish macros in an English version?
Application close problem
Input for TextBox having a mask for date or $ amount
Using named range in vlookup
More Listbox help..
Pass public variable from one userform to a second...
Selecting rows
Copying EVERYTHING from one workbook to another
The Defined Name of An Active Cell
Need Help on Formula For Printing
disabling a cell in excel
Remove and Import Module
Open all files in folder automatically using VBA
question to Ron
Print Area
Password protect only a single module?
Copy outside Clipboard contents (html page) to a cell in Excel
Open file based on yesterday's date
Email question Please.
Re: move a special character
variable question
How to import a .csv file?
Programmatically Disabling Excel Toolbars for one session only?
How do I use quotes in an IF statement?
How to remove hyperlink from a cell using VBA code
Need a formula that will calculate a cell of text.
Re: Macro for copying value
SetSourceData Source = pivot table on same sheet
userform and spreadsheet formulas
Trouble with RANDBETWEEN
Re: move a special character
2 Part question involving SaveAs and Auto Save when quit.
How do I find all named ranges in VB.NET?
RE: move a special character
Macro for copying value
Or Like
spreadsheet with multiple worksheets?
Rici
"Insert" Macro
how can hide and show columns using macro?
"cut" textstring
Mousedown / Charting
setting range().hidden=True causes range error 1004
How to enter a formula ?
Macro that unprotects worksheets, transfers data, then reprotects
Version issues
changing a section of text
how to select first blank row?
filter by more than 2 criteria
File saved as cell entry macro
Trigger macro with keypress event??
Combobox question
Concatenate Function/converting military time to AM/PM
I am getting a error with XmlDataQuery
Directing a Save As in VBA
multiselect listbox backcolor
Convert files from one program to another
Copy Data from one workbook to another one
Inputbox - Select ranges
Modify a excel link
Protection
Button to call a user form?
Detecting when a user deletes a row
Concatenate/Text Functions
How do I enter words in the margin
Error in Code - Pasting Values
How to calculate next WORKDAY?
Find, highlight, mark, cut and paste macro
SaveAs Read Only
Change the color of a cell based on a calculated value
Code Will Not Run
Printing Single Page
Copying the cell contents(a math function) that calculates a numbe
Undo a Union
How to disable the scrolling in worksheet
Public Variables
Problem deleting vba module using vba code
Copy data from workbooks
working with the correct worksheet
What object should I use?
page numbers in a workbook
Reference : Lotus Notes Automation Classes
how i print excel background
How do i get the print dialog box to appear in a macro? Help!!!
dropdown list...where did it go?!
vba problem lookup in a matrix
Delete then Concatenate
Can someone help me with this slow code
Worksheet rounding vs VBA rounding
won't select cell on another sheet
copying values in a range
Select method of range class failed, Run time error 1004
Please Help!!! How Do I Specify A particualr work book to execute code on
Remove all rows with bold text
Re: Find the Saturday
Filter
Using a macro to delete last 4 rows and last 2 columns which vary
How to get datapoint number?
Toggle Button
calculated item not allowed in pivot
ID Validation using macros in excel
filldown macro
Massive Array needed....in code
Copy ata from several workbooks and paste into new work book
ActiveWorkbook.SaveAs - dealing with file already exists
Dynamic userform. Problem with format, events and returning values
select cell at random and delete contents
Picture Import Questions - Size and Placement
need help
conditional formatting total
Input box query
Excel Macro to change row and font color based on column value
Go to the next blank row in a column (xlDown)
namespace.pickfolder
How to resize Excel displayable area display entire ChartArea
COUNTIF
unique id for excel cell/range objects
Help With Code - Array and Range
Whole Fraction
formula for different cell contents
Simple multi-password access
sql criteria change
Casting in an Excel ADO SQL Command
Data series
A COPY macro
XML Spreadsheet - and using VBA / VB Script
How to keep ONKey's macro on Worksheet Selection Change Event
VBA to remove hyperlink?
Countif in VB Script
Collection Problems
Help Formula changes itself
Complie error: can't find project or library
Change in cell from formula to auto run a macro
conditional formatting based on values of another cell
Code ran, now it doesn't
Close button greyed-out???
proceed to the next column
Search if a cell range contains a particular value
Compare same Column in 2 Workbooks
Workbooks.add([Template]) Crashing Excel
Savings Each Sheet as a Separate File
Dealing with Worksheet Names
Object doesn't support this method
Using automatically entered code
Similar vs. Exact comparison
Date Function problem
strange loop problem
Paste values in VB
Goldmine
Special characters in shortcut menus
set header font size using a variable?
Formula in 1 Cell to put information into other cells
xl environment not fully functional
Date Problem
Vacation Spreadsheet- formula not working.
Creating Pivot Tables
Match / find a value
Column size will shrink every time when pivot tables are added into sheets
Option button object proeprties or object not found in vba
find and select all cells with a alphabetic character
Code to Refresh Pivot Table
Formula question?
Error Handling
personal.xls
FormulaR1C1 - 16/02/1871
automatic insert date when clicking cel
set excel zoom in 80
Errors when embedded in a browser.
Open Workbook in separate window
Menu Bars
Menu Bars
How do i do segmentation analysis in excel ?
Change Color of Text when Text Changes
Conflict with "Right" / "Left" Command
find and select cells with a given value
Array formula to text
not urgent
Autopaste data based on correct MO.
Workbooks.OpenText dropping last char from input
Sheet unprotect event
Store UDF and use it on other machines not in network
Automatic replacing a file while in a macro
Validation List Question
worksheet functions change to values? Formula are text?
Copy multiple formulas to used range
Selecting data for certain conditions.
Specific Date Query with Pivot Table
A Crosshair to Highlight the Entire Row/Column Prior to active cel
OnKey query
addfields method error
autoshapes
Excel and SQL help
setting excel visually
ListBox
Test to see if a server is mapped
DSN error
Help with Simple Function
How to delete the even rows?
Help with quiting a workbook
Formatting Data Columns of various length with Macros
linked cell
maximum of rows in custom list
Do until button clicked
Grabbing Data from another File
Setting a range when value is given
where on earth is the macro?
specific cell
Listbox Alignment Help
Visible PivotItems matching criteria
How to create insert statements?
Is there a way to find out which cell has been altered?
User-changeable paths into Excel - avoid hard coding
Excel Automation/Using xla file
Sendmail not working when computer is locked
what is an OLE action
Macro for coping cells from one worksheet to another
Drop down in local Gujarati fonts
VBA to unhide columns
Bug in Excel handling VBA/VBScript installation of Add-Ins
"currentcell.value" not working when numeric?
populate a spreadsheet from SQL Server
how do I do a check on the data enter in the cell?
calc mode question
Autocad vba programme runs with Excel 97 but not with Excel 2000
Re: Storing TextBox info in cells, then retrieving on next load-up
Macro to Create Table
Getting weekday for a date
Storing TextBox info in cells, then retrieving on next load-up
Creating a new worksheet?
Pickfolder Method with Userform
turning selection into a range
Entry in One Cell Updates Another
Need a copy macro
Deleting Pictures
Cell update to run macro
Deleting sheets
Worksheet_FollowHyperlink
Help importing data from a closed workbook
Calculate Time
Re: Validate InputBox entry
Need sample code
Running SQL queries for Access using Excel VBA
How to Create Control Array at VBA Excel
Control array problem
Help! Limit on number of Ranges you can use at one time?
Curious IsNull test
select dynamic range with dynamic start point
Last row plus one
Vlookup error
Countif
Worksheet_calculate()
How working with Access Databases through Excel 2003 Standar Editi
Multiple Tabs - Data combine
Keeping The Focus From Changing. How?
Setting OnAction Property Fails
RefreshAll / Protect Help Required
Add-Ins
find and copy cells to different workbook
Email error Object dosen't support this property or method
Reconciliation
Help with populating cells using formulas or macros
CurDir in excel 2003
Open workbook in user-defined folder
Check Box to call Macro
Links
removing certain text from a string
References to multiple sheets
Import pictures from the web
assigning formula to a target column
Automatically Email Excel File
Replace .txt file
Selecting a dynamic range
WebQuery to Array?
Keep y-axis aligned
Date Calculation Problem
Form - Text Box Focus
Time Calculation
return random letters - an example
using WScript.CreateObject("Wscript.Shell
XML Data
CREATING E-MAIL ATTACHMENT WITH 'BeforeSave Events' IN CODE
Browser window
Error 1004- In a PC with softwares in German there is no Error
Using COM to Create an Excel Spreadsheet from ColdFusion
How to select a range based on values in 1 column
copy value from unopened workbook
Workbook_SheetCalculate looping
Viewing only the #’s
Inserting excel into an access
Import data from the middle of a text file
copy cell above - use with subtotals
COM Addin for Excel: Despite referencing the Excel Object Library no objects availabl
Code fails if ran more than once
Excel Forms
Problem in Excel RTD and Manual Recalculation
make macro run quietly
Activate fails when someone else is in the sheet
VBA: how to... cell properties has to change based on a condition
Speeding Up Code
Editing code to insert two rows
Loop and find less than...
Hiding worksheets
create a mdb databse and a table and add records from Excel VBA
I want to enter a name then have EXCEL search a worksheet for add.
PivotTable converted from Excel 97 to 2003
Newbie VB month/date help
Spaces in VBA
Macro to VB
output macro
Install ThisWorkbook and Module1 files with batch script
Existing file ?
How to lock the clipboard
Delete Row
insert name of sheets into a column A
insert the name of sheets inti a column A
re : Finding the datas and deleting datas which are not found.
Formatting Data Columns of various length with Macros
End Of Records
Hyperlink probelm
Save file queries
Find duplicate string
Quotation Marks
Find Text within Text String
Find criteria and return name with VB
vba problem with isnumeric
worksheet double face
Moving data from form to spreadsheet + VBA advice
Create Excel PivotTable that uses Access query as external data so
Deleting Rows using VBA
Find Out Logged in User
scenario manager programming question
Exiting a procedure with a userform
Replacing subtotal with a formula
Messages at end of file
conceptual question
CommandBarControl ID
Addressing specific textboxes on a form
Formulas
Designated a cell as a name range
Cancel a Procedure through a Userform
can i have excel go to a new row after a set time?
How to reference code located in an Add-in File
Inserting a blank row when data changes
How Do I do This?
Retrieving Web POST data
Macro
convert an excel prn output file from dos to unix?
Series of check boxes
How do I return location (not value)of an Excel array's max value
1 touch printing macro
Ignore Other Applications" setting
Coping Rows based on specific criteria to designated pages.
Group Worksheets
Run-time error 1004 with sort
Building an array of worksheets for printing
Event Triggers
Hide one sheet tab
UserForm unloaded still visible
Inserting a Code
cut and pasting a row in another workbook on the next available l.
RE: Inserting a Code
Task Bar Message usage
RE: Run-time error 1004 with sort
RE: Inserting a Code
RE: Inserting a Code
Open CSV
msgbox
print vb .. set page breaks
RE: UserForm unloaded still visible
Changing XValues and Values in a chart
Use of SaveAsUI
Can I switch back to Excel sheet while a form is shown?
How to make listbox show the last item being added?
Help with - J.Walkenbachs code
This weeks Monday
Return the row number of a cell relative to a range
FaceId's
time cards
Advice on method
Date in Combi Box
Save Excel file without Macrs!!
Removing Add-ins programmatically from Excel 2003 using VBScript
Ref Edit
Macro - for Print Screen
number of copies in a print dialog box
Reposting to get your kind attention
Excel Macro Distribution
variable in a formula
Roller del mouse su editor VBA
MSCOMM returning garbage as input
How to merge all selected areas into one area
Paste Special Transpose
Trim Difficulties
Run Macro on close
Offset
Create a Temp Toolbar
Macro is weird!
index function in vba
Filters and dynamic ranges
How to... with macro?
On click question?
synonyms
Navigate Sheets - better way.
copy and paste error
VBA to place sheet name in cell
Get number of different values in a column
Exporting to Excel
Tool Bar
visual basic command to special paste a row of formulas into value
RE: FREE Indian oil for men!
hyperlink and email problem
Compare master list and update
Can't 'tick' box on fom with Sendkeys {SPACEBAR}
LastRow function - #VALUE
Run macro in one open workbook only
borders
Save Excel file into PDF file............
Entering dates in vba inputbox as ddmmyy. Excel returns mmddyy
Inserting Variable Number of Rows
Need some fancy graphics
Diff. in manual entry and list selection
Common Formulas in VBA
make 1234 -> 012034
Write Data from Sheet1 to sheet2 Until
Slow down SendKeys macro
AutoFilter returning All Rows
Pivot Table - Rounding the numbers in the Data Area
Stopping Autofill at alst line of file
NFL schedule, pivot tables, and validation...
look up and append result to row for multiple identical entries
Selecting
names on col 1
select contents of cell
Save Message
macro on Sheet activation
Option Button visible after a time delay
Digital Certificates
Dynamic FormulaR1C1 value
Pivot tables
Viewer message during Macro run
URGENT- Random Sample per range of data
Modify code in UDF
Help Linking Cell Formatting
User defined function to count pay days in current month.
input box
Importing Stock Data
InsertLines crashes Excel
SUMIF which work's with multiple sheets
InsertLines crashes Excel
Trapping error with dynamic range
Merge simple macros to create Complex macro
Error if text not found
Sort method using C++ automation
paste negative time with PasteSpecial
Help with Sheet Name Please
How do I resize calendar?
Range Named
XML Sort Question
currency rates
Returning to last cell in a do until loop
External Data - Field Names Changed
graphics legends move around even when locked via properties
converting formulas into values using a macro in visual basic edit
inserting a worksheet using visual basic
visual basic command identify a worksheet in a workbook
How to return multiple cells?
Edit Boxes
Date format and concatenation
selecting rows of data
A Challenge
VBA Code Efficiency Question
Cut and Copy
Achive and read Database
Security message when getting a .CSV file from Internet
Loop through, open, and modify all workbooks in file
Form Creation
Macro to edit time on worksheet
Dates
Copy files
hiding rows with a macro
Line breaks in MsgBox concatenated variables
Available functions within Excel VBA
What's the corrent event?
Macro to increase cell number by 1 at a time
Adding current selection
Total varying no of columns
How do get the internet connection wizard for Excel?
Combobox with 2 fonts?
Form Initialized
Determine excel language
sort button,macro, or ?
transfering data from 2 wbook
Function with VSTO ?
deciphering html: listbox
Transfer selected rows to sheet
Adding new rows with borders
ADO Update Help!
Saving info on form
Cannot lock project
Change Font Characteristic
Workbook_SheetChange not working
FileSearch Problems
Hide Personal Macro in VBA Project Explorer
VCRTDserver memory leak problem
Track Sheet Name Changes... Help!
Copy a row from one sheet to another and not all columns copy
Developing in 2000 for 2002 application; problems?
LEFT JOIN sql query
protect cells
Selecting from a Validation Drop Down Box aborts macro
Insert new row above and copy Formatting
turning on/off cursor movement during VBA execution
How to Draw an Arc which is 1/4 of a circle?
matrix arithmetic using arrays in vba
Complex focus problem
writting excel formulas in english in spanish version of office.
copying a chart and/or bookmarking a chart
Possible to Add Horizontal Line to Embedded Graph via VBA?
get name of sheets
Sub Concatenate runtime errors
If any cell in named range = 8 then shade named range
Copy if true
What event to detect click on UserForm ListBox?
Hide UserForm with Keyboard?
Formula to vba if possible please
Use custom VBA functions in cell formulas?
Syntax problem
using VBA to get away from circular reference
Hide row if cell is empty
excel
Match
Problem setting RGB Values with ShapeRange
Looking up named ranges as an array
Differebnce betwen VB and VB,.net
how do I search a pattern color & string in excel
Cursor auto move from one cell to another
Adding buttons while looping through files Question
Run or Call
I need a macro that will reset cells to zero
Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo
Fast way to clear Listbox selection
Combobox to range
XSD Maps and worksheets
Solve Order of a CalculatedField in a Pivot Table
Make Variable Cell that is Blank?
Worksheet visible in an addin ?
copy if true
Cross Tables
using CLOSE and NOTHING
VBA Find Issue
Why doesMacro speeds up when I hit ESC?
object movement
Not Urgent
Need help determining formula
Help with Transposing Macro
Last user to make a change
Tranposing Columns to Rows for Thousand Records
Automatic Range Naming using Advanced Filter?
RE: Creating sub menu in Command bar
cell contents
Userforms
Does File Exist
problem calculate
Are all properties of controls on ctrl toolbox toolbar accessable?
vba problem dialogue box and cell in sheet
Opening a list of workbooks
If Statement with multiple qualifiers
Function program
xla programming
Toggling background colors
How to Edit Cell Text
Problem getting solver to work in macro
selecting charts for printing
Determining A Cell If it contain A string value
Multiple fonts in one cell
Help in generating Permuation&Sequencing list from two arrays
CheckBox Query
Date in Cell sent to Access Query
Cell size limit?
Outlook task from xls or vice versa
Printing Anomaly
Option button group name
Variable as name of object does not work - Why?
VBA - Entries Into Properties
Database look up
Determine number of lines of text within a cell
Finding all AutoShapes in workbook
TAB and focus moving from unprotected cell in protected sheet til dropdown.
Columnwiths for a dropdown on a sheet
Outlook email url in body
Elliptic Integrals
1004 error
Referencing a com addin from a .net application via ole automation
Not able to run my application twice!
add target
Linked sheets problem!!
Sorting a Range using VBA
calculate difference in time spanning a day, during office hours o
Is there are 'sendkey' statement to activate the spacebar?
How do I sum multiple columns counting including blanks and dates
VBA ComboBox Highlighting
Unicode Help
How to create excel add-ins
value of any cell in row 1 = 8 then colour the whole row
Calling macro on cell change
Re: Duplicate remover
Cell reference?
search and replace question
copy events... help...
Duplicate remover
Activate ChartObjects on protected sheet??
Copy method crashed Excel somtimes
Inserting and copy from a word object in Excel
How do i keep the names of the colums on each new page
Concatenating 2 Character to form name Variable
Sum on Dynamic Data Range - Macro
Find a value
Need Function
supress screen refresh when macros running in excel VB
re : Possible to run private sub macros by writing another private
help with stupid (simple) error
Workbooks.OpenText StartRow:=2 Not Skipping Row 1
Date Format
How to Round up to nearest whole number at a specific decimal?
Sharing File on server
Linking
Subtotals in a range that could vary in size
How to find first blank row to paste to?
Using OR to evaluate TEXT
Referencing Object Names with Variable
if statements with AND or OR condition criteria
How do I write an Excel Macro to run Solver repeatedly?
Using the Find method with formulas
Creating Macros to work with ranges of varying sizes
red row
Data Validation Problem - In cell drop down
Problem with Workbook_BeforeSave event
5th-odr poly coefficients automatically displayed in excel cells?
difficulty with conversion program
designing a form that will update each month
EXCEL Opening Multiple Text Files
transfering data value from 2 Wbook...
Selecting amounts to display based on quantity
email worksheet as rich text
Brake a loop - once more.
Help in using an Offset in a .Range().Select
Converting column data to row data macro
macro to open latest file
File Browse Function (Open dialog box for choosing file)
posting 20050825
Function using XMLDataQuery in Excel: Not refreshing automatically on worksheet
Scroll to the right or left
trying to delete selected range with macro
Re: Error 1004 when programming DataLabels.Position
Error 2147352567 (80020009) Could not proxy for user
Construct Coluns via VBA
show filter criteria
Too many decimal places
Hiding A TextBox On A UserForm Under A CommandButton
If Cell Contents Don't Match, Move All Data Down One Row
Number variable loses format on write
Search range add value
Graphic objects and Add-In problems
Function help text
Add Row after a Specific Cell
DataType Property
Number formatting when importing to Excel from Access
How NOT to get the date
Determining End User Actions
How to reference a SWS subfolder in Excel VBA
set windows
Autofilter by unique values
change colour of disabled textbox text
Help, Copy Cell, using VB
Programming header/footer strings with line feed
Import From with macro
Adding Times
hyperlinks
making column's head in different collar during filtering
Ok I have to be difficult
Excel Cell.Replace question
CommonDialog control issue
Opening Zipped files directly from Excel
Animated .gif
Keystrock in VB
C-function in Excel through VBA : how ?
generating report from excel, trouble with bookmark..
Message Boxes and Hyperlinks
Custom format text
Select Method from Combo Box
Parameter query with total
Function query
mimic goalseek
Do Loop
Can't enter breakmode at this time
building new workbook from sheets in different workbooks
Unique Values in a Column
Need help for sure
Dynamically Resize Columns?
Selection.AutoFilter Field:=1
How do I set up an if statement to move to next column each time
Excel
Updating graph
Can't stop Excel re-calculating on opening - hmmm...
date
Autoload a book of macros ?
Iwould like to change Excel 97 to Excel 2000 for Windows ME?
Assign macro to right click menu ?
Brake in a loop
VLOOKUP with LARGE
Error 438
auto closing a work book
Error Handling
Please Help!
Weird Macro Problem
Evaluating an expression...
loop and findnext
Range selection
CopyFace issue in XL 2002
Dynamic commandbar button problem
Error Alert
formula for named cell/range based on cell values
Failed userform loading and cause application crash
Counting selected option buttons in column?
finding matching cells in worksheets
copying values in range
Method Range of object '_Global' failed
custom formating text
flexible file search & opening
Charts and Addins
Extract Double from a Textfield Cell
TextBox Macro - Is there an easier way ?
Referring to named ranges
Grouping several macros into one scrollable menu
Updating Links on Open
Macros To Update Charts
Conditional formating
Convert 1 row of data to columns
Pivot table to launch Macro
Searching for a specific cell using a variable.
Select all cell with the same format
Deleting Rows using a range in Column A
separate each sort order ?
International Language Functions
Smart VLookup...
Function Program
Help needed with Macro
Slider control limitations
Before print, cancel print and cancel copy/paste
programmatically change pivot table rows/columns
copy data if data exists
Excel Sort Problems
Re: Help with Saving ComboBox information
Help with Saving ComboBox information
posting 20050824
Printing Help!
what is a BI-query in excel?
Controling 1 Office program from aother
Copying other column values when detected
hi how r u
Return Address of Blank Cells in MsgBox
Macro slows down on subsequent runs
How can I dynamically change the range for Range("A1:M500")?
running a macro on a different operating system
Run-time error '1004' on Range.Activate
How to stop sequential numbering
Pivot Field Event?
posting 20050824
Split Window
Opening a PDF file
access to the multiple values on clipboard
Re: Unlock/Lock VBProject through code?
delete
Unlock/Lock VBProject through code?
Email from Excel useing FollowHyperLink
Security Certificate Question
Sum a dataset with 2 criteria
Stoping the Link
select a cell based on A1 contents
Imposible????
Get info from running Excel instance
Splitting Names Down Columns
wordart
Do Loop
Help with dropdown menus
Combo boxes
Loop help
-2147352573 (80020003): Unable to find the specied object
naming charts
Flashing cell or row when condition is met
More variable problems
Is there a Dialog box constant for the format cells DG?
copy module across excel spreadsheets
A loop to merge cells based on a value
Why doesn't this work
macro error
Form Changes Not Saved
Adding text to cells
Cross Reference
selecting columns and a loop
OpenText Method
Solve Order of a CalculatedField in a Pivot Table
Out of Memory?
help with cell compare in two worksheets
Offset
I have a programing problem!
place output of several debug.print statements on the same line
Automatic Charting from main Spreadsheet.
Help in adding XML maps to a worksheet using a script
Problem with a program code
Find Contents of Cell (Macro) - Help me!
UNDERSTANDING VARIABLE SCOPE
Efficient Arrays?
Comparing against values in a combobox??
How to enable Parameter Icon on the External Data tool bar
Excel Macro call Word Macro with Parameters
Need a save as macro
RE: Extreme VB Scripting problems
background saves in Excel 2002.
Turn off Read-Only
Remove Read-Only from worksheet
Self Cert Signature now has problem?
Excell
Slow macro
Need a vb loop for vlookup
Inserting Cells In Worksheet With Macro
Color in Multipage Form
How do I get Excel to access an externall dll ?
How do I get Excel to access an externall dll ?
Inputting text in a formula
Excel Forms
Need a vb loop for vlookup
Populate columns in one column one after one
Re: Alignment and format in listbox columns