Excel Programming [Archive] - Page 106

Calculation mode retention
Excel VBA ".value" / Strange Behaviour!!!
Delete Blank rows
search a string and strip out ONLY the capital letters
Interesting Office 12 information
Textboxes
delete dulipate rows by checking each and every cell in a row till end.
Reference Class Module in Access from Excel
use somebody else's self certificate to sign a macro
Code to pull the value of a Cell of the next Worksheet to the left
SOS-How to pass array parameter to Workbooks.OpenText(...) in VC++
Protect file name
Code mistake
Help with ROUND
testing for open workbook
how do I edit a record in database
Can you Lookup/Match then copy formating?
Using code from custom menu bar to a Command button
Launch "Browser URL" when Cell clicked
Full recalculation when opening a workbook
Switching to a tab in the worksheet
Formatting for Degrees Minutes and Seconds
Placing a code before Save & Save As
To complete Progress Bar indicator level to 100%
range copy question
Adding extra email address to a single Worksheet
Documentation for Investment and Trading Systems including Excel V
check contain value with macro
Missing library or project
Worksheet Data Sorting
Sudoku puzzle template
conditional format with hex2dec
Code for scrollbar to go to top
Q: copying PageSetup properties from one worksheet to another
Test cells within Range("S16:S19) are NOT Numbers
Excel PageSetup failure when not logged onto server
Change dollar amount to a negative if another colum has a "P"
Global variables - where do you place them?
Worksheet_Change or Worksheet_SelectionChange
Target.Address Doesn't Work in Excel 97?
Please Help - "SOS"
Retrieve MS Access DDB Property in Excel VBA
How to protect VBA code in Excel through C#
Autofilter/xlVisible problem when counting rows
Create/copy combo boxes in one range if condition is met in a different range
VBA module/function to generate random numbers with specified mean and SD
# of sheets in a new workbook
Password protecting sheets through VBA
issue with concatonating string exporting to excel through C#
'Loop within a Loop'
copy data to master sheet
Finding read-only & pwd protection attibutes of Word & Excel files
This query cannot be edited by the Query Wizard
Launching a batch file
Close form instead of hide
macro to insert row, copy cells and keep hidden columns
setting FaceID problem
Focus after combobox
Set-up Automatic E-Mail
Reference drive letter that can change
Macro for aligning duplicates in XL97
Change event - checking dates
Using macro to do same task with different cells
Why isn't my pivot table formula working?
.FaceID
Crossing Applications - Possible?
How to make a button VBA code reference other VBA code subroutines???
Looking for range values in another range/sheet
CHOOSE TO STOP A MACRO OR NOT
creating a function
Calculation / Iteration
Can I lock the selection in the pivot table?
Code Signing of Excel VBA projects
returning values from columns to another sheet, based on conditions
Dynamic Grouping
Horizontal Cells changed to Vertical cells
Months
Advanced issue; second instance of Excel will not go away!
Programatically control a shapes TextBox
Run Time Error 5 - Invalid Procedure Call or Argument Q
functions
how do I put in 2**X
Is there a more efficient way to do this?
Calculation problem
Toggle Code
Copy Cell Routine (FAO Tom Ogilvie)
Command Bar & Workbook Deactivate
Select case statement - it will not work and i dont understand why! :o(
3 Questions - No Answers - Help me please
move cursor
Check if unicode was installed.
SendKeys problem
Calculate active sheet on sheet selection
Excel VBA connection to SQL Server using ADO
Getting info from word using macros
Calling Edit Buttom Image?
Copying values from one file to another
referencing last non-empty cell...
flashing text in Excel
stock level teaser
Macro to select various cells
MACRO TO TRANSFER DATA IN EXCEL 2000 PRO TO ACCES
ISBLANK for a Range
Copying across multiple files
Countif cell has shading
I keep hitting F1 by mistake
Cell reference dependency
problem with coding
Rebuild Array-formulas
dienstrooster
xxxxxx
Code Only works when sheet is in focus
Code needed to test if user clicked a button
Can i get rid of an error message
make email add forward the work sheet
Copy problem with cells which have Wrap Text property specified
How to set a column to accept only a specified number of digits
CodeModule utilization problem
RTD server performance
issue with pivot-tables
Running & maintaining macros remotely
Pivot table marco problem!
XLA makes XL2003 crash
XLA makes XL2003 crash
Importing a text file
why VBA. ?
How to pass FieldInfo parameter to Workbooks::OpenText(...) in VC+
Simple Error Checking
Calendar Control 9
Remove the module
Dropdownlist in a Cell
How to prevent datalabels overlaping each other?
Macro for Control ListBox
Problem with a date using Mail Merge
My Data Table
Import data using macro recorder
Automatic nameing of ranges based on a label
Need to insert formula to a variable number of rows
Opened Workbook
Create Charts using VBA with different X and Y values
Help with VBA Macro to automatically copy/paste as Values
Select a Cell - Move Row to the Top of the screen
Avoiding page breaks across merged cells - Code not working as expected
Duplex Printing
Populating a dialogbox
Call to Re-Named Module [to match Sub() name] fails ?
Copying Cells
User form and hiding worksheets
Chart is Upside Down
Residential Builder Gantt Chart in Excel
Run-time Error'91: Object variable or With block variable not set
Loading a calendar (user form) from another project (personal.xls)
Locked Property Error
Replacing Non Printable Characters
Detection of Macro Code
Can't set Chart's SeriesCollection XValues
Password Protect Running of Macro
Clear Combobox from forms toolbar
Display a message in a worksheet
VBA - Identify Begin/End of Cell Ranges
Create a formula to fill in a date series without using
List Box Question
Q: Open VB - Editor from macro...?
Inputbox question
Stupid, stupid question....
Is it Possible Q
VBA - Line Numbers ?
Permutation in excel
Round variable to 4 decimal places
consecutive cells
league table from results
Checking for valid dates on entry
outlook express email question
Shift data from row to row
To populate a column with a date
Macros from German excel don't work with English version
How to create a variable from a calculation
VBA - Open Folder Where .xls Resides
Add Time in Filename
Can you test for a range (Q16:19) any cell is ISBLANK
excel formula to recognize overtime in a day as you prep schedule
Delete Comment if contents = "HIDDEN FORMULA"
Sub() calling Sub()'s in the "worksheet event code” passing toggle
userName
Moving display of comments closer to parent cell
Clearing Checkbox
VBA
cell color
dropdownmenu with additem
Refreshing Object Properties after "Set"
Looping macro
create a macro for a combo box to change a pivot table
Emailing with EXCEL
where do i find a list of macro keywords
PESONAL WORKBOOK PLEASE HELP
startup
search question
How to assign 2 letters to automatically input a sentence / excel
Can I convert Lotus macros to Excel?
Reposting: Drag And Drop Implementation in excel
Toolbars Disable/Enable
trouble with row selection
Copy certain columns to another sheet using a macro
database query to upload a dbf file
number formatting based on cell value
Excel's VBA Help Topics
validation list with comma values?
Indirect equivalent in VBA code
How To replace If Q
How to assign value using a Char Codes?
Formula: How to write.."if A2 is blank then b2=today's date?
Save Changes with no change to save
Drag And Drop Implementation in excel
Problem with the Web Query
Hiding scrollbars in active sheet
Max number of sheets in workbook
SQL practice with Excel?
Question rather than a query
I instruction to move to a different Worksheet
Please Help!!!! If statement, lock and unlock cells
Crrection Help for a macro to locate max value cell
Testing 2 conditions on an IF statement
Will using a "personal macro workbook" slow down my other VBA code
Resetting Page Number in Excell
My variable always says False when I set it to True?
Popup commandbar and Setfocus
ScreenUpdating function not working?
Sum If in VBA
Different Returns
Charting Problem
Lookup Ques - finding value within a string to lookup
Drop down box
Close Workbook if Macros not enabled
sheet builder macro
Navigate a worksheet when under control of a macro....
Sum if in VBA
Syntax of hide/unhide personal.xls toggle
My guess it's a simple quesion, but I'm a beginner
matching multiple rows
Code Question
Can you paste file *NAMES* into Excel to form a database of them?
Rounding Up For Retail Pricing
Problem with calculating
sequential number breaks
Complicated sorting
excel vbe scroll range - how to save?
Set MyPath variable as workbook.path
Syntax to select all data
Excel 12 - Information Released
Help. Find in sheetB a variable value from sheetA
File Saving
Auto Open file VBA Refresh MS Query Save Close
Clear unactive combo boxes
Run-Time Error 462
For you JIM, 19/09/05
Excel Combo Box
VBA to Concatenate and Autofill??
Is this possible......?
Assigning numeric value to text in drop-down menu
declarations
Assigning set of range names
Copy highlighter
First & Last
Closing Hidden Workbook when Active Workbook is Closed
Excel VBA with outlook
insert blank row when cell changes
Excel VBA, Loop, array, cut and paste
Automatic query data refresh with template-- system or file setting?
How to avoid excel automatically detect the cells formatl???
How to refresh a web query every x mn?
Supress dialog box for missing linked file
Format as fraction - why doesn't this work?
In execel how can I convert dates from yyyymmdd to mm/dd/yyyy
excel limit data entry range, control cursor movement to 2 cols
How to pass sheet reference to a procedure
Personal.xls
Start Windows Explorer from Excel
Edit Text in Formula
Macro to subtract data from cells
changing a recorded macro - date problem....
Excel Explosion
Excel OLE in VC++;AutoFormat Method
Delete Userform
Copy empty cells from one workbook to another - Code
Converting from US date to UK date
Replacing references from one file to another
Changing a cell to the same tab index color as it’s value
Retrieving data from not opened Workbook
Copying range to other workbook
Re: insert text to a specific cell
Help me Someone!!!!!
Re: VBA Code req to close all workbooks
Change Text Case
insert text to a specific cell
How to create a Pivottable from Textfile
VBA Code req to close all workbooks
Determining how excel was started
Simply DLL in VB.NET and using it in VBA
Moving rows to another worksheet based on content of cell
ActiveCell.Value changes with Format?
Controlling VB executable from Excel File
formula
Outlining with condition?
create a chart without set range
Delete rows that do not contain a list of values
Arrays in macros
Excell Programming
Cell color
Creating a new excel file programatically
Inputbox Convert Millimeters to Feet and Inches
Fill.backcolor and forecolor do not consistent in Chart and Shapes
Re: Vlookup in VBA?
Vlookup in VBA?
Tring to look this dynamicaly instead of manual code.?
changing drive letter in custom macro toolbar buttons
Shet Number Position
How to test Worksheet exists before trying to create it?
Excel sheet contects are to be formatted into some specific format
Macro for one-click paste special transpose
sheets count
Email Help
How to create Help Text?
How to specify a cell format for pivot data field?
Calendar
Copying sheets from ListBox of names to a new worksheet
Locking VBA module so view only
converting CSV to XLS for online download
Parsing Arguments Question
Need a list of command button face ID's (images)
Opening a file to a dynamic sheet
Range Definition in Macro ?
floating toolbar
Return top ten results
Two situations in the same column
Lookups
vlookup retaining data?
counting consecutive repeated values in a column along with the range
Prevent printing of some sheets and not others in a single doc?
Pull Down Menu Macro
how can I sort on the column selected by the user?
ComboBox
Find Cell Contents on Another Sheet in Workbook
Combo Box - Please Help!
Worksheet Parsing of Rows Based Upon Column Value
Setting a workbooks protection/read only/locked
Sumproduct to count
Object Postioning property not available for control
Automatically email co-worker when a range of Excel cells change
setting ComboBox Control font
how do i create a button to clear a value field i created?
I want to pull out certain address in excel and put into a file
update control source value
Input box opens hidden worksheet
listbox sizeing problem
Problem with Name of Excel Chart
ADO 6.3 compatibility with 6.0?
reading data from 2nd file in 1st file using Combobox
Copy empty cells from one worksheet to another
Concat Variant Values
macro help
How do I check if a text value is repeated in a column (Excel)?
Can an Excel query retrieve information from AS400 database?
Can an Excel query retrieve information from AS400 database?
'Out of stack space' error on SaveAs
Why does this simple thing not work?
Detect if a cell value is a formula
last day of the month
How do I copy all of excel file including header
Can somebody explain to me how Bob Phillips' unique record counter works?
Copying toolbar
How do I send a macro and toolbar to another user?
How can I get a cell's comment moved into an adjacent cell as a st
validate controls
Delete cell contents that contain numbers and not formulae ...
Reading a color, and setting a value
Event Procedure - Pick List Choice Unhides Worksheet
>>> Programming with symbols
IF Statement for Combo Box List
Range empty?
Dealing with 3 Printer Ports
cannot connect to .mdf database
Multidimensional Arrays as Properties in Class Files?
Looping through Excel Applications
incorporate string variable into VB code
copy/paste
Copy empty cells from one workbook to another - Code
Excel VBA: How to track changed cells
Relative Referencing Formulas in Arrays
Code execution has been interrupted
Excel not responding. Only works if I run split macro in 2.
"Slidey Bar" for Code Progess
Cannot open file for output
Pass Combo Values to an ODBC Parameter........
Copy Locked Cell Status
Manipulating clipboard?
How do I toggle a button across a range of columns
Constant in Formula
PageBreak problem. How to improve performance?
Fetching datetime/user-defined field from Excel?
Automation Error and Document not saved
Finding a value from another workbook
Macros for calculating the range
Macros for calculating the range
icon problem
Can I create a List Box that ties to a macro?
get range of cells based on colour
Drop Down List
Can I make the arrow on a List Box show all the time?
table grouping
Duplicating rows across sheets
Excel on the Taskbar
Hide excel, display userform only
userform startup splash screen
Count numbers within a row
Force Macro Enabled
Filter list in place if a cell has a keyword within a formula
Call an XLS that is one directory “UP” from where the VBS file is?
automatically update money central quotes
Find any number within string
RE: VBA problem
Pop-Up for Range
word OLEObject in excel
Save file with time date stamp
RE: VBA problem with excel 2003
Rotation property?
Edit text of formula
Font size test
Open File with name incorporating ~yesterday's date
Creating a dynamic Worksheet name?
Function () that manipulates other cells
Passing chartobject as a parameter to sub
User function argument question
VBA password problem
Copping cells EXACTLY from one Worksheet to a new Worksheet?
hide rows with macro/togglebutton
2 comboboxs, different sheet references
Running Monarch from within VBA
valuation formula or macro
Need help w/ macro creating a chart
show list of wbooks present into a dir
Can you import data into an Excel Calendar Template?
trigger event if any data in modified on ONLY the current workshee
Clear cell based on shading
Import from mainframe
Multi-Dimensional Array Let & Get
worksheet projecting month to year service contract amounts
How do I merge entire columns without merging the rows?
Email from Contact List
Userform Date
Combo Box of Control Toolbox
Passing parms to a VBS file or a macro when executed?
i need help plz
Initialize Userform, Populate Listbox, Dynamic RowSource?
VBS starts Excel. How to point to different macro when run?
Excel Securyty, ¿eh?
How to sort on the row selected by user?
Manipulate pivot tables in VBA
dynamic range question
checking for cell value when exiting
How to ask VB for the last cell modified???
Macro Help Please
Activate "current workbook"
Macro to change worksheet page settings VERY SLOW.
circular reference when using a UDF
VSTO and Excel--End Cell Edit Mode?
TreeView Help
If statements with drop down toolbar
Master workbook
Less than numbers issue please help
for each optionbutton
3 unaswered questions,1.customized format 2.button question 3.Open
Column showing "overdue"?
cannot make the excel fill in/delete cells fast
Sum Column
VBs scripting for calling excel sreadsheet
Copy a directory
How can I get an excel macro to close without saving !
Runtime error 424 - Object required
Can't find messages
Change desktop icon
Letters and numbers only
Controlling the windows taskbar from VBA (API example)
Upgrade problems with 2003
EXcel with VB6.0
Selecting rows based simultaneously on 3 criteria
Parse String into Variables
Which info to change in my macro?
Identifying Text
Dynamic File Loading
Test for file path, alert user and close workbook
formulas to macros
working on a selected file via GetOpenFilename
INSERT INTO sql statement causing error
File Open Multiselect
Deleting all rows after the last active cell
link between list on same sheet
Adding code to a control on a form causes excel to crash
Save a File with a cell value
Adding code to control on form causes Excel to crash
How to show old macros?
Conditional Text?
Send a Fax via VBA
Placing Workshet Name in cells
iterating groups?
delete hyperlinks from graphical objects in excel sheet
VB FILE LOCKED?????
timer in Excel VBA
word object in excel
Remove hyperlink from a graphical object
Create a folder from excel
Excel97 macro to archive Outlook mailbox
Copy Last row UsedRange to next row
How to rearrange order based on dates of inputs?
run macro on selected sheets only
Where are the hidden macros?
How to determine full path of table by a macro within it
Autofill
Copying data into alternate unprotected cells in another spreadsheet
VBA Code to extract records between a date range
comapre 2 col.
copy and paste to different work book
Find Function
Formating Print Margins
locating the cell having maximum value
incorporate variable into VB code
Automating file opening and saving
How do I use VC++6.0 to protect a excel file to readonly
Excel saves CSV using semicolon(;) instead of comma(,)
Protect multiple worksheets in a workbook at one time in EXCEL.
Close Workbook
Excel Macros in XML
Thank you
Very slow macro
Where to find the best URL for a Excel/VBA COMMAND REFERENCE URL?
Function - Malfunction
Why would Excel change position of control buttons?
to find the last column in macros
Help; When protecting the Workbook, tab Macros won't work
Multiple SendMail Recipients
copying problems..........
IF IS NUMBER THEN
Macro to change row number within formula
Size of arrayformula with VBA
macro linking to excel
Is folder accessible?
insert alternatives combobox
On MouseOver for Cells/Sheets
Message box to confirm action
HELP! - how to set in spreadsheet to be used by only one user?
Should Method Belong to the Class?
Date Value auto filled in
sub for deleting data on a sheet in a range
Keep contents in clipboard
Dueling programs
Getting macro to record keystrokes instead of cell contents
having a macro insert a comment
Email Syntax error
How to remove " via vba ?
Logical Testing
Nonsequential column numbering
storing data
THIS IS A BUG
Opening/Closing workbooks without dialog boxes
More Excel VBA and Access
Access and Excel VBA
change cell color..
cell size and find increment
Can a file know if opened using a program?
preventing reference to a particular cell
auto-export VBA modules
sendkeys examples in excel
Personal.xls
removal of delimiter
Need to Save Excel XML as just Excel file for user to open in Excel 2000
Placement of Chart in Worksheet
help with retreive print
Positioning a Button
Excel Sub-Totaling not Compiling the Total Lines in Proper Order
Problem trying to make my DLL callback a VBA function with paramet
Copy rows across sheets
buttons
Find and loop
Creating Msg. Box
Macro to open a workbook
Conditional Formatting type of operation
RE: Transposing Sun and Moon rise and set times...
initial worksheet
Run Module1 first then automatically run Module2
how can i define initial worksheet
Colour of commented VBA
Unique Values in a list
Prevent Save in Excel 2000
Help with code
Form Issue in VBA
HELP with inserting formula
Trouble creating DSN-less connection
VBA Hiding Rows
Auto Run Macro Upon Entry
close code
VB: moving data range
Logical Loop
Browse dialoge
57121 error, but not a Mac in sight
VBA Code Recompilation with new version of COM Dll
Distributing elements forming n groups
Access library
VBA Code req to select Notes or Outlook
Recalculation
Conditional execution
Copy Condiltional Formatting using code
Workbook tracking.
Drop down menu for navigating between worksheets
transpose the code from "rows" to "columns"
Receive soap attachment from JAVA to VBA
Renaming a sheet
Cumulative Time Problem calculating more than 24 hours.
can I use excel vba to write tables to a mysql database?
Returning a value dependant on a cell...
Use part of string
Look Up Available Speakers
Copy data from diff workbooks but without opening sheets
2 different functions on Double Click
dos
Difference operator in Excel VBA
Goto a form in MS ACCESS
How to access live data
Want to Open Windows Explorer With an Excel Macro
WHAT's THE RULE?: Use of apostrophes(" ")
finding the row value of a defined name
Write headerhandler to decompress the attachment
Unhide items in PivotTable
micro programming links
Excel ODBC query tables memory overflow
go to sheet1 to sheet2
Email challenge
Exporting a worksheet as a static image
Find text and move it to other cell
Multicolumn listbox data display
BeforeDoubleClick Cancel=True not working
Know when XL loaded from Outlook
Data Selection Page Links
Help with copying a drop down box
HELP - 'Named' functions
Shrinking an Excel File
Macro Help!!
Interrupt While loop
Best fitting curve
Macro to move the contents of a cell
'Named' formulas problem
Email Range of Cell Content to create subject and body from link
Update Value Message, Getting Data from Other Excel File
Before_Save event
Ordering Lists
combining rows and deleting easy for u experts
Finding Specific Data and modifying it
know possible, but have no idea how
Mass population using a macro or something else?
Add-in failing with different install drives
multiple files from one file
Create a macro to Open Hypenlinks
Running a query from an open workbook
synching two lists
need help converting rows to columns (not transpose)
Cycle through a MultiPage Control
Copying cells from on sheet to another sheet (via sheet module)
Use of a Key line
Id
Run procedure in Personal.xls which needs name of calling workbook
Copy module from one file to another
2 excel windows
Time error in user form
Data Validation Issue/question
My command button has stopped functioning
What variable would I use to aquire Today()
Transposing Sun and Moon rise and set times...
Total sum based on file name
combination macro
Help adding info from Multiple Books to 1 sheet.
how to assign sub routines to events
Need to Save Excel XML as just Excel file for user to open in Excel 2000
How to detect if there is change in any cell vlaue in a worksheet?
over 65500 cells?
Macro to modify a macro
X marks the spot
Turning off automatic calculation when opening a CSV file
Odd fill down formula macro question
Find a specific word in a column
ControlTipText Questions
VBA Script in Excel Stalls Out On It's Own After Opening Secondary Excel File
VBA Script in Excel Stalls Out On It's Own After Opening Secondary Excel File
2 excel windows open
SQL query a workbook -> too many named ranges?
Checking before opening "activate:newwindow" to see if already opened
Turning Excel Worksheet Linked to Word Document into Report Templa
TextBox ControlSource
Remove all borders from a range
Wait until MSQuery Refresh finished
SendMail error
moving around a sheet
Run Time Error for Vlookup & Match command
Body for e-mail using sendMail
Copy selection based on relative reference
Excel Search Filter
Repeat F2
Updating records in an Access DB
Need to know what cell called the custom VBA function?
Decoupling the source of a Chart
Speed Up A Macro / Delete Worksheets
C# .NET Excel development and Internationalization
All uppercase characters
Formula error
Pro-actively run formula
Paste Conditional Formats
Can you Copy a Chart from a Website into Excel?
Macro Help
Help! Query Refreshing
veryhidden with xl2000 & xl2003
Web Query
Printer Setup Dialog Box
VBA Help needed copy a worksheet to a new workbook
Copy cell contents using Input Box
Index & Match w/ VBA
Bitmap manipulation from VBA/VB
form location on sworksheet
Help Needed copying a worksheet to new workbook
Xla with activeX crash in XL2003
Scroll with active input box
How do I calc interest using 2 interest rates in 1 calendar year
APPLICATION.RANGE EXCEL
Set Calculation Mode to Automatic without calculating
Delete file if file exists.
two consescutive finds
Save as Text (tab delimited) problem
Challenge Converting Non-Contiguous References
Worksheet_Deactivate() problem with deleting data
Apostrophe
To copy data from different workbooks
diabling the macro alert in opening files
Entering Formulas in VBA
Right-click Combo Event
Worksheet_Deactivate() problem with deleting data
FAN Charts
2 pivot tables in one sheet
Excel icon
Code for Sending files using lotus note
optimize coding on named range
Populate a Combo or List Box
"Selection is too large" error
range in a table form
Formatting portions of a cell
please help!
Is there a way to test first if MySampleAll.xls is already open
Pop-up Alert Help
Why would FIND not work as a batch file in a DOS window?
text in custom toolbar buttons
Excel-sort paragraphs in a doc(s):egAll on heart on one page?
no worksheets are visible when I open a file by a right click
One solution solved one more to go… Loop & Cell variables?
Macro to randomize and delete accessed hyperlinks
Newbie Frage: How to macro-out the daily numbers??
Is it possible?
Extract Data Between Cell Ranges
Auto run a macro when a date/time has occured - any thoughts?
Toolbar Reactivation
Moving cells and deleting rows
Calculating Dates from Non Leap Seconds
is it possible?
'combine' question
Formats of the Row above
formula through vb code
Coding question
IF statement
copy colomn by code
application.activeprinter and network device
MsForms.Control Event Class
is text capital
Can Someone Please Help with this Looping & Match Macro
Control Panel-Dual Display API
Select Case
Languages support in Macros
XY Chart Labeler
Is This Possible?
Timer Question
Excel List Sorter
a count function
Macro Help Please
If Question
convert Bullen PastePicture to VB6 ActiveX dll?
Code to automate exporting to a .txt file
Alternate shading based on series of numbers in 3 columns
cell color
Invoice
If cell contains a pattern delete the row
Copy Macro.
how would you change these....
Simple Function HELP!!!
get the line at cursor number in the module
VBA Array Function
Option Button/Focus Problem on Worksheet
OptionButton in a Form
Find and select maximum value in a range
IExtensibility Click Event
find the data
How to branch?
Some real (in my mind) programming
Import data from Web cvs format
how to save a file from a diaglog box using VB or VBA
MS Word Programming
Number doesn't want to be a number
Help with search and Replace
Argument for contain instead of equals
Upload to bank account
Select Cell based on Variable address
Using names ranges to set print area in a macro
Error 336
delete the copy of row to another worksheet when date is deleted
textstring to worksheet range
FileSystem.RMDIR
Clean/replace textstring
FileSearch filter
Custom Sort Problems
triggering macros
List conditional formatter
List conditional formatter
using a calculated column value within a range
UDF Returning an Error Value: How to?
Exporting to a .txt file - VBA Code
upload data from a dbf file
Set Cell Fill Color
how to hide something with excel
Date stamp after value select from listbox??
Unique problem with recorded macro
startign with VBA
Nesting if then loop
identify city, state zip
Need to create unique list from list of multiple entries
Naming field & replacing characters
simple question
Summing duplicate entries and non duplicates
If Then Statement
Worksheet_Calculate Question
Please Help Me With This Code
Executing a macro from pressing a shape
Please Help with this code
Effective method to compare worksheets?
Memory Usage In Excel VBA Programming
Memory Management In Excel Programming
Why is the Excel Addin the Activeworkbook
Auto_open not executing
Buttons
Modify Command Button
Event Procedures in an Add-In
Textbox Info
"ByRef argument type mismatch" Error
assigning a macro to a cell?
Re: Wait for user response
Wait for user response
Challenge Converting Non-Contiguous References
Dynamic Columns in Named Ranges
Weeknum
Querytable results into vba Recordset
Matching rows of data using number.
navigation macro freezes
Iterate through a form
List of property names and values for a given Object
Can I Reference a Cell “Number” Dynamically?
help locating first empty cell in a column
Creating a userform to import files
Listbox - Store values
Macro to convert data
Determine if XL file opened from Outlook or a saved file
Create a mask inside a textbox
Reading data from a user form into a sheet
Make VBA sub available to any workbook
Range Selection
What would be Excel's equivalent for a Lotus line "[Input].MoveCellPointer $Right,1"?
Is this worth a try
Programmatic cancel of shortcut menu
Popup calendar
How do you rename Multiple files using text from a cell in the file?
Range Selection
Renaming Worksheet
Column Width property does not work
Entering data on differnent sheets in WB
Forcing display of the full text of a cell
Myrna Larson, locate??
Moving an email in Outlook with excel vba
hiding toolbars for my workbook only
reading a formula and pasting it
Page Numbering Offest by Two
Cell colour chg when formula results equal a weekend day, i.e., "Saturday" and a date that falls on a Saturday?
Macro runs slow
code/command to count the number of fonts
Use the Option box value in a module
Populating a multi column listbox with ADO Recordset
How do I 'move' cells from one workbook to another?
Is this possible: Parse a Cell
Goto an Access Form
Permutation in excel
Half of Screen Turn Grey
Where else to get help?
User Form
Using a Formula to get Range of Data to an Array
Find sheet references
How to display map that user selects region
"Indirect" reference to a cell in a code: how to do it?
How to set date cell when its row changes
Help With a Variable Formula
listbox
AddIns making macro available all the time?
Listbox
No menus, no toolbars, no nothing!!
sorting error
CopyPicture only works second time
Newbie Needs Help
Absolute addresses and ranges
Calling stored proc with parameters ..
3 dimensional array
macro to change a name of a hyperlink
Lock cell selection cancels UserInterFaceOnly
VSTO2005 - HResult Exception obtaining Range Object
Hyperlink
keep previous result when change, urgent
Day of the Week from Date
Replace a spreadsheets named cells/ranges with exact cell address.
Replace a spreadsheets named cells/ranges with exact cell address!
Sheet name to string variable
Permutation in excel
how to use a cell value as the base for the name of a variable
Loading AxSpreadsheet from a .NET resource
To repeat data row after row.
I need a macro to run when a cells in a specific column ares exited...
Distribution loop
Drop down list with search-as-you-type behaviour
Macro Problem
Excel and Asp.NET
Need Help on Making a Loop
Automatic refresh on opening required
ADD, RENAME AND DELETE COLUMNS using ADO
Validation, drop down list
find first o from right
Opening an Excel file in OWC10.AxSpreadSheet
This one is WEIRD!
Combo Box Scroll Bar
Shell Function - Execute DOS Command
How do I set up a bowling schedule for an eight team league
Macro crashes if option "yes" is not chosen
UpdateLinks
Transposition of Text Data Assistance Needed
What's wrong with my procedure to show tabs?
put value into cell after return from macro
CommandButton Code
file search in subfolders
Looping through range names
Document not saved
Entering current date and time
[Group] Workbook?
Copying Row Heights, or Complete Rows
Radians to Degrees
Clipboard Problem
concatenate + format color
Referring to named ranges in a macro
Creating a Custom commandbar button
Creating a Custom commandbar button
format column to text
Listbox value
Loan amount fx if interest rate, payment and amortization know
Programatically Changing Hover Labels
Cell value & hyperlink
Hopefully easy prob for an excel expert
Walking Through Cells Using a Loop
Where is Clipboard
inalRow = Range("A65536").End(xlUp).Row
Range problem
Copy protect utility for a workbook?
I am an idiot - Please help me!
Run out of resources .... loop to new tabs
Controlling the 'cancel' button in xldialogprint
Sizing a chart
Populating Specific Lists Based on Criteria
Extract the maximum value and copy the entire row.
Macro - Final
Auto Populate fields
action on cell activate
Macro to delete blank rows
Macro security
ListBox
bad at using functions ...
Regular expression searching problem
How do I make a cell's contents equal to another cell's contents with macro program?
Please help!
Formating number to fix length
Entering Data
Neutral date format in VBA
How to know if Excel is called by another Office app like Word
List Open Workbooks in a combobox
Loop to new tabs
Addin macro to delete names in current workbook
Help with Userform Needed
Error when executing 'Charts.Add' command