5601:
Can we zip a file using macro.
5602:
Can this be done?
5603:
code for sorting data
5604:
XL2002 - Group / Outline / ShowDetail...
5605:
Help with Excel and Sharepoint
5606:
Help.........
5607:
Restriction for the Date Field in UserForm
5608:
PASTESPECIAL THE COPIED DATA IN " With Sheet " STATEMENT
5609:
Macro issue
5610:
how to block sending mail from excel workbook.
5611:
Excel 2007 insert HTML with images
5612:
Setting the row height based on a cell value
5613:
help
5614:
help
5615:
List Box Item Format
5616:
Maintain image selection
5617:
is RND really random?
5618:
hi
5619:
help
5620:
Populating cell from database (1031 characters)
5621:
Syntax problem with code - chip.gorma
5622:
Troubleshoot Overflow
5623:
Variable dependent Custom Dialog boxes
5624:
Dropping Data When Copying
5625:
Find optimization
5626:
Paste selection minus the first row....
5627:
Macro to compare columns and output the results
5628:
build text file
5629:
Macro to fill column with SUMPRODUCT formula
5630:
Selection/Filtering Question
5631:
build text file
5632:
Rounding Up
5633:
Need Macro to Print Current Page Only (2)
5634:
Floating Command Bar &/or Buttons
5635:
merging an excel 2007 ribbon items into exisitng classic excel too
5636:
Selecting data programmatically
5637:
row by row comparison using a "countif" and "and" condition?
5638:
Help with Code
5639:
Imbedded Picture Names
5640:
Review of Microsoft.Jet.OLEDB.4.0 Connection
5641:
Splitting up timeperiod
5642:
COPY BY MACRO DOWN TO LAST VALUE CELL IN COLUMN "A"
5643:
Check if file is excel file
5644:
coding help to set a specific time frame
5645:
Insert new Worksheet with name, and insert the sheet into its
5646:
Creating new Powerpoint object and opening
5647:
VBA Type Mismatch
5648:
How to Genarate random letter
5649:
Uploading data to database
5650:
Multiple Criteria for SumIf
5651:
Workbook Unshare Error
5652:
Excel 2003 - change cells depending on answer from drop-down menu
5653:
sort an array on selected column
5654:
Inporting and Deleting Sheets
5655:
Lock Unlock cells in VBA
5656:
retain Selection
5657:
Right-click cell and open filename in explorer program
5658:
Clearing contents
5659:
odbc help!!!
5660:
Modify Function Category Names and Contents
5661:
Excel
5662:
How do I ? Macro - cont'd from 5/9 posting
5663:
what is the event for sending mail thro VSTO Excel Addin.
5664:
Excel smart tags programming with .NET - recognizing formulas?
5665:
VBA functions
5666:
Loop Through Sheets, Copy/Paste if Match
5667:
Excel VBA process increases exponentially with more records to
5668:
Excel keeps running after closing on server
5669:
Clear All from last row of data down
5670:
data time frame
5671:
Find value with the help of macro.
5672:
Logical functions
5673:
Remove Duplicates in ComboBox
5674:
Loop
5675:
date finding loop.
5676:
Disable user forms being displayed in the VB editor??
5677:
Nested VLOOKUP in IF statement
5678:
Code is not detecting the date.
5679:
open .txt file
5680:
Excel form to update data from MS Access data table based on criteria
5681:
Change font size of header on every sheet?
5682:
Count funtion
5683:
Pivot table - Unique values
5684:
in excel 2003 what is the replacement for the old extract formul?
5685:
Excel Solver in VB
5686:
Data from Access
5687:
Updating Data
5688:
Vlookup, several tables, one sheet
5689:
printing of linked picture includes buttons not included in area
5690:
obscure array sort
5691:
Data Validation for % input in userfom
5692:
batch editing a document
5693:
Copy chart to clipboard
5694:
Determining if a cell/range is in error?
5695:
External Data refreshment
5696:
Enable Macro - default //
5697:
Date vs Date$
5698:
Finding Characters in a String
5699:
Referencing mso enumerations (e.g., msoLineSolid)
5700:
All Pivot table include different pivot field to save as individual
5701:
HELPPPPP Please - Comparing Data
5702:
Insert characters into String
5703:
Time format in userform textbox
5704:
[GetMacroRegId}
5705:
Text - Blink //
5706:
textbox font style
5707:
Macros and data analysis
5708:
Form Objects in an array?
5709:
short key to invoke command button in userform
5710:
number of types
5711:
Want to learn macros in excel
5712:
formula
5713:
VBA question: How to extract cell values in different languages
5714:
Excel Services Chart Generation for SharePoint Dashboard Display
5715:
Div/0 error
5716:
Any macro programming sample for accessing database through Excel?
5717:
"Method 'Add' of object 'INodes' failed" in TreeView.
5718:
Macros: Strategies For Where They Live?
5719:
Series of custom dialog boxes
5720:
"Breaklink Problem"
5721:
SUM columns based on 2 pieces of logic
5722:
How to replace the image on the Office Button in Excel 2007?
5723:
Drag and Drop
5724:
need VBA to clear dependent data validation lists in several rows
5725:
Using a variable in a formula
5726:
Listbox
5727:
compare 2columes of name
5728:
Do not execute Double Click Event when UserForm is Showing
5729:
Macro to Insert Object with browsing ability
5730:
Change Excel query with a inputbox
5731:
VBA and Pivot Table Query for Text values
5732:
Conditional Formating
5733:
Converting Excel Equation into VBA
5734:
Is there a test for an empty string that returns a boolean?
5735:
Macro - How do i....?
5736:
=sum doesn't work properly
5737:
Function Call to check Workbooks.Open
5738:
Calculating Cells
5739:
Open to today's date
5740:
need help tweaking Debra Dalgleish macro
5741:
Checkboxes and Arrays
5742:
Formula for selecting highlighted cells only
5743:
currency formatting of cells with code
5744:
Record Macro Window.
5745:
worksheet menu bar
5746:
Any sample to connect a remoted database through Excel?
5747:
VBA formula too long?
5748:
Getting folder size information into cell???
5749:
Merge muliple sheets in multiple workbook below each other.
5750:
workbook / worksheet change event
5751:
Pulling data from 3000 files
5752:
My code enters break mode but there are no breakpoints
5753:
Macro to show/hide rows
5754:
Variable Input
5755:
Macro Error Help!!
5756:
Count function?
5757:
Appending Contents Of Multiple Spreadsheets Into One
5758:
What's the API call to kill the KB buffer?
5759:
ListBox Displaying With Some Items Already Selected In 2007
5760:
Checking if a cell contains a string that is not case sensitive
5761:
TreeView's pos on UserForm changes by itself.
5762:
updating pivot table data via external xls file which is replaced
5763:
Numeric data
5764:
Cell references and merged cells
5765:
Excel 2007 SP1 VBA Help
5766:
Help to speed up this macro
5767:
How do you collapse a TreeView?
5768:
WM_SETREDRAW doesn't work unless...what?
5769:
Confrimation of copy paste operation
5770:
Capture paste from Office Clipboard
5771:
Modeless Form help please
5772:
Can i link various text in a cell to a picture
5773:
Thanks to Stephen Bullen for fixing VBA's miserable UserForm.
5774:
Excel 2007 - How do I ...
5775:
UserForm ShowModal Problem
5776:
code to extract data from a website runs of XP but not Vista
5777:
Automanipulating IE drop-down list in VBA/Excel
5778:
Create a Macro with a List
5779:
I am not sure
5780:
How to execute macro based on a users computer settings
5781:
How best to break up code
5782:
VBA Additional controls
5783:
Controlling how a second excel file opens
5784:
Checkbox
5785:
Running Macros Remotely (.tcl file)
5786:
Combo Box and smart key selection
5787:
Working with Arrays
5788:
Selfcert no longer working correctly
5789:
Check access right to folder
5790:
Save Date
5791:
Userform: what happen to the sub who launched it?
5792:
Excel VBA Query Across Databases
5793:
Copy rows from multiple workbook into a different workbook (sheet)
5794:
Staff resource query
5795:
Follow Hyperlink in Cell
5796:
Comparing 2 sheets
5797:
Text Box - Initial Content
5798:
Application.Run
5799:
VB/Excel query
5800:
Compile Error in Hidden Module: Module 1
5801:
Variable length named ranges
5802:
ms excel 2007 Filesearch
5803:
Math Operation: Set Subtraction
5804:
Select Column based on Sheet Name
5805:
Help with Grabbing Cell Value from Range
5806:
Sheet Protection Question
5807:
Tracing where spreadsheet is opened from
5808:
Retrieving the values of Excel check boxes in .NET
5809:
Userform Initialize Problem !
5810:
worksheet SaveAs WK4 in background
5811:
Please help!
5812:
Setting up Sum ranges inside a macro.
5813:
Checkboxes with the same Group Name not Responding
5814:
Identify shape in cell
5815:
Iterate rows of spreadsheet(s}\Get values
5816:
Help with match function, i need to tally
5817:
ADO help: Only get first 255 characters of field...
5818:
distributing a spreadsheet with macro buttons
5819:
Easy Worksheet Function help
5820:
UDF Function to calculate mean moving range (control charts)
5821:
Trying to create Macro to delete duplicate Rows
5822:
Optimising Code
5823:
Multiple checkbox selection
5824:
Excel2000: Avoiding loop in Worksheet_Change event
5825:
Automation add-in - UDF to multi cells...
5826:
List of email addresses
5827:
Open several files and copy the contents
5828:
One Workbook to Several Workbooks
5829:
How do I exit from a macro when a condition is not met
5830:
Userform coding problem
5831:
Upgrade PivotTable drop-down selection box
5832:
Grab all filtered rows for some action
5833:
Macro defining dynamic named ranges
5834:
Drop-Down Arrow in AutoFilter
5835:
Running code.
5836:
Automatically Change Row Height Based on Cell Contents?
5837:
Adding a divider to an add-in using vba in excel 2007
5838:
Problem in excel - possible MACRO solution ?
5839:
Counting and adding values int two different columns
5840:
Adding items in one row if criteria in another column is met.
5841:
Warning message while macro runs
5842:
Option Button FaceID in a custom commandbar
5843:
Sum Column Y at first blank-bottom cell.
5844:
dual zero conditional row deletion
5845:
stuffing japanese text into a variable
5846:
Pivot table not recognizing same field values
5847:
Find & Copy Files Listed in Excel Worksheet ?
5848:
Find and Replace Question
5849:
Runs once and only once
5850:
Entering a formula
5851:
Copy past function on cell containing selective formula
5852:
closing a variable file name with macros
5853:
I need a way to pull a list based on criteria a user inputs.
5854:
Refer to Column with a variable
5855:
select a list, then sort #2
5856:
tabs by dates
5857:
Range to array excluding null values
5858:
locating excel file
5859:
If sh.Name <> Sheet1 Then
5860:
Macro to insert repeat comments
5861:
Remove On Activate Sheet Event
5862:
open Workbook path
5863:
Change Save Dir in IE (VBA)
5864:
Programmatically call a menu item from a menu from a Add-in
5865:
Analysis Toolpak Loaded or Not
5866:
Advanced Filter problems using VBA in XL2007
5867:
if then formula
5868:
Scrolling columns in lockstep
5869:
Cell should display, login name.
5870:
Conditional Drop Down List
5871:
Copying Worksheet Formatting (Rows to Repeat at Top)
5872:
Triple Filter? Ron de Bruin Code.
5873:
How to: IF FALSE in 2 Cells, Then Obtain Value From 3rd Cell?
5874:
How to call a workbook Event..
5875:
Hyperlink within formula
5876:
number seperation
5877:
With Application; Me.Top = ...
5878:
Range.Group Method - group rows, not columns
5879:
Excel CDO
5880:
Is there any way to solve this problem ?
5881:
match and offset
5882:
Minimize Ribbon
5883:
Object Required Error
5884:
Spreadsheet or Table Control for Form
5885:
passing ComboBox to subroutine
5886:
Get From Clipboard
5887:
Macro to Refresh child pivot table
5888:
Automation
5889:
List Table or Spreadsheet Object for Form
5890:
Selecting rows using defined reference as end row
5891:
Return list of file names from specific directory
5892:
Selecting cells using a defined reference
5893:
Icon Sets in Conditional Formatting
5894:
find textbox insertion point
5895:
I need help with macro
5896:
caps in cells
5897:
Embed HTML in generated email body
5898:
Importing excel data into vector graphics programs
5899:
Getting the position of an item in a pivot table
5900:
"Freezing" Conditional Formatting
5901:
Circular scripting between sheets in the same workbook
5902:
Using ranges with Visual Basic, stuck...
5903:
Excel 2003 stripping out line feeds
5904:
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE
5905:
Copy multiple charts to an array?
5906:
Trigger CAPS LOCK ON When Wk Bk is Opened?
5907:
organising staff rosters with 3 teams
5908:
Use event to catch the running of a macro from an add-in
5909:
Pivot Table Issue...
5910:
Floating Command Button
5911:
Need Macro to print curent page only
5912:
Need a Macro to Scroll to the left
5913:
How do I set up a column to automatically number the next row
5914:
Compare 2 excel workbooks
5915:
Data Validation problem still remaining
5916:
Linked Workbook Files
5917:
.OnEntry Macro does not fire when pasting
5918:
Vlookup Question
5919:
Woksheet spliting
5920:
Data Validation List Problem
5921:
Autofilter Range
5922:
Random number generation
5923:
VBA to VBS Translation - References
5924:
lookup folmula i/e n/a
5925:
list box dialogue msgbox
5926:
Microsoft Map is no longer supported with Microsoft Office Excel
5927:
Same page setup across multiple sheets (Excel 2000)
5928:
Problem sorting file dates in an array
5929:
Bitmaps on forms
5930:
Solver Macro
5931:
Solver Macro
5932:
Connecting to an Access database
5933:
Setting conditional colours for cells
5934:
Naming Ranges
5935:
random sampling TEXT
5936:
Debugging Code
5937:
Set group of wksheets to top of page
5938:
Batch Processing Macro
5939:
UserForm is missing the most basic Win controls. WHAT the?
5940:
Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_
5941:
Macro Halting During Execution
5942:
Unable to assign FormulaR1C1 correctly
5943:
Auto-increment file name
5944:
extracting embedded or Ole Object data
5945:
Reference active worksheet from macro in personal.xls
5946:
"Subscript Out of Range" Error Question
5947:
Notify users by email of document update
5948:
Worksheet protection VBA
5949:
Select Range and Find Values ***Maybe Loop?***
5950:
Formula for CF