Excel Programming [Archive] - Page 129

Trip to Disney
Displaying a 1d Array in a spreadsheet and a list-box
Would it be worth making a dll for this?
new line in msgbox text
R1C1 Fix
Read Contents of text File into worksheet
password corrupt...help! (please)
Newbie - macro help required urgently!
How to make a macro available to all the workbooks?
Need help editing a string
Copy & paste cell after inserting blank row
Flexible procedure
Excel conversion to word 2000 Text
C++ source code for Excel files (non_MFC)
VBA and VLOOKUP Question
extracting time from a cell
excell - query
VLookUp function
Sheet Name change
Merging multiple sheets into one sheet
Formating output.
how to stop a loop
QuerTable query!
Help to adjust code
find and demerge merged cells
searching a cellvalue in a range
DateFormat (dd-mmm-yyyy) (dd-mmm-jjjj) Problem.
help with macro
how to save shared file
Help with a Formula Within a Function Please
Searching a list using wildcards
UDF error when renaming Module1
How to get data from server?
How to use Java in Excel VBA?
How to use Java in Excel VBA?
How to use Java in Excel VBA?
Input Values Instead of Hard Coded Values
Printing Problems
excel process problem 2
seperate number and character in a cell
Check Reference to ADODB in Workbook_Open
area under curve and bilinear representation
for every workbook in folder
Couting data
excel process problem
Links in formulas change when another user runs a workbook - 2003
Calling a function from a subroutine loop
if statement for sheet not found in workbook
Find from one sheet to another
Re: How do I set up incremental numbering of Invoices in Excel?
Re: How do I set up incremental numbering of Invoices in Excel?
Re: Customizing the toolbar Icon
References to open/hidden workbooks become hard-coded in formulas- 2003
VBA to Reference a file when not logged in? unc address?
Customizing the toolbar Icon
difficult problem
making macro run automatically
how do you add-u cells value the othes is based another celll be
Checking previous 7 rows for dates and values
Conveting numbers to text, like a checkbook.
Keyboard shortcut Alternative?
Using a function in a macros to enter data in a specified cell
Adding values to 2-dim array
Is the floppy in the A drive?
Migrating forms to VB6 from VBA
SetSourceData for Chart
Apply a formula to every numerical value in a selection/workbook.
Buttons in 1 module?
dont understand compile error
for each worksheet ...
Database fields get cut off in Excel
Whats wrong with this code?
Macro that creates a directory but...
Creating a macro that lists directory names within a directory....
Enable filter to work in a protected sheet from Excel 2003 to 2000
Newbie Help on VBA Calander
range question
In Excel, How to get cell reference of a particular word in anoth.
Upper Case on Input Q
Changing Forms
What's wrong?
Solution Needed, please help!
Delete Macro in VBA Project Office 2003
draw button
Problems with ChDrive, ChDir
Enable / Disable a button using a macro
Checking to see whether a string contains a certain character
Call up a Macro within another Macro
Problems with setting values in a listbox
VBA and ComDlg32.ocx
HELP!!!! VBA Project Locked - Project Unviewable
VBA with Font dialog without use comdlg.ocx
Counting items in an array
RunTime Error 424 in a USERFORM's code
austdate
find out line count source in vbe
Paste cell content to another program
Converting XL4 Macro Sheet to VBA
IF and or
Using Userform code in a Workbook
Copying formula...
adding to a cell in excel
Running a macro from a command line
How to use worksheetFunction.Frequency
What do I need to download to open a .xls file?
trouble with conditional formatting
Tracking by date
My Command Buttons keep floating on the sheet???
Project Two - Sheet Number
Excel 2003 COM interop problems
Runtime error 9 in "How to find a date in a range with VBA ?"
Tool Bar does not hide
PC to Mac VBA Cross-platform compatibility
For guru's: textbox printing problems
Year to Year Sales Data Sort
Select multiple items in a listbox
free lance excel code developers
Slow in program after running few times
Error 2029 using Find XL 97
making a range of cell formula absolute
Copy VBA Module and Form from Workbook to another workbook
Stepping through Pivot table page field items with VBA
Excel add-in MS Query
CopyMemory - Array of UDTs referenced as a pointer to a string
Regarding to owc (Spreadsheet) Toolbar
Search cells in a column and return yes/no if they are present in named range
Detect if a selected cell is within a named range
Removing Controls at RunTime?
Getting output of a called external executale
RE: Import extrenal data exceeds 65536
PivotTable: ChildItems and ParentItem don't work
RE: ActiveX initialization in Excel
macro interruption: help.....
need help with a formula
Excel 2002 : question on Hyperlinks
Programming of alternative actions in VB macros
Copy entire row if...
stop calculation on workboook open
help please!!! error "object invoked has disconnected from its cli
Sum Visible
PROBLEM : Excel automatically updates the macro locations in the toolbar
Carriage return in a cell
Convert extracted number - Paste Special / Add
SQL Query and Summary
Filling drop down box
manipulating displayed pictures: can I rename the various Shapes to make coding easier.
Counting the number of nonempty cells
connecting a pivot table to a data cube in VBA
Data searching based on cell contents using VBa
Macro unexpectedly jumps to other macros and functions
trouble with simple loop . . .ARGH!
Checking Cell Values Row-by-Row
font color depending upon value possible?
How do I list names alphabetically?
OpenRecordset
What is this Strange Characet? Find/Replace
Can I shorten this?
File size (2nd post)
Change the MSGBOX
prevent pasting into multiple lines
how can i link workbooks in excel 2000
one sub for many Combos in different way
how to move up and down different rows?
Find & Replace *
Date/Time
Advice on Reading the Object Browser
Pros need help
Find text in string
ComboBox create add'l lines of code
Re: Disabling Menu Item
Re: Expanding Excel
User defined menu
Import Excel Forms into Visual Basic?
programmaticaly test more then 1000 excel files for "opening Errors"
Userform Questions
CROSS REFERENCE BETWEEN WORKBOOKs
Userform maintaining items in list box after exiting Excel
Sort Certain Worksheets in Workbook
Using find and replace
Screen Flash
Unselecting a Cell??
Using the Windows API to extract the Windows User Name
Programming Help - evaluate, select and Past into new workbook
Random Events
Macro cut and paste quits, can't re-create
references between macros not working
How Do you Change the text/value of Range in a Function?
Identifying an open workbook / sheet
Copy macro to a new workbook - new question
Return Sheet Names from Closed Workbook
Sorting out ages
Matching data in separate lists
Find date and copy range based on that date
File size too big
Replacing (identical) values in multiple workbooks simultaneously?
avoid multiple text in range
IF BLANK
Identifying Duplicate Values Code Modification Help
Open workbook and Excel closes
Automatically Copy Row based on Date (Month)
copying macro to a new workbook
User Defined Functions
RE: Creating and controlling objects in a UserForm
Create a two-line header programmatically
RE: TextBox on a UserForm -- AfterUpdate
Worksheet Change
Labeling plots!
RE: Sheets.copy problem
Copy rows with a difference
RE: Where else to look for procedure call
hyperlink based on user's input
Chart Data
store cell contents and cell address for comparsion & suming
Query from ASP
Using a cell ref for the data_field arg in a GETPIVOTDATA formula
CheckBox and Data Selection
VBA Loop Problem
Creating a User Defined Array Function
deleting sheet protection
password protect one sheet in within file
multiple split screen
Input >Output without =
external reference error
Find the last used Row on a Worksheet
copy to a Closed workbook. whith Path .
Changing the colors of a cell
If,Then,Else Macro
accessing last cell in selection on sheet
closing without saving within a macro
Protect sheets w/o user password prompt
protect a worksheet for everybody except the VBA writer
Re: Import extrenal data exceeds 65536
Problem vlookup ->solution macro
HitTest function does not return node as documented
Print "ActiveWorkbook.FullName" always.....but
Is it possible to create a ole-link in a excelfooter?
Saving file to *.prn format
advanced filter
Error closing embedded Excel workbook in PowerPoint
Range split
Re: Formula reference index?
Re: Cells.Select won't work!!!
Macros inside macros, and pasting into macro code.
Re: Sumif - double column comparison
Sumif - For Each problem (several column comparison)
Auto Complete
listbox shrinks!
Using VB Excel to create Game Show
Re: Select Multiple Shape Objects
VBA - bignum
Repeating code
Why the command button in excel will move when print.
Re: Map and user rights
Re: mot de passe pour plusieur application
Getting the index number by supplying worksheet name
subscript out of range error
Re: Formula reference index?
Strategy Query
RE: Import extrenal data exceeds 65536
VBA "move" method?
Printing VBA
Assign Macro To Button At Runtime
Sum a variable database
NonModal Forms and Set Focus
does Excel have memory limit of data Array?
Re: Import extrenal data exceeds 65536
Range array need it in one statement?
Import Data with the filename coming from inputbox ?
Partial Search using Macro
Unable to get the Text property of the WorksheetFunction class
Recommend a good Excel Book
Loading Data from File ~~!!~~
Excel VBA code under MSProject
Editing Numbers on a Form
Copy from clipboard?
sort data after import
Re: mot de passe pour plusieur application
Script a userid and password (apache)
How can I reduce the Size?
Reverse Direction of For-Each-Next?
RE: using macro to name a dynamic cell
ListBox with use like inputbox
conditional sum wizard
List ranges a formula refers to
Problem with using the ActiveWindow property - sometimes
Need help!!Could not find installable ISAM
Labeling plots!
Code Glitch from version to version
excel vba copy files
Hide, Print, Unhide Rows
Hyperlink in Excel
Combo Box created in code
Re: How do I save an embedded item from a worksheet into a folder
ThisWorkbook.FullName - A different approach
How to create labels in a UserForm dynamically and be able to resize them with the mouse.
Re: shape colors dependent on calculations
Re: Problem with fraction showing up as date when copied
Disabling Excel VBA Pop-ups...
Launching Excel programmatically not the same as launching excel manually
Re: how can I know if a workbook is locked?
How do I set the focus to a page in a multipage
Re: VBA export excel to .txt, number format problem
Count all VLOOKUP() functions on worksheet
Re: Control starting value for spinner
Protection
Re: view code in excel sheets
Re: Excel 2003 wont recognize UDF written with 2000
view code in excel sheets
Trouble with Elseif command
don't charge to convert the microsoft office, many can't afford t.
Re: Where else to look for procedure call
ThisWorkbook.FullName
Combo Box
Re: What first - sheet_change, calculate,selection, etc.
Application.LibraryPath returning invalid path
Re: Logic Statements
Re: SheetChange Event
Matrix Operations (MInvert Function)
RE: Get Outlook Address Book info
RE: Get Outlook Address Book info
Simple questions (I hope)
Is it even possible?
RE: use a macro to close a file
Re: SheetChange Event
Re: vba to call a referenced range
Multiply a Range by a Constant
Mailing Label Printing
controls
checkbox activation
Project One - Nearly done - Protection issues
find and delete duplicate entries in two columns or find and prin.
Concatenate 12 Adjacent Rows into First Cell in Row
Test if a workbook is open already
sort and add data
Easy Syntax question: referring to worksheet by VBA name
Un-docking the Watch Window in Excel Worksheet
event when addin starts
VBScript code behind Excel
Count CheckBoxes in UserForm
IF File Exists
addin crashes on only 1 computer
optimizing code? (hide)
Help! Equations with multiple unknown quantities
spreadsheet that assigns vacation based upon seniority/time off a.
Help to alter code slightly
VBA Line Control
Hiding Macros
how to access macro code
Instant runoff voting spreadsheet.
Format all sheets in a workbook
Using XL to grab current user's Outlook calendar item titles, dates, and durations?
Can I freeze pane on an inactive worksheet?
Plotting Graphs by Arrays
Google archives
Return action when a selected cell has focus.
Sheet and userform
How do I delete entirerow that contains few command buttons
Removing & Importing user forms via code?
variable trouble
Multiple answers from vlookup
VB to create 2 data validations
formatting a work book
Sumif values from different sheets
????decreasing text??????
problem in removing add-in
Refrencing cells using old Paste link method HELP!
Macros - get information from Multiple sheets in a work book?
modules
Between dates
Deleting legend entries
Call a sheet name by reference to a Cell need help
Vlookup with multiple answers
How do I create a custom add-in
loosing decimal upon sorting?
How can I delete a worksheet from the workbook.
Clear all cell in a sheet
vlookup in vba
Watermark
Check for list of 3 values (alpha) in a column
label colour (MakeAppointmentInOutlook2003)
Naming a Tab
Activecell.value or value2?
Too many different cell format
Copy sheet to sheet based on examples from ron
Moving row between worksheets
Need advice, help on creating Microsoft month calendar control using the winapi in Excel
how high is my PrintTitleRows
Write in the spreadsheet having a form open
Use same connection for multiple recordsets
Cells variable
Search for file using first 2 digits
Method failed when creating new worksheets
Check for list of 3 values (alpha) in a column
URGENT : How to get CHECKBOX object value from a Excel Worksheet by a C# Class
Pivot Tables calculated field problem from VBA, please I need help
Dynamic color selection in charts
Paste As Link Failing
fileopen
Filter/Advanced Filter
Grouping in Pivot Table
Address of a variables
vlookup
Filter using combo box
Code signing a VBA macro in 2002 and 2003
Pivoting in Excel
Error 91 -- Object variable or With block variable not set
"CAN'T EXECUTE CODE IN BREAK MODE"
How do I calculate "x+x=2x" using Excel?
Workbooks with variable names
Grouping and outline
get value from cell
Worksheet_Change
Date format on cells defaulting to US instead of UK
Change the start of a workbook
Define Range Name
Export selections into new Workbooks
Save file as a new file
Moving a control in a userform
Value in a textbox
not so good
animation
Unprotect question.
Problem with lookups via VBA
Copy again
timer
graceful exits
Can you help to find the right formula?
Nested Loop Offset Glitch - Object required (Error 424)
Automatic List Numbering
Querying a list with Excel
where can I calcualte my pay check
importing sheets
Copying hidden pages
Error unhiding in excel 97
Copy
I found this great little site
Price Averaging, auto update
need to repeat rows at bottom of excel spreadsheet
Copy and paste from one cell to same cell twice
messagebox without default button
messagebox without default button
twist on next empty cell
Directory browser
Input data from sheet to file and vv
Changing active cell to a color
Excel asks for addin password on exit
Bug? Multiple values in merged cells
Removing "Sheet1"
Number in forms
Problems with appilcation.filesearch
Addins - Is it necessary to duplicate changes in both the VBAProject AND the Addin
Range Minus operator?
AutoOpen
Browse Forms Controls and change TextBox color based on cell color
VBA code protection in Excel
adding columns
Macro Button Picture
VBA Date Format
Apparently Erroneous Resource Error Message
Auto filter Code
paste code
Check for open workbook
VBE Window will not scroll with wheel mouse
Help needed with Solver macro
Can I chart cells with values only........surely the answer is yes????
entering arbitrary numbers in formula to get a different answer
Is it possible to pint and click from with VBA
Formula in a cell (in Visual Basic)
Workbook_Open and ComboBox
Help with Save As in a macro.
Can anyone solve this mystery?
ComboBox
mouse click or mouseover and get color
Delte Autofiltered
Copy/Paste
microsoft visual basic
change validation on protected sheet
Charting in Excel to Powerpoint - Quality
Clear Captions from labels
Passing arrays to VBA module
Move to Active Row Column B
MACRO TO FIND SUBSTRING OR SUBTEXT !
Move data from cells to form? Help!
How to get a sum of values from multiple sheets
Connecting to excel datasheets using C#
clear captions from all labels
Cumbersome Code
Trying to increment by one day in a macro
macro can't form a Range on an inactive Worksheet
macro can't form a Range on an inactive Worksheet
audible alarm macros
Function in a Template revisited
Import Sheet from Closed Workbook
Creating a random number of arrays
Triggering Excel Macro from MS-Project
lookup a value in a table
Need Programmer Advice concerning NonModal Forms
Delete rows with specific leftmost value
How do I place an imported external data text filename in a Worksh
Passing Data From Excel to Word
Setting number format on range of cells
function to return cell address
code running super slow...
Compareing 2 Worksheets in different workbooks
Remove option to save
Replacing XLS file rather than saving
Google Search Add-in update
Excel relative reference not working with charts
excel file width calculating
oulook excel macro problems
Help with a Macro to list all filenames and mod dates in a folder
Copy cells into another workbook with an input box to select the file
Randomizing Hell
Trend
Creating a WBS numbering system
Dealing with Ranges
activecell.offset does not work
Using data on a server
word spellchecking in excel
Run-time error 438
Need to create a monthly calendar with Tuesday starting the week off
Add month to date
Spreadsheet Creation - ADO
Dynamic Label Caption
Renamed File
Opening files with a input box
how to track a change in a cell content
Web Query Sleep or Wait for return values
Runs Fine In Step Mode But Crashes Excel Otherwise
payroll calculator for canada
COM Port help please
Formatting cells to put the " mark for inches?
Problem with setting the ListFillRange in VBA
User Defined Forumla and persistence
Help in user-defined sub
How to read emails from Excel
Avoiding SELECT
Getting "Object Required" Error Message - Need Help !!!
Rowkount
Disable "select sheet" prompt
programming of matrix formulas in vba
Proper Programing
References to unsaved documents??
cell reference
Using shared "Read Only" program file
Convert comma separated string to DropDown
Get Hidden fields of an html form on the web
Saving Excel Workbook in VB6
Input box with variable
Error when using VBA to change hyperlink on a shape
Disable 'Error Report' using VBA
copy certain cells to a new excelfile/workbook
How do I capture user paste action and convert to Paste Special
Getting a valid position of hyperlink
Stop execution of ThisWorkBook Code
Selection Questions
Compatability
Check box text background remains white, does not match general background
Moving Selection and Time based run macro
VBA Question: Getting values from hidden sheets
Advice, help on code using winapi and month-calendar-object of Comctl32.dll
Find first blank cell
Error approching SQL server with DAO?
VBA to SOAP...
how to delete unwanted sheets
Timer which counting smaller than 1 second intervals
Problem with pivot tables
Future of VBA in Excel
I want to know if a row has been deleted or is about to be deleted?
Help with a macro creating a formula for a pivot table
XLA problem.
Missing Objects in Excel VBA
macros on charts that use fixed filenames
Macro : switch between excel and word
Output color to a text (rtf) file
Comparing password entry vs stored password - 2003
Sometimes range calculate doesn't work in macro. Why?
Avoiding duplication in objects with large commonality
HELP! input phone no from phone line
Finding existing manual pagebreaks
Label on one sheet gets captiuon from another
How to Get Folder Names
How to Cycle through open workbooks
Can I chart cells with values only........surely the answer is yes????
Is is possible to disable certain menu items
Help needed with Solver macro
retreiving multiple pictures from the office clip board
set datalabel font size for all charts in a row
excel and retreiving multiple pictures from the office clip board
UserForm help....
Best Fit Column Width
Random Sort
Underline if Cell Value is Met
Best Fit Column Width
what is >> filespec ??
How to go to next workbook?
Identify when a user attempts to turn on "Allow cell drag and drop"
password protection
hiding rows on worksheets
URGENT!! PLEASE I NEED to finish this by 530 CT
Need help parsing Text and Numbers
Algorithm to convert Column Letter to Number
Code that identify row number
Replace data from a specified column
Activating scroll bars in a text box on a userform
Open a file from excel-2
Help with programming
help with option buttons
Close the other application
COM PORTs
Increment variable not incrementing?
Speed
Need a macro
Lost VBA Project Password
Forms - Dropdown Boxes
lookup data in another sheet
MultiPage Parent Name
Coloring the duplicates with VBA
Hide my VB script?
Links and more links :(
hiding rows on worksheets
Updating Links
control box, macro security and trouble saving a file
Last cell
Coercing a variant into an array
Exel VBA
Hide Not e
Urgent!!! Is this possible
I need an excel macro to name ranges
Random Numbers
Very Quick Question
FileSearch does not work, XP SVP1, Office 2002
Writing value to worksheet cell
Problem with the following code
VBA extensibility library for deleting forms, modules, code etc...
Runtime Error 7, Out of Memory
open database method
RE: VBA extensibility library for deleting forms, modules, code etc...
Post to Public Folders
=IF(Values_Entered???
Working with two workbooks
VBA extensibility Library
XL2K Qualifiers
Identifying a value
exporting comments?
Hide / unhide column in VBA
Recovering from temporary loss of network drive - Excel VBA problem
Sequential looping
custom menu doesn't drop down via shortcut
Listbox and vba auto filter
custom menu doesn't drop down via shortcut
Very Quick Question
How to delete & import a macro
displaying text based on "TRUE" result from data comparison
Looking for <> empty cells
Filename Issue
Excel with Custom TLB-DLL - Cannot Add Reference - Help Please
circular reference code
Inadvertant Program Call
custom menu doesn't drop down via shortcut
=IF(Values_Entered???
range question
What is RunTime Error '1004'?
Search macro
Compare/match positve number against negative number?
Filename Issue
Script user id and password
Return Days since Date Entered in Column.
Macro question
Return Days since Date Entered in Column.
Default Directories
Running Clock
Disable macros
Default Directories
Access from add_in userform to main template userform....
Autofill to the left of data
Circular Reference Peculiarity
Multiple "Range" with "Cells" property?
HELP! input phone no from phone line
Controling Your Customized Form? Can I minimize it?
getting the column and rows from a selection
Restricting what a 'print' macro should print
Compare/match positve number against negative number?
Error '1004' in WorksheetFunction
Highlighting contents of cells
Working with Dates: Calculating A Running Total for Days Held
Multiple "Range" with "Cells" property?
How to capture row of a string value
Printing date range in excel2000
" workbook not saved " Message
Help with ScrollRow
How to reference to a number/a group of chartobjects?
Macro for multiple charts
Downloading photos tagged as XL
XL2K and Links
Programming Organisation Charts
Tool bar in excel
Need help getting started
How to Generate the Excel report By Using ASP
Need help getting started
HELP: Copying and pasting to Sheets...
Exif Information
Dynamic Arrays and Formulae
Text boxes and control source
Dynamic Arrays and Formulae
Change control methods
HIDE Workbook whilst VBA Form Open
Add cell content to another cell
HELP: Copying and pasting to Sheets...
Display Worksheet image on a form
error 50290 when working from dll
Dynamic Arrays and Formulae
Problems making a formulas in excel
Application.screenupdating is not working in Excel 2002 though it.
sort on coloured cells
Please repost ans to this one
Cross-Workbook Data/Function Referance
Office97 Objects will Not Run Under 2000
Copy and Paste from 1 sheet to another
Save and Close all Open Workbooks using VBScript
Disable a worksheet so user cannot mess with
Disable a worksheet so user cannot mess with
Workbook
Opening Multiple Files
Auto Filter
New offering: Class to handle multi key presses in sorted list
Please Help-sorting Data
UDF's
Findfiles finds(?) phantom files....
Pasting a portion of a Merged Range
How to enter the phone no. while the phone rings?
what is the best way to hide code in excel?
Filling form text boxes from cells. Incredibly simple I know, but I'm new. :-(
Attaching Files to Emails
insert row
Sort an Array
Text to Columns using VB
Is a folder list extraction possible?
searching for a value...
Text to Columns using VB
MODAL vs. NonMODAL
using research pane
range select not working with small sets
Adding won't work???
Using Multipages in a Form
EXCEL: Find data in worksheet and create a new sheet in same workbook
Get Top rows
Display Worksheet image on a form
Adding months to a Date in VBA
How can I simulate menus through macro (Visual BasiC) ?
This should be simple but...
where to get solver patch?
Directly setting variable to formula
Auto answer - "Do you wish to save changes"
Using code to create a control on an Excel userform
data validation format loss
Excel ADO Crash
VBA in Excel guide
Working with Dates: Calculating A Running Total for Days Held
Hiding an SQL connection string in an Excel macro
Copy cell row
How do you add the warning pull down next to a cell?
Print Preview Screen in Excel?
Returning a variable from a sub
How do I delete a query off a sheet???
Lost VBA Project Password
Application error when attempting to write code to a workbook
Run Macro on Cell Click..
Help! Excel pastes in "shape" format
Row from test value
Pivot link to database
modifying code in run time
Macro to add Row each time PN chgs
Avoid re-running code in Worksheet_SelectionChange
SUMIF in VBA
Data validation
The evil Template Wizard troubles me... even in my sleep! :(
Running Clock
Returning a variable from a sub
Moving out Portions of Text from a Cell.
row disabling upon check box click
Add_In VS Reference
Error '1004' in WorksheetFunction
Calling procedure from another WKB with parameters
Running Clock
Two Quick Questions
Excel Crash on start
XML Spreadsheet
Transpose
Change Sort order Temporarily
Run PPT code from excel
Re: Run Macro on Cell Click..
TEMPLATE FOR ACCOUNTING?
Coding assistance needed.
Replace text given a value in other cell
Check to see if Excel has closed
Controling Your Customized Form? Can I minimize it?
vs.net 2003 and OWC Spreadsheet question!
SUMIF in VBA
Recovering from temporary loss of network drive - Excel VBA problem
Convert Columns to Rows
Working with text boxes!!
Error in macro creation
2 macros in one field
If statement not working properly
ActiveWindow.SelectedSheets.PrintPreview
Sub to aquire list of worksheets
How do I delete a query off a sheet???
2 strange ones..
Sub to aquire list of worksheets
Sub to aquire list of worksheets
removing duplicate rows
Add new sheets with week ending dates
Averaging a range in VBA
ScrollRow
Error '1004' in WorksheetFunction
Excel invoicing
clear combox
IS(BLANK)
macro+email help
search for absense of data
Change Sort order Temporarily
Copy and Paste from 1 sheet to another
Sub to aquire list of worksheets
Login to a web page & automatically fill in pasword
Suspend window while Excel VBA macro is executing
Random Numbers Greater Than 65,000
HIDE Workbook whilst VBA Form Open
About Arrays
Using progress bar with existing loop
Please Help-sorting Data
Changin number when adding rows
Documentation of Excel 2003 objects
CheckBox open File
Shell Command
Excel Profiling
Open / Close Workbook Memory issue
Daily Macro to Download Data, Order and paste in order
Excel performance profiling
Creating Excel Charts using VBA
CheckBox open File
Reg fix or VBA for Off. Excel 02 Security Notice?
Rank for range with two criterion - hard
Largest sum of two values in wksht collection
Add worksheet based on textbox/userform
Formating some text in cells?
Macro Protection
Delete first character in ActiveCell
Forum and other site?
Combobox Query
Lost VBA Project Password
Transfering Data from ListBox to Worksheet
Excel macro help
Excel Calculation Not Completing Via VBA
Help with lookup
spreadsheet do not update
Worksheet is not updated
Corner Roundness
Find value, then Create a Range
autosum in VBA
Hide Menus on a Workbook opening
Excel Add-In performance problem
Looping and Offset
SUMIF in VBA
suppress system msgs in excel 2k
VBA 800a01a8 error - ideas?
Suppressing or trapping system msgs in excel 2k
Transfer data from List Box
COPYING DATA FROM ONE SHEET TO ANOTHEr
Menu Options
Run a sub or function on program start?
Send mouse click?
macro to copy absolute cells, then paste relative
Automation from VB6
Need to compare code in multiple modules to a master copy
Changing PageSetup Across All Worksheets
Ho do we solve this mathmatical puzzle
Another Worksheet Linking Question
coloring issue
VB help
Adding time to script
insert cell contents into page header
Lotus notes message sent vial excel macro
Can't get HLookup to work in VBA
Previously Posted...Need Help!
Writing value in cell in another sheet
each 15th row
Fuzzy Matching
MultiSelect ListBox
How recover location with vlookup...
Range definition problem
search for absense of data
Excel 2003 and Hummingbird DM5
Does anyone know how to establish a DDE with Peachtree Accounting.
LeftFooterPicture instruction does not appear to work
Column find code not working correctly
Microsoft Query security
every 15th row - formula
convert time
VBA n00b :\
Lost VBA Project Password
printing multiple worksheets with different specified quantity.
how can I see if an array contain a certain variable?
Wanting to add best 3 out of 4 numbers in Excel?
excel pivot table linked to external source
Excel Automation Problem with Late Binding
Hyperlink burned to a CD doesn't work
Re-initialising Excel calculation settings
VS.NET 2003 .DLL used in Excel - works on my machine, no one else's
Function in a Teemplate
I need a macro that will insert names in an excel worksheet, the .
can i send a network msg in visual basics?
Macro speed capacity on HyperThreaded systems
Excel / Visual basic question
Two Quick Questions
Pivot table order problem
updating add-in references from command line
#NAME? Error Fix?
Dynamic Arrays and Formulae
Compile Error: Method or data member not found
Selecting & Pasting Dynamic Ranges
Interesting problem
Registry Default File Location Prevents Shell
One more and I'll finish this complicated macro
range.find method called into a VBA function (problem)
Import partial record from text file string
Programatically changing the chart datapoints
word triggers date to change
Need group all sheets in a workbook
Interesting problem
Help me to convert Excel to XML
Change while loop from count to formula
Help me to convert Excel to XML
Aquiring Directory names
It takes 24 hrs to run: with counter 3 mins?
custom templates
custom templates
api viewer
Help required with code - Automation Error
How do I set up auto-numbering on cells?
A macro to tell excel to input to next empty cell
Can I only recalculate a part of a worksheet?
RANGE in VBA
Looking for Lotus 123 menu equivalents
Problem With Links
organize the data--Help!
Prompt for Value
Manual Recalculation
Prompt for Value
printing via vba
VB Editor in Excel
Prompt for Value
data to file
Macro Scheduler
simple? question about ranges
"FIND" generates "Type mismatch" error
Aquiring Directory names
Two Quick Questions
Compile Error: Method or data member not found
Macro Protection
Re: Macro Protection
User Defined Fuction Returning Range Help
cell to file
Convert Excel to XML
How do I solve Error 2902
set color (vc++)
how can i exports or save picture out of excel worksheet
Change while loop from count to formula
xlm solver commands in excel 2003
XLA function called twice
Passing a handle from Excel to a dll
Crating new sheet at determinate time
VB6 COM Add-In and Modeless Dialogbox
filename
Opening Variable File Names
How can i create a macro in excel 2003 that will work in Excel 20.
ISERROR Formula
Compile Error: Method or data member not found
VBA / Pivottable / showdetail - problem
how open dbf in shared mode?
How to copy a worksheet without its code ?
save command
Can someone explain to me? Pls?
Hyperlink Headache
View Macro Code
A macro written by a macro
Font strikethrough
translating worksheet formula into VBA
copying text via linked cell from combo box to macro code
Add data from another spreadsheet
code to identify matching text
Data Entry in the same file by 2 computers
hiding formula bar
Re: what's the best book on Excel VBA?
Excel addin problem
Can someone explain to me? Pls?
Animation
Freeze Panes
How Do I Select A Cell In Another Workbook?!
How to determine which function is loaded