Excel Programming [Archive] - Page 14

Conditional formating
set PageSetup.PrintArea from MS Project
VBA to set Pivot Table formats
Print Text File
Programming for Different Versions
Get name of procedure that is running?
<= in the numeric format
Excel Socket Programming of client side
Send Keys to Open Userform
Compare cells and force most recent change
Simplifying IF Statement
Insert Missing Numbers
Apology
Add command to ribbon
populating cells with array bug?
Search and Copy from one tab to a second tab in the same workbook
Expand Search Listbox beyond MatchEntryComplete
Displaying data from pivot in columns
Save as Text
Unable to Delete Sheets or see Properties
Save-as without stating path
Find blank cell in range
Accessing the VBProject through another program
How to delete correct # of rows
Lookup/Match/Not sure
Macro for cell showing exact value
Help with SetSourceData
"Double Click" macro?
NETWORKDAYS Function - errors #NAME? Is there a solution to thisyet?
Clearing Errors
Tab pages in a UserForm1 in VBA
VBA using VLookUp
Excel DDE and Socket C#
conflict in code somewhere
FindNonDuplicateRecordsInWorksheets
select new wkbk when name varies
type mismatch error
stop long running macro which call dll
Alternate to Sheet_Calc when Filter applied.
Prevent range reference
Office DevCon in Australia
Format Data Series in a Pivot Chart
Where to change default Add-in folder
Macro to take user to a specific date
ComboBox & TextBox Problem
VBA adding Conditional Format to Range referencing another column value
How to check and skip column during paste
Importing Excel data with macros to SQL server
Excel 2003 - macro options grayed-out
Using Hyperterminal
Finding A Number Existing Between A Specific Range?
Need to split large text field
Format SQL Query results in Excel
Date input to exclude weekends
emailing everyone on the list
Mr. Patrick Molloy
Microsoft comm controls
Excel 2003 Custom Menus-ShortcutText
Custom right-click menu without changing Excel.App
Merge data from two temp files into a master
To link sheet1 cell to sheet2 three rows merged cell
Efficiently moving data between worksheets and VBA array variables
Recording a 'Save As...'
importing file into a new file
Big challenge!! Formula for count last 10 columns since today!
in-cell dropdown for vlookup return
Replace the image in a "controlbox image"....
Primes
Date Picker wil not be visible
Add in specific cells
Change visible true/false of controls
Msgbox
HELP WITH A FORM IN EXCEL.
excel 2007 add-ins and other VBA hidden files. General information
Copy data from multiple columns and populate it in another sheet in one column,,
Using VLookup on user form (VBA)
Variable column names and ranges in Pivot Tables within macros.
autofill formula to dynamic row count
Copy Changes in one workbook to another identical Master Workbook
Using SUMPRODUCT where one of the columns can be either TEST or aNUMBER
Remotely close a workbook
Fill 2 column list box with Advanced Data Filter results
textbox Do nothing
using code to communicate with com1 serial port
I have a sheet that I cannot unhide.
date filtering by number
XLSM File opens duplicate copies?
filtering dates within this week
No request, just a word of thanks
Rows to Columnsq
Change column values depending upon the selection
Get Tooltip Text, 3rd Party App
IF using VBA
Counting calculated formulas in a Column
Problem with code (error code 9)
Help with importing data from nasdaq.com
Delette active sheet from form button
insert text variable
delete duplicate records
Conditional formatting using icon sets in excel 2007
Type Mismatch Error when calling Function
Please Help: display "%" sign after a number
tip: extending a range
Excel Formula
Problem accessing Office Help
Exporting Data?
Disabling the Combo Box
How to delete a module
Repeat titles across multiple sheets of a workbook
Variable error on second use???
VBA in Excel to read the VBA Code
2007 VB Controls Backwards Compatibility
Data Validation - Combo Box open with single click
Speed up routine
Excel print to Outlook
Name a variable range
Formula Error
How to specify Print Area with a Range
Auto conversion of the Text to Number Getting Failed in Excel 2007
Save Date in File Name
Don't understand infor in the web searched
Object size by copy/paste is different between Office 2003 and 200
How to using VBA to print Postscript File using windows printerdirectly ?
Call Private Sub From Different Module
Enable Multiple events in the same time
Can userforms be embedded in a spreadsheet cell?
Do cells have a string-property I can use to store "stuff" with ce
Do cells have a string-property I can use to store "stuff" with ce
Does VBA support flattening/serializing to "binary" string?
List box in macro
two same workbooks opened -- don't want this
refresh excel real time from dll
autofilter raises error 1004
Excel Templates for Compound Interest Loans
Activating Open Workbooks using VBA
Automatically perform action when closing Excel Worksheet
Excel macro that to close PowerPoint - if PPT it is open.
How Do I hide an excel file from VB.Net code?
Retrieve enterd with userform
How to open another program and file?
Macros
Paste upon click
Color sort - any cell in row that has colorindex = 4
Internet Hyperlink
Ole Server Error related to Office 2007 installation
macro for custom data entry
setting a control's text from the value of a cell
Many to One (Excel sheet)
Set a column to "text"
Bat file called from macro addressing network drives - NOT!
selecting range as input in VBA
Update Query from Excel VBA module
Format Cells dialog is not displayed when file generated with XLS
VB Script Help in Excel 2007
Static Variable
import worksheet from a different excel file
Combo box, select item, auto create another combo box in field
Activechart Location
Conditional formatting puzzle
How do I automate the moving between tabs in a form?
ERROR: subscript out of range
Paste only Values, no Formatting
Getting intermediate results from Solver Functions... Possible?
finding last column not always working correctly
Export user inputs to a template and save it as a different file
Filter and copy data to other sheet
Is this a bug in excel 2007 charting
How can I get an email address from the GAL
Where to place UDF modules for general use
copy named range & paste
Custom Worksheet Functions and Intellisense.
Web
Disable row delete in a worksheet (not all worksheets in theworkbook)
Transfer variable between macros
Auto-fill across multiple tabs
Setting Cell BackColors From VBA
Formula Bar Hidden
Question on Deleting Querytables
Multiple Command Buttons
Mid Function with XlInsertObject Hlp!
Deletes Current Names and then adds New Names
Macro Trigger
Macros
filter file extension on remote pc for file open
Looping through records
AUTOMATING E-MAILS
VB Data Validation check - apologies for incorrect post
Copyfile
Accessing Hyperlinks thru code
Intimate the # of records being imported
Row number and Column number
macro adding rows
Chart zoom
Filtering information
Chart SeriesCollection Names
how to create a zoom butom in vba excel
how to create a zoom butom in vba excel
To join 1st line & 2nd line of text in text in Excel VBA Code
on error resume next dilemna
Fill 2 column list box with sheet names
Cut and remove last text
combining text and variable in a .value
How to find new UDF to edit
if a checkbox is checked then...
Excel just dies - XL97
Immed Win: how to home down and clear?
help with case
Testing to find if UserForm is Loaded
Reference Controls to chang attributes through Array
Protect
paste transpose
save a range to copy for later
referencing a variable from a form in a module
referencing a variable from a form in a module
Retrieving Archived (EAS) Outlook Attachment
compound if statement
auto-protect a sheet upon workbook close
ADODB: duplicates -problem
Difference office versions
MS Excel Delete row if criteria is meet
Activate each sheet in workbook with exception of...
NO pivot table
calling an _Exit event
Creating UDF prompts (XL 2007)
Excel using Word --- Object is not responding
VBA Syntax for Countif condition where only 1st char in Range of each cell = "M"
VBE opens automatically -- why??
HELP: Trying to populate form fields posted on intranet from a dat
Copy Sheet to New File Without Code
new template & save on first open
Trying to save directly to .Doc and using save as MHTML
scroll bar inside an embedded chart in Excel 2007
how to preset to a network drive?
Excel and Word 2007 Macro Issue
Personal.xls Will Not Hide
VB.NET with Excel VBA
Help with Type mismatch error
Restrict User to a directory
Help - I'm getting desperate
Importing Text
Hlp - Display only file name when Insert Object As Icon
What's It Doing?
To create a macro to fetch data from excel sheet (2003) using a qu
Referring to Excel objects in VSTO
Copy each data record of a name list and place it under the onecopied
Merge multiple workbooks into one.
ListBox RowSource Property
generic use of sheet name in user-defined function
please help me, asp!!
IF DATE Statement help please
Selecting a column , row or cell
Re: instance of class from dll, is it possible??
WorkBook Deactivate Event
Private Sub Question
Find Autofilter Header range
How to refresh an Excel workbook from VBA
split 1.5/2.1 into 1.5 and 2.1
Sub to carve out uniques based on col header whose position may va
Range Selection - From Lowest 2 Highest Values?
Softcode Path from File Open dialog
graph image -how to superimpose or extra data-point by VBA
Match
importing tabs/sheets only from the currently open files
how to superimpose chart images or extract data by vba
Opening a excel file from a macro
excel socket programming
Scrolling down a web page using VBA
getting the source code of a web page
please answer me, i need your helps!!!
command button help
Button looses Macro setting when running Macro
retrieve data from an .aspx web page
numeric picture formats
User select folder name
Delete ALL ListObjects
Using SaveAs Dialog and Changing Location
Find sub not finding
Menu-bar missing when launching Excel
Scrolling down a web page using VBA
If String starts with a * (asterik)
message box
Macro copy data based on cell formatting and paste special values
vba + excel + html
vbscript/excel issue
Excel 2010 add in support
pulling values from column g into a variable, and returning variableon spreadsheet
copy pieces of different word doc s
Recordset with Primary Key
Creating a button in Macro
vlookup woes
Erro 429 Set gApp = CreateObject("AcroExch.App")
Auto-Protect Sheet on Open and on Close
How-To Remove Extra Spaces
Formula based on another cell value
Selet Syntax
Re: VBA just dies - EXCEL 97
Copy from ActiveRow, Paste to A2 in Another Sheet
could anyone answer the question on how to produce a 1-d table, PL
It Then Else Question
VBA help
Complete .PDF form in VBA
how can detect that setting object failed
How do I identify the current locale?
Date comparison between 2 datetime fields
how to produce this 1-d table?
Auto Update Second File
opening a workbook as read only
Save As
Count number of different entries in a column
Treeview - XML editor in VBA
footer text overlaps sheet text
SQL to unprotect and protect worksheet
Cannot call the worksheet function Weeknum
Run Access Command
Problem finding cell contents
BeforeDoubleClick on Protected Sheet
Testing dynamic range for values
Change paragraph format in Word from Excel...
Codename not set
Password for a macro?
very urgent!!!
Filling a Cell with Yellow backgound after testing for -ve cell d
Looking for Excel ODBC 64 bit driver
Select range problem
Rows columns to repeat while printing in a workbook
auto refresh excel
Re: vb script in dts throws error when operating on Excel file - helpplease!
urgent +++ imp
Transfer all data from one cell to another, and keep it dynamic
Excel 2007 not in foreground when launched in Vista or Windows 7
move data w/o blank data to another sheet
Comparing Rows
Running macro based on cell value
highlight rows based on value of column F
Making this sheet compatible for excel 2003 users (conditionl frmt
Autofill Macro
Updating a SQL stored procedure within EXCEL
Problem with UDF
VBA time date stamp
Concatenate All Possible Combinations
Opening a document in Word from Excel
Suppressing Excel2007 Messages
Concatenate contiguous fields on one worksheet into 1 field on ano
Rename sheet with content in specific cell
VBIDE helpfile
Undefined function 'replace' in expression
Re: change text in string
getObject and password protected workbook
Re: Userform: Unable to setfocus from multipage
Userform: Unable to setfocus from multipage
Find and replace in Word from Excel
change text in string
Modify macro to find cells beginning with A - help needed
Code causes a problem
m=1
HELP: Populate corresponding userform text fields from access data
Sort Macro Compatibility
Finding content of cell in visible "protected" sheets
Last used cell problem
XL: ping mapquest or googlemaps to get driving time + distance?
Application-defined or object-defined error
Copying a value from one workbook to another
Macro reads cells with numbers . If given number is found , delets
Thumbnails
Can't replace commas with period
pdf Reader
Answering Pop questions when macro is running
Determine which cell was populated
Enable Command Bar
Need macro that analyses 2 columns . Delets row if same text is fo
pivot table filter macro error
Create a loop
More control over moving and inserting OLE Objects via code
Prevent closing if values do not match
If sheet exists and it is named run this code
Grocery list
Display Calculated amount in a textbox on userform
Closing running sub from a different one
Sub to stack data n paste unique order ID lines
activate optionbutton in a userform based o a condition formatting
Macro analyses cells in 2 columns . If same text found , keeps row
Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application()
Dynamic range issue
Excel automation problem
Macro Help
Turning off Selection/sizing handles?
Windows Explorer
unlock vba password using another vba code
Listbox Column Display
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ?
Random Number between a Range of Numbers
read xml method-- faster one
I want to change the chart series line settings in a macro
End of rows in a column
socket programming in excel vba as client
Code to Insert File as Icon & Open Browse Dialog Box
Multipage Buttons?
Close an active ODBC connection
Macro Help
Selecting Range of Copied Text
Button controlled "self populating PopUP" menu
An old chestnut: finding the last cell in a range
changing image when mousepointer moves over certain cells
Push data from Excel to SQL Server
Connect Files
Underlying events in a worksheet?
Event when cursor changes cells, but no select(?)
How to assign a reference to [Validation .add] xlValidateList(?)
Help with VBA Capitalization
Testing for different versions of Office
Turn protection Off... <run code>... turn protection back on
Copy every worksheet
μεταφορά αρχειων και προγραματων EXEL Σε φορητο PC(MOBILE WINDOWS)
Copy Text Box Contents into Rows
change cells when a particular user makes her input
MsgBox. problem to continue the macro
Search
looping programme require
Multiple or nested AdvancedFilters?
Call macro from active workbook
Went from Office 2003 to 2007. Error 438 VB v.6.5.
Excel 2010
App-V - Excel- Programmaticaly accessing the virtualized Excel DLL
How to open a linked graphic?
type mismatch when opening a userform
Multipage Buttons??
Open UserForm
Cannot find a loaded VBA addin
Code corruption problem
Using SUMPRODUCT Function on Calculated (Function-Derived) Data
Insert Row and calculate difference between two dates
import a .dwg or .pdf
A .XLSM file suddenly quadrupled in size
Excel and JD Edwards
Search for sepcific words and delete rows between them
Sort column without referencing sheet name
Adding Page Numbers
Date Time Picker
How to read previous copy selection address
Button to saveas then new sheet asks Questions
MS Query - changing data using inputbox?
2007 AutoFit, WrapText, fails
Format Textbox w/ $ sign
copy and past based on criteria
How to prevent and event?
code for impoting userform and module
Getting data from a closed wbook
Is it possible to build sort statement?
Fill empty cell macro not working
Fill Blank Cell Not working
Excel Macro
Web Services Tool Kit Usage - Handling the data returned from WS c
Yes/No message box appears based on cell's value and its selectionproduces a value
ActiveWorksheet.Sections(1) does not work
Text in the first page footer
SaveAs?
Open Userform two ways
HLOOKUP
Excel VBA Project Excel Lost !
finding where text wraps in a textbox
How to hide "Image1" when you hide Row
Text not looping through ranges
BeforeSave Problems
More then 1 worksheet_change event
Variables
2007 - is it possible to set a hyperlink in a msgbox??
Sorting of table depending on a drop-down-list entry
Combine Advanced Filter with a loop?
Icon Type and Name when Insert File As Icon
SpecialCells(xlCellTypeBlanks) = error 1004 No cells found
UDF for extracting only numeric values.
How to define variable a("H") = "Follow-up"...
Referencing a cells value
can't save my file with macro
Replace a format of a part of a cell
Userform List Box content not visible?
Trouble with Validation formula1:=Join(... Is '!' a reserved cha
Triggering procedures
OnTimer - The macro 'macro name' cannot be found.
Excel Spellnumber Formula
debug not working
Concatenate without duplicates
Find and copy
XML-Gallery- Ron DeBruin
Opening a Word document from Excel
Dynamic Arrays
About the autocalculate in the status bar...
AutoFilter Macro Protected Sheet
Copy sheet from closed workbook
Database interface.
Active or current file path
Simple SetFocus on userform issue
Button in a toolbar to insert a specific function
programming delima
Sort by a Variable Range
protection violation with ScreenUpdating change
Need to open a file and a hidden file and hidden toolbar
Workbooks.add count:=X?
RE: Workbooks.add count:=X?
boolean variable?
Closing down running macros at the file close
Setting "save as" and "save"
turning number into text
The Macro Button is disable
Macro Help
Create a Drop down List on a Form
Delete Hidden Sheets
Macro Question
Macro analyses Cell . If text found , delets entire row
Grossery Budget spred sheet.
a Disaster in the Making - R/T error 1004
Greater than, less than, cut and paste rows to sheet3
column to row macro
Unexplained WorkbookBeforeSave SaveAs Error Causes Excel to Crash
Copy number to pivot table
Run Time Error 91 -
Opening time
macro to extraxt information
Mid function
Delete rows but keep formatting to 1000
AutoFilter & Selecting First Visible Cell
Selecting names based on Teams (using dropdown)
Data Val MultiSelect on Userform?
Excel Userform Org Chart?
Function needed to pull in cell values
Building A string
Please Help: Upload a File and save it at a specific location
Userform Control Change from Different Workbook
Assigning a date that is before expiration date
Add-In Adding to Help File?
MS Excel VBA Worksheets group tables in one table.
merge word documents from excel macro
Conflicting VBA Coding
Worksheet_BeforeDoubleClick event question
Command Button - Send and Save
Which day
Opening the "find all" feature on workbook launch
LISTBOX
Questions on Combo Box
delete entire row with condition
c.Resize
Selecting Range between two named ranges
Cell updates not occuring
How can I use VB to hide Row 57 if cell A53 has a value of 1?
copying one entire row from a source sheet to a destination sheet
macro in excel 2007
Create a list of Sheet names
Pivot Tables Overtaking Non-Pivot Rows
Getting Pivot Tables to Displace Columns Populated Only with 0's
Importing a Text File Into 1 Column
Selecting sheet 2
Named ranges
Macro to copy a sheet and delete a macro button
Macro Timing off in IE7
Re: using filter based on last column
Can't trigger Keydown event
Re: Display only file name in embedded icon
INPUT BOX in excel 2003
Page Number
macro to copy rows that contain a cell with a certain number
Problem with connection to sql server from excel
Excel listbox
Concatinating two spreadsheets by a column
Unable to get the VLookup property of the WorksheetFunction class
Retrieving short system date format in VBA
Clear Files Displayed As Icons
Auto shutdown for inactivity in Excel
Protection of cell in excel
Excel 2003 list of names and calling
working with MsAccess in multiuser environment: error Cannot start
Determine tje last visible row on the screen.
Selecting rows
On Line guide like windows creation in excel
Project - VBA Project window - Excel 2003
Macro to Loop through and sort worksheets
Macro that analyses data from 3 columns and puts result in 4th
Complicated sum
Macro to determine chart name
Parsing Address, City ST ZIP
Macro Help
Always the same average for random numbers!?
Hide control until report section populates
Formula to Sort Numbers
Reducing a List by Eliminating Entries in it Found in Another List
Sorting Formula Question
Link Text Boxes (As can do in Word)
data as a combo box or list box
quick access tool bar show/hide custom button on open/close workbo
What does allcalc (a table_array) refer to in a cell formula?
Paste problem from HTA
Macro for calling the previous worksheet
call C++ DLL from VBA
How do I obtain a digital signature certificate for my projects?
Automatically load solver reference library
move entire column
Open Files with Macro or switch windows with macro
Add Trim Function to Code
Lookup
posting
How do you embed Access Report in Excel?
Application.Evaluate("5705")
VBA Function returns #VALUE! when working on another book
Macro to replace a range of cell values
Microsoft Date and Time Picker control for User Form
How to detect protected sheet
Problem copying name range
Data Val MultiSelect ?
Problem with VBA Functions that use a DefinedRange as parameter
Find and replace
Macro - reads cells in a column .If keyword found moves cell conte
MACRO HELP
Col number not letter
Changing font for msgbox
Finding the top 10 from a month of data
Macro that delets all cells containg ALL words in bold
Get sheet name in formula
How to open CSV as text?
Loop clean up
Subtotal function
ADO and User function
Macro to determine min/max values of column
Macro that splits content from cell if given character is found
UDF in PERSONAL.XLSB
Macro searches for keyword. If found , puts 0 in cell from next co
sorting data
What you see is what I want
dropdown list select event.
Repost - Best way to get data from Access 2003 to Excel 2003
macro to do subtotal by eachqtr in calendar year
Looping Through an Array and Transposing
Check for dual key Duplicates
Determine which row is active below freeze pane
Address of Formula
macro which delets cell if the cell above has the same keyword
ROUND AND SUM
Automatically input file names from a directory to Excel sheet?
PDF export add-in
Userform within a userform ...
Square before beginning of a new line
Wilcard for Workbooks???
Online Help on VBIDE
how can i take of the buttons of the pivot table or the informacio
SOURCE "VALIDATION"
Assign buttons on QAT
FORMULAR INSERTION
Concise Way To Select All Rows Except First?
Problem with Union
Quick ? - Worksheet_BeforeDoubleClick
Can i remove the informnation of a hyperlink???
XY coordinates to cell address? is it possible
Macro which searches for a character . When found delets what's be
Multiple chart creation using multiple series in the same row
Macro - searches for key word in a column and concatenates entire
Attempting a dynamically defined conditional in VBA
Unable to format a control in a Userform
Validate User Input in Dialog box
Control of Sheet Tab functions?
method to split data rows to multiple worksheets.
Update Pivot tables in a shared workbook
Resizing a form at run-time?
Restricted Functions
Determine path to picture displayed in image control
Publish as PDF/XPS Strange
Reference Personal.xlsb in other projects...
delete certain rows only
Error Handler displaying message when no error
Simple Do Loop!
Multiple chart selection in Excel 2007
Read data from workbook without showing it?
Macro that compares columns and identifies changes
IF Statement based on first two characters of cell
macro doesn't recognize korean letters
Find Minimum and Return a Figure
Macro that takes words from a sentence and puts them in diff cells
Excel COM dll - how to escape from process
Declare a Public Array
UserForm shown and worksheet active
mail merge - pls help me
Programmatically copy text from screen in other application
inconsistant teatment of web data
adding data column without changing sheets
Count repeated entries without typing the entry (large data base)
Make protected hidden row & column headers appear and rehide based ona cell's value
bad file name or number - accesing sharepoint folder
Loop through range, Autofit height
excel addin options
Macro that change words in predefined numbers
CheckBox / Linked Cell Problem
Need macro that transforms key words into predefined numbers
Mail Merge
Need macro that concatenates cells with text
Run time error 13 - type mismatch
Need macro that delete rows starting with specified letter/word
Controls for Excel 2007
How can i remove the "printing" windows when i print excel workboo
Find matching values, copy/paste values as well as values in ColA
Macro When Worksheet Opens
Cant "picture" Format from Clipboard to .bmp file type
Userform Question
Pivot table custom/calculated field?
Open xlsm as a template file
EXTRACTING ROWS OF DATA/FORMULAS TO CREATE NEW WORKBOOK
Printing userforms
Paste values?
Is it possible?
Txt to Column wizard
Update the excel file on my computer, once a new version excel fileis add on other computer within same network.
Find column number of last used cell in a row
Ensure cell contains a number
Selecting Range Based on Cell Content then Copy/Paste to New Sheet,Looping
Resizing of picture different in run time and design time
Re: xldynamic is back
excel 2007 conditional formatting question
Yes, another variable range question....
What is the AcceptLabelsInFormulas workaround for XL2007?
datamining with excel
If Cell = X, Then Copy Entire Row Into A New Sheet
Automatically Adding a Worksheet
If logical statement and a function
Formula Question
Excel Formula
Resolve object pointer any use for this?
UserForm Mouseover???
Macro for Data Mining
Copy rows to different sheets
Search and list in a new worksheet 3 cells from up to 1000spreadsheets
Searching two ranges
Making Default Code Apply to Preexisting Workbooks
How to run a shell command via VBA?
Unhide multiple worksheets
Code Execution has been interrupted
copy records from range to another range
Web Query? Is This Possible?
MsgBox including range value
searching
SaveAS dialog box gives run time error 1004 in Excel VBA
Help with Workbook Calculation
Doesn't work with or without parenthesis?
Slow exports from MS Project to Excel
how do i Save a file with the name i want and with CVS(Command Del
WRQ Reflection
Extract RGB values for selected chart series
How many days fall in each month?
Check for Complie Error in VBA code via VBIDE
Automated Print from Excel to PDF
Searching this newsgroup
Macros will not run with two Excel applications open
How to specify an absolute cell ref in FormulaR1C1
Standard Paper sizes not the right number of points
case sensitive IF, Visual Basic macro IF
"=TEXT(RC[-1],"MMM")"
How to protect formats in unprotected cells
vba to check range of cells and print
Months between two dates
How to change comment Box width and high
Count if
Search for the cell content between sheets and copy corresponding
Using ShowScrollBar API call in VBA?
how to get the PageFields in c# for Excel2007
Textbox value as sourcerange
How to calculate a Range from Row and Column count
Fill serie
Apply error trap to all objects in worksheet?
Macro to place borders between groups or rows
Excel: 'Find All' macro
colour format text when copied from text box
1004 error when using ATPVBAEN.XLAM!Regress
Insert Comment in Current Call and set then width
Assign Ranges On Different Worksheets.
Concatenate results without decimals
How do you capture the name of the current worksheet in VBA?
Can I pre-load wav file into memory on opening excel wb?
Looking for a value in a previous row
Maintaining Shift details Data
copy unique values into listbox, then modify sheet from these values
Cell Color changes On Input even if new input matches default
Coppying cells, including conditional formatting ('03 & '07)
Add menu to QAT with VBA Excel 2007 & 2003
Inserting and copying Rows based on a variable
slow execution time in excel 2007
How can I get a list of the available printer names
Excel 2000 SP3 versus Excel 2007 --error code 0Xc0000005
Incorporating 2 scripts together that only work separately right now.
macro to copy data and paste to a new sheet in next available cell
How can I get a list of the available printer names?
Is it possible to disable a single sheet for ActiveWorkbook.Refres
Class Raise Event not firing
VB Code to save a copy of the workbook as another name
ComboBox.Enable giving error on ActiveWorkbook.RefreshAll
Lines in UserForm??
value from cbo box and text box
BEFORE SheetSelectionChange
Tag Property for TreeView Node
RE: xldynamic is back
Counting entries in a range
Print page based on the value of a cell
How to fake/simulate more than 256 columns
Recording
RE: xldynamic is back
Change Cell color
Autofit
UserForm and Worksheet ???
vbext_pk_Proc and vbext_pk_Get in Class Modules
UserForm Not Visible on Load???
Code execution has been interrupted
Macro To run after Template Refresh
Activeworkbook.ApplyTheme()
Create merge cells from table definition
FORMS ListBox
Search used cells for values containing named range
Workbook Variables
Copy entire row(s) to another workbook based on partial cell crite
Preview Excel file before opening
Dim item As ListItem
Streamlining macro created by macro recorder
Add - Trim(Clean())
loop thru folder looking for files with date code in name
Insert a calculated number of blank rows
INcremental increase
Data samples
list box listfillrange entity and events
Rich Text Box problem
count visible cells after autofilter
copy entire row and paste values only to another sheet
Counting Colours
This excel sends email when used with Outlook 200 and 2003 but not2007 can anyone help
MACRO HELP
Divide one range with another
how to move mouse using excel macro
Textboxes and labels in Userform??
run macro in formula with "if" condition
Making Excel visible from Word
How do I use VBA to play sound clip from website?
On error resume next
Compare Two Columns
Excel 2007: create specifically named copies of an autoshape?
Pie Chart Tweaking?
View Access Reports on a Userform?!
VBA help - undo search and show all records
Select TreeView Node with cursor instead of mouse click
How to strore exact double from macro into Excel cell?
Stop Refreshing via VBA
Open spreadsheet on specific tab
hide or remove filter arrows from protected pivot table
Split up delimited string & insert row below
rng propblem
Taking two passes at at Text File using Do Until Loops
copy table to new sheet
Adapting your Unique Value method Attn: Ron de Bruin
Operation is not allowed when the object is closed
How to set up macro in Excel
Inaccurate LAST ROW / LAST COLUMN #
Find cell for today
Font in Header - @22 "25 Miles" goes to 409 font
Macro Help
mix font attributes of text returned from cell formula
Shortcut keystroke for ...
Invalid procedure call or argument.
How to CopyFolder to a readonly Folder? Help???
need to call data from a one worksheet list and insert into anothe
Help Using EntireColumn
Need formula to count blank cells
Run macro if user goes to a specific worksheet
Hopefully an easy one - turning a list into a row
finding cell with + and sorting
Create New Workbook on Hyperlink
Selecting/copying a dynamic range in VB
Format in text boxes with multiple text lines
XL2007: Add my certificate?
Code no longer working
Com Add-In Modifying RIbbon in 2007?
Should be quick and easy to do this in excel but drawing a blank
Dynamic MAX formula
Creating a new "directory" on Sharepoint
Could not set BorderStyle property
Custom Ribbon
Fomat with Code Q
getting the selected range and active cell of a non active worksheetsheet
Don't Show Msg Box if file ext is .xls
if worksheet visible - calendar form
Blocking Access to Sheet
Differences Between Excel 2007 Versions
TIP: subject matter
HELP PLEASE
External Data
RowSource command
WorkbookOpen in COMAddin for CSV-files
Save with filename ACJRNyyyymmddhhmm
XL2003 toolbar macros in XL2007
Excel Can't Complete This Task with Available Resources.
Is this the right way to implement your own VBA Control?
Range Defined names loop
Sorting Data from ont sheet to several sheets
Processing Text Data for importing into Excel
VBA Code to Find & AutoFilter last zero occurrence
Recordset to Listbox, no application.transpose
Can this be done as a Case statement?
possible to enumerate objs from drawing toolbar - like textbox in
Best Practice for Obtaining hWnd
Find and replace a character in a cell with another cell's content
On exit?
Instr() with multiple search terms
Deleting Rows based on the duplicate contents of a single cell
Page margins on Page break preview
Smaller VBA? Loop or Offset?
Searching for name series
Combining two different subs w/ similar variables
Excel data display userform problem
why doesn't macro record text color, or patterns?
Why recalculation does not start?
Financial Week numbers
Storing add-in properties with workbook - how to? (VSTO 2007)
How to delete previous data from 1 macro before running the next?
Remove VBA before doing .SaveAs
Find text in cell based on color value of another cell
No Subject
Comparing data (conditionally) between two spreadsheets
Repeat the titles across multiple sheets of a workbook.
Copy Data to non-office program
reset hidden commandbars using workbook_beforeclose()
Copying worksheet A values into worksheet B - missing cell values
Auto Refresh Query Table
Remove Alpha from AlphaNumeric String...
Alternative to blind formatting
Images in outlook e-mails.
Error 9 - Subscript out of range
Invoke AutoSum From VBA?
Sorting columns - can't maintain column width
Open a .pdf file using vba in excel 2003
Set date time picker to null (blank)
capture cell number format with VBA
Multiple file extensions causing issues
Oppdate pivot i change in sheet
Automatic update
Chart source data
Counting records with ADO
Sequential numbering
Chart_select event problem
Cannot extend table
Laptop Audit
Cursor problem on shared workbook
Save file as Tilda Delimited without spaces or commas between colu
Best way to get data from Access 2003 to Excel 2003
Colorindex
Control Tip Text Question
Userform "Comment"
Copy a complete row
Re: Cannot view code in VBE of a file with no password protection
Combining Multiple Rows of Data in Excel
Excel 2003 Pivot Table - deleted items still show in drop downs
Re: Reading USPS page results
OO4O execute a query against Oracle, VBA Excel 2003
Remote Machine not available
Re: Cannot view code in VBE of a file with no password protection
Working With Checkboxes
so how do you stop?
"With ActiveSheet" validation question
transpose and concatenate
txt box linked to combo box - help
XL2007 : variable value changes unexpectedly
Insert and Update data
Text box output linked to combo box value
Variable rows
Conditional Formating with colour
Cell vales
CSV files, ASCII characters, and Outlook Tasks Lists...oh my!
Hide or chg the font to white?
Exit code
VBA over-write identical worksheet-ranged-cells only if receiving sheet's cell is empty
move a variable value in a macro to a cell
Questions/help with UserForm
File owner attributes through Excel VBA
bringing up a window to make header row selections
Text box output linked to combo box value
Scroll to Top of Sheet, When Sheet is FIRST Activated
How to check if an Add In is present.
RE: disable Edit/Cut menu option (and other specific ones)
Can I change this code to be relative to the active cell?
disable Tools/Customize menu option
Re: Reading USPS page results
Close DropDown of ComboBox2 & Open ComboBox1 on Error
Grouped Sheets
Cell refresh
Output a string to the console?
Writing records to CSV file
Delete Macro based on condition in Two Columns
Code issue
Test if Last Character in Column of Cells is Alpha Character
Putting list items under appropriate date?
Re: loop variable range
Re: Cell content change Event
Stop copying down values
RE: loop variable range
Re: VB error '1004' Unable to get VLookup property to work right
RE: loop variable range
Re: Delete Range of Columns
RE: VB error '1004' Unable to get VLookup property to work right
Re: loop variable range
UDF & Named Range error Excel 2007
RE: Delete Range of Columns