Excel Programming [Archive] - Page 105

Color added to Dos
Dynamic Chart updates
Find Largest Number "Again"
Access to Excel Macro
Auto assign password to existing files
looping in vba for excel
Only need every second number
Can code delete code
Auto adjusting a user form
Active Form
PASTE SPECIAL PICTURE FROM EXCEL TO POWERPOINT
Compare values in 2 ranges
Mutliple fonts within cell
DDE Data Streaming Macro
Copy rows untill blank row then paste into new sheet
Setting up an incremented Variable name
Macro help
Changing cell color based on mathematical outcome
Dynamic Filenames with Application.Run
Need help with adding variables to cell addresses
trap arrow key press in userform
adding multiple columns to a listbox
quit app - Tushar Mehta HELP
Adding a formula to a cell that already has text
Reference a named range
comparing worksheets
Print Range - VBA
Deleting rows loop
Protect/Unprotect w/ VBA not working as supposed...
How to check a cell for content before running macro.
Keep the same center while zooming
syntax error
Remove VBA code behind a worksheet
Using DATE in VBA, gives error
What Template does this Excel WorkBook derive from ?
Not equal to
I need a Macro
Closing die hard process EXCEL.EXE
Use excel to insert data at the bottom of existing data
converting paths to pictures
Copy to end
PasteFace issue
Prevent file from working
Find Largest Number
Fiind from textbox and paste into sheet1
Amortization Speadsheet with a Difference
Select rows to format
copy cell with non null value
Screenupdating in 2003
copy formula with adding e.g. 10 cells
UNIX REFLECTION
How to test text string to know if it is a date
name of range from macro
Copying cells from one workbook to another.
EMBEDing an object to access procedures such as MouseMove
XP VBA Compile error...Missing files
Form
Add property problem
Changing a variable with a SLIDE-BAR.
HOW DO I DO IF SUMS
Pole nazvov
how to use ProgressBar1
I need help limiting the "now()" syntax
ActiveCell Offset
input box containing a list?
Toggle AutoShape Colour
auto archiving
Macro to add text in Cell (in a range of Row)
read macro code by vb code
CmdBarMenu.Control Deleted
Make excel the active page
macro
Sort CSV file from Yahoo Finance Query
How to loop by chaning the cell reference?
Calculation
Writing directory info to individual cells
Passing variables between forms
VBA PC-Mac Compatibility
Cell protection
How to parse data in text file
PLOTTING BASED ON MONTH/YEAR [DATE] MACROS
Specify a cell in next page from a specified cell on page being wo
Problem: How to copy excel sheet in C++
Automatically fill in postcodes
Crashing Macro, Not Enough Memory
Cell Spacing
ADDING POSTCODES AUTOMATICALLY
Display a selection while UserForm is in focus
Sort data whn represeted by formulas
delete row based on column value??
Sort data whn represeted by formulas
Unlocking pwd protected vba modules
VBA PC-Mac Compatibility
Better Fix For Endless Do While Statement
Advice needed: "Portable" macros?
Test for between times
Transferring Excel Data to Word Document
Clean up strings before creating a text file
Excel 2002 RTD Help URGENT !!!
problem getting data from sheet into txt_boxes in userform
Problem assigning values to a range of cells
97 digital signatures
limit character in textbox
Macro for filter
is this an accepted way to set the path
Help with Sort Method
nested for loops and end for
another pivot table question
Helping with copy and paste
changes in the date function from 2000 to 2003?
variable not declared error & syntax error
Adapt code to loop through sheets
Macro page breaks on column value not row 1 - use value in footer?
Problems printing using ExecWB
Creat a command button
Trouble with looping
A macro to make a summary sheet
Keeping manually entered data
Variable losing its value when calling new sub
build param string for WHERE IN (....)
Macro to colur tabs based on cel value
define a print area and name it based on info in first cell in a row...
Can Combobox range be variable?
Error setting number format
PasteSpecial error handling
Importing Fixed Width File Macro
Formula to calculate time
Changing Oracle connection from DSN to DSN-Less
How to reference the contents of a list in a floating toolbar?
Is there a way to make a spreadsheet open at system log off?
Excel VBA macro
VBA Form in Excel
Adding Subtotal to Macro
CTRKL-END of a Statement
code error after autorecover fires
Comparing 2 dynamic ranges for matching names
how do i compare 2 cells and extract the text that is different?
running a macro when a certain cell changes
Slow file saves
Find next
Auto-populating cells depending on the value of other cells!
Expand the Height of a form if "Not Managed" selected
issue with adding weeks to the date
average date / new function
AxSpreadsheet Help !!!
VBA>custom footer>cell ref + font size
Macro to add text in Cell
BeforeClose Problem
PasteSpecial xlPasteFormats ends macro
QueryTables.Add Connection Parameter
How do I set autofilter criteria as the ActiveCell Value in VBA?
AddIn to delete sheet
Activating the next cell
Workbook EDIT MENU
Gridview style control
Displaying Cell Value in UserForm Label
Vlookup problem in code
Macro Needed - Please Help!
Moving Horizontal PageBreak
Using a value from an Input box?
Copy/paste from file
How do I limit number of sheets in a Workbook?
Saving data
cell lenk
Combo
Opening a csv file
Calling macros, looping function? Can this code be written more efficiently?
Workbook_Open - Multiple Events not all working
bringing certain data from sheet2:sheet9 to sheet1
Macro - Cell reference - (Range)
pivot table questions
Extract Address Information from a Word Document
subtotal/pivot table question
Displaying one userform from another
Editing text of an XML file
VBA - Not Last Column or Row
Macro to Conditionally format Thick Border
where can i get a replace key code for mic office 2003
VBA Dynamic Selection
How can I setup a date without the slashes moving in a worksheet?
macro to batch fix errors on password protected workbooks
Password prompt add-in exit NOT Google Desktop
Macro code to check & copy columns
Send printer escape commands to a printer using VBA
Cells formated as custom numerics to text box error.
How do I create If/Then Macros contingent on cell values?
Event ID 1000
open a file in VB that the date changes every day.
Add Text to Textbox value by looping data
Excel create bookmark
File size increases with each save
PasteSpecial method of Range class failed
security/protecting an excel program
saving w/sheet to different location
IF Formulas
"Strip" Cell Formula
control gif with VB
Excel Automation Problem With Add-Ins
I want to look up a cost but I need two criteria met Vlookup give.
macro help
Opening a file that changes dates
Finding the name of an object using VB
How to close file from vbs?
How other people can view an xls file importing external data.
outlook
Link Excel dates to Calendar in Outlook
NETWORKDAYS FUNCTION
Insert Visio Button sheet pops up automatically
Command Bars
Pulling data from different sheets
Resetting Last Cell
converting text to numbers
Accessing other programs through VBA
Excel & VB pasting web page
Protection
Need help, how to increment numbers for each unique text string.
How to create a script to trust an assembly - Excel 2003 - Office System Project with C#
stop a macro from running everytime a cell is changed
Still Lost
Transferring cell data to textboxes
Rounding Macro
How can I format the cells to capitalize ALL letters in a word?
PasteSpecial: values and formats possible in vbs?
Please Help
download file from web service to be used for pivot
how to close app in code?
Object Problem in Excel
Excel's 20th birthday?
dividing time
Common Dialog control
Command Bars
syntax for filename:=
Macro to add rows between cells - new at VBA
Referencing an External Sheet without Knowing its Name - XL2K
Macro to delete Row
Copying user selected cells to a new worksheet using VBA
Paste sheet to new file with unknown file name - VBA
Cursor skip over a cell
Need help with simple macro
Controlling flicker in mouse move events
After sharing workbook VB code stops working. Runtime Error 1004
Help with protecting cells
Find Text from textBox then past what is found on sheet1
Copy range from multiple workbooks and include workbook name
Excel to Word problem
Need help with pivot Table Macro in 97
Error Code when compare cells in excel macro
Run Time Error 9 Compile Error
VB handling on mdi print error code 1004
Using Concatenate but splitting line with "tab"
Access Subtotals from Macro
Adding formula to multiple workbooks
Declaration of public variable - Question
Error Handling vlookup against multiple tables
best way to proceed
toolbar shared with others(does not stay the same)???
Date not converting to regional format
Hyperlinks and opening any sheet a workbook
Trouble with german / english dateformatting
Find text in Word, then replace with hyperlink
extracting specific data from a list
Trigger on leaving cell (of entire column)
What is the real name?
Makro to Run on Open Workbook
Tom Ogilvy - Thanks
Rogue Password on Properties and References
Creating a macro which presses a button containing a recorded macro
copy from hidden sheet
Move values to make a list
Automatic function in Excel
HOW TO DISPLAY DIFFERENT IMAGES IN EXCEL USING IMAGE CONTROL?
What am I doing wrong?
ActiveCell issues
AutoCalc Worksheet in ManualCalc Workbook
Should I remove code lines that turn auto calculation off?
Re: Coloring a range depending on a cell value
Excel 12 - finding the last row
Trim Variable
Add to an Array
Formating within pivot table
Coloring a range depending on a cell value
Circular reference after mouseclick
File Size Help
PS4 Pagesetup, pscale as array
master file for passwords
How to add rows(cells) to a named range
Huge Memory Leaks using ODBC Drivers from Excel to retrieve data
Hide & Unhide with a Checkbox
Help with offset
Importing names from one excel file to another
Prevent DialogBox closing
macro to remove space
Positioning an Object (say a box) on a Excel cell
Excel 97 & XP
create chart error '1004' ..
Global Variable
Save as box
Merged Cell Question?
controlling a pivot table using a combo box
output statement in marco plz
RESIZE of matrix by MARCO
Compare Files with VBA
to place a link to an HTML file on a chart?
Splash screens from VBA!
Printing the shortcuts for macros
more VBA code help...please!
Add Text to Textbox value by looping through a data range.
Find from Textbox and Paste into Cell on sheet one
VBA Code please
Using the SaveAs in VBA
Set worksheet.
like beatin a dead horse
Inserting a picture/drawing
Application Event Scope Problem
Return the value of fields in Outlook Contacts
Problem during load
How do I import an XLT worksheet into another workbook?
closed files
Installing Excel 2000 on a system with Excel XP - any advice?
Compile Error Method or data member not found
Workbook Open Macro
Find text in Word, then replace with hyperlink
Freeze and Split
killing all procedures?
adding columns based on lists
Edit add-in
VBA code in excel problem
Excel 2000 => upgraded to 2003 and macro to change font color fail
PRoblem with Menu Set up
number of module limts
Excel VBA: Setting PageSetup.TopMargin for _EACH_ page
Vlookup VB Help
how do I update stock quotes using automation with vb
Select method of range class failed
C# syntax for getting multiple sheets?
Select method of range class failed
Question about how dates in worksheets are typecast when used in V
On Enter: next row copying certain fields from previous row
print one sheet of workbook
Locking out parts of worksheet actions
check for OLE DB provider?
Workbook name
Search Folders Method
Ghost Cell Selection
How to align decimals and limit number of sig fig's displayed
remote userform control
How do I insert a selectable calendar into a cell in excel?
automating jmp thru excel
Sheet Password
Cut and paste using a macro
keeping track of time
Word Library reference
Work with a PDF file
One A day
Question about VB constants
Multiple Excel Sheets into one tab-delimited file - horizontal paste
Need a macro to insert text in a cell that already has text.Excel
adding a single quote and comma to every cell in Excel
Use of UNC
Automate Inventory
Delete space in Text
Keyboard shortcut
best way to format on cell change
Macro to remove blanks in text
1 CalendarForm - Many date boxes
Linked file in same folder but unknown path
VBScript to pull html source code
Programming Comments from the inside!! Asistance Please
MSForms UserForm Window Handle - Win32 API Call from VBA
Help with a simple form
Disabling Events
Excel97 - Syntax for Find, Offset, Insert Page
Referencing named ranges
Importing txt into XL as Delimited, what's wrong w my code?
Simple IF thing?
Problem looping through combobox
Word dialog editreplace
How do I assign a variable to the curent work sheet?
VBA test for the existance of a worksheet.
Array of all selected sheet names?
Followup on Vlookup
Enter data in next empty row after cell name
Sort - Header:=xlGuess vs Header:=xlNo
Is there any way to use a voting button in excel?
checkbox true/false label
how to create a new text file
Help with MSQuery & CAST function
Can't open my Excel workbook.
Re: It's getting a bit complicated
macro for finding formatted cells
Runtime error 1004 - unable to set Visible property of Worksheet c
Formula to freeze a cell
wish to make a Birthday reminder!!
Autofill Macro for 2 rows and 100 columns
Autofill Macro for 2 rows and 100 columns
Re: Save changes in Excel 97 from file created in 2000
Re: Hope Someone Can Help...
How to create a self extracting zip file that starts excel with a macro
GetOpenFileName
Count series in range
Re: draw arrows using formula
Global VBA Project?
Re: Filename as string
Loop through combo and copy graphs to Powerpoint
ComboBox list reliant on the entry from a different ComboBox
Creating An Event Procedure
how to Disabling Printing Notification Dialog Boxes in Windows IN VBA
Strange issue freezing parent form when unloading a child form
If Statement
Find color in row
Combining singles data records
VBA: Concatenate with carriage returns
Re: password protection
CheckBox Conundrum
password protection
Refere to cell representing a path to a file
Don't open file if no response to enable macros
Deploying an Excel Application
Userform
strange randomization
Data in Cross-Tab format: needs to be written in Table Format
Not-so-noob
Instantiate controls and forms in an Add-in
VBA - Passing Cell Location To Variable
set to upper with code
Protect Worksheet Help!
Disable Right Click in Spreadsheet
Help with find
Excel '97 text import problems:
test: please ignore
How do I limit the period of use of my xls programs for trial use
Arabic characters gives ASCII code 63
how do I use my solver solution on next month's numbers
interesting interpolation
Question about cell adressing
20 minutes trying...
Need macro to insert chart w/ FIXED size & location
AutoFitHeight and Height not working together
propogating cells with data from numerous sheets
remote writing to userforms
difficult transpose?
Dataform - Forward/Backward Control
Code to handle clipboard message
Function Vlookup, Match or Index?
VBA - Choosing rows based on a criteria
Function Vlookup, Match or Index?
Driving me crazy!
Output to a file?
Address Function
check for alphabet in datalabel and then superscript that letter
Lost
Edit hyperlinks
Euroconvert
I need to determine the last line in a column and then add data
Mouse Location, Movement and Spreadsheet Location
Looking up data from one place to another
Open word then find replace text
Looping through a range
Drawing Charts with VBA
Default Objects and code in cells to be in New cells/row when inse
Using macros to hide columns
Euroconvert
Excel 2003 vs 2000: PasteSpecial
Filling empty cells with contents from another cell
Adding or Deleteing Rows in a Range with an Array formula
Autofill information from Sheet 1 to Sheet 2?
Relative Links becoming Absolute Links?
Setting print range with macro
Pivot Tables and Charts
Looking for ANYONE who likes and knows both EXCEL VBA and JAVA
Anyone going from MySql on web server to Excel on desktop?
the ultimate stock trading data model
Macro Problem
Can I link or embed .pdf files into or to an excel file?
opening SPSS and a macro from Excel VBA
skipping empty cells that are not empty
filter unique values Excel
How Do I Get A ComboBox To Add Entry To It's List If Not In List
Delete Rows Error Message
Run Time Error 1004 - Application-defined or object-defined error
Startup Code in a Workbook
Objective/Goal Tracing
XLT with macros ==> XLS without macros
Wondering if this is possible with a Macro or if another solution is better...
Determining a previous cell value if deleted
Separating Strings
Locking a Workbook
Macro HELP!!
Date / Time Picker V6.0 - Control moves location on userform!
Office 2003 Service Pack 2
VBE Help
URGENT -- search in string for a value in another column, if found, return value from next column
Use sheet name in formula
I WOULD LIKE TO RANDOMLY GENERATE FROM LIST I CREATE ON SAME PAGE
Library missing
Chart - VBA
Lookup
Time ticker
Help with Look up code
Making array from range
Last cell location
How to format Userform caption?
Date Problem
Conditional Format Cells containing formula
Strange hyperlink behavior
Sum Selection
Watermark centered in PageLay-out
Convert to .PDF macro
procedure/function calling
Sheet Number
test if a value is an integer
refedit errors when tabbing to another control
How to add more cells to a selection?
Userform Control Error
ReferencesEvents
How to speed up this macro?
MouseHover in VBA
easy one - select a cell
No Title on Userform
worksheet other colour
SQL Query in Microsoft Excel
Fill out web sites automatically
help with a macro needed
adding macro
Browse up to file
Open doc every second time line run
Smallest range on sheet containing non-blank cells?
Linear Programming
Starting another program (again) Maybe TOM
Making A number AdvanceWith Each Cycle
Difficulty in SaveAs an Addin
array question
Finding duplicate entries with matching lengths, total the quantities, delete the extras
formula for coloring text
date / time picker error
Open a access database using VBA
evaluate a function
Forgotten Password
Looping through to add series into a dynamic range chart
Save As VBA
Workbook Protection
Mailing excel pages
Copy four worksheets from one workbook into a new workbook.e-mail
Return most recent file in subdirectory with out using FileSearch
skip automatic update question to excel
Support Article: 305342 - Workarounds provided DO NOt work as expe
VBA functions - faster than worksheet formulas?
Help using form as menu
Copying values from one Workbook to Another
SP2 & Self signed Digital Certificate
Import n .csv data
Transposing text in text file to Excel Sheet.
code for hiding formulas
when I download from the web a "date"...
Run time error '-2147467259 (80004005) adding icon
FTP from Excel
starting another program
Adding a menu
xlDialogOpen get it to return Path
Another approach - Program Command Button
Hiding rows - Excel 2000, 2002 vs 2003
Error 1004
Using Offset with Autofilter data
sort colums
Working with ranges
Worksheet_SelectionChange(ByVal Target As Range) questions
Looping folder changing - Save Preview Picture
Deleting lines with a variable.
Execute code after printing with the BeforePrint event
Retrieve or extract cell formatting information using VBA
text import inhibit required
Advanced topic: Communicate via IP address
How to view properties of a cell
Picture control in Excel/VBA ?
Class Events
Compile error
email on condition from "import external data"
Custom Keypad
DialogBox Layout
disable unhiding columns
How do I relegate the curser movement in a formula?
Trouble turning off sheet updating and returning to original active cell
Ensuring Macros are running
Trouble returning to original active cell
Verify if a workbook exist with a macro
stop from running everytime a cell is changed
VB6, How do i open (instead of edit) an excel OLE doc when it is double clicked?
Open Worbook and Disable Macros
cursor behavious when restricting selection to unlocked cells
2 dimensional array and freq function?
Array function, two dimensions?? and worksheet arrays
ReferencesEvents
Array function, two dimensions??
macro for copying
Opening XML files using Office 2000 or VB6
date in combo formatted as number
unique text additem combobox
Excel Vba Programming
sub total
Excel programming- VERY VERY URGET
Extract data from an old Quattro file
Copy data from sheet 1 to sheet 2 based on day/date
background
Help with a complex formula
Select individual cells only?
recognize USB drive
How to use a opened web page for web querry
Can a Macro contain an IF statement? How?
Deleting graphs (if existing)
Conditional Format on returned value
How do I :
XLodbc.xla to ADO
Help me please
.OnAction points to wrong file.module.procedure
checking if an url exists
Match
Log Workbook
ADD A BUTTON
Past Special changes results for macros... how to prevent this
Can VBA process messages posted to its main form?
Check for value before printing...
Change AutoShape Text Color in VBA?
Need help: how to semi-automatically replace an empty value in a row with a row average?
ADO recordset problem with stored procedure
Unselect range
macro for processing one excel file and saving it to other
very urgent macro problem
Brainstorming possible file errors/problems
looping for a condition
Search by filter using macro
Auto expanding Range
"Can't move focus..."
Column..._Global failed error
help please..... can this be done
Repeating macro with dynamic range
compare string to column
Sudden Excel Problem after XP SP2 install
Find Character & Highlight Cell
Calling excel macro from VB 6 app problem
Custom Function #Name Problem
Determining weather a macro will run or not
Unable to Set XValues property of the Series class
Export excel table to acess table using VBA Code
Monitor Changes
Run-Time error 13 on a FileOpen command
lookup cell value
How do I get beyond the upper limit of 65,500 records on Excel?
How To Print the contents of a TextBox
Cells updating - can it be stopped?
Finding Cells
GIF, JPEG, TNF -format
VBA controlled conditional format
Change event causes program to freeze
Formatting Cell Ranges
Client Authentication
run-time error '9': Subscript out of range
Excel to Word
Problems Setting properties of class module
VBA to run queries in 5 different worksheets
Text File error message
Protect workbook & keep change history
Setting a range on a particular sheet
shell in synchrone mode
Totaling range help needed
after refresh query
Rename multiple sheets
"Folder Select" Dialogue - Opening multiple files from selected folder
How cell ranges are handled by worksheet functions/row column matc
Database Connection
IF statement to add data when blank
Compile error on "Right", missing Library
Win XP Logon Name
end call macro
Free ebook - excel vba programming
do anybody have a sample code for executing excel macro from vb code?<eom>
conditional format for rows according to the result of a formula
shared on/off, read only off/on
Copy "active"
Sorting/Searching & returning data
Changing Pivot Table Field Name
find row number
How do you get a row number is a Cell?
generate all subsets (2^n array)
PivotTable controlled by more than one page field item
How to get text in cell into variable
Automatically save report to new file name each month
Form Input, with (listbox) review then copy to worksheet
Counting Positions
macro
move contact name for specific Company
Displaying AutoFilter criteria
lock a range question
How MsgBox can show address?
Question on autonumber
How can I force my code to wait
If syntax to test if command button exists
Repeat: Active Cell's Address
Blocked e-mail attachments
Delete Row IF
Insert A Row
How to get ActiveCell's address?
References keep becoming unchecked
Showing form
Who has this (shared) workbook open
Macro for Custom Header
Filtering data to a userform listbox
WorksheetFunctions
Public declare for Set....
dynamic ranges
Calendar Control - limiting min & max
Waiting for the calculation to be completed
Set formatting variable
using a go to the last row in a formula
Get Values from Closed Excel
count down timer in text box
Identify Load Drive
Loop???
Can you use a Range $N$xx:$Q$xx in Target.Address?
Automation Error
Creating an excel macro to open and save sheets to a different directory
Is there a SUB like "Sub Worksheet_De-Activate()"?
copy/paste
VBA module not responding!??
Conditionally Formatting a Cell
Comparing data of two sheets
Is it possible to create a custom Task Pane view?
Excel 2003: Grabbing a dataset from a webservice and then sending to a webservice?
Getting a count of formula results only.
Find an existing file.
Dynamic Cell Nameing
Replace "." to ","
Insert Template Sheet?
Problem with downloading data in Excel 2003
Make Table Query limitation
Allow only numeric data in certain cells & only text strings in others
How do I set up a macro to automatically delete certain cells?
macro
Much difference between VBA in XL2002 and XL2003?
Test if cell has diagonal borders
continual updating
Form or Spreadsheet?
it works, it doesn work, its works....and so on.
determine the active workbook containing a specific sheet
Hyperlink Code
Printing Macro?
Excell HELp PLSSSS
Auto Filter Delete Rows by Criteria Doesn't Work Range To Complicated
FormulaR1C1 - autoconverting strings to numerics
occasions
Read,Show,Update,Format & Save a text file.
defining a range of cells in excel using cell content
Repeat Macro until Empty Cell Reached
Excel macro ~ open form ~ new record
trivial summary diagrams
Traying something new
Security and Macro Enable help
Charts and VS2005 B2
Need Help Setting Cell Values
Show all dependents
Help on Workbook close and workbook save events
Running Standard Module Code from Dataform
PASSWORD PROTECTED DOCUMENT
create a folder using a macro
Tab names
vlooukp horizzaontal...
Combo Box
inserting page breaks automtically
Conditionallly formatting a textbox
Tough One - Return output from Dos Process without writing to file
Groups in Excel VBA
Change property of comments only
how to execute macro from vb 6.0 code?
How do I set the rowsource for a ComboBox for a dynamic list?
counting everytime red cells turn white per column
Run time error '91
Daily updates of pivot tables
Match Date Search
Pause code, wait for input, no input received, carry on with the code
formula with text string
data validation list arrow style
Invoice
How to store text to variable
Event Procedure - Extending code
Highlight wrong entries in SuDoKu
Add Toolbar to workbook
Context Menu
Harmonize date format
Counting number of identical values (or text) in a range
columns hidden
Error: Object required
Runnings SQL Queries from excel
Inserting Rows with the change event active
filtering out data using other worksheet
Picture in Cell of Active Sheet
SuDoku
Setting Row to be = to another Worksheet?
Please Help Wth Cell shading
creating a summary from a data dump
OptionBox error checking
Hidden Cells Text Revealed - Bug?
totally newbie to VBA need help
sort and tally routine
Run/Execute string expression
Textbox Question
Checkbox problem
Checkbox problem
time and auto macro run by setting time
transfer spread sheet
Move Records from Sheet1 to Sheet2
Move a workbook from one instance of excel applicaiton to another
Limit characters in a word/text box in excel
Spreadsheet save using a macro
Using VBA to colour a cell
Passing array from Access to Excel function
Need help programming some variable ranges
Build an excel application
Values and Formulas - Problem - High Importance
Return results based on multiple criteria
AdvancedFilter with VBA
question about debug.print
Selection.Interior.ColorIndex = 0 Error
Changing text in a Text Box
HELP!! Change formulas programmatically -- all I get is text!
Creating a labor proforma.
How do I change format
Cell jump
Getting readonly & password properties without opening file
Populating an array from a integers values column rows
Vlookup in multiple arrays
file save problem
Block the cut option
copying dynamic range based on cell outside of range
User form
Open to Worksheet
Outlining with condition? part 2
big problem selecting and saving data
Copy Worksheet with Code
VBA code for Internet User ID & Password
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
Program to make cell a formula
offset problems
Can you create a macro to hide rows with zero values?
Range.ListHeaderRows
Printing -- Page Number Continuity
Changing path of button macro assignment
loops
Need Help ASAP
Excel and Outlook
Programming for a Dynamic 'Where' clause
Opening a PDF from Excel
Sort on close - Possible?
Call Statement and Return Value
How to locate a new outlook folder
How do I write an IF function to accomodate equal to or more than
Add to Shortcut Menu
Select a column based on a cell entry
Macros are disabled
VBA Find and Replace (Tidy Up)
Prevent virus scan of Excel workbook
From MMDDYY to YYMMDD
Combining VBA code for columns
can you add a shortcut to a macro after it's been made
Change the Value of cell to Whole Number
How can I delete unprintable characters using VBA in Excel?
Compare strings of data
Automated range selection
How do I Advancing to next column/cell in a Sheet.range(x)?
problem vba dialoguebox and database in excel
Copying list values
Runtime Error Msg: "Cannot empty the Clipboard"
can I insert a Sort "Button" in a cell within Excel
How to avoid counting blanks in a list
Simple Macro, works in Excel 2002, 2003 but won't work in 2000
Calculation Problem
SumByColor Macro...
proper way to create a userform
Search & Extraction of Cells in a Workbook without opening it?
If statement to stop Macro
Macro to return to Current Sheet and Cell
Search option
Closing Excel - no save prompt
macro to save wookbook add 1 to to a ref No. clear cells
Cell Codes
Transfer Data from Excel 2000 to the Access data base
Help with error code
Print "Landscape" in explorer
Insert/delete rows
Check if Shortcut created
Gain access to Email
Limit number of entries in quiz sheet
VBA in Excel 2003
Change links/reference a new file
Combo box background colour
COM Add-in - Simple Function
using worksheet in same workbook for query
Won't Work with Excel'97 - What Will Q
retrieve data from spreadsheet using combobox in dialoguebox
Schedule table
picking a userform to show
change reference for 'visual basic for application' in VBA editor?
Change Options under Tools>Optioons>View Tab When User Opens Workbook
Use a variable anywhere in the workbook - How to create?
What was the default name for the Auto_Open() module?
Hyperlinks
Referencing cells that array covers
Search text & record number of times it appears
Importing external data
if anyone wants office 2k3 sp2
Find/Lookup data within hidden cells
worksheet data filter
how to reset the activesheet usedrange value
Excel Color
unable to copy sheets
Need formulas
Is there a command in visual basic to move down one space, e.g. m.
"Rotating" / Pivoting / tranforming Data
Passing Parameters to Word from Excel
can't close files opened in an excel application??
Listbox Column Heading Help
sorting columns
Remove Macro
Determining End Of data
random sort
Shapes.AddNodes Error on adding next point <0.25 away from prev po
Update Values as soon as a Worksheet becomes active?
Allow user select file to copy data from "Application.GetOpenFilen
ADO connection question
Visual Studio Tools for Office - CountIf, Ctrl-Shift-Enter, Array
Question about filename formula ..
Report Criteria
Issues with Hyperlinks in XL97
VERY Basic Define Variables Help Needed
Create sequential file name for uploaded template
spreadsheet locks after display of msgbox
Totalling Range Values
Retrieving all worksheet names into a new worksheet
Suppress Alerts - Update Links
Cannot get the parameter option to work in Excel query
Getting data off a form onto a worksheet
StatusBar fails to update
Use VBA to automatically email from Excel
reference vsto Excel ListObject in Vb.Net 2005 project/app
lookup value then clear some cells
resizing a range
Need function for dd/mm/yy hh:mm + X working days
Rotate a text box?
How to copy data from several worksheets into one
Selective Deleting
Creating "records" in UserForm
Help with VBA code, making it spacific to one workbook
Count depth of Colored Cell
Simple yet wrong
Call procedure from another Excel File?
How to automate web login?
Emial with notes
Email with notes
Changing embedded file name
Use VBA to allow you to select a file name from a directory (public drive/server)
Email
How To Get A Named Range To Grow
Combo Box and Recordset
Excel Charts & VBA
set focus on txt field
how change formula with this code?
MICOSOFT GIF FILES: patent issue
Importing a macro programatically
Expanding Menu items in VBA
Date Question
How can I use a variable as cell address?
Top Ranked Opportunities
How do I automatically copy cell values from one sheet to another?
MID STATEMENT vs MID FUNCTION
Insert Row Macro with Hidden Columns
"Open With" external application macro
cicling sheets
delete duplicates macro to color instead of delete
Calling a Sheet
Com add-in
search 2 spreadsheets and compare a value.
autocomplete
excel loop in cell formula
Deleting Named Ranges
new sheets..?
combo box transparency
Linking word and Excel
Paste Special Values VBA
part of a code not being executed
2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do)
Help with - Get File dialoge code
bassfisher
ListBox Selected Items into an Array
web query peculiar problem
Getting value of Option button
Sheets("sheet1").Range command between workbooks
User form and send mail
i want to delete duplicate items in a list using code.
Accept Cell Edit
private sub- which procedure called it
Activecell offset value with formula?
mergercell problem