Excel Programming [Archive] - Page 98

how to create xls from CSV files
How to evaluate a blank field
Moving Rows Up - based on contents
using Find instead of VLOOKUP in search
overlapped functions in vba for excel
Trying to use cells as a variable to calculate(count) an array
Object variable or With block variable not set
Time stamp macro to capture changes from one workbook to another
Macro to email a subset of data
filtering in a workbook
Cell value in Title Bar or System Tray -Possible?
Store sheet names in Access
Formula to return last day of month for each month in year?
ROI Spreadsheet
Turn off virus scan during open
I would like to combine information from 2 tables in just one?
Christmas Card sent/received list
Search using the words in a cell
Floating point problem??
How can I add a new summary function (Median) to a pivot report?
copyingsheets between workbooks with same name
Crashing excel on exit
Dynamic comments
combobox out of memory error
send pop up message to particular user
C# and Excel
currency in vba userform
zoom settings
Changing Dates
Expanding ranges causing probs?
Timecode macro
CreateObject("InternetExplorer.Application")
automatic updating of worksheets
Renumber a WorkSheet
PROBLEM: Keywords;= Userform, Class Modules, ButtonGroup and Nomenclature
Array Sort on 2 keys
Reading data from other files
Date
Date
Date
Iterative solving using VBA ...
Lookup function
VBA - Deleting Small Text Files
arrange windows vertically - 2 selected sheets
Copying list boxes
Compile Error\Interacting with Access
How to read HTML
Tab Order Automation??
MsgBox Closes Automatically
Integration/area under a curve VBA code?
Stop Code
Integration/area under a curve VBA code?
highlight the current cell
Macro row and column conditional formating problem
multilple nested if statements in one cell
search sheet to get info on another
Learning VBA online for Excel
sorting a range
Code: Assign Function(s) to all cells in a column
Expanding ranges after sort???
Urgent help in excel macros
Force Start Row in Export
Code bug help please
how to get min value from a column using VBA
match data
combine columns
how to check the array have value
GetOpenFilename MultiSelect failure
Linking two workbooks
Combo Box
maximum number of Right-click options
i want to control with userform like mztools
Copy Sheet Formula Reference
sequential move across sheets
Cant help it
Help-Simple Sub
Identifying Visible Toolbars
paste to word document and save
how to create a new folder through a macro ??
Convert Excel Formula to VBA
Saving current workbook
Programming advice please
Compare 2 sheet and insert result into other
Concatenate Non Blank Cells
I need a help for the Excel formula.
Q on Entering a Criteria within a Query
ActiveSheet.SaveAs
Multipage Userform
Extract Data from an Access Database in to Excel
Copy cell data from workbook based on user input
Help writing a macro
How do i open excel sheets under one excel program
finding the last cell typed in
Data with starting with - causes Type Mismatch
UserForm out of Memory Error
Macro to delete row if value in column J =0
Can't Disable the "Insert - Rows" menu option in Excel using VBA m
programming VBE -> Deleting All Code From A Module
Creating a list of values
Insert Concatenate Formula
value in userform
Disable paste special attributes
VBA, and SaveAs Function
Error in code
Copy matching lines
Code to create and name a sheet
What to use for floating help?
Generic protect/unprotect code through buttons and code?
Using a macro how do I transfer information from excel to word.
VBA Can't select cell - what's up
Calculating Calif overtime on timesheet
Code execution has been interrupted
Macro Creation
Problem with creating chart within existing worksheet.
Writing neat code
Worksheet_Change: Date Time Input [mmddyy hhmm] to [mm/dd/yy hh:mm]
Combobox moves when worksheet is printed???
To access a previous object via class module
ListBox question
vlookup up to the next increment
Returning a resultset from Oracle Stored Procedure using ADO (VBA)
Auto format a workbook to Print
paste values macro
Select first 3 sheets
Newbie help...
On activate event
RE newbie question workbook using c# thanks
Assigning Macros to Grouped Shapes
Checking Blank Rows
How do I delete 250 rows on Excel sheet where ever a cell value =0
newbie question workbook using c#
Combine data on one sheet
Custom header - utilize a cell for it's contents
input excel data to access db in web server
getting data from word into excel
What function to determine the second small integer from a list?
'Template' within a worksheet - change existing worksheets
Copy/Paste Revisted
Running a Macro from a Command Button
Code to get data from webpage into Excel (v.2)
Offset Formula problem
to open a pdf file from excel
How to write a language independent formula
Starting a macro when switching to a worksheet?
dinamic contents of combobox, listbox etc
Active Cell - Remember
filling cells with formulas
color corresponding cell in other column
c# recieving button event
Macro Print to file limited the no of character in a row?
Macro Print to file limited the no of character in a row?
Moving data from one part of a worksheet to another with a button
workbook security
displaying a list of info
Cell of sheet Not accepting 32767 character
Using match in vba.. with various files
Making a number have Text format
pivottable
Disable command bar only in one active workbook
Input mask for changing a numeric to a Zero
Automatically Change Date every 2 weeks
Advancedfilter
Sumproduct with two conditions(or more)
HRESULT: 0x800A03EC setting DataSource for pivot tables.
Transpose
Need to perform the same macro to multiple xls files in VB2005 Exp
How do I update the Vertical scrollbar
make macros (sub) work for add-in?
Bug? AutoShape position properties incorrect
Question about creating macro (to export to quickbooks pro)
Macro selecting multiple items in list box
Use VBA code to display message if combobox selection not in list
verifying one cell and pasting number next to it
Range selecting in non-active workbook
Macro for deleting rows
Find differenced between two columns...
find value and delete cell and the cell next to it
Animation
now available for editing
Delete Multiple Rows based on Selection
Macro Toolbar has disappeared
Excel Add-in for Analysis Services: can't connect
Filer and Copy
Auto filter question
Altering a macro with a macro
subtract hours, not time of day
Formula needed with a changing denominator for each grouping
Custom Hotkey Strategy
hyperlink for the Office-2003 Excel web component
linking data
Range Object Question
Delete Tabs
starting .bat file from excel VBA
Positioning pictures in a cell
Do while not blank macro
Find a year in cells....
Repositioning cursor
ControlButtons in a UserForm
How can I insert a drop down date picker to worksheet cells?
Merging information from multiple cells or worksheets
Re: Essbase over-rides basic Functionality?
Macro to combine (sum) like items
Variables in VBA
RE: Find similar lines and combine
Save Macro
IF
Unhiding all worksheets.
Excel and Office Communicator
Combine 2 Macros
Macro To Printout Worksheets Crashes
Macro to copy a value if number
Name Active Workbook
switching between applications
Excel upload to Access (VBA help)
Setting an Essbase Option using code
Data from Multi Variable Dropdowns
Email selected range in Excel
Change Speech Engine with VBA
Setting right-hand internal margin in textbox
Limit Files via VBA not folder rights or permissions
Macro to copy cell values to row below
Chosing the top 3 values from a list
changing bacground colour if formula altered
Creating a generic progress bar
Identifying drive letter with Save-as to a server
Remove Hyperlinks
Writing a range to an array...
Pasting into another application usin Excel VBA
Want to select cells in B1:B19 which have same value as in cell A1
Looping thru Sheets without activating
Data given produces a cell info
Cell Blink or message if cells date = today date
Excel PageBreaks and the Rows to Count thereof
I give up-- I need help Pleeeezze? Anybody up to a little challange?
Formatting after Web Query Refresh
help: code for importing xml into excel sheet
VBA Copy Paste Problem
Newbie Question
Autofilter Pulldown
Need Help in Printing
Code to set text length in cell
Comparing Multidimensional Arrays?
help! how to delete useless rows in 2 dim array by VBA
Setting Directory when Saving File
Pivot Table, Limit 255 rows, Invert rows and column
MSDN should include a VBA reference.
Extract Data into a Summarized form
class functions
Merging Info in Two Cells
Object Required Error 424
values in userform
Better Way To Do This SLOW code
using arrays to transpose data
Duplicate CommandButton macros
Worksheet Activation from another workbook
Loop through column headers to search from column name and get cell range
Possible to Change DialogPrintPreview CBs?
Sorting data--impact to formula references and charting
Help with MSCOMM control
Macro to add rows and populate cells
Macro Error
Macro Error
active cell list name
TBs and Ckbxes move left on screen after printing
Basic question
How do I lock a cell in excel file ?
Lock cells for combo box values only
Unlocking a Project
Inserting new items into columns
Run-time error '9' on With statement
Virus Protection Workaround??
Sorting arrays that contain multiple values
VBA error in charting function. Help!
Userform Woes
Worksheet_Activate not working on multiple cells
Close Files Fast
code to find stuff in each sheet?
Using interop.excel to open a workbook, the workbook doesn't ask to save changes.
Inserting columns
closing read-only without save dialog box appearing
avoid warning when removing sheet
cell references to different sheets with lists
Copy/paste the template whenever new sheet is created
some complicated programming me thinks, update worksheet function
Progmatically add code to worksheet_activate
want to access xml from excel object model
Create & Format XL Comments with VBA
Generic Window/Workbook text
Dual input cells
More efficient way to calculate values
using bahttext function
Centering a Userform after Height Change
Changing Number Format
arrange cell order
Solver function
Workbook name problem
Correct Syntax
Can't get the right formula function.
Lopp in column to find and select
Tabela DInÃ¢mica - MACRO
sql.request
Input for Macros
VB Newbie - Counting occurences in array
DataObject Error in Excel version 2002
VBA that automatically generates a series of cash flows based on a start date, an end date and frequency
Code bug
knowing error line and module name
Replace Values in range selection
Print contents of textbox (has scrollbars)
Extract Digit Function Question
CF -- User input date range
RE: Input for Macros
How do I remove data fields I do not need from data source?
Progress bar during workbook save
Message box in excel
Textbox highlighting issue
Extract Digits Questions
Configuring DT Pickers
Add Commandbar when Add-in is install
RE: Input for Macros
Range().resize giving errors
Re: Range().resize giving errors
Forms ran as EXE
How do I remove duplicate fields in excel
Range().resize giving errors
Screening Data
vba help screen
Sort Code
I closed all menus/toolbars with macro. Any way to fix w/o losing my XLB??
Generate Histogram
Extract Number from text
Open Minitab via EXCEL/VBA
Type Mismatch??
if activecell = the cell below
looping thru each w/sheet
reading a range name as part of Save-as file
reading a range name as part of Save-as file
Help with a UDF Function using Arrays...
How to create & use User Forms
Valid select statements using OLEDB and Excel
Trouble With MacroOptions
Shortcut Nested If Statements
Inserting forumla using vba
How to do a mass update to formulas?
Set tab order for textboxes
Question: loading a file into a Object?
Question: File already exists
Creating an add-in
XL 97 - designing form with zooming capabilities
Update graphs with Macro
how can i use cell information as a tab name automatically?
variable transpose
Routine that saves a file. If more than 7 in directory, deletes the oldest.
How can I lock a single cell in an Excel following data entry?
Importing data from Access to Excel 2003 using code
Topic: Please help DrawingObjects in Cells
FileSearch using FileType
Hiding/UnHiding Selected Worksheets
Hashing
What is the VBA command to terminate the Excel.exe process
Clarification needed about Scope Of Variables
Macro to insert Now() when cell updates
Preventing user from closing form with "X"
Put Filename Variable in Macro
If/then code problem
Process a row if a string search finds certain words from a list
Create a sheet and name it
check to see if all dates are for the current year
How to generate random X given only min, max, mean?
Find multiple values
two very simple questions
How do i pull details from a table to appear as a list in excel?
Code bombing on Loop While line
Wie erstelle ich im Makro einen Relativen Bezug?
filling array with non-contiguous range
Password protection
Wanting to write a macro to concatenate and store info.
Search/replace Userform Variable
How to use Excel Functions in VBA?
Using VBA to change a Column heading in a pivot to a cell referenc
Extract based on Delimiters
How 2 use right shift "<<" and left shift ">>" operator in excel?
VBA code to always select next available new workbook
How to Count only Colored cells
Advance filter to find date wise?
Auto setting column widths accross a whole workbook
running another application from VBA
Can I run Visual Basic procedure using Excel Visual Basic editor?
COUNTIF - Cell reference does not work !!
Character formating for User defined function problem
using linest excel function from msaccess with multidimensional ar
Make query
repeated end(xldown)
How to judge some cell that had been added comments?
Using Vlookup in Worksheet_SelectionChange
End Down, Down
importing undelimited text file data, character-by-character
Return the name of a range
Hoe kan in gefilterde gegevens doorvoeren naar een andere tabel
Need to loop my macro
Merry Xmas
Deleted empty row for some columns
VBA help not displaying all topics.
Cycle through all worksheets
Looking For A Specific Formula Programmatically
copy and paste from row below
Calendar inhance
prevent button from copying
update collection of arrays
application user input
What am I doing wrong?
Conditional formatting - different cell colour for each year following from user input date?
need form pulldown white while box is color
Insert Additional Numeric Value in a cell using VBA
Code works, but is slow
Excel/Office PIA & Security Policy
Thanks
Opening a file from a cell value
q:read value from serial port
Merry Xmas
search for a specific word and copy the word and the preceeding words until a comma
Vlookup What if not Found
Name of Current Macro running?
How to get all Excel instance
Summary page
checking celles by vb excel2000
Licensing question
Checking a cell's (Row,Column)
programatically color fonts and auto sorting
Repeat code over 300 rows
Adding a item to the right click menu?
A little advice on comparing cells
Commanbar toolbar - can we customize size?
A simple copy problem
Quick and easy solution needed!
dates in userform
VBA to open a .mdb file
how to reverse cells value
VLOOKUP Formula using variable for lookup_value
How to make add-in work for all users
Multiple user password
Custom Toolbars
Last Cell
Formulas Not Calculating in Excel 2003
IF then statements
Delete pivot table
Complete newb, I know!
Button clicks and textbox Exit events
marco for a pivot table and expansion
Conditional formatting
Control Scroll bar
Changes to Add-Ins are not saved...
Printing web page selection
DateDIF
spliting out data in one field into two
Default date in a UserForm box
changing addin extensions
Search cells on a page?
Data Parsing Problem
Formula
Workbook and Window object question
embedding picture or object in a cell
Cutom View
click event
Determine Find/Replace settings and then restore them?
source code management
Macro to add rows and populate cells based on critera
If formula question
Print Failure - Default File Location
bond convexity
Macro to move info and delete duplicat records
Copying several columns
Bottons Fail After Moving File
Buttons Fail After Moving File to Different Folder
macro to copy & paste cell data into another cell
Setting HotKey Programmatically
Macro to move cell contents based on formatting
scroll window to display selected cell in visible area?
Hex Edit Excel
how to sort many rows independently?
WORD-DELIMITED string vba macro for excel/word
Macro Runs Too Fast
DataForm.Show does not work in code
Totals & updating totals
Need help to troubleshoot Automation Error
How to insert Data
ElseIf Statement problem
Thanks a million
DT Object missing
Merry Christmas
how to combine and's with or's in a if statement
After For..Next..Go to Next Row Data
Multiple File Select
ListBox problem
Issues about making project references
MY ARRAY FORMULA IS SLOW IF DATA LIST IS MORE THAN 10000R0WS
Pivot question
How to switch between different workbooks?
Offsetting formula results
Varify status before runing code
Can I upgrade Excel to allow longer formulas?
retrieve data interval
killing accents sos
How to get the row number of new value in a column???
Visual Basic Help
How to read text content of AS400 screen
macro to insert formula if cell format criteria satisafied
Emailing an Excel cell range
No Frames in Control Toolbox?
Finding sheet a range is on?
exporting data from Workbooks in Folder
How to post data
Calculating Max, Min, Ave etc of a large region
simple question
Context-sensitive custom menu item.
Condense Code
create an add-in from macro
Colored worksheet tabs in Excel 2000?
Copying columns of numbers 2
CSV file, but not regular commas
I need some checking done
Copying columns of numbers
Create a time stamp from a date and vv
Macro, delete rows that meet criteria
Question about text files from excel. DESPERATE HELP NEEDED.
DEBUG EXCEL
invoke "Save Changes?" prompt
filtering rows of a spreadsheet
Clear data range, and copy static value.
Function to store last row and use in autofill selection
How do I use VB to set permissions for cell ranges in Excel 2K3?
How to define a relative named range in VBA
Show a Excel UserForm in Access
Pasting an Excel array
Public Functions
Date and Time Picker
Conditional Font Color
OnChange function only when a certain cell changes
How can I control the macro's running time?
How do I round down a number in a cell w/ a fomula in it?
XIrr in VBA error
How to indicate that UDF didn't converge?
Nameing A New Workbook
Cause workbook to fail to open if user opts to disable macros
Macro to copy from one sheet to another and trim data
importing data from access
Sort Error
Import data from multiple excel files
Macro and FileDialog
How to copy Dropdown boxes?
Default Dir
Move to bottom of Column
ProgressBar in VSTO
Macro/Function for Keyboard button combinations
Paste
SelectionChange event
Moving every other row
Not enough memory
Using Workbook_AddinInstall -vs- Workbook_Open Events
absolute reference to sheet in other workbook
Protecting Linked Workbooks
Apply formula to a range with multiple selections
formatting variables
Learning VB6 or VB2005?
How can I delete 'fuzzy' duplicated rows?
Powerpoint presentation that reads from Excel sheet
Is there a way to create dates 7 days apart automatically?
email a worksheet - problems
VbYesNo MsgBox won't respond to "No"
Creating a text file and printing excel spreadsheet data onto it
named ranges in a For Loop
Exclude hidden workbooks from list
need macro help
Arrow cursor for a excel WB
How to select sorted data listed under an unsorted grouping?
figuring out the next number in a series
Create named ranges
Issues about making references to a workbook
When do I need Rng.Address(External:=True)
VB and C# compilation differences
Run Access query from Excel, input value to query being value in c
Copying a variable selection size ?
Find defined Name in List, then Goto
Macro to select the result of an autofilter action
Logical Expression For MULTIPLE Cells???
Type Mismatch Error Populating Label
How to Link value from a Cell to a control in the userform
pointer to sub
How do I get the current Excel CustomView in VB
File Processing Macros - Need Assistance
Simple Calculation
Importing data from several existing workbooks into main workbook
Is there a method to find distinct values in a column
date find using find method
Error Handling an attempt to change a protected cell
Excel Cell Sequence
smart form
.value only to 2 dp?
disabling custom buttons during cell edit mode
Access Actions from Excel
Columns to Text
How can I organize values from one table to another.
Font color of exact function return in excel should be customize
error passing a formula to a cell from a string
Code cleanup help please
Another way to trigger a macro?
Pivot Table groups Refresh
text within a string
test for new, unsaved workbook
Display System Processes
Mimic Print Preview?
stopping at text....
BrowseForFolder
find every different text or data in a column - for Excel
Chopping the last 4 characters of a string in VBA
Display issues with upgrade 2000 to XP
ODBC Oracle Table, Delete From Excel?
Error
User controls on sheet question. - How to toggle between design and execute mode?
What type of code do you put in "ThisWorkBook"???
workbook close macro
inserting break in code
form closing with the X
VLookup
Add character before 1st letter of string
Floating toolbar Q - is there a limit to # of icons we can display/use?
Unlocking and locking a specific cell
An unanswered question about changing the numeric part
Bringing up the Unhide Sheet list via macro
Saving csv file on Web
Evaluate sumproduct question
listbox click event help
Help simple problem
uuqal sign in formula bar Excel 2003
Search And Replace Whole Words
Drop Down Menu with Hyperlinks
Sumproduct problem
date returning time in vba intermediate window
Error 91 with IE object in Excel
Ordering Worksheets
Moving worksheet
Dynamic Calculation
How do I do an else if statement?
Copying info from one worksheet to another
vb code for running macro from toolbutton
Code Error
Satisfy Cell Requirements Before Printing
Having trouble getting 'Local' parameter in SaveAs method to work
Get Cell Values from Other .xls files
linking worksheets from two differnt files
Accessing external database causing problems?
Refresh External Data Then All Pivot Tables Based On It
Why I cannot open microsoft offices 2003 files at all ?
cant dim as commandbar
Column To Column, Row By Row Worksheet name list
Looping through cells using VBA
convert from wordperfect to excel
Stumped
Waiting Working
CurDir
Checking for Empty Scattered Cells
defaulting to the desktop
Items in ComboBox appear "half-sized"
Referring to a Range Based on Selected Rows
Creating multiple messages from spreadsheet
Calculation
Excel programming window user interface
Calculating values...
Checking Cell Contents
Inserting data from excel into access
Please help : Macro doesnt work on other PCs
How to detect excess rows in txt or csv files before opening?
How to detect excess rows in txt or csv files before opening?
Cycling through one column in a range
Fomat (Date, yymmdd) function...
extract from multiple worksheets
Applying FIND Function on a Compound word
best way to remove external links
Updating Named Ranges with VBA using a list
Turn AutoFilters Off
Add standard excel button to custom toolbar menu
using command button instead of edit function
Option buttons: How to get the selected option from a group?
Recording a call
pause vba action without using Application.Wait?
Code not finding records
Paste Question
Store hidden information in a spreadsheet
Most recent file list
Finding smallest numbers
Modified vb - but it won't work
Sheet Name as a Variable?
Import into a Sheet module
Email workbook question
checking for hidden columns
xl
Append info in all worksheets in workbook in one sheet
From clumns to rows
ActiveX Cannot create object
clearing ranges
Changing a cell without selecting it
Analysis ToolPak - enable it programmatically?
combine worksheet functions to make macro to automate everything
Exit from Excel window
macro to create toolbar on open and clear it on close
Split values in one cell and place them in different cells
how to get updated valued from excel cells?
Deleting cells
Accessing Excel Formula
Email Workseet as Body of email
Paste column as number
HTML import problem
Not able to get dialog data of MFC using xll
[OT] SAP - short question
VBA - Insert Values from listItems to textbox
Help for how to pop-up images &/or use text-to-speech on distant c
Problem with Blocking Dynamically generated UserForm Call
Double Click for Time
calling .net dlls
Sort Question
delete macro question
Very strange ListBox problem
easy way to check for forbidden characters?
How do i fill a list box on a form in excel
How do I register my dll complied with ATL to a different PC?
Taking information out of excel and making a table of responses in
Stretching a userform with the mouse
95 Code Conversions
must I travel through UserForm_activate event?
For Loops and Named ranges
programming for advanced filter using external criteria file
Limiting Functions
Centering Text Not Working
Refreshing pivot table from different worksheet
How to read TableDefs in ADO
count data from 2 seperate columns
Setting a range within a loop variable for copy/paste
arrays
syntax error
Charting in VBA problem
vba cut and paste
populating excel cells with data from data sources
Managging some ranges
Obtani "R1:C1" format of a Range
Another Atempt
labels on x axis from vba is acting weird
Auto close the prompt & dialog boxes
When data in TextBox2 matches data in TextBox1
Better way to delete macros & other components???
Filtered Data Refresh
Essbase Causing Selection Change Event to Fire
World Cup
World Cup
Temporarily unprotect cell then protect afterwards
calculationstate
How to change the source URL of an XML Map?
Needing to select file path with Set command
Possible to sort part of a cell?
using xml to specify ranges
Can I automate copy of rows based on cell values
Pasting Macro
exporting to another workbook
Problem assinging FaceID to toolbar
How to suppress Excel default message
frequency in VBA
finding row 7
Converting WordPerfect to Excel
recall records
Change fill color based on value of another cell in Excel
ole link from excel to access
userforms showing and hiding
conditional formatting w/ check for beginning odd or even
getting a number format from a cell
Linking data
Autofit code Issue
Sort without Selecting
Re: VBA on a Hidden Worksheet
VBA on a Hidden Worksheet
VARIABLES IN ROWS - Help on The Right Syntax
is this possible with a macro....
Xlusrgal.xls
Removing 1st four rows from a range
Environ user tracking
Add to zip file and email
calculate cell formulas during VBA sub
Application Visible
Going loopy on a loop
open Tiff application from excel vba
Auto fit in merged cells
Extracting from excel to acess database
Autosave VBA
creating a date format entry from seperate integers
Combo Box List Question
Unable to fill Listbox thru VBA
opening a blank excel workbook from visual studio express
Worksheet_Change funktioniert nicht
Worksheet_Change funktioniert nicht
Sending message via MS Messenger
opening files on network drives via a brouser
VB editor opens by magic
Problems with Array
Interesting problem with VBA generated textbox (or textframe of shape) length
OFFSET FUNCTION
Whatever I do I get the wrong result
changing printer.papersize=vbPRPSLetter
autofilter macro in excel2000
Calendar (Excel Function or VBA)
first empty cell
Refreshing MS Query and Excel Pivot Tables using VBA
Border Formats
Select empty column & paste - Help please
Stk Quotes:: QueryTable is weird ??
Need help resolving error in defining last row
Rename a module
need help with formatting data collected from database...
Error when protecting sheet with cell has seperate password.
Excel Shapes
What am I missing?
create new sheets from a header row
Help with using OnKey
equivalent n´th day in a month
macros and column selection
Sorting
Counting a Change in Data in a Subtotal
If Function
Delete row if value in another workbook
Commandbutton caption change
Delete row if value in another workbook
userform tabs
Sorting
Fill a cell with a data range
Add closed workbook filenames that meet certain criteria to a message box
Macro Effecting Formatting
How to use Alt keys + symbol keys to invoke a macro?
Test for Merge
Allow only Hyperlinks
Error when No data to paste
removing blank entries from an array
How to add a public subroutine to a class module
Data validation and empty cells
Transpone Excel tables with macro/VBA
Saving Values
Find/Replace built-in dialog in XP
Automatically Setting Row Height with Merged Cells
last column..?
Analysis Toolpak appears loaded, but isn't
Extracting info from a string using VBA plz
Referencing a sheet in VLOOKUP
Changing sheet references in formulas
Before & After Refresh
Split Cell Into Seperate Rows
Inserting Pictures into cells
Need to find a match
code for adding a '% of total' column
Convert WordPerfect to Excel: Add In
how do you sort two columns; data and headers
2 Files open - Paste to One
Saving multi-tab excel file created from comma delimited text file
windows macro
sending email without outlook messages
____ Return file path via APIs !!!!
counting with three conditions
HOW CAN I APPLY CONDITIONAL FORMATTING BASED TO AN ENTIRE ROW?
CountIf
Help required to code a '% of total' column
Formulas don't update?
Find then GoTo problem code
Weeknumber of calendar date?
Problem with formulas updating
About send email of selected range in Excel
Do you have templates for CRM related issues
Do you have templates for CRM related issues
Return a value if 2 Conditions apply
VB Code to 'read' .txt files and display info in Excel
Problem transferring array data onto worksheet using Resize
Summing column w/o VBA. Help.
open workbook from a macro and continue this macro afterwards
Import an Image into Excel using VB.Net and Option Strict On
Restoring the Recently Used File List
Add a formula to sheet2 for to each nonempty line in sheet1
Date in text box reading mm/dd/yy instead of dd/mm/yy
.txt In .xls out Macro
How to calculate data that is entered into a text box
How to add a button in Excel tool bar in order to run my macro?
Export to HTML with Validation dropdown list
Sub cannot run (Error 5)
How do you add a treadline to a chart in excel?
Macro to copy 2 columns to new spreadsheet each new day
Distribute XLT - don't want to do it individually on each machine
Opening a template.xls using VBA code.
funcres(funcres.xla)
Print Preview
If Then Else with Exit For
Debug Excel 2003
Having trouble combining 4 cells with formulas into one cell formu
Please help. Yacht Race Handicap Median?
Adding Sub Menu Item to Current Custom Menu
Save file as filename plus fieldname
Password protection for an individual form
Macro help for goal seek
Subtotal and running/cumulative total!
Delete Entire Row If Q
BorderAround method failure
Stop users from accessing "Protection" option from "Tools" menu
Help - Can VBA bypass and open excel as read-only?
Highlight active range?
Help - Can Excel create a text file??
removing commas from a string
vlookup question
Goto misused: help to tidy Code
Shell Synchornous?
Run Macro on Cell Change Error
Power of Macros
Is .Select ever needed?
Biggest commercial .xla file?
Help With code
Consolidate Ranges into 1 Workbook
Change the level of protections (MAKRA)
Refreshing Web Query Problem
For better Performance in VBA for Excel - Strings manipulation OR Objects manipulation
Count times between 2 times and 2 dates
adjusting a VB script to my needs
Positioning on a sheet
Excel-VB Macro Variables
Re: Assistant NewBallon formatting
Re: More bills
List Files in a Directory
How to add selected row into listbox?
Securing an Excel application
Worksheet Name Variable Problem
Still having problem with IF-Then statement
Nearly There! (Revisted)
Application for scheduling students?
Moving a Selection of Data???
drop dowm menu for excel workbook worksheets.
RTD server with VC++
Format Cells Dialog Box won't display!
Format Cells Dialog Box won't display!
Start a new session when a session is already opend
adding functions to drop-down items
Moving Range Selection Right One Column at a Time
Format Cells Dialog Box won't display!
Better codes to run faster?
How do I use a date in a cell for "lookup_value" in HLOOKUP functi
macros and cells
Chart.Export error '1004' after upgrade to Excel 2003
Right click menu
Simple MultiColumn Sorting
Customized spin button
Custom Lookup Function
memory issues
Zipping the current Excel Spreadsheet with PkZip
Checking info against cells containing multiple values
Change commandbutton text from userform
Commandbutton backcolor change on event
New here so be gentle
Using R1C1 in VB to select a range
Date Format??
How do I compare two arrays of numeric strings?
Using Case in MSquery
Change Tracking
personal.xls
AdvandcedFilter - Oh I need help
Combine Workbooks
I should know this but ...
Array sort
Change the interior color of a cell - Code Review
protect a cell based on values in range
permanently add library reference
permanently add library reference
Flow of control from UserForm to Sheet1 sub
CurrentDate + 3 months (arithmetic with dates???)
search within PDF...
How do I close/exit Excel programmatically
Automate Page Header Text
How to Separate an email address
Out of Space in coloum
combobox fill problem
Custom Button - Excel Add-in
excel web queries: make the box for the website name much longer
counting instances of a character within a string
problem getting formulas in cells that user adresses..
Excel 97 modules appear as tabs
Error 13 on many trim with cells started with +
WHERE CAN I FIND N JOBCARD TEMPLATE
Commandbars
naming worksheets
Last 2 files joined together
Userform level class instance doesn't recognize methods
Creating a macro to copy a number of charts from Excel to PPT
Function to return interior colour of a cell
range values in an array?
Simple loop problem
Dependent Macro/Toggle Buttons
? how to pull data from another sheet based on value
VB for Deleting Rows in Excel
Updating cells that are adjacent to a query
Event Trigger
Analysing outlook calender
wksht name as current date - m-d-yy