Excel Programming [Archive] - Page 46

Indian SUCKS SUCKS SUCKS
Passing a value from one userform to another (multiple) form
Entering a Sum Formula in VBA with variables
How to get Properties Generate tab Location value
Add-in
Complie error
How to search for ceratin word in a web site using excel macro
vanishing buttons
Email - Outmail - From
Problem in using Chart.ApplyCustomType for Excel 2007
Excel macro SHortcut Keys Disappeared and Defaults re appeared
closing excel file through code
Auto sort
Macro to record history of Excel files
import excel file to access but only new data
Create SumIf function for date parameters
commands have been grayed out
pivot table using vba problem
From variable to excel constant
Finding xla
How to generate random number sets
How can I save a macro to an excel 2007 woorkbook
how to get the value of a text box in a sub or function
Data Validation Macro
MenuMaker
Can Excel modify data in a Query?
PivotTable from a ADODB.Recordset ?
Better way to find matches across multiple cells?
Best way to find repeated matches?
Code for dealing with #REF
Date on UserForm
Cell Reference with Hyperlinks
Concatenate unique items
Statusbar
Find File
listing a column in reverse order
Using ADO with Pivot Tables
Convert timespan d:hh:mm:ss to number
filename as variable
Locating end of used range- not returning expected value
Macro Clear Cell Contents
Getting names of files in subdirectories
Insert comment in a cell Excel
Dynamically declare and populate variables
UserName Property
Substitute worksheet function considered harmful: can createunopenable workbooks with cell values greater than 32k
Random match name to date
Macro Autofill Question
Save only a range from an excel file to another
macro to copy to another workbook
converting numbers
phantom 'Task Pane' problem
SQL Syntax Error in Query
Reference workbook name to cell reference
linking OLAP queries
Create New .txt file
Number Format Question
Textbox1.Value Question
DV Issues with IF statements. Call function instead?
Error 1004
Find last row with data in set range
Data entry commitment without hitting Enter key
ACCESSING closed files
LAST value of loop to be a variable
merge xps documents
Copy embedded chart with updated data request
Dynamic selection of a range
Delet certain row in a sheets in workbook
command bar
Userform Multipage
Send data from Excel in email from specific email address
Break Mode
Excel to Powerpoint - copy/paste text box
How to Capture log of Activities on each worksheet of a Workbook
MOVING WITH A RANGE-TAB
RANGE SELECTION
POSITION OF ErrorHandler?
Putting a variable value into the Clipboard
Ranking and Movement
Ideas for a menu
Sheets.Copy breaking the links
Using a variable as an argument
adding a page number in a cell
Two Question
How to write a macro to jump from 1 input field to the next?
copy method problem
Adding a named formula in VBA
macro renaming tab
Move around excel sheet
Wait for refresh/calc before proceeding
Tab to and from combobox
Print with staple
How will we create UDF's on 64 bit OS after support for VBA is dro
Inporting data: can I tell the query which cell to place the data
excel sheet opening as web page
"Unable to get the Hlookup property" VBA
Close all open modules
naming a tab based on a cells value
Failed Comparison... why?
Counting from one column by specific identifier
Checking if worksheet exsits
Using Countif on Array
Freeze Sheet Tab
Counting a subset
Hiding Rows Based on Cell Value
looking for a Excel consultant
Spreadsheet control in Office 2007
i think there is a problem with my loop
empty
Code Execution Has Been Interrupted
Splitting variables with a comma error with slashes
how do I create a macro that will activate other macros?
help with code
Mold Manufacturer
Additional controls in Office 2007
copy data from worksheet in folder a to worksheet in folder b
SQL on Column with Text and Numbers
fx button shows ... for a UDF
VB code to copy and past a row or set of cells...
Retrieving List of Macros in Workbook
SolverSolve function exits abnormally
Print Outline/Group Structure
Accessing individual items in an array returned by a function
How to Define and Use a Dynamic Array
Excel error connecting to sqlserver using ADODB, but can thru Datamenu
macro to copy entire workbook to another.
Writing tabular data from excel to sql server using VBA
Array problem
Using Worksheet_change module in protected workbook.
Repeated calls to Solver.xla causing Excel problems
vlookup
Lookup function, but then a bit complicater
Button to automatically change linked cells
Further to my last thread - Check for worksheet in a closed file
Help with code please
Add-in - add a custom function to a custom group.
Can't see macros in .xla file
office 3 calender
runtime error 9
Calling MVPs and Microsoft Techs and Excel experts
programmatic conversion of XLSX into XLS
Printing
MS EXCEL - To supress warning messages created by Anlysis ToolPak
macro for copying between Workbooks
Disable Window Minimize/Maximise/Resize
How to parse UDF arguments? (separators are localized)
project protecting
Insert Blank row at change in a given Column
Subtotal with more than one Function
SENDKEYS COMMAND
coping a entire tab to a new tab
Merge muliple pdf's
Problem loading DLL: Error
Copy data onto new workbook and move onto next lot of data
Need to find and replace text inside a macro using vba
Syntax again for DA
Size comment box
Code for Subtotals
Userform Initialize
email user form
Identify number of numeric sets in a long string of numbers
Macro for "Next" Button on User Form?
Help pLease... Creating a Usage Log
Next and Back Buttons
An auto macro to change color of the active cell
Form Text Box
Searching and Then Copy Cell to word
If/Then Macro For Each Visible Worksheet
Named ranges in the VBE
Conditonal listbox
Loop in a Macro
set range error in add sheet
excellde telefon rehberi nasıl oluşturabilirim?
MSGBOX UPON ERROR
Automation Add In, functions parameters as Range
Help with a loop
use the range value from a cell to update the cell with data
How to Synchronize page fields for two or more than 2 pivot tables?
user Forms Question
conditional list boxes
Built-in Commandbar, can't find the right one
Searching only Column A
downloading excel file for open causes "file is locked for editing
Custom commandbar (1 works, 1 doesn't)
VB6 and Excel question
Excel Formula
Ensure macros enabled - C. Pearson's sheet visibility method
Unwanted Hyperlink
Worksheet copy to another workbook
Find an exact word in a cell with many words
Problem with varaible dates in SQL query
Multiple worksheet named ranges to PDF
slow .Clear in 2007
SetLinkOnData only fires once?
Add additional logic to my code
Autofill until last cell in a row
Date reformat and export
Controls on Chart Forget assigned Macros.
multipage
Open second spreadsheet with certain permissions via onopen
Check for worksheet in closed workbook
Automatic Cell Locking
Formatting Problem
Doing nothing when pressing Cancel on InputBox
XL 2003 / IE 6.00.2900 - Macro menu unavailable
Import data from external XLS tio dropdown-list.
Date search and date extract
Double clicking on a pivot table
How could I deal with the concurrency in my project ?
Going To The Last Empty Row and Pasting Special (Values).
How can I calculate the minimum value of a VBA array?
Print User Forms as one document
AUTOMATICALLY ADD NEW SHEET VALUES IN CONSOLDATED SHEET
CAN files be accessed with a macro when closed
MACRO in a Loop Problem
Question on User Forms and Command Buttons
Listbox update on command
How do a sort a multidimensional array(1000,2) in Excel-VBA?
Multiple Excel File Import
Function cannot obtain cell values
Help with FOR LOOP and and Advance Filter
re : Save As
How to Evaluate Values in the filter used range
PivotTable with Server Page Field Leaves MS Query Application WindowOpen After Refresh.
Need help with FOR NEXT LOOP
Slow Opening Excel Workbook from Access
File Properties
Add ins for outlook object 11.0
More than one User Forms
Value Returned in Message Box Q
macro
switch the "scroll" led with vba
defined names in conditional-formatting don't work
Export VBA Modules
Change CellA.
summary of values for a period of time
Pop up Box that displays files sheets Q
looping
Range to VLOOKUP as a Variable (range in another file)
Referencing worksheet
VBE windows, zoom, ActiveX controls: Just one hit on memory, or many?
Excel XLL versus DLL
How to propagate xlErrNull back to Excel formula?
Update Sheet code using VBA - question for Chip Pearson
User Form and database
Gantt Chart with VBA
Plot Ranges
Run-time error '1004'
Color of Buttons
Position of Userform in other scrrens/monitor problem
Relative adress in recored macro
Please Help in this Compound Interest UDF
Counting Unique Values
Make the charecters in a cell to equal a certain quanity
Hide Macro from View Q
Deleting Part of a cell value
filesystemobject
How to access functions in .xll file using VBA?
pLeAsE hELp! format function in excel visual basic editor
event integration
Have A1 in Top left corner of screen Q
Code to Change Sheet Name
Copy and paste only values
How to calculate 6 working days between two dates
Looping
Gotta be some more Efficient code
Link input cells on user form to macro
Merge Macro Excel 2007
Looking for consultant to do some Excel macro programming
Replace all non-operators from string
Find and Replace in a Macro
manual/auto calculation toggle button
activate/deactivate the scroll button by vba
Personal.xls file with multiple Excel versions
Suppressing ODBC Login Prompt
Easy question, I think
VB protect sheet but allow certain options
Undo a scroll action
VB Import/Export CSV
Newbie to VSTO basic question about what to buy
Conditional Formatting using Dates but excluding weekends
Fomatting a row based on style of a cell within the same row
percentages
Command Button disappears
Macro to select a row that has max value and paste it in an empty row
how to check if more than one excel file is open?
Macros
HELP!! VBA Nested IF Function
Invalid function importing data query from Access
Public Const & RowSource
Deleting row from entry in listbox on a form error
Weekends for timesheet
Find column and then insert column
traveling days
(reposting) Memory problem: Out of Memory and cannot save
Thanks!
Counting number of columns in CSV/Text file
Opening another workbook
excel days counting formula
Changing file/open and file/saveas directories
Delete Blank Rows - specify column via dialog
Start my application when a .txt is added to or updated in aparticular directory
max of a range every set amount
VB Excel Code returning my error message twice instead of once....
Conditional formatting based on dates
I want to create a macro that opens the Find Box on the sheet
Need to update Multiple PivotTables from same sorce
PivotTableWizard Using Csharp
SoD table - Excel for Roles conflicts
Error with MarcoOptions method, add a new category
VBA help
Loop Within a Loop Problem
Excel 2007: OpenDatabase fails to connect to a SQL database
macro that searches by first and last and enters id number
Autofilter
Disable Setup button on Print Preview screen
Input Box Help
Creating a Formula Refer a New Sheet that is created Q
How to read from txt file from bottom to top?
buy cheap lotro gold powerleveling
Creating a calendar
Password security problem: view of the hiden worksheet in xlsm and xlsx file !?
Database Search Function
Compatibility issue?
Excel crashes after running macro !!! Urgent
delete group not object
EAN-13 checksum
Refer named range in a copied sheet
Vlookup property missing
Temporary Internet Files
Concvert Full Width Katakana characters into Half Width Katakana C
Excel and Flash
Pure .NET Office add-in vs VSTO solutions
Textbox Writing
Pause for data entry
Should be easy, but not working out
multiple cells copy & paste
Memory problem: Out of Memory and cannot save
Memory problem: Am I hitting the 64K segment boundary?
addins dont load when launched by access
Memory problem: Userforms and ActiveX controls: How many is too many?
Memory problem: Need to set object variables for userforms? Forranges?
Autofilter
A Whole Slew of CheckBoxes
Excel Formula Dates
Mirror Workbook
Form Data Input
Number of pages
User Form Data Input
Count Number of Records and Number of Fields in CSV File
Track Inserted Rows/Columns in two spreadsheets
Bypass "Save PDF File As" Prompt via VBA in Excel
Loop Until Desired Columns left
Searching
MS Query Application Window Remains Open After Refreshing PivotTable
On Error GoTo Doesn't Work
Filter
if Error, Pause or Loop
RUNTIME 1004
Using a 2 dimensional string array variable like a lookup function
custom excel function returns array, showing #VALUE in cells
Validating with Like
I am desperate for help on Excel export to Quick books
Saving/Refreshing with Ontime
Display alert problem
Importing Visual Studio form into VBA?
Find 0s on Sheet and Replace with Formula
Repeating a loop
Find Number Then Do Until Loop Question
Test if moving off a cell without choosing a value
Copying sheet tab "x" number of times
call sub inside other sub
Help with Data Validation.
Add User Name to Comment
Find End in Undefined Range > Select Range > Trim
loop for-next with variable end
Re: Select and copy certain tabs using macro
Newbie attempting VBA Scripting
Choose function in Excel 2003
len of item in an array
Rename a Sheet Q
Select / Activate last Sheet
Two formats within one cell
Variable text manipulation
removing maximize control from excel application (not justworksheet)?
Looking for values
Throw out the Excel Object Model and then bring it back!
Macro Short Cut Key Issue
Another hyperlink quandry:
Finding words with capital letters and numbers in them
Repost - CommandBarButtons not responding
Filter and Corresponding Validation List
Range problem
Select and copy certain tabs using macro
Modifying chart source range using variable
Add rows Automatically
Button - Macro to auto-populate data
Input Box for data-entry
Error handling
Delete rows macro
Getting a celldata from another excel worksheet
STILL_ACTIVE
round
Merging Two Files
2003: Slow Response on ClearContents
ActiveWorkbook.SaveAs does not work
Copy rows onto existing sheet / start a new sheet if full
subtracting one csv file from another
Pulling Data from Web Automatically
Hi all,
Input and display help...
Setting xsi in Excel XML output...
How to make a txtbox not visible
Changing cell formula in VBA
Changing Control Object Name( command buttons etc ) from VBA code
Macro for Fill Down where number of rows differs and without havingto hardcode column ranges
PageSetup
Split the Worksheet
Worbook increases in size, slows down too much
Set Range.....am I to blind?
using a vlookup to enter text into rows beneath the vlookup cell
input box method for macro
Workbook Reset AutoFilter to ShowAll
Look for values into Ranges
Reoccurring mathamatical answers
How to return Excel errors from VBA?
Is a cell in a range?
hiding unused rows using macros
Dave Peterson Numbering Worksheets
Adding Help Text to Newly Created Functions
Vlookup?
vba excel - public function in module
Changing Watch variable value
Password Form
Chart Seriew Values
delete empty rows
Tab to combobox and select it instead of the cell
Word-Object: Type mismatch
Filter Pivot table from a form
UserForm Not Hiding
Pivot Table Column Issue
Select certain tabs using macro
Conditional Formating
Best Practices Question
referring to increasing VBA variable name in loop
Pasting lists into Forms
Hide/Show column at run-time
Get data from email attachments
autocomplete method disables the copy function
Vista and VB6 DLL
Winform Exporting Data to Excel form Datagridview
Filtering a numerical range
Macro to change macro or module level const that is calculated
Fast Filesearch
Conditional Formatting with Dates
Determine if clipboard is empty
Restrict dialog box closing
delete data from excel without openning it
SQL Sentence from Text File
convert date as text to number
Error every other run
QueryTable Last Refresh Date?
Find variable in Col B, Copy Paste Values in Cn:Tn to Row below
Checking reference for named cells
Concat a parameter into a vlookup?
Exporting selected tabs multiple times to different file names
Use column of data in query to SQL
UserForm.Show error
moving to the next line in the appropriate column using VBA code
Copy tab ? times
Edit Sheets in Excel Addin
Automating creation of named ranges???
Pivot Table question
Inserting a picture that is embedded in an Access Report
Automating the conversion of CSV files to XLSX files
Output on .csv with 90 line limit
Select Case
Sounds
Re: Removing Access External Data Queries from Excel
Running macros in Excel 2007
putting a picure
Removing Access External Data Queries from Excel
EOF general usage
Add-In macro execution problem
Delete Row if Value in Column L equals zero
multiple if statement
SplitVertical + C#
resetting combo box to top line
Row Insert Function
New to Arrays, want to use them in user forms,
Setting Print Area
Identifying Beginning and Ending Rows in a Selected Range
Invalid Procedure Call Or Argument with VBScript
Replace Worksheet
Why use Class Modules?
Moving all the cell content
Producing a login sheet for excel and a linking stock with an ordrpage.
Calculate *without* updating external links
I can't update external data sources using vba
Capital letters in cells
Saving an update file in same directory as older one
how can i create a cell that will blink on/off on a true conditio.
Find text from range and delete row
Ignore case of text in code
Refereing to a picture in a excel cell
Selections fill a form
Sum values in listbox
REVERSE GEOCODE LOOKUP
changing function keys in windows xp
Macro opens files as it tries to access them !!!
how to extend columns
Minverse
Forms Combo Box Listindex set to zero
Alternating color row makes excel run very slow
Help with array
Delete Columns if value equals zero
Need macros in file to be available, but don't want file to open
Hide cell contents
Single stepping gives different result
Transferring my data from one workbook to another
Updating total cells after column deletions.
Find numeric characters found within cell text and convert tohyperlink
Help with formula
Help with formula
Create Folders From Excel
Calendar
Paste-special values disabled
Unlocked cells become locked on paste
Problem with transfert between Sheets
Check path and files
Spell checking textbox on a userform
Calendar Control Help
E-mail if Cell B33 = Yes
Updating Code when a row is inserted
Scrolling error in listbox on Vista
Checking for a picture
Input box rounding
Tweak to clear button code needed
macro to convert string to dec
Help with Macro
Combo Box help
Exporting Excel to acces
User Forms in excel 2007
Calling a Macro from another workbook
Compare allowing variance
Create a new Worksheet with a few Twists
Comma in number in msgbox
Grouping and Macros
Automatic Open Created Spreadsheet
Prevent PivotTable Overwrite Warning and Disallow Overwrite
xlDialogOpen arguments
Vba - conditional formating
User Form
Programmatically allowing user to select worksheet
Re: Advanced filtering of Union of named Ranges
Command Button / Macro won't execute properly
Automatic date formating
Macros with Grouping
Find and colour all cells with Validation
Automatic date formating
How to add a Macro (.bas file) in Excel?
Is there a fuction that counts number of highlighted cells Excell
Pause, print preview, resume macro
Lost My Personal Macro Workbook - Thanks Ron de Bruin!
Pivot Table via Macro
Changing Path for SaveAs Functions
Filter pivot table results without filtering in SQL query
Email using Outlook
System Error &H8007007E (-2147024770) The specified module could n
CommandBarButtons not responding
Excel Question
drop-list with different colors for the same charachter
Change LinkedCell with VBA
How to Set datarange for pivot table?
Turn off Auto-Converting entries
Change CommandBarButton state not working
messagebox macro
hash value of range
Problems with RefreshAll method
LinkedCell problem
Form In .xla file
Custom tooll bars in excel 2007
get the Alternative text of a pic.
Command Button Naming
Option box for running a macro
Is there an If Or Then statement?
Bitch Arabic
Set Page Break Lines using VBA
work from home jobs
Cell index?
Pivot Table help
Printing according to computer
Macros function sporadically
How to create a trigger macro in Excel
get from Excel 2003 add-in to Excel 2007 add-in
Complete Excel VBA Reference
Comparing pivot tables entries with data in another worksheet
My Excel VBA form "Whites" out
VBA to count rows from specific cell and insert rows
Load a File Error 9
Using "Paste" Method in VBA
copying
MyArray (ComboBox.ListCount-1) possible?
Another to get hard returns in instead of: " & Chr(10) & "
How to add total from alternate cells?
Updating PivotTable SourceDate using VBA
Save as problem for Excel 97/2000 (with VBA-protection in excel 20
Positioning a comment
Wildcard Character Placement in MS Query
Mail Merge Question
Delete Data from textboxes
How do I insert blank cells with VBA?
Using VBA to parse RTD objectdata
Office 2007 compatible with Office 2000 macro programming
assigning tasks to users
Comparing Pivot table entries with cells in another worksheet
Count backwards with a for next loop
make buttons move when scrolling
find multiple values code tweak
invalid procedure call
Enumerating the names of *subs* and *functions*
how can I get the worksheet with the pivottable sourcedata whenworking with a pivotchart ?
Concatenate a Const Name in Sub Routine
how do i get get worksheet name for pivottable sourcedata whenworking on pivotchart
Autofilling
How do i restritict permission with IRM in Excel 2007?
ThisWorkbook.Path & Windows Vista
Filter on active cell
Excel Add-In and Data cache
Hide rows within a range IF...
Change Rotation of category axis in XL 2007.
Create a Clear button to clear unprotected cells
Delete row if value does not exist
Read and search
Duplicate
Using Graph properties in VBA
Variable Issue
Graphing
comparing contents of worksheets
How to protect excel workbook from macro starting from Developer - Code ribbon?
"Protecting" VBA macro from source reading...
adding cells to show in a text box
Document Container in Excel
Code to auto update a footer
how to set workbook window active
adding shapes to forms
Lost My Personal Macro Workbook
User Defined Function Opens Improperly - Round III
How to code: If active cell is B1, goto H17 when enter pressed
reutrn a value from a cell in each workbook filename from another
reutrn a value from a cell in each workbook filename from another
Hi, I am new and looking to hookup
Add text to a cell that has a formula
Find Method question...
set cell value
using textbox for cell values
With excel 2003 could open .csv file but not in excel 2007.
copy rows based on conditions and insert them into another sheet...
activating the previous sheet
How to force selection of all current text in textbox control onentry?
Making list from varius data
Cell value consistency/macro problem.
file not found stumped
Cell value consistency for all sheets/Macro problem.
Return a value programming
Copy/Paste Values & Formats from each Sheet & Book in Folder A to B.
User Defined Function Opens Improperly - Round II
hi arrays again
Print only down to last occupied row
Complex numbers in excel
Multiple search and copy
search column for data
Copy range from one workbook to another
Temporary Internet Files
error 5174 file could not be found
Trouble Setting Up Graph With Scroll Bar
understanding the .FIND example
Can you set up a "Return" key - like a typewriter?
Find and Replace
Fetching data from WCF/Web service?
Capturing data from a form
End a procedure from a different procedure
Multiple sheet #REF
=COUNTIF(A5:A51,"=D240:Q251") Why will the cell D220 not TOTAL
How to do bit manipulation in VBA?
User Defined Function Opens Improperly
round time in column to nearest half hour
How to disable certain code segment?
Create image in Form 'on the fly'
Autofilter-Filtered List Scan
Vlookup with varing Column length
Returning a qualified drop down list
delete rows when finding certain content.
Securing coded hyperlinks
Exit Sub not exiting
At a complete loss for lookup/delete...
Long User Form Question.
arrays
Macro to have equal size charts and picture in MS Word
Excel if and else statement
head spinning loop...
Preventing printing
Custom sort with user form
How can I attach a combobox to a cell and have it resize if the column width is alterd
lookup information on separate sheets to delete
loop through columns (using for-loop)
Vlookup where value begins with
Vlookup w/ #N/A suppression
Combobox with current date
Refresh Ext Date Range Query with workbook closed? (Exc2003)
Newbie Excel Programming Question
Finding text or part of a text inside the value cell
Range as cell numbers
Re: Date entry and format changing?
test mark
Can't activate an existing workbook
Find the last hidden sheet
Chart vs Sheet distinction
fill in empty cells beneath filled ones
Retrieve focus After Update
Autopopulate via VBA
Change Refedit control icon
Tracking border event
VBA modules protected by password
Using the outcome of cell A in a formula in cell B as a worksheet
Calling a procedure from another workbook
Automatic distribution of raw data?
Strange behaviour - very slow after filter
VBA if loop
Chart points ON/OFF help request
Search gui
alert if selection contains hidden rows
About Promt Window
Storing and retrieving 3-D arrays in/from workbook names
counting through the alphabet that is above 702..
Calendar Userform Problems
Re: elements in an array
VLookUp Syntax Error ?
Controlling cursor w/ macro
Button in Form
excel
Password prompt when closing Excel
Dinamic Validations Lists
INDIRECT and SUBSTITUTE
vb6 vs vba question
Pivot Table to count values
Visual Basc window displays after unlocking the computer
Excel-called Dotnet DLL is using wrong Framework
Vlookup in different sheets and workbooks
Excel 2000 User Forms & Macros - Will they work with Excel 2007
Reference to Columns
Short cut keys within excels VBA Forms
VS2008, Excel Add-in, Problems with Reflection
Call a sub procedure from another workbook
Formula
Referencing Active Sheet
Re: Find the End of a Pivot table
Excel Function Query
merging cells
Why would 1 excel PC understand chr(13) and anoughter wouldn't?
data disappear after extracting from querytable
Consolidation - including text consolidation
Transporting Excel 97 Macros
Is Workbook open without error
RE: insert 24 hour clock worksheet
Pictures runtime error using VBA
move formatted cells
Refresh table after code runs
Compare columns
play girls
RE: Macro - Clear Borders
Future of VBA?
diff between used range row and lastrow
How to add Menu Bar to User form
How to paste a shape on a specific index in Excel 2007 worksheet
Reference Outlook in VBA
Library not registered Error Message
Deleting content after the last data value in VB or Macro.
RE: Calling an Excel function from Delphi w/ OLE
ScrollArea : How I can do that
How to populate a combobox based on selection from another combobo
Query Table Deleted on Refresh
remove sheet2 gray out
Subscript out of range setting Workbooks.Item(bookname)
Drag and Drop editing that does not change cell references
Use a variable for a Form reference
Paste value and Auto row increment
Error LineStyle
Select a sheet
ActiveNext
test file - is open?
Rest execution of procedure's or macro's
Call Excel Macro from Outlook
How to know which cell caracters are underlined
macro timing issue
Sort issue
Re: elements in an array
recording macro for a formula
RE: Time multiplied by currancy rate
type error
How to match a text value to a number value?
Excel 2003 - Seleccionar caracteres duma célula - Macro
Re: Programmatically set checkbox values on worsheet
RE: input box to allow range OR strings
Last Active Sheet
automtaically choose printer
How to fix this erorr (Selected Collating sequence not support by theoperating system)
How to fix this erorr (Selected Collating sequence not support by theoperating system)
How may actionable items can you have under an ElseIf Statement
RE: Macro - Clear Borders
Re: can someone help me with code for tab/enter stops?
Re: can someone help me with code for tab/enter stops?
Re: Saving HTML as Excell
Re: Step through cells in a selected range
Re: Step through cells in a selected range
Re: Step through cells in a selected range
Copying a row to new sheet based on column value
Page Setup not working in macro
Dynamic graph
Finding blank cell
Fill Combo Box
long memo access fields when loaded to excel 2003 with vb
syntax error
EXCEL CRASHES ON SECOND XLQUERY REFRESH
Programatically Filter a protected shared worksheet
Slow excel because of shapes?
Need a macro to count number of occurrences
Simulate a doubleclick on Internet trough VBA
How to run a procedure from other Project
rearrange Columns according to predefined order
Project Planning using Excel
posting code
How to select Visible Cells range minus 2 rows (frozen panes)
How to set up caption on a button at startup?
Select range then name it
2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
How to resize worksheet
Set variable to active cell address
how to call a custom menubar item
circular reference when using dynamic rage
Microsoft.Office.Tools.Excel.ListObject
How to pick the second largest value in a data set?
Increasing Row Value
Excel Link (MATLAB) help
Scientific Notation problem
SUMPRODUCT array formula
My page settings changed and won't reset (print settings)
Module Question
Collate option unchecked in excel
Convert and save a worksheet as a PDF file
Windows Media Player - how to establish references?
Invalid Procedure Call or Argument - Run-time error '5'
CountIf cell value greater than 14
Need furmula of R-squared by polynomial regression
Return row
Excel DCOM Identity
UserForm_Initialize, how to exit sub based on condition?
Using offset to select a range
Constrain Excel Solver solutions to a list?
Evaluate Method Returns Type Mismatch
Evaluate Method Returns Type Mismatch
Evaluate Method Returns Type Mismatch
Excel macros - shared between different xls files?
UserName Function: Not Working
Converting Cell Values Through Automation
How to automatically covert excel version by coding
Match and copy rows from 2 sheets
Sheet name from range
OneColorGradient
Update of UDF (User Defined Function)
changing location of words either in word or excel
Pivot Table via Macro
VBA Help Naming Sheets
Does TREND or LINEST work for "LOGIT"?
how can i change the arrow color using IF condition
Pictures.Insert not working correctly in excel 2008.
ListBox Control
Deleting Check Boxes Within a Range
Help with nested IF statements
Copy sheet with >255 chars per cell
opening worksheet
Corrupted sheet - What the cause?
can you store macros on server?
Chart Title Reverts Back To Previous Value
Generating Passwords in Cells
Automated Gradient Calculator Macro
Creating Complex Functions in the Worksheet Formula Bar - THIS ISNUTS!
how to name filename with date in macro
Print Preview chart when chart is clicked request.
Toggle Design Mode in Excel by AddIn
referencing Solver.xlam vs. Solver.xla - 2007 vs. 2003
How can I copy a linked excel doc including the source database
VBA FOR SUBTOTAL
OnTime Event Scheduled?
Generating pairs from a given set
Controling alignment in header
If in Excrl not in VBA
Chess!
Open a file from vba code
macro for copying background color
Help me transfer values from sheet 1 to sheet 2
Saving in csv file after removing unused cells
How to select range like page setup
Problem trying to use Excel objects in VS 2005 Express - Worksheet
Assigning Tasks to another User does not seem to work
IRM and Sorting
How to Access a Range in Another Workbook
Filter using Mid
Formatting the background of unlocked cells
if for merged cells
dynamic range in a macro
Create New Spread From Old Worksheet
pivottable/pivotcache question
select only where text exists
Edit a Literal or Integer
Macro Help - truncate text
edit a integer or literal
autorun macro from access
Losing Named Range Definitions
Max of 1 column for each unique entry in another column
Open .net form from Excel VBA
How do I export event dates into a calendar format?
changing property of a box while using if/then statements
2007 Help
Programmatically Restart Excel
Conditional Cell Link in Spinner?
protecting boarders
Check if number already are in the sheet
VBA Macro With User Protection Settings
Deleteing cells
Change the cell value based on changing date
Detect existence of a sheet
Using cell data to open other templates?
How to create XLA?
Custom property of a cell.....how?
Date Sorting
Cell range excluding blank returns
Comparing Dates
Assigning a macro to a button on a toolbar
Phases of the moon
Refreshing Pivot Tables
comparing dates
Pivot Table via Macro
User form - Get record & Edit Data
how to limit custom toolbar's display
How do i translate figures in a cell to word in another cell?
database formats
copy and paste
user form, field split???
filling a row with data, depending on certain criteria
Importing VBA file into Excel
Test for record dates?
Show Results in TextBoxes, ONLY if All TextBoxes have Data in them
Refresh Data
Test if entire row is selected
Autofilter used with merged cells
Tracking cell values...?
Showing the same line when going to another sheet
Programatically Filter a protected shared worksheet
How to add New Module through coding
Show progress of copying
Excel converting dates to numbers.
compare 2 xl sheet with same data
IRM protect Excel-Addins programmatically
IRM protect Excel-Addins programmatically
Add-in memory leak
Looking for someone
Storing real time data into Sql Server
Copy Worksheet Function
Remove - "A program is trying to access e-mail addresses you..."
Printing in miniature
Events don't seem to trigger after deleting cell values
Cell Visibility Algorithm
Vlookup - Issue....
Set range to value from another sheet
assigning different background colours in a range
Multipage dialogbox
ParamArray debug anomaly
Is there a way to add a timeout value to a line of code or functio
Does nobody have an idea ?
macro doesnt run
Re: Re: Help, excel error 53 (loading userform) <== problem solved
Maximum non-blank row in a specific range as a variable
Using autofilter results
Help, excel error 53 (loading userform)
LinkSources full workbook path
Write array from vb6 dll to a specified worksheet in Excel
VBA code for expiry date
VBA FOR expiry Date
Copy Sheets to RAM and back
Chess!
VBA Code/Formula to generate list of rows
Help
PDF995 on NE00
Need macro or programme
Reading back a Read/Write Property
Beginner macro programming question
Userform, select entire field
How to get count summary of number that corolates with a name?
Format code returning error