Excel Programming [Archive] - Page 85

floating
how can the lookup function work with two boolean functions
Import and Split CSV - 2
Closing a db file getting errors
check for insert row action...
Need to turn on ALT F11 on in excel
Leftover formatting in code
Re: Import and Split CSV
Pivot Chart Help!
Import and Split CSV
HasFormula() vs. has a "numeric" entry
Using the result of a cell's formula as an argument within a running macro? / More
Please help
Removing a macro
Summation Formula Question (Code Inside)
Find all rows of a color and copy those rows to a new worksheet
Delete Rows
City, ST ZIP need to separate into 3 fields
how can I use VBA to format a column to currency
Determining if column(s) need to be Autofitted
xl setup and vb reference libraries
Move Files from Folder to Folder
Have macro run automatically as soon as excel is opened.
How to return the result of a cell's formula as an argument within a running macro?
Module to make all absolute references relative
More problems witn Benford's law application
Web Query Question
Object Library References
Change event due to Cut & Paste, Drag & Drop or Edit
Upper Case Woes
Error 2015
Stuck in Design mode
How to Print a File or Control
is it possible to create a time-scale using charts?
AGILE VBA
Percent Based Off Last Row Sum
Learning VBA
BuiltInDocumentProperties
Macro Help
Macro to Print specific cells with formatting
how to stop a hidden session from Excel
Macro - Title - Input Box
Printing Worksheets (Array)
macro file name
Hyperlink help
Dropdown list to populate another sheet
faster way to hide rows w/o using autofilter?
VB form Newbie
Module Numbering
Test af fyldfarver
dynamic fill of listbox - need help
Looping
Macro fails in network
2nd Post - Urgently need help on VBA Procedure
Creating a folder using macro...
Data Validation - Mulitiple Tabs
PLease Help..Neeed Hyperlinks from cell values
Macro Formula Reproduction
How do I set up a greater than but less than formula in excel?
Need to extract hyperlink
Transpose
Workbook_Open macro question
how do I copy worksheets between workbooks without the macros?
get_Range function throws an exception
Formula Reproduction
Combo Box - AfterUpdate
ADO Record by Record
working with links
Selecting Column & Row contain text
InputBox default value?
Running a .exe from VBA
Some VB coding required
to find the conditiona format of a cell in vba
Changing the code on an external link.
No. of Columns
autosize
based on Cell/Column content ,cut one sheet's values and paste it in other sheet?
Shortcut Attributes
Find and copy
changing find to for/next
finding blank entries
Unique Number
Closing Within Macros
selecting the currently active column
select the contents of a cell
Gant representation.
Pivot Table Creation
Using input box to improve my method
Opening MS Applications
VBA loops and Dolver help
i entered this formula =Randbetween(B111,B110) but no number
I'm Stumped
Userform.Caption is blank when reference passed to class
Macro help, populating excel spreadsheet
Convert Date format UK to US
Activate MS Outlook in macro?
Automated contract received/accepted/loaded spreadsheet design HELP NEEDED
Challenge experts will LOVE!!, can you get the formula??
Using a formula in different columns, for corresponding data
Generating 1004 error messages while running a marco
Locating the row that has no values. Selecting that row till the last row after that and deleting it?
copy two columns without blanks in the first column
Make excel stop if the date cell is blank
2nd Thursday of the month
multi-line text file import to excel
Data save (data base)
Advanced Filtering problem
Force Save over existing file
Cells(Rows.Count, "b").End(xlUp).Row
Hyperlinks and multiple files to open
Limit a calculation to a certain number
Extract macro text out of Excel (Newbie)
Seperating data from one column into two columns
Combine several columns of different length into one single column
One to many problem?
code help w/userform
Help with Recursive Call?
NORMSDIST() and NORMSINV()
Change Registry in VBA
File size
.SendMail Method into Eudora
XL 2003 Graphs: Retrieving Point Name
Transfer data
type mismatch error in Benford's law macro
How to determine whether text in cell needs to be wrapped?
Macro to import text file and update calculation to include new co
Returning the wrong values...but not in the Immediate window?
Print area based on item list
My first macro, uses Vlookup but doesnt update unless hit I enter
List Index filtering
Open Office
Printing Problem
need help
CountIF in VBA
VBA Command - I need help Please!
Need to extract hyperlink
Event trigger in Excel?
Pivot Refresh over ODBC
to Copy the Entire Row
Pop up warning message based on a certain value
Change #DIV/0! across a range
MSFlexgrid in Excel
FormatConditions VBA Bug?
ComboBox fill ActiveCell
Leftover Workbooks with Opening Excel in IE Browser Window
MORE listbox code
Excel 2000 - 2003 Compatability problem with pivottables
VB editor bug?
turn off link resolution?
Sorting
#REF! error with custom function programmed in VB
Calling the "Duration" function in excel to be used in VBA?
Workbook Deactivate event problem
Problems with Excel 2003 - Dashboards
conection with Oracle database
Excel thinks 1900 was a leap year???
How do I declare a function whose output is an array?
Compilation error when using an English VB program on a French Exc
Help with macro that gets fired with check Box
Macro buttons need to be exorcised
VBA Shortcut needed
Adding and removing text within cells
Summing a Field while Using an Autofilter
set variable to activeworkbook
I'm adding 1.5 & 1 and VBA is telling me its 2 ?!?!
listbox code
multi-function macro possibilities?
Random Password Generator
How to, check if a picture object exist
VBA & Multiprocessor PCs
I need your help. I want to add additional text within cells
Date Problem
Macro to delete characters in field
lock cells
Best way to "filter" an array
how to delete different data from different cell at a time and lea
macro launched when condition is true
Conditional Formatting - Range of Dates
Loop that finds blanks, then subtotals values into different column
How many nested statements is this?
Using variable for range address
Min & Max of a dynamically updating cell value
Slightly off topic - counting rows in XLS?
Macro loops and solver (VBA)
Can i use Paste Special in this way?
Excel 2003: Files can not be found
Help with Excel FreezePanes from code
Delete worksheet - dialog box showing
Copying UserForms & Modules to another workbook
How to Combine or Merge Columns?
Macro run from if then function
Fomatting based on columns displayed
How to use a macro from another excelsheet
Re: Simple Loop Help Please
Simple Loop Help Please
passing arguments to events
Range("A1").select doesn't work!
Yes / No - Goto VBA
VB's Command Button vs Form's Command Button
Help Cleaning up Code
macro does not work from commandbutton
Help: XL & Outlook
Automated Printing
go back/previous cell
Automated Printing
Undo a Macro?
Sum up a dynamic range
Macro Names
Specifiying a Range
How to add shortcut to custom menu entry?
help with copying worksheet (excel 97 vs excel 2000)
Importing Text File
Haven't fully tested my code - whats wrong with it????
Removal red rows in excel
Macro Drop Formula As Far As Required
problem in deleting and inserting a row
problem in excel
Form, or seperate text boxes?
HELP!!!! needed in Excel
HELP!!!! needed in Excel
based on Cell/Column content ,cut one sheet's values and paste it in other sheet?
Immediate Window phantom entries
Circularity
Removing spaces and adding comma's using a Macro
Filling an array from one sheet to another
Excel - Date comparision in VBA
Can anyone help with the following macro?
Print Area
programmatic advanced filter
Just another listbox question . . .
moving sheet changes object assignment?
string function
Macro issue
Worksheet Coding
CurrentRegion works different in the Editor than in the workbook
Random Number Generator
refering to details in another sub
copy cell value problem
Like with * returns incorrect sheet name
Help with the old #DIV/0! chesnut
Enforcing a Cell format
distributing an Excel/VBA app
Why does Range.Rows.Insert sometimes not work?
VBA - Click mouse to change cursor to cross hair that spans the en
VBA - Excel VBA URL's
VBA - Internet Resource URL's
Tom Ogilvy or anyone else who can help!
Chart: range info from seriescollection?
change cell values based on drop down box selection
CommandBarButton onClick
copy data from one excel to another in Visual C#
Importing HTML File
HLOOKUP, VLOOKUP
Locate specific record
Copy row from one sheet to another
Creating Help Files with HTML Workshop
hhctrl.ocx
A Dollar's Worth
Printing the contents of a text control on a user form
InternetExplorer
C# Automation Server and named range reference
Read-Only
customized chart-please help!
Exit Sub
Get text from a Html form
VBA does not receive Excel Events
Write Code w/VBA
Limits to using Call
user form input
Specific Range Deletion
.chm Help Viewer
Need Help With ADO Recordset and Loop
Deleting old workbook data
Import text file and create new spreadsheet
Vlookup
insert user and pasword in a frame of web page...
Count number of shifts...
excel 2003 and c++ API documentation?
Listbox data required
Opening file with date tags
lock cells until one cell is filled
How do I access a "Global Variable" of one Workbook from another??
Textbox problem
Navigating with a macro
Automatic Cell Population
Message Box bleeds when dragged
Re: solver.xla VBA bug?
Problems with DAO and SQL Server
need a way to create seperate worksheets from a master
Hyperlink
Viewing Excel through a web-browser
Running an addin-macro from another Macro
Macroo assigned to CommandButton
Need assistance to write a macro that does the following
EXTREMELY slow toolbars?
SEARCH AND DELETE
Excel & Outlook
Unique Data Validation
Fill empty cells
Autosum function
problem selecting a range using variables
Disable creation of Enhanced Meta Files?
Combine multiple rows to 1 row.... help
I want to get the sum of a total number of fields on a weekly basis.
I broke my Excel!!
HOW DO I GO TO DIFFERENT CELLS BASED ON WHAT IS IN A CERTAIN CELL
help needed trying to find autoshape/shape name
Creating a Workable Space With UserForm
force to use a specific XLA
Recordset keeps returning EOF and shouldn't be.
Can I run a message box Macro on Save in Excel?
accessing word file from an excel file
Object browser icons?
How to reference to other Excel application in VBA
Help with Count, CountIf, Sum Functions
Copy all Range Names to Personal.xls
Convert CSV from clipboard into a transposed list (part solution provided)
Help with calling a function
Save workbook as a PDF File
#NAME trying to find VB function?
Enter formulas in a certain number of rows, based on a cell value
Breaking links in a macro
Displaying the progress of calculating cells
Auto Add Row
Loosing variables help needed
pick from list
Automation Error help needed
Ifs, Selects & Loops Error Statements
Worksheet Menu Toolbar
How do i truncate a series to lie between 0 and 1?
VBA block warning
How do U Color shade Locked and FormulaHidden Cells
vba, step to next line
Scroll and print
VBA Setting value error
waiting Query result
Automating Import of Date Information
"how do i use color with if in exel"
How can I catch a Paste action and default it to PasteSpecial-Values
password
How do I open a file from a named cell?
Automatic recalculation of array functions
Password Protecting a particular Sub
HELP!!!! VB Macro in Excel
HELP!!!! VB Macro in Excel
Fill a Listbox with mult. Variables in userform
For Next Issue
copy problem using excel VBA
Display only selected fields in a PivotTable with VBA
Programatically changing MS-Query properties within Excel.
Adding a tip when the mouse is hovered over a shape in Excel....
Skip if variable not determined
removing tabs and newlines
generating text box value based on equation from other boxes
Use of Range(Cell1,Cell2) in chart creation
Setting the active printer
change pivot field of button type figure to general text
conversion question
Alt + F8
independent macros
How to automatically create and populate worksheets?
Split one field into two
UserForm Listbox doesn't update
sumproduct in VBA
Remote Procedure Calls
run time error(13) type mismatch in Excel Feed
Blah
check if the result of a formula is null
.Parameter property of CommandBarButton
Finding all the values and storing them
Excel loops and If blocks
Formula in macro
Is there a CopyToRecordset (Oppisite of CopyFromRecordset)
Cell Row and Column address
setting page breaks.
Input Box Asking for Date, and Validating Format
Web-Based Excel Reporting
How do you remove leading zeros from a column in an Access databas
Date last saved/updated
Canceling Workbook Before_Save event
Add, edit, delete, save functions in excel using macros
reference, test and change cell font.
VBA, database and Charts
getting rid of unprintable chraracters...?
listbox and textbox problem
Print pages
Update all the work books
Problem with Monotype Sorts Check Mark
Exporting data range from Excel to Access
Variable
How to count optionbuttons on specific range on worksheet
Get embeded HTML Button text
Chartlabeler Question?
Calendar Input
HELP I need a function or macro to crop cells
program
finding chart series low
Using VBE to change tab name
Continuing a loop from within an if statement?
simple vba queries.. please help..
Date find and copy function.
How to get Excel to open text files by the time created not name
Função de números por extenso
not releasing excel objects..pl see this simple code.
Hide Selected Cells
Conditionally formatting
timesheet auto populate date?
Userform Captions
Date Time of Last Execution
Excel Still Thinks Workbook Has Macro Code
autofit
Hide Columns When Printing
pdfDist.FileToPDF does nothing
For Each / Next
add wks into form
Getting rid of command bar chevrons that allow "customize" menu (Excel 2003)
Compile error
Use Task Scheduler to automatically run Excel workbook
How do I calculate a several tier IRR waterfall?
HELP: MsgBox takes 99% CPU usage... why?
save word doc
USE
help me to sort out data by text
retrieving Text from a textfile in Excel
Need help on MACRO for copying between worksheets
012979666
Difference between before_close and auto_close
Closing Excel using VBA
Importing pictures or graphics
ContextSwitchDeadlock with Excel VSTO
Defining a Variable
Data is pulled from LotusNotes to Excel2003 ,the file hangs.
PMT Calculation
function: copy current path or filename to clipboard (XLS)
Logging data using the same textfile over and over again
Excel needs function to Convert Rowindex into RowCode (2 -> B)etc
Run time error 1004: "No list was found.."
help looping through textboxs on userform
Renaming a workbook without saving
-4127 is created by my macro.(Bug?)
How to Check Empty Rows in Sheet2 when sheet1 buton clicked
Excel shared file problem
Like operator
add text into right-side of menu bar
Non Refreshing/Recalculating Cell ??
Job
Reading Wordpad - Rich Text Format
pulling data from another sheet
Opening a file with date extension
Link page formula error problem
naming the column
Inventory
Combobox Query
How to create a simple VBA Custom Function
VBA - Hex To ASCII
If line ends in assigned value then change item in COMMENT.
don't save macro results in template
Using a Macro that switches between workbooks
Special characters, printing
Passing value of variant
Edit Forms
Expressing If formula in VBA
web and excel find text string...
VBA - Error Using Mid To Parse A Data (.dat) File
Deleteing Rows starting with value (text)
Macro - select and paste
Cell background color (interior color) setting not working
Find Character Position in String
Fastest way to find item in an array.
Unable to get the dropdowns property of the worksheet class???
Help with a simple macro.
Validation List
I need to convert a series of DOB's from yyyymmdd to mmddyyyy
fetch data from excel page
Passing variables for range series charts, what to do with post macro run; unable to
insert function, please help
Help its not working
Combo box error on form
How to prevent multi-access for XLAs?
Setting a Custom Class as a Global variable
Moved file, changed path, macros don't work
VB Questionmarks in a For loop
Counter to delete a row
Adding items to a right click menu
Works when stepped-through, but errors when macro ran
How can I make the copied range from another worksheet independently
How to pass address(es) as parameters
Forcing the cursor
Calandar
Excel and Finance
Single statement database/range processing with criteria
Importing multiple files
Random Selection
Find 2 Matches Wors Then Cut Selected Rows
Loading xml files
Quickest Way of making an Array
find max value in multi worksheets
quick help: get folder name
formatting decimal places for complex numbers
Columns in textbox
SQL query syntax
Lookup from a very heavy file
User to choose an item from a list
Add-In password is requested when closing Excel
Timestamp for ComboBox
saving macro gloally
Custom Functions are static?
ListBOX1_Click problem
Reset Excel Defaults
macro to savecopy as and break links
Deleting a row
Return a Value Based on 3 Critera
macro converts formula using imbeded literals
passing an object
date time Formating
Sum in hidden column
How to refresh Share workbook in excel someone can see changes
Date Time Question
Is Empty
VLookup error
Pull Pivot Data
Newby Needs minor tweak on this VBA Macro code for Excel
one line!!!
Hovering over variable no longer shows value
looping
Accessing data in pivot tables
List Filenames from Folder
Open another excel file in macro
Combine CSV files into 1 Excel Workbook as sheets
data flow chart
Would this require a program in EXCEL? multiple conditional statements
XLA in startup path
Delete range on open
send mail from excel 2000 with multiple attachments
Error Trapping question....
limiting rows in a text box?
double quotes syntax required
Need a template for setting up a permissions database in Excel
Message Box
cannot get GetOpenFilename to work
applying math operation across range of cells
Help! with MECE tabulations
Collecting textbox input within a for loop
extract data from a cell
Importing multiple files
Dynamic Toolbar icon
Staff Rota Template?
Convert Workbook (to text)
Sum vs. Addition
SendMail to multiple recipients, one variable, and one constant
ActiveSheet & Apropriate Reference
Searching 2 columns for dates and text problem
command button on worksheet
Converting a report into a Pivot Table format
Need to change existing formula into values...
Passing Custom Class Variables through Functions
Very slow unhidding rows Excel 2000 SP3
Copying contents of w/s drop down boxes to another sheet and creating a named range?
Help with macro to give a message box
Workbooks.Open fails when using a full network path....
Insert a column with it's own delete button?
Saving Data
Hide non-contiguous columns
Excel FileDialog object and Visual Basic 6.
using a worksheet range to populate a combo box in excel
press button via vb and excel
MSG box if
sending email from excel using macro
Time-Tracker form, multiple instance of Excel
Formatting a date from a textbox
Subtotal \ Grand Total in VBA
forgotten variations of loop
Styles in a cell
Logging username, date and time
Sava As and templates
add colours to caracters
How do range objects work?
Named Range
Multiple workbooks
Do until code attempt..
How do I diable Show Tabs under Option Menu
Open file in VBA
SpellNumber Function
Run time error : Excel 2000 and Excel 2003 : different behavior of Macro
Re: rows of text in merged cell with wrap text
opening an existing text file useing code
Comparing using "If" function
Help, please
Slight prob with this code
inadvertently created loop
How do I use variable dates with a SQL Query
Matrix averages
Auto-detect range size
Voting Response
Truncating a string in Excel
inserting rows in between using VBA
Very Simple Question
Removing duplicate rows and combining unique data
userform label double-click goes to click event
Crosscheck ranges
Chart
Creating a Range from two specified Ranges
Help! finding data and pasting it to another sheet!
Very slow unhidding rows Excel 2000 SP3
Excel newWorkbook event not firing
Playing audio, but not from the start
% of subtotal needed in pivot table
Thanks !!!
Autoatically insert blank row above total when no more rows
Excel Copy and Paste Issue
New instance of excel.exe not firing newWorkbook event
New instance of excel.exe not firing newWorkbook event
Opening to a certain page...
Need help: search and delete columns
positional relevance
Share macros on a network?
How to Get Date of Each Cell....
refersTo property
Message Box in a macro
Textboxes - restrict double-click and selection.delete
Varibles determine macro to run
How to do Selection.Subtotal in VBScript/ASP ?
Function ????
Password in a macro
VBA to "Label" and "Unlabel" formula
List all modules in workbook X?
Unprotecting Sheets
Getting The Chart Wizard To Appear
Have this great Macro, but!!
Excel OptionButtons Value Clearing
Custom file menu used to redirect to desired sheet
add-in problems
Excel VBA window appear unexpectedly.... Really annoying
Best Online Source 4 MS-Excel & Complex database Handling?
Late Tracking
Find & Delete columns to the left stopping at column B
excel: international formula names in c#
Find & Delete columns to the left stopping at column B
Does anyone have an ad in or Macro code to find Phantom Links?
Removing Cell Labels
count record in web page...
question on user-defined formula calculation mode: can it be instantaneous?
Language independent Pivot settings
Reference older libraries
VSTO Excel Crashes in Debug
Change dialog button assignment
Form problem
Shared file issues
Delete Rows in Worksheet2 that Match Criteria in Worksheet1!A1:A20
Writing Help for a Formula
Sort method possible without using select
Calling Another spreadsheet
data format 99
how to properly loop a macro
Count and Sort list.
Command Button Macro
Can you see what's wrong withthis code please..
Format range of cells for Array formula
Workbooks.Open 2000 vs 2003
Creating shapes dynamically and connecting them
Who's up for a challenge!!
Sending a range as an image attached to an e-mail
Adding New Member Variables to Cells and Worksheets
User Defined Functions
Work wil rows returned from AutoFilter
Replace Excel Message w/Custom Message
Conditional Date Formatting
activate current sheet
Removing Links and Formulas
Worksheet change code to colour in rows in a database
can i import barcode data directly to excel
how to copy option button from one worksheet to another
Resizing a pivot column based on Field Name
Need a spreadsheet that sorts by month/yr & 2 other sorts w/total
DisplayWorkbookTabs Macro
Fix for mouse wheel in VBE
Create own add-in
pass workbook on to function?
Wildcard
template code in one place
VBA - Launch VBA Macro From VB
EXCELL I WANT TO LOOK UP AN ITEM AND FILL IN MORE THAN 1 COLUMB
Count Number of different numbers
Selecting a call and using info in auto filter custom select
Problem with VBA macro running inside VB
Pasting line to a chart point
system calls in excel
Modules in VBAProject (PERSONAL.xls)
Insert a number a number in column
Insert a number a number in column
Check Voucher Template
Tools | References
Character Stripping
lookup two tables
working with selected cells
Need Excel 2003 Programming help...
How do I select printer using VBA?
Autofilter Question
Error using ".submit"
Disabling SaveAs
copy matrix (diagonal)
VISUAL BASIC CODE
Disallow changes once expiry reached
VBA - Text To Columns in VBA
Sum Relative Number of Cells in Column
Using a combo box on multiple pivot tables
Selecting multiple rows within a CurrentRegion
Auto fill for dates?
[XL2000] ObjFolder.Self.Path - 438 error
Please I Need Help
Can I get a number in such a format as it should be?
Find, Copy, Paste to new row
Maniuplating Worksheet Tabs
formula!!!!!
Multiple Excel Search
Message box if cell is greater than less than 0
VBAProject remains open after Workbook closes
Defining Ranges using macros
OLE Automation and Mutliple Office Releases
Macro copying cells to a list in another spreadsheet
Macro for Print Loop within Excel
Userform help
Excel API events
Access -> Excel
Conditional Formatting - Thick Borders?
Error Handling - Edit>Go To>Special
macro for excel, automate task
Macro to copy workbooks from one location to another.
Changing Field Name
Goto a referenced cell
Calendar Control Changing System Date
userform listbox cannot get listbox.value to transfer back to main sub
AutoFit Very, Very Slow
Need Help Creating a Loop
Excel crashes when Combo Box loses focus
Stop column width from changing on pivot table....?
Search a spreadsheet for words in certain fields
How to create and name a new workbook based on each unique record
Find and replace within a column
Pb with additional VBA reference
user input decides cell copy range
loop syntax
look for sheet name in list and creat hyperlink to cell
look for sheet name in list and creat hyperlink to cell
macro High Security Issue
Workbooks.OpenText problem in XL2000
filenames and workbooks
Merging worksheets into one
insert column macro
Pasting Between Excel and Word
Change Formula with Macro
Printing from Excel using a macro - Phase II
Auto delete of a sheet
selecting Variable range
.xlT File & Spreadsheet Becoming Invisible
NETWORK (LAN) MACRO QUESTION: W XP Pro, SP-2
Week starts on Saturday - Working days
adding checkboxes
Week starts on Saturday - Working days
Week starts on Saturday - Working days
Cell Format Check
Slight VBA Code Change required
Closing a workbook exported to the website
Count 2 (Two) specific words in a cell in a given range
select a cell following vlookup
insert formula
Error 1004 Recordset - Help
Copy Lotus Data Into Excel
Reasons why Worksheet_Deactivate fails?
Macro Help for Substrings
Autosum a variable column length using VB
Novice trying to call a web service using Excel 2003
Peculiar Problem when Doing a Sheet.Copy
Excel and VBA.NET
Hardware effect on Chart creation speed
Determine if a cell is in a range?
Add total
Time Tracker
Time Tracker
Worksheet_deactivate fails - any ideas?
Setting left position works in XL 2k and 2002 but..
Macro to Check only one box
Empty cells not Empty!
So, what if it's already open?
counting actual and displayed values
Why Application.CutCopyMode giving problem
Validating a unique reference in a textbox
Please help. poss VBA
Help needed on loop
Use sort in VBA
extract data from a text file
CU
Saving a file to have the filename of the dated it was created
Type mismatch problem in array - ??
Clearing data from a so called protected sheet???
Help with saving from a cell
ODBC managment with VB Excel
Code Execution has been interrupted - ??
Macro - use variable integer as text
Sum formula in macro returns zero
copy range from one excel sheet to other fails.
Excel 2000 file types have been changing.
VB Combobox field problem in Excel 2000
date serial
.xlT File & Spreadsheet Becoming Invisible
VBA: Opening a .txt chosen by the user
I am trying to convert an excel worksheet to a pdf.
Can't delete columns in Excel VBA
Date since hired displayed in years.months
Basic Question - How do I return the worksheet number of the active worksheet?
Find last cell of data
Can we require "Enable Macros" or else the file can't be opened?
Increase cell limit from 1004
Alternative Ways to Spellcheck a Range
Problem inserting images in VBA forms in Excel on a Mac
AutoFit Infinite Loop?
Run a macro by the number typed in a box/button
Message Box with a Timer
Extracting Numerous Text files into Excel
How do I start an inventory system for a small business
VBA Help on Not Copying Specific Worksheets
ow can I get the active sheet name to a var in a macro??
TopLeftCell change to "bottom"LeftCell
Creating Comment Programatically
Trouble when trying to call a sub
Sales Commission
Automatically calculate in a cell comment
dialog box
Keeping track of changes and saves
Need help - color cells
Printing Embedded Word Document
What's the correct format to check the name of a sheet?
Get Current Year
Additional Controls not opened
Show Data Form
Copying buttons
assign value to range
Integrating variables in formulas in VB???
Excel and SQL
Toggle Buttons
Customizing colors
Is this possible?
Is this even possible????
Naming a Range...?
button to jump to another worksheet
Database Linked Spreadsheet
Macro for Pivot Table
Error 400 - help
Is it possible to set a conditional lock for a cell in Excell ?
worksheet change event
VBA - Loop a Function
Sample Codes for SQL for Excel VBA
Setting a Range depending on variables
Pasting
How to find intersection points between lines using Excel?
Macro for adding new items to list
merging excel books
setting background
Program Auto Yes for overwriting files
RemoveItem - ComboBox
Searching and Matching Lists
Sending to groups in outlook
spaces and codes don't get along
How to "unnamed" workbook.
Collect data and sum, w/ connection to another sheet
clearcontents for some columns of a row
Indirect Name
Any vba code to disable only close button in Excel workbook, please?
Splitting Cell content into separate Rows
Accessing dll
Scheduling a Macro to Run
vlookup in VBA (dynamic range)
screenupdating = true
using cells values to determine macro action
Hide/Show a row based on data entry in another row
VB doesn't like this Formula?
Run-Time error '1004: Unable to get the PivotTables property of the worksheet class
Excel Macro to open file, load & do charts, functional but not usable/not a good prog
excel references
Named Range Change Based On AutoFilter
rewrite in range
Move a sheet to last sheet of wkbk
Help, Code won't work and I have no clue
VBA novice: new to userform & VB editing...
Change Named Cell ranges based upon value of another cell?
Any way to save VBA code so it works with older Excel revisions?
How to save a single worksheet as worksheet name in new folder??
Forcing VBA to wait until sheet completely calculated
Set a set as Calendar Control Object
search for dates set by a formula
July - UK Excel User Conference
Auto-Protect multiple Sheets on closing?
Replacing spaces with zeros
Opening Built-In Date Form Dialog Box Programmatically
Change Pivot Field Value
Choose (open) workbook for actions on user prompt
PivotTable: how to align row data to the left?
PivotTable: how to add vertical lines in Data Item area
Error moving sheets between workbooks
Count Filled colour in cell in given range
Workbook_open - Sub problem
Pasting rows below the last row with data?
Opening Built-In Custom AutoFilter Dialog Box Programmatically
name wise Text summary
Resize columns for all sheets in a workbook
Count Specific word in Specific range
VBA - createobject - If
Opening Built-In Dialog Box Programmatically
Problems with programatically referening libraries
Date Format Error
Bound Combo box in userform
Can somebody tell me what cause the mistake?
VBA to display image on a form - image is defined in Range Name
Executing a Value in a cell
returning values application.dialogs(...).show
Darn function in vba
populate unique entries to txt file
Skipping blank cells in simple math formula
How to turn a cell "OFF" or Null it's Contents?
Deploy "Microsoft DTSPackage Object Library"?!
Filldown? & Cmb?
Annoying Problem
How to display unicode character in Visual Basic script.
Loading an xml
routing slip
Excel error with .NET web application
Can someone please tell this newb what he's doing wrong?
Input Box Asking for Multiple Responses
Access a worksheet level named range with Refers To like "=5".
AutoFilter based on 2 Fields and 2 Criteria?
Combo Box List Dropdown
tab password
selecting checkbox numbers
database ODBC custom formula retrieval and other
Launching Help from F1 on Keyword
Drop Down?
Before Print - Case Select?
Selctionner la derniere ligne et collage special
Merging a full column into a single
textbox format
Ordering a list of numbers?
proportionally fill a cell
Macro Toggle On/Off
keep new menu item with workbook
Creating a button + Issue w/ digital signing
Using AutoFilter
Re: Using AutoFilter
Run Time Error 1004
EXECL.EXE command line
Macro to copy all spreadsheets into 1 spreadsheet
?row and ?key -- Worksheet_Change
Send Email When Cell Value Changes
how do I merge two worksheets and save as individually
Adding formulas to cells
Programmatically verify VBA digital signature and timestamp
Catching text from a Control.
multiple objects in single cell
Auto copy and paste
Create a form to switch sheets
Manual Calculate for Excel Workbook
export to CSV more than 65k rows
Formatting in Excel
Force file name change
Filtering Data In several Tables at the same time.
Messy Users
FTP Directory Listing
Passing Variables through Custom Dialog Boxes
Macro to delete row based on criteria (first few characters of string)
ComboBox1_Change - is triggered when file closes
For Loop Problem
Spell Check range and move to active cells
Set Page Number to One After Page Break
Select Cells In Column that have data
validating data in acolumn
Text Length Data Validation, without error message.
Copy data from one file to another
Function to display a count of visible cells/rows... doesn't
Font Color Index / Name Source
Custom dll troubles
Re: Trapping Add Shape Event
creating Excel Application Object in C#?
Unable to set XValues Property of Series Class
Userform button - shortcut key?
Generic Form
Referencin "Calling" Cell from VBA Function
Re: My ultimate goal is to create an ID that will always be unique
sort and column numbers
finding two cells to sum
Sub works sometimes and sometimes doesn't
How do I?
Opening Windows Explorer...
Guides "Template" - in Danish "Guiden Skabelon"
Summing until empty cell
msgbox background colour
Summing until empty cell
get value from same cell on all sheets in a workbook.
Close an application with sendkeys
VBA column identifier and looping
Runtime error 91 help
Custom Class In VBA