Excel Programming [Archive] - Page 93

copying changing range
macro help please
Validation
Tweaking Code
Enabling macros for my workbook
Range class failed
Next Row
Macro Instability
Excel Problem....
Merging 2 excel file into single excel
Merging 2 excel file into single excel
Creating a stack to push/pull ranges
calculate blocks contained in a larger piece of wood
Excel app now requires password
Sort by Hierarchy
Formula in a Macro
The project file " is corrupt and can't be opened
Tweaking Code
Help! Question about Worksheets.Copy
print or row like command in excel vba
"Out of Resources" Message
Macro gives the wrong date format
Worksheet-template (HELP!)
statistics question
What am I missing?
Excel 2003 very slow
Count Cells in Range
Office SP2 update causes Excel automation crash!
Re: coding a submit button
How to iterate through sheets and set ActiveWindow
Screen 'Refreshing' - Too Much Code???
group method - is there a collection
VBA Help Please (delete row)
Array
Target Address/Value Macro Won't Work
Spell Check Macro Help
Compare two worksheets and highlight the one sheet’s difference from the other one
Put values into excel range from single dimension array
programmatically deselect a selection?
Return network share/drive letter equivalent
Opening file without alerts
Fast way to make rows visible and invisible
Adding PivotTable to AxSpreadsheet
Ron DB! -Calander question
VBA - Determine last cell in range?
Deactivate then Reactivate UpdateLinks
using a cell value as graphic file address
validation
Cell Formatting Failure
Undefined function
Updating a Validation List
While refreshing data excel hangs because the certain page is temporary not accessibl
How do you get Excel to record a macros using relative refernce mo
Macros
Undefined function
ADO Resource
Help with a loop VBA with an if statement
Creating or going to a worksheet
Add-in / xla causing random wierd GPF / crash
Macro - pls help =)
Combo Box Referencing and Assignment
AS400 transfer via VBA
Pivot Table version (xlPivotTableVersion12)
Shared Workbook
PASTING CHARTV IN METAFILE FORMAT TO PPT
CUBE FUNCTIONS!
Conditional Formatting Limitations ?
find and move data within a column
outlook/excel interface error?
use vba to write vba for a chart sheet created on the fly
Cannot Get SQL Query to Work with "LIKE"
develop an if then else loop in excell that follows cursor moves
Excel buttons display differently on different PC's
Adding leading spaces
Email
Setting Shortcut Keys
Best way to check
Command buttons
VBA newbie needs help with triggering a macro
How to write a macro to select print ranges that vary monthly
Click cell to activate macro
RecordHigh(Cell)
Time and date each entry
Excel Rookie Question
Whats wrong with this?
Inserting a row
Creating combinations based on a criteria
Nested Arrays
Can anyone do this?
Replace characters in columns in excel
Getting RAND() value but NOT its Function?!?
Transpose (?)
Delete rows foward if cell is empty
custom format cell, if value is 0, then write "-"
export to excel from acces and format
CmdButton - How to make button it the default button?
How do I expand Excel lookup function to search more than 16,384 r
questions about Dim
VBA help please - remove leading spaces
MsgBox Help
"Smart" Copy
Form Show Error
Auto Fillter data and copy to other table
Modules and code
From CellA1 to a column of Date
How do I perform a certain function if VBA throws up an error?
Works fine in debug, but...
exporting image from sheet
How to make Form Modeless
Macro assistance please - again!
macro to copy down formulas
Conditional format for labels
how do i run a macro in excel 12 beta?
How to handle double byte data??
reusing a recordset for a pivot-table
copying multiple selections
Deleting ActiveX control???
VBA pulling data from other workbooks?
Hide column depending on its header
Loop .WebTables to increment by 1
Automatically save workbook when exiting
Cut and move rows to different worksheets
accessing value of a cell having formula
Best way to do this!!
Need a macro code for formula using both absolut and relative refe
Sort by an expression?
list boxes - multiple row sources?
Controlling Row Inserts and Deletes Via Code
How to activate Add-ins for files in a particular folder????
conditional count of cells between dates
shortcuts
[VBA] how can a Vlookup return the Formula instead of the Value?
Compare Strings Question
Need Simple Copy and Insert Row, Move Down Macro
copy 2 cells into 1 cell
Named ranges vs setting range in code
Is it possible to display cell value on a form?
cell.formula fails
How to manipulate a row with a certain value
Create a Macro to Copy a Worksheet, and link certain cells...
date references in macros
Problem running Find code for different sheet
Loop Issues
Help with UserForm code.
SUMIF function
Error 400 on making row visible on a protected sheet
how do I set letters to indicate a range of values in one cell
a complex use of sumproduct ?
Setting ScrollRoll without ActiveWindow
For Loop Help
Access Editing from Excel
counting criteria within alist
VBA to set print area of single page
VBA Question Multiply vs' replace
How to update macro from 2000 to 2003
Number Format Controls on a User Form
How to do this? Thanks
Strange question about combobox and msgbox
VBA Help Please (rookie issue)
Removing the Insert Function from the tool bar
Pivottable invalidated by .childfield
sorting a range into a single column
How Can I use "#N/A" return from a vlookup to change row color?
Alerts in sorting
A QueryTable refresh, a named range, the 'Hidden' property
Best way to do this!!
Pivot Item: removing non-existant item from the drop down
Lookup and paste
Macro Virus?
how to stop text size from reducing in TextBoxes in Excel
saving in other File types
Macro (Codes)
Excel 2003, can't setfocus in a textbox inside a multipage, tab key don work!
French Vs English
Running code/switching between sheets
Casting Problem in VBA
Message Box
Replace only "A*" by an other text
Marco & hyperlink
Copy Problem
Try again - adress from a range to combobox
iterate columns to select certain cells
Manipulating text file data
Check if several workbooks are open
RowSource for User Form
DELETE SPACES In part
Deletion of rows in a column according to a given criteria
Location of Cell Between Embedded Chart
Importing a File into a Template
MACRO VBA TO SAVE EVEN IF FILE EXISTS
Repeat tasks automatically to others sheets
Inserting a combox
Help,, need macro to replace 'space' in list of names with "." (dot), then compare ss
VBE Tools>References
Moving sheets to another workbook
Simple question about FORM / SAVE & EXCEL
Emailing A List of People using VBA
Asci equivalent of soft return (alt+enter)
Use An Excel Built-In Function Entirely Within VBA
EXCEL CACHING ...
Would like Macro example to write out a range of cells to a file
Re: Concatenate 3 columns.
Userforms keep popping up, need code to stop it
Value from Combobox to Cell (Excel 2003)
Concatenate 3 columns.
COUNTING 3 DIFFERENT TYPES OF DATA FROM A RANGE
Copy cell
Copy destination problem
Record a macro which enters a password to unprotect a workbook
Closing and attaching spreadsheet to an email
Getting "Object Variable or With Block Variable not set" error
lookup function
Convert excel to different file format.
Not allow the user to link to other workbooks
Want to Set the File Save As path
Excel & PCL Commands
What is the fastest way to pull a recordset using ADO to Oracle.
Delete file if it starts with a number
Multiselect List Box
How do you edit the text in a userform-textbox?
1:N mappings
Application level events - calling from standard module
Changing filename
Using Cells Method to define Ranges
Set a range in a Macro to copy
Big Help
When last saved?
Date in Header
Last row with data in a column
Printing subtotals on same page
Need selected item from listbox after double click
count with a range
Retrieving Excel Database Data
urgent help needed please anyone
autorun macro by pressing hyperlink, help
255 character limit
cells mandatory to fill
shortcut for add-In menu
Workbook by name open?
Apply code to other worksheets
Relative cells in macro - and pasting a formula too.
Chabnging macros to functions
Unload Userform doesn't work here - why?
Re: How to use Excel VBA to query a SAP database?
Help on excel macros
My Macro crashes excel - anyone know why.
Replace element of chart source?
Using Conditional Sums/Averages on Arrays
QueryTables - Excel 2000 to 2002 migration
Deleting Specific Dimensions of a 3D Array
Listbox - Rowsource
Why won't this allow decimals...instead it keeps rounding...and won't format correctly.
Extract tables - Web Querry
Stop Workbook from closing.
Using "dd/mm/yyyy h:mm" on Date Variables
Is there any way to access the formula bar through VBA code?
Copy & Paste (Merged & Centered)
Arrange Meeting in Excel
how do i use IF ELSE IF FUNCTION in excel to chk more condition
Making cells mandatory to fill in if a previous cell contains info
Does Excel Statistic Feature comes as a COM component or a library
worksheet change
Shared Workbook flag?
Print area
Forms and Macros
How to retrieve data from web?
Date converting problem
dde link
How to create different workbooks from a single worksheet
navigate sheet onclick
Print VBA in color?
WorkBook VS General Module
Unembed photos in a list of word documents from Excel
Autoshape event handler?
Spaces in a cell
Tab order on User Form not working
how to save file on different computers
Calling subroutines from Class Modules
how can I compute from degrees to degrees-minutes-seconds?
how to do web login for web project on Linux machine?
Need to expand Macro
Range = print area? to unhide rows.
=ROW-1, =SUBTOTAL(3,$B$2:$B2) don't work in hidden rows.
VB and Excel
Change date in URL
SQL server does not exist or access denied
Marcos and buttons
From Outlook to spreadsheet
case
time
Issue w/ AutoNumber Field during DAO Record Insert
selecting adjacent cells
Inserting rows
SendKeys problem
Compare and Copy
Help with Lists
excel chart to powerpoint
how do import data from two sheets into one
signing a spreadsheet
Excel hangs
changing the date separator
hide macro in listbox
Using double click on active cell to open a custom help window
Two values in a combobox
Collecting data from multiple sheets in wbk
Use a lookup with a variable for the workbook name
EntireRow.Delete only removing half of the rows
arrays
Macro for Saving!!
copy formulas from a contiguous range to a safe place and copy them back later
Excel crashes when copy
Do Loop Won't Stop Looping
Display a form prior to workbook being displayed
Excel Developer Needed - Dallas, TX
Restrict copy paste ability
Test to see if custom menu exists
programmatic grouping of columns in pivot table
Listbox RowSource problem
A1 in sheet1 =” =SUM('sheet2:sheet3'!A1)”
Deploy Excel Macros
Enter a number to the same cell for all sheets
Problem with cursor position after Find is run.
Showing Toolbar Buttons as Pressed...
lookup function with 2 parameter in VBA ?
worksheet_Change
Still stumped with printing macro
Move contents from one tab to another
Deleting cells in Macro
run-time error '91' - Close Button Error
Compare to columns on two different spread sheet, only pick up the
Reading from a closed workbook
Adding rows within a list
Finding major peaks and troughs
Need help with UserName entry
Trigger copy on AfterUpdate event
Cell protection
IF then question
Using Groups on Protected Sheets
Sum in hierarchy
How to capture when a User changes the printer
VBA Code runtime error only after opening Locals window
How do I copy a cell with effects?
Good Practice
macros opening files
Is there a way to make a sheet viewable but not selectable?
ThisWorkbook
Delete Files with less than 2 sheets
Sheet calculation target cell
Insert row for each different value in a vector
Compare data with in a couple of sheets then output to a blank sheet
VBA code question?!
Merge and move worksheets
setting error handling on control creation and deletion
error code help
Print Form
Range parameter on different sheet not working?
Combo Box tab navigation
urgent VBA question
Count Matrix
Insert text in bold
Does XML have equivalent code for ADO?
Excel to Word
sharing Add-In on a network
Enter data into excel and export it to a webpage
how to delete a string from another string
I need instructions
Custom Document Properties - Last Calculation Date
Programming help statements into my VBA custom user defined functi
Repost: NumberFormat/Autofilter/Rounding Problem
Saving file to specific directory
Consolidation of selected worksheet from several workbooks
Connecting two checkboxes on different sheets
Vertical into Horizontal
Urgent.. Need help with Excel..
Not empty but zero
Pivot table Destination
Pop Up box to filter based on User Criteria
Problems Programming a sort to move rows
How to test cell contents in a macro?
how to erase the full content of a sheet
MemoryFree
Column with semicolon-separated values
Does anybody know when Excel 2003 SP 3 will be available?
Newbie, Variables not retained in sub?
Simple Msgbox needed
Play Sound File
module not found error in Excel Marco
Looping and creating sub sums
check if formula parameter is a cell-adress
ComboBox with colors?
Userform Image
Partial Searching on a row
Using Solver add-in across multiple computers
Web query excel 2003 not good for Excel 2000 code
Convert workbooks of worksheets into different order
Slect left and right part of text
Reverse True/False with VBA
Excel2000: Searching a value in named range
VBA macro Cell argument
Top 10 Values
word to excel (how to avoid enter button marks?)
Table To Text ( MS Word)
Worksheet name anomalies
Deleting ? Again . . . Sorry
Create login popup for excel worksheet
copy content of 1 sheet to another one.
pie-chart problem using macro..
Reduce the file size of Word file by removing all images in it
calling a function
Essbase VBA Functions for Excel Add-In
how to input date only in A1 cell.
Don't save external data.
how to use dbgrid control
Cell Values from a Closed Workbook
Compile VBA Project
insert row and add functions
List of Environ expressions
Can a non-modal form be viewed w/o Excel in the background?
Index data
How to load/insert/update an embedded word object to Access...
Using EQUIV and INDEX fonction in vba
Open Event not working
Ctrl + Home on all worksheets
Date format
Convert column to text
Ignoring Blank Cells in a range
Pasting Banking Info to Excel - Debits and Credits
Visual Basic in Excel to Control Internet Explorer Object
hyperlink to other sheets in the workbook using vba
macro to paste active cell's full path into another cell
Please help with cut&paste to "Save As" problem!!
Print Form
Execute warning message
Bypass Worksheet_Change Sub
Convert every xls file in a folder to csv
Data Validation based on range of values
range name question
Application/Object error in code
Copy the body of an existing email in new emails generated via Excel with VBA.
Why Excel programming???
NumberFormat/Autofilter/Rounding Problem
Hide/Unhide worksheets based on login?
automate csv field change?
Insert combobox in excel to complete lookup function
AutoRun Macro Based on a Sum Calculation
Change color of active row
remove a control from a worksheet
combining two short VBA scripts from two buttons
update links when Macro ends
Date and Day Programming
Help, inconsistent results on Filter -> Unique, to new location.
Selecting image on worksheet and deleting..
simple: type mismatch
Footer variable for user name?
Copying then deleting every second row
Problems with NORMDIST
ExcelVBA Paste record In next empty next Row
How do I save a linked word form a Macro in excel?
merge excell data
VB editor for word pops up???
select rows of data & move to new column
How to change the VBA Editor's font size?
The reel address from a combobox ( bob phillips)
doesn't appear Read-only notify alert
XML to Excel 2003
Setting the scrollbar positon
Importing CSV as text
Names not deleted until book closed
Loop through a User-Defined Type?
Return intesected range
Named Ranges
Delete record if cell is empty
Code error
Search for non alphanumeric characters
Filtering in VBA
Obtaining cell reference from index function
Selecting values in the page field of a pivot table
Random Number Generator
Replace first 8 letters of filename with Macro
excel on the web
Inserting Proc-Call Into BeforeSave
Commandbutton flashes, then laout changes
Calculate,Copy, Paste Cell Group
Range object in Worksheetfunction.Sum
Macro to populate files
Showing all in Filter
Selecting Range
Trim not working....
Import dat. file
Private Sub on the fly
How to read a line from Ms Word
How to make custom functions (VBA) read changes automatically?
Macro menu item versus keyboard shortcut on pivot table
Address from a combobox
Porgramme a undo,Redo on a form
Renaming a button using a macro
Code to calculate the first row and last row of a range
BaselineDate
lookup
Name a range
How to name the list
How do I make a Pivot Case sensitive?
Ticklabel problem
Conditional formatting a cell
Tracking domain names
How can I create a worksheet using Macro
How can I create/add a worksheet using Macro
word to Excel
Avoid unloading of .xla addins when closing books are cancelled.
How to add real time data from broker website?
Delete two records together with looping
Memory problem (I think ???)
AutoFilter in C#
Add area code to phone numbers in ranges
"With Sheets" Issue - macro on one sheet to affect hidden rows on other sheets
Loop through worksheets to unhide rows
dbgrid control usage
Printer orientation with multi pages
No toolbars or menus?
Needless Horizontal scrollbar in Listbox
How do I create an executable excel file?
Compare values in different columns
How do you make a column number its self in order from a given #
How do you make a column number its self in order from a given #
Pasting problems
Common routine to handle a check box
Saving the spreadsheet only with no code? Selecting shapes too.
removing acontrol from the toolbar
Changing Command Button Based on Data Entry
Copy and Paste Special Dynamic Range
Adding Controls in a toolbar?
Perform code on all (closed) workbooks scattered across sub-folders of common parent folder
Show only specified columns
How to write vba to evaluate the text font and size on an active cell range?
select one range and then go to next
Inputbox/Regression Problem
Saving the spreadsheet only with no code? Selecting shapes too.
No additional controls in VBE
Run Time Error 1004: Please Help
Run Time Error 1004: Please help
Tenure - Anniversary Year
To find more than one Please
GetObject method not work after Call Shell Method
Selecting an output folder
VBA Trim - has no effect in workbook- looking for ideas
1004 - Unable to set the hidden property of the range class
Three loops to this circus
URL links in Excel spreadsheet
Why is c not a valid name?
Formula
Working with Cells on Userform
Copy one worksheet from one workbook to another....
Problem wqith connection to Oracle
argument and Cell Color
Disable Autosave via Code
reference problem
add automatically a component to component palette
Sorting data with Named Ranges
Why does this coding not work?
Clear Contents won't work on merged cells
Creating a check digit
macro to list file name and path in separate cells
Table with descriptions of ButtonFaces
Macro asking for a password twice when unprotecting sheet
Creating macros
Cant run vba code independantly.
ChartType inconsistent on various LanguagePacks
Why is NewWindow Ignored?
Oleobjects group box
Macro help
Funciton that Combines 3 or more Arrays
user forms coding help
why I got error value after running this code?
Replacing Word text with Excel data problem
VBA availability AFTER unsharing workbook
Finding Empty Cells
avoid overflow?
Field width when printing to immediate window
Newbie syntax question
Compile error in my Application
Printing with watermark in Excel
Incrementing a number with non-decimal base
Subject: Your Help Needed with the Data List Generation
Auto numbers??
convert excel formulas from english to norwegian
Shared workbook-VBA availability
Program to create a matrix
Excel 2000 file when opened in Excel XP generates errors
Use of check boxes
How to define table array in Vlookup function using VBA?
Sum up identical workbooks
VBA Format Row Height
Automatic running of Macros
auto-size userforms
Is Excel "caching" pages ?
User forms
Comparing columns - "special" case
Your Help Needed with the Data List Generation
Hyperlink
If you dont know exact name of a feature, you cant get help on it
is there any substring function in macro?
Excel Links
Screen Resolution
Urgent simple formula help
Printing specific pages
Has anyone out there created an excel dart league template?
Did LostFocus ever exist or is just a dream?!
How can I put interactive buttons in Excel document
Toolbar Query
XML - VBA conversion (.uxdc file)
ControlTipText
Less than 10
Change image in UserForm
I would like to create a button on the worksheet to work a macro
Value from form to excel sheet
Finding the End of a Range
Macro to copy range of cells and paste into 1 sheet
Excel Date Question
Areas
Code seems to crash after clearing comments
How to do this?
Disabling VBE Break on All Errors Programmatically with DAO SetOpt
Best Practice
Progress Bar form window goes white
Command button copy array
VBA to get Google to search
excel to powerpoint- paste a range
Excel 2002 VBA code to return a page number within a worksheet
Bold contents of a variable
Zoom a range without actually selecting it
wordart
Does VB have SYMBOLIC CONSTANTS similar to C/C++
Another If/Then ?
Right Mouse click advances macro?
locate picture location using macro
Ron - Summary_cells_from_Different_Workbooks_2
combobox question
Lock down a wokbook
Auto Rostering of Staff
Reference to Item in Collection
Create a list of unque entries
deselect all option buttons in a frame
date Calender user form
XP Profesional
Copy rows macro
Date format
some functions doesnt work in macro?
Help with code to re-arrange data for pareto analysis
how to make my custom formula in OLAP data source pivot table?
Where to place code that changes a cell value?
GetText Client Access AS400 window API Help
Selection too large
vlookup table in another workbook
VBA to count rows in a sheet and increase counter on another sheet then print
how to print to pdf?
Adding Two Text Cells
userform to store employee numbers...
Matching Values in Columns problems
Market data for different versions of Excel?
Macro reading new rows
i have to press sent to email
FFT in Excel
Help! complicated programming visual basic
Automation : Excel::Font : get_Font does not work
Combo Box code
Adding digital signaure to multiple files at once
Adding a coulmn total using a range name and sheet name
remove stuff code
Dynamic scroll area
How to avoid an error dialog
Help with Extending code (Comparing Two Sheets)
DATA VALIDATION
resizing a range
Yet more problems with Excel forms :(
Problem with a macro changing paths
VBA Question (rookie issue)
Where to place code that changes a cell value?
LOOKUP Problems
MsgBox, VBYes, VBNo
Help me count this
Recording maximum and minimum
geting data from internet
combobox question
Excel printing macro problem
VBA Help please (rookie issue)
user input into active excel macro- prompt - respond -insert-cont
---
Check Box Value
list boxes
problem in excel sheet
excel
Sort referencing incorrect worksheet
Resource for Programming ...
Strange Toolbar behavior
changelink macro failing. Prior link is to a non existent file.
working microsoft office using a single program
Deleting groups of continuous rows where col K = "x"
Page with tab names in cells
Is it possible???
counting occurences from multiple ranges
resizing a range
concatenting dates showing m/d instead of m/d/y
Finding data of one sheet in another sheet
Dynamic Toolbars
<HELP>Modify calender code for a combo box
[B]counting multiple occurences with data missing[/B]
".Protect userinterfaceonly:=True" & ".EnableSelection = xlUnlockedCells" not tabing
select all cells in an active sheet containg links to other (external) workbooks.
Deleting dates
"next without for" macro error
Row Color based on cell entry
Excel Lookup?? Problem!
VBA Password
Proper SQL Syntax - DAO
Match problem
Need Some Help
Specify data to import from other excel file
Lookup problems
Problem coding NextFind
If Worksheet exists...Then run code
mailing labels. . .but first, name list
Inability to Capture Username
Macro - copy cell contents IF
Excel Runtime Available?
Range variables and Freeze Panes
combobox question
Code Breaking
Sorting unique values and returning values from a formula
calculate time for employees in 24 hour operation
If then else
Inputbox/Regression Problem
Array Data Not Persistent
Sorting Numbers as Text in Pivot Table
Help !
Subtotals in a range of varying size
Macro error-"Selection is too large"
Populate cell IF another cell is blank
How to Specify Multiple Rows to Hide
How to indicate that the current visible worksheet is the active o
Why does this statement give an error message?
Multipling the value of 3 text boxes
Move cell contents to another column IF
Eliminating duplicate records using advanced filter even with unique set to true
Disappearing drop-down box
Posting VBA for Excel
Need help with beginner VB question
Merge and Move Data??
Clipboard Limits in Excel?
Sum workbooks cells
program to print some landscape, some portrait?
Working with non-specific cell references
calculate now for user defined functions?
Radio Buttons
CSV file with Comma in text Field
Reposting Date List Generation Question
macro slow after printing
Code Review
Copying random rows to other worksheets
Workbook Property or Method
Keep data visable in excel from vbscript input
R/T error 1004 - App-defin or obj defin error on last presented li
Getting the last line of data in a data sheet.
Formula via VB error
Creating ToolBar at Run Time
Workbook_BeforeClose: Cancel doesn't work
Select a cel on a worksheet
Help needed for combo box
Post Code UK Structure Verification
reposting: combining multiple columns into one column - enhancements
Help needed with the list of the trading days between start/endDat
Why does copy after worksheets command not work on some computers
compare values
Array Problem -- again!
Any thoughts - VBA Slow Down with Range.Clear Command
Private sub worksheet_change(bval target as range) issue
Xml mapping
getting Excel to create an extra column
Macro on specified Workbook
visible footer
Run a macro after time
VBA Help needed -- compile error: object required
How to make a macro that automatically starts after clicking a cel
After Save Event (Interop)
Stop a macro
Save As... / Save as Web Page... how to differentiate?
How Can I '{F4} Key down event' on RefEdit Control?
Pass contents of a cell to a macro
Hide Enable/Disable Startup
Minimizing windows for 50+ opened books at one go
Macro in Lotus 123 to ExcelXP
Help not sure what i'm doing
RE: How to subtract weekend days?
Event Procedure not working
Excel warning "too many different types of cells", then crashes..
CAN I GROUP TABS UNDER A "MASTERTAB" IN EXCEL WORKBOOK
Use a cell value to point to desired location.
Re: How do I link cells, sheet to sheet, to recognize row deletion
What am I doing wrong, here?
Determining volume/number.
Re: Macros-creating new sheets
Macro
Checkbox Offset
sum alphanumeric cells
macro to search for a set of numbers in a row
Can I link a row on sheet 2 to a row on sheet 1?
Named values drop-down
Excel VBA Lookup Functions
Fork Truck database
Running a Marcro when sheet is opened
Stop the loop when found.
Load forms from another workbook
get module line from erl and procedure
default = vbNo in Msgbox
Open dialogue box and importing text files
How do I turn a VBA script on and off with an entry in a cell
Security Across Applications
ReDim Variant array for worksheet copy
changelink with the name and new name as strings is failing
worksheet change infinite loop/calculate for user functions
Can I call a sub procedure from another file?
copy an array formula
Localisation decimal problems
Localisation problem??
How to highlight Top 10 and Bottom 10 Amounts in a Column
Copy contents if.......
Is it possible to add a tab to the Options section in the Tools Menu?
Macro code to open a workbook only when closed
Basic question....syntax on active cells from a filter
merge worksheet from different files
What is Error "Method "Paste" of object "_Worksheet" failed?
Difference btween Automatic and Manual calculations.
Overridding the "already exists" message with the SaveAs method
Setup/ sharing questions
In Excel, how do I create a point and click icon?
Input Box
Returning Values
For and IF statement error
Reformat Number
Remove Blank Cells within each row
INDEX/MATCH formula in VBA to populate text boxes
Why is Application.CutCopyMode False?
Comments
Pivot...and macro.
Eliminating Toolbars,Sheet Tabs,Scroll Bars. etc.
Insert Copied Cells?
Split text like line wrap into multi columns
Input box
Dynamic Formula Built from Search Criteria
C
Counting occurences which includes text
How to format number the same way calculators do
Drag and drop images
Help converting code to late binding
need help revising
Excel to Word and back again
Color of custom button caption
Problem with Excel Form and VBA code
Formatting Month display via macro
Excel worksheet cell comment box
Combining Data from multiple sheets...
Cell Link in a Drop Down - Where does it get its data?
Counting occurences which includes text
Cursor disappears / Cursor verschwindet
Remove old selections in Pivottable row field dropdown list
A Macro to search and sum
Multiple range formula
Cases within Cases
Copy range using offset range value
Systematically Renaming Ranges
Defining a range for a look up
Checking that file exist and if not display a message
Date format from UserForm
If ... Then Loop
Cannot create object
TRICKY: different data sets within the same page
Macro To Insert Row And Add Data.
Funtion that adds two named ranges
catching cancel on QueryTable.Refresh
[hyperlink] del 'browsed pgs'?
Excel ODBC Driver with ADO
Rollover Define Name
Referencing sheets/objects
Approach web-data via Excel
Missing Sequential Numbers
VBA opentext command
VBA opentext command
Publishing my excel workbook on the web
Opening Word in Excel
emailing a whole spreadsheet
how to learn vba systematically
FormatConditions(1).Formula1
Use existing macro to create another macro
Deleting Last values in an array
Cycle through each row and look for string in each cell
Macros to send email automatically
how to record new macro using vba
help I need a formula
Disabling worksheet_change when deleting rows . .
Disabling worksheet_change when running a specific macro . .
Greater or Lesser Than Formula
How do I retrieve the current workbook link in vba?
Need code to pair off numbers
insert Worksheet_SelectionChange(ByVal Target As Range) through vba
replacing warning message
Conditional autolist
average with conditions
Error Checking
Print Area
Printing PDF outputting to multple files - change to 1 file
loop...until ..
HELP!! automate excel pivot table from acces
Select Date Range
Automatic install of Add-in
can you encrypt an excel cell
Problems with a VB addin for Excel
Changing title from default
Visual Basic References
Formula won't copy and offset as I intend
Have I reached Excels limits? (this is a repost)
this is code that down excel
how to increase a spreadsheet's column number from 256 to a large.
Have I reach limitations of Excel
enable option buttons
Why is Excel so bad at dealing with user forms ? isn't this a major unresolved flaw ?
trouble selecting a named cell
Combo Box
how do I debug my Excel macro & make it actually WORK?
Help with Visual Basic for Excel
Insert Picture Macro.
What is the server name of this newsgroup?
Hyperlink in excel spreadsheet to email file automatically
delete empty rows of a sheet
Counting only values
sum of cells
delete just empty rows
Save VBA without saving the workbook?
floating list box in Excel?
Excel User Conference - Few hours left - Early Bird pricing
prevent same entry in a single column
Testing a group of option buttons for a selection.
Macro for text file with different size
Use VBA to change security settings
Attn: DP - Automating a dependent list - Code not working
Saving sheets as their own workbooks?
sending outlook tasks to multiple people
Help with opening variable filenames
Form Control for Cell Reference
Excel aborts on file open...
Excel Addin works that works on a template workbook
Help with hiding rows by VBA
Excel2003 could not load managed COM Component
Justify Method
How to get rid of #Value!
Forms wont show in VBA.... is this a known bug or do I have a corrupted Excel file ?
VBA code erroring in XL97...
insert blank line at change of year
ActiveX
Lookups and references in relation to countA, sumproducts
Solver Reference Problem
Can you put a formula on a field that requires user input?
Conditional formatting & Messagebox
nested if vba problem
Help! Forms that lose their show method !!
User define function and dialog
Conditional Formating - Change Color
Dynamically populating textboxes on a form
Orphaned Menu Item
Save Excel file as Web Page through VB.NET
Why does this code not work?
Macro to do the sum at the last when ever type chages
sheet namimg macro
multi-column listbox on userform, multiple issues
Detect missing rows
Macros across office programs...
VBA code merge Word doc with Excel data
Macro Troubles
How do I set an excel macro to run when the spreadshet is opened
multi line caption on command button??
Custom Userforms
Having problem with subtotal helpme out
macro doesn't do anything
Plz help.....Problem in creating a dynamic form
Macro To Find Data And Insert Row
Can't use Vlookup on data range
getting data from access
Deleting worksheets privately
help --- Commandbars
keep getting type mismatch error
Showing Forms using a public variable
subscript out of range error for .csv file and vlookup
data from userform to a cell on an execel sheet
MacroOptions problem
Count multiples and add to pivot table
How do I write a formula in excel that will calculate time?
Detect printer properties
Controling Excel using Word VBA
Plz help.. When a prodhiernr changes i want to sum the costs for this product.
Filtered list for Combo Box ListFillRange - Nested Combo Boxes
Using ODBC function calls
How make Module remember closed status in VBE?