View Full Version : Excel Programming
Pages :
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
[
26]
27 |
28 |
29 |
30 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
41 |
42 |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
65 |
66 |
67 |
68 |
69 |
70 |
71 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
144 |
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
- Can't find a hidden worksheet that appears in the name manager
- How do I extract the last update date from a different excel file?
- Re: Excel 2003: Customizing Toolbars
- VBA to acsertain if last w/s change was "insert Row"
- Updated header information from cell
- input of selected cells equals content of another cell
- Excel macro to add an hyperlink that shows only the filename (no p
- Output from UDF matrixfunction sometimes a row, sometimes a column,why?
- how to make the content in an excel cell read only?!
- how to compare parts of text in different cells
- UDF in Excel 2007 for Filter or Query
- Disabled VB Editor Button and Macro Buttons
- Why this isn't running properly (excel macro) Pls help!!
- New to Excel Programming
- Automatically go to a cell when opening sheet
- How to show and hide a picture on a button at runtime?
- Workbooks collection
- VBA code to format only the cells added in a new row insertion
- CopyTransposePaste into next blank row
- Help with PROPERTY GET
- Referencing two types of sheets - I get Error HELP!!
- Command buttons not responding-sticking
- How to extend the life of a variable from one Private Sub routine to another?
- ComboBox problem
- lenghty code
- Move SUBTOTAL cells
- VBA for worksheet change (add row) event (I think)
- reality canvass: VBA as career? VBA as extra skill in another career?
- Hyperlink
- Arithmetic Error -- Converting Expression to Int -- Weird Behavior
- Formatting workbook and going to first sheet
- Creating a Macro Recorder from scratch
- range function
- (maybe) pivot table question
- Adding Command buttins by macro
- Create A Windows Shortcut To a .xls File?
- 2003 to 2007 , ActiveWorkbook.ReadOnly
- How to modify the sql statement on a pivot table using VBA- XL2000
- Does this column have any "###"?
- Using DAO to write to textbox in userform
- Automating a comment entry using code - specific requiremnents..
- OptionButtons from ControlToolbox
- Wrapping multiline text in merged cells
- Set properties of a Check Box
- Enabling an option button using the enter key
- OnKey problem
- Global Const for password
- How to stop Random
- Kill Delayed?
- Data Validation - Can 2 items from a list be combined?
- Why ? What is error 424 ?
- VLOOKUP ---> Assistance Needed
- ranges
- Re-setting HPageBreaks
- making a named range available from an add-in
- How to simulate File-Send-To Exchange Folder
- Change BackColor of CommandButtons in Black by Macro
- Subject: Shared workbook for Writing
- Formula detection - Unique vs Copied?
- Copy rows with Interior Colour Index values 15 and 35 to a new she
- Put number next to Sheet name
- Select more than on CommandButton
- how to recognize a specific letter in a cell
- how o recognize a specific letter in different places in a cell??
- How to make my code recognize one letter in a text in a cell???
- code execution has been interupted - Excel 2003
- Multiple record counter
- How to thanks for your beloved ?
- intersection with multiple ranges
- Re: counting how many lines of code in each workbook - memory issues
- Where is the Microsoft Script Editor?
- Macro Covering Many Columns, why has to be UNION
- AppActivate problems or is there a better way to take focus froma non modal user form
- Data Validation, ignore blank ?? jan09
- "PLEASE WAIT" Window Message
- Macro does not delete all the required rows
- determine the actual vissible text
- Sum values of column 5 of listbox1
- Invoke Macro on entering data in column
- sheets active vs select
- counting occurences of cell matches
- determine how a cell is formatted
- .Find and return range
- Try a gay Aborigine today! Young virile Aborigines will performfor you.
- Calculate NPV - Array must be flexible
- vbe or worksheet function for cpu saving ??
- Read the search keyword
- Get Sory options??
- Customize Standard Toolbar
- Edit a Cell
- Populating 2 ranges with different random nums in each cell
- Vlookup REF error
- Focus problem??
- Printing
- Sortering av alder
- hyperterminal, excel, and MSComm
- Filtering multiple sheets
- folder hierarchy transfer to excel sheet
- Connection to MySQL using VBA
- inserting the numbers into excel column ?
- I'd like to have a chart placed on my user form?
- Best method for working with Excel Database
- Reading and writing to ini files in Excel 2007
- InStrRev Question
- regions in excel
- execute a macro from cell click event
- Sort question (of sorts)
- Reset New Workbooks
- does anyone know of a basic CMMS template/app. in XCEL?
- Enabling/Disabling multiple option buttons
- Shared workbook for Writing
- copy excel named ranges to powerpoint as pict with VBA
- Excel vba programming primer somewhere?
- Excel TableDestination As String?
- Ranking Duplicate Numbers
- Application.ScreenUpdate
- Auto Execute Macro
- Making customized asynchronous function
- SelfCert Fails to Create Certificate
- range calculate
- DDE link in VBE
- vba if and goto statements
- Keeping running tallies of items in two columns
- VB to set wordwrap on Control Toolbox Textbox
- Change cell value when selection made from drop list in another ce
- Change all numbers to zero
- How to wirte vba to find the opening file?
- Unable to get the PivotItems property of the PivotField Class
- Concatinating strings in a footer
- ActiveX control security
- Print preview from macro problem
- How to write VBA
- sumif when criteria range is larger but includes criteria
- sumif when criteria range is larger but includes criteria
- hiding select rows in sheets
- Some basic VBA questions
- Value Rounded when copied from another cell
- how do i change cell colour by value in excell
- I cannot find what is wrong with this code please Help me
- Date Format
- Need help with a Formula
- Use Names of Named Ranges in ComboBox
- Print & Close Buttons in Print Preview grayed-out when '07 script
- AxHost.GetIPictureDispFromPicture causes Excel 2002 to crash
- Parse cells with line breaks
- Open most recent file
- How to avoid Compatibility Checker MsgBox? VBA to avoid or prevent?
- Update Links and Essbase Retrievals
- How to compare two differnet cell ranges to see if they are the sa
- Viewing archived data
- Event Code Error trying to insert a picture
- Looking to remove pivot fields from pivot table via macro
- Copy in other cell just one letter.
- If statement question
- Macro + protection
- Attaching a Read Receipt to Outlook E-mail
- accessing twice a memo field in a recordset
- Finding date in a string
- changing validation drop down based on another cell value
- how to generate '*' in a textbox field that takes a password?
- VBA reset cell value if greater then 0
- Why? When I unlock my machine Visual Basic Editor appears (when I'min Excel)
- Animation
- Enable ActiveX control Option in Trust Centre
- Testing a sheet for a change since last accessed
- worksheet as SQL linked table (format problem).
- Pls help with simple sub
- Workbook Compare utility
- Recalculation Failure
- Print page one of sheet only
- disappear excel embedded messagebox in protected sheet
- Creating a Check Box within a Cell (
- Table Tools for Excel 2007
- Application.ScreenUpdating = False
- RE: Using SEARCH in a single cell to COUNT multiple entries of sam
- Macro to find, copy and paste
- CSV
- RE: Using SEARCH in a single cell to COUNT multiple entries of same te
- Using SEARCH in a single cell to COUNT multiple entries of same te
- RE: excel programming
- excel programming
- Copy/Paste in VBA Excel
- Re: two "ThisWorkbooks"
- How to Programmaticaly Delete or disable minimize and Maximise but
- RE: two "ThisWorkbooks"
- Re: Compare rows
- RE: Compare rows
- Cell referencing, formulas, macros
- RE: find a sheet by a cell
- two "ThisWorkbooks"
- Compare rows
- find a sheet by a cell
- Key Word's for VLOOKUP
- Upgrade to 2003, strange stuff in Immediate Window
- Trace dependents - get formulae
- VBA - Cannot find project or library
- remove pivotfields and refresh
- objFolder.ParseName Method Not Found
- I want to separate text at all the full stops
- duplicating a frame
- Reading data from Excel Worksheet in vb
- Unable to name certain ranges
- unlocking VBA project programatically
- Where is the API documentation - Office 2007
- Msg Box Yes / No Q
- erasing space/blank in a cell
- macro - paste special (transpose)
- How can I click on a cell and enter a default value?
- HELP REQUIRED: Dynamic VLookup
- Search a database with multiple strings?
- Offset the result
- VBA coding a nested Vlookup, and a sumif formula
- Trace dependents
- Dates and comments
- vba sumif and vlookup codes
- count partial string in a range
- Concat rows -
- Data Matching and exporting
- Name definitions
- Problem adding the values of 2 TextBoxes
- Changing From Address before sending mail
- Joining 2 modules as 1 for email with Excel
- Data Query using Match/Index
- Pivot table
- Reference two types of named sheet in a code
- How do I trapped the error and optimize the code?
- PivotTable
- WORKSHEETS
- Pixel discrepency
- remove or add items from a pivot tables
- Problem with Solver add-in. Changing values
- Print area - Message box
- Can I pass the logon credentials in a macro to a ODBC query
- Re: Command Button not responding
- Relocating my AddIn
- Command Button not responding
- Importing a file..then saving back to original file
- Dynamic multi-sheet excel downloads without ActiveX?
- Re: Clearing cells in a range upon exitting Excel
- RE: Clearing cells in a range upon exitting Excel
- Re: Clearing cells in a range upon exitting Excel
- Clearing cells in a range upon exitting Excel
- Delete Multiple Rows in one go
- C# Excel Add-in
- Invoice Number duplicate Check
- Copy and Paste exact formula
- code snippet below. Is there a shorter way to do this type of thin
- Automatic Date Stamp
- search and/or loop dilema
- Detecting Table Change
- Merge the contents of multiple cells into one cell
- Code Jumps
- event handler for calculation
- Code termination resets public variable
- what is the way to select ASCII file and import it into excel sheet?
- Locked Cells and Hyperlinks
- Hide/Show some worksheets
- Can I Licence my macros?
- Get cell address calling a function in C#
- Reset All Command Buttons on an Excel UserForm
- Pros/Cons of having users Trust the VBA Project
- Detect if a Defined Name Exists
- Buttons for saving and exiting a workbook
- Macro button
- Auto fit wrapped and merged cells in entire worksheet Options
- How to reference a precedent range in another sheet?
- search 2 criteria then update data
- Match Value and Show MsgBox
- Whats wrong with this!!!!!
- Formula depending on cell value
- TextBox to time
- Array help.
- Vlookup using ComboBox value
- Evaluate function
- MSCOMCT2.OCX registration error "ClassFactory cannot supply requestedclass"
- Code to automatically email when xls file is save?
- Re: Excel DB Queries: passwords and connections
- Moving a label on a form at run time.
- in VBA script, make cell values = formula value, not formula
- how to count the most frequently used words in a range
- User variable to get object value
- Sum data from multiple Workbooks.
- Please help... real simple question...
- code
- VBA Formula Excel 2007
- Update "centerheader" code running slowly need help speeding up
- Querying multiple Excel files
- ODBC question
- Server Threw An Exception Error
- Using a values from a lookup table to populate a range
- Data From Multiple Sheets into one
- Using FileDir and then putting those files in order by date
- ComboBox Focus
- Macro error - open file with 'Invalid sheet name' - repair/recover
- Unable to make the name Property of the Range Object Local
- Download Exchange Global Contacts using VBA
- advise if active workbook is read only
- adding the date to comment boxes
- repeat range of data values down through end of table
- simple code that does a search for me and returns a string
- Delet Sheets with out Automation Error
- Run a macro from within a function
- how to enter data into different work sheets from a single interfa
- Custom tab available to all open workbooks?
- Changing cell color by clicking the cell
- multiple criteria
- VBA Password Recovery
- Create .exe file for an add-in
- excel count/sum
- Find and instance of "X" and all rows between the next instance of "X"
- custom sort by vba
- webquery needs to import to row, not column
- Opening Workbook as Read Only and using ".Activate"
- Not statements and blank page printing
- Screen Flickers and slows down worksheet functions
- create .csv and thn FTP tht file
- copying comments in excel to a separate worksheet
- Find does not work in sheets with Pivot tables
- Transfer Date Loop
- Change Date code to yesterday/day before ,,,,
- Change Date code to yesterday/day before ,,,,
- Change Date code to yesterday/day before ,,,,
- Accessing an Excel file which has macros
- location for XLA's that I can easily get to
- Matrix manipulation in vba code
- Refresh data on form
- Failing to capture values correctly?
- after autofilter/delete rows left not visible
- Macro to define ranges
- Using matrices is vba code
- Copy rows and insert (x) number of times
- Function for week number
- Need Help!!
- How to run macros as one close a excel?
- Query Tables naming not going to plan...
- Every 4th Row
- clear the entire active worksheet
- Chart line width
- How does this line of code run?
- Hide menu items
- inserting word art programmatically in excel 2007
- "Run-Time Error '1004'
- vba code for inserting word art using in excel 2007
- Miscellaneous VBA Questions
- Open workbook selected form dialog
- Print area - selection
- Too many different formats and Userforms
- I NEED A SIMPLE LABOR SCHEDULE...HELP
- Copy a blank Cell
- Does closing modules increase stability?
- Aborting a User Form display
- Macro to print to pdf and email each sheet
- Run-Time error 1004 Application defined or object defined error -
- Using VBA to access data via the Internet
- Help - return date-time from a given # of days
- iterating through worksheets
- Re: Invalid procedure call or argument
- how to group sheets to perform a find
- RE: printing question
- XL2003
- macro for importing external data
- Invalid procedure call or argument
- Excel 2003 & XML Question
- printing question
- Compute Named Formulas
- CF (If Formula Is ) placed into macro
- Chart No Show by Using ChartWizard - 2007 Excel, C#
- using a value in a cell to hide rows
- How to access .NET Framework FileVersionInfo data type
- RE: XL2003 - ThisWorkbook.VBProject.VBComponents("ThisWorkbook" ).CodeM
- Enter formula in Macro/VBA
- Delete rows if fits criteria in a Macro
- XL2003 - ThisWorkbook.VBProject.VBComponents("ThisWorkbook" ).CodeModule
- Converting a Word doc to a multi-column Excel spreadsheet
- Detecting Internet Site
- Copy rows between two criteria
- difference between Value and Value2 and obtaining the value of a cell in excel xp and later
- Validation on text input boxes on a form
- Password Protect File in '07 With Macros
- I want to transfer data in a list based on value to an other workb
- how do create a formula
- Macros for sorting entries
- Chip Pearson Compare add-in question
- Change Event
- Email Lotus Notes
- Hyperlink macro - with filename
- Whats the diff with this If statement than the traditional If-else
- Slow to add or delete sheet
- Userform Combobox or List box?
- filter multiple columns for one value
- Offset of active cell
- Formula to match words
- Insert line sum rows
- Unwanted prompts when clsoing a workbook
- Macro security level
- Macro should autosave
- 2 Problems with Excel
- Connect MS Excel to SQL server sing internet: is it possible???
- cells to behave like check boxes
- How does this function works?
- Getting Information about Events Seen In the Object Browser
- Stopping a series of macros
- TIME
- What excel formula gives me the funcion (x*y%)/12 in my calculator
- How do Incorporate a condition in a case statement?
- Stopping a userform subroutine
- AutoFill Macro
- Range name copy Macro
- Maximize Userform
- Range name copy
- Excel 2007 Help
- Need program logic to sort fieldA & delete duplicates
- Loop, copy, past
- Delete all Range Names Q
- Am referencing data want to place actual value
- Issue with conditional formatting - Formula changing
- Macro that uses range names
- 2007 Merge cells taking forever
- Programming for Excel Charts
- Re: Solver come out a different solversolve msg
- Enabling/Disabling OptionButtons, CheckBoxes etc. in another works
- use of arrow keys in Excel
- Reading SQL Table into Excel and calculating/inserting group line (with VBA)?
- Worksheet_change event
- Excel Picture manipulation in 2007
- Delete row of cells in range based on condition
- Excel 2007 Visual Basic Editor
- Altering macro code
- Excel 2003 to 2007 VBA Change
- formula
- Office Home & Student 2007
- Re: How to set 'insert picture' default open location
- Re: How to set 'insert picture' default open location
- VBA=Excel cell
- Date Format Glitch - Book1.xls (0/1)
- Re: using variables in listbox
- RE: Setting timer to run macro at regular intervals
- Re: How to search files using EXCEL codes?
- Re: CommandButton not responding
- RE: Setting timer to run macro at regular intervals
- Re: Setting timer to run macro at regular intervals
- Re: using variables in listbox
- Re: CommandButton not responding
- Referencing Userform Controls
- How to obtain current selection using C++
- What is the [-409] and the @
- Add-in Serious Error Message
- ActiveCell.Address to return non Absolute reference
- “Calendar Control” to Insert Dates
- Grouping data on seperate Worksheets
- command bar name not recognized
- Commission Calculator
- opening html in excel
- Application InputBox Type 8 Error
- Drop-down in FIND dialog
- pivot source change
- MATCH() and ISERROR() to extract set differences
- Calculating TextBoxes
- MS Query becomes inert
- BeforeClose Event problem
- How can I print from cell A1 to the last row ?
- Programmatically create html as input to Excel
- Adding lines to a TextBox
- Text Data Fields mixed with binary (Comp) and packed (Comp-3) data
- Text Data mixed with Binary (Comp) and Packed (Comp-3) fields.
- Confirm save file
- highlight row if cell value equal zero
- excel's range item method
- 2 Problems with Excel
- RE: polynomial regression
- polynomial regression
- Is it Possible
- Transferring Data from Code to a Textbox in the Form
- Using Excel to send email from gmail
- previous year
- Releasing Range Object
- Macro should Save and Overwrite file
- VBA-How to calc the day (number) for the Monday of Current Week
- HOW TO HIDE/SHOW PICTURE AS PER LOGIC IS NOT DESCRIBED PROPERLY.
- Displaying the extent of a range variable
- Using variable in Excel formula in VBA statement
- a command button problem
- How can I optimize this code?
- Is it possible to store multiple hyperlinks in a cell for Excel
- Open specific workbook
- Evaluate formula
- Formating a number in a textbox
- Macro not returning correct data
- to add a button to the active excel cell! here's the way!
- VBA macro in Excel
- Show Pricing and Description
- Addings sheets using Macro
- Filter range based on results of multiple selections in a listbox
- Unable to correct VBA code
- Copy range incld. format (e.g.conditional formatting) from closed
- Re: Send Free SMS Worlwide to any mobile phone iphone gsm
- Windows API - Searching a fonction
- Excel 2007 ribbon Controls & "My.Settings" equivalent in VBA
- Weird option button behavior
- Populate text box with sql from DAO
- Excel and Visual Basic
- macro for top10 & worst10 ranking
- macro for top10 and wors10 in ranking
- I generate excel file from c# & want to display image in it
- Identifying Conditional Format
- If I use 10 macro is ok but if I use 10: Auckland City Depot it is
- Microsoft Visual Basic for Applications Extensibility 5.3 Issue
- "IOAD command"
- How to initiate a sound via VBA?
- Printing macro comments in color
- Not able to declare variable in MS Query.
- Toobar Customisation
- protect in macro
- Fastest way to create clickable buttons in Excel via VBA
- .Sort.SortFields
- Trying to evaluate cell referenes in a string
- Ask for email title/comments in working Mail Active Sheet code
- convert to date
- problem when creating a series of matrix
- problem with creating a serie of matrixes
- Pivot Table refresh in VBA code not working
- Applying worksheet formatting to all sheets in workbook
- Importing .csv file once daily leaves a data connection
- Programmatically adding a conditional format
- Works on some systems with Excel 2003 and not on others
- Can macro test fill color in cell with conditional format?
- Barcode scanners
- Match and Copy to Next Sheet
- Weird Behaviour Function not invoked
- Import data macro
- Cells.Interior.Color question
- How can I format the last row !
- need a macro to drop excel sheets that were not populated
- How to open an Excel password protected file?
- Inserting formulas depending on a variable
- Navigate a user form using enter key
- How do I set up conditional formatting to give the greenbar effect?
- Complie Syntax Error
- System.Diagnostics.Process.Start Excel Commands
- Recgnizing signs 2
- Problem with .TintAndShade
- Using Excel statistical functions on a subset of an array
- Macro Help
- Sending an automatic e-mail
- Find a number i a range
- Getting around Dependency Tree Performance Problems
- personal.xls always opening??
- Recognizing signs
- problems adding botton to a menu bar
- Importing data from Adobe 8.0 to Excel 2007
- Add Cell name
- Displaying an Excel Range
- Testing for a directory
- Macro Unexpectedly calls a Function
- Temporarily store files in local PC
- Consolidate
- find next blank column in set area
- Automating a simple multiplication to a reference cell
- How do I make this code shorter? Its Result should be given to var
- Excel object library method to open a document in safe mode?
- Copying data from a table based on two date values
- Excel AutoFillOption
- null date?
- Saving filename and file save date?
- Why does this stop excell from working
- Special lookup
- Run Macro On Exit
- Need Excel spreadsheet help on a dropdown box!!
- NetWorkdays Not Recognized in 2007
- Using Validation.Type on a Range
- Using Excel to import .csv file into Access table
- Comparing Values from One Cell to Another
- looping?
- using the itemmethod
- Re: Multiple selection from and into validated cell.
- UserForm assigns cell address to Variable
- Determine the distance between 2 cells in a column
- set variable from .find
- how do I join multi dimentional arrays
- protecting the entire worksheet
- ACCESS Query in EXCEL
- QUERY halts VBA
- Automatic Calculation in Code Takes Longer than Worksheet
- Found Data Not in Window View
- Question on Removing Characters
- Auto Filter memory
- printing specific cells
- Subtract Months
- Relative cell position in VBA
- Re: File -> New, bypassing task pane
- Project References
- 3 different hyperlinks attached to the same cell?
- Compare Contents of 2 listboxes
- IF Statement Help
- get value from combobox on toolbar
- Warning if other files open
- checking for dupes
- Range Names
- Calendar default date
- Pasting Values Problem - sorting feature messed up
- Application.Evaluate
- How To Call A Function When A User Activates a Dialog Box
- Loop through rows to consolidate data
- using the functions of the excel to identify if a color in the cellchanged
- SQL import to Excel using VBA for PC and MAC
- File Sizes are much larger
- Dis-able Online Help
- Change Current Directory
- Excel 2007 : Create a Chart (record macro)
- How to combine arrays?
- Macro to create a new tab based on an existing tab
- Macro to add a line at the bottom of a table with prefilled functi
- Get data from another workbook
- Filter set in macro filters all values out
- delete rows from AutoFilter or Advanced Filter range
- XP Vista & Office Cheap!
- Update Links prompt
- Check Box
- Remove add-in - also remove toolbar
- VB For Excel Help Files
- Direction of entry to a cell
- serial communication
- ole timeout
- why is this code not working?
- calculate
- Find() and Replace() in Excel 2007 not working.
- Wrong data type returned from user-defined function
- a problem with variable number of parameters.
- Ole timeout - jdperrose
- DataValidation ListBox
- sample macro
- Esxcel conditional formatting
- VBA Reference Books
- Problem Closing Sheet
- VBA and pasting
- Re: Sheet Naming
- RE: Change order of data in a cell
- Cell Background Color Change --> Change Event
- Auto complete typing from another column
- CopyFromRecordset fails if more than 911 byte in a field
- VBA Function Reference
- RE: Code to select cells with data
- RE: delete rows from an Advanced Filter range
- Problems with writing array to worksheet using resize
- RE: Code to copy and paste those cells that have data
- delete rows from an Advanced Filter range
- Code to copy and paste those cells that have data
- RE: Sheet Naming
- RE: Change order of data in a cell
- Code to select cells with data
- Re: Change order of data in a cell
- Sheet Naming
- Points based on goal & weight of measures
- Change order of data in a cell
- Substitute a variable in a loop
- UDF: Count rows in named range
- Sheet Select Macro
- range name as file name
- Detect Previous Add-In Version
- How can a print macro run faster ?
- Macro Error stops App Macro
- Edit text in a Command button
- Capture Worksheet Change Value
- protect multiple sheets at one time with options
- Automation
- Input box question
- Documentation for command parameters for Excel4 calls
- VBA Change Format of All Cells in a Workbook
- line break character
- Stop Excel changing CSV text into dates
- Using Input Bx to Find Record
- SendKeys question
- Userform with 1024+ textboxes
- Custom function problem
- after a .Find command, offset the output 2 rows down.
- Cycle through A Range
- can this formula be coded?
- Save and print if change made
- Adding new data to sheet2 from sheet1
- Calling a module from textbox
- Adding text to an email
- macro program
- Encrypt the contents of a specific group of cells
- refer to another cell in the same row with the active cell
- a problem with excel addin
- a button on an excel cell
- Copying (variable) rows from another spreadsheet
- using variable in value1 of PivotFilters.Add
- macro for pivot tables
- Worksheet Change Q
- Internet unnamed button not working
- run Internet explorer in VBA 2007 (EXCEL)
- Getting name of sheet
- Same name macros - One in XLA and the other in COM AddIn
- How to run macro for "private sub.."
- transposing repeating data records in excel
- Return value based on fraction of a list - VBA
- Saving Active Worksheet
- special filter or query
- #value error
- Column Subtotal Question
- Envelope Size
- Dynamic text box labeling
- If Statement..i think
- macro to show File Comments property
- Macro or formula
- Get Picture from Access Database
- EXCEL: to retrive data from the web
- MS Excel 2003 add-in converstion to MS Excel 2007
- (Name) vs Name properies for a worksheet
- Windows Message when Directory Already Exist
- Remove Item from ListBox1
- Run Macro when a condition is met
- AutoComplete feature in Drop Down Menus?
- Sum even columns
- Number Format based on Cell Content
- print range bottom right cell
- I want to make an order entry program for customers...
- Macro to select cells at current cell
- ShortName
- Vista IE7 excel 2000 VBA
- Select range starting at active cell
- Advanced Find & Replace
- removing data
- Excel Option/Reference/Install/Environment/etc. Issue
- Excel macro to read and edit mail rules
- replacing characters in a string
- Going to a cell in column B
- Visible Property
- Delete an OLE Check Box in COde when a deleting a row
- Insert number of rows based on criteria
- Copy Cell to Comment
- VBA script causes clipboard to be lost
- Select range from a varaible
- IF - formatting problem
- Clicking into refedit changes screen to bottom of worksheet
- Macro To Send Emails
- Find formatting in text in cell, insert tags aroundformatting
- Forms built using VB6 used in a DLL used by Excel
- space from right
- web refresh question
- Match Values
- 365 qoutes to be included in file
- Manipulate cells from UDF
- datepart question
- Trapping SheetChange Event in COM add-in
- Putting Internet explorer into Excel
- Update Sheet
- Copy and paste ONLY conditional format
- last row of sheet1 to use in a formula in sheet2
- Stack Overflow
- Subscript out of range, and more
- Loop within loop?
- Not sorted union range.
- sorting a range of cells in the same column by Address
- Timestamp Problems
- copy multiple cells to another sheet
- Re: (ADO)Getting data from access database Memo field
- Digital signature breaks on insertion of new Worksheets
- Macro to copy and paste row
- Size of CommandButton changing while not expected !
- Run sort macro on active worksheet
- Determining if the user enabled macros
- Working with dates in VBA
- Excel: Code to delete entire rows when font is Strikethrough?
- MultiSelect Textbox
- Data Validation for TextBoxes
- Copy data from one sheet to another
- Setting a code range = coords of the cell containing the function
- Help please with autofilter and dates
- To Database, or not...
- view web page with external links offline on laptop
- Excel VBA Vs Chart Data Tables
- Multiple users experience slowdown ??
- Excel 2000 formulas won't copy
- Individual Character fonts in a cell
- import info from one workbook to another workbook
- Print Entire Workbook
- Communication between two Excel COM add-ins
- Visual Basic
- Helpfiles missing when excel is exported to Labview using Excel200
- Open Foldr Macro..?
- comment
- Preserve keyword
- Excel Calendar/Rota program problem
- Protection Password Prompt Problem
- Can't save in Hidden Worksheet after converting to Excel Add-In
- Excel 2003/2007 Shared File Issues
- Limit fields in drilldown detail from pivot
- Column Subtotals with variable number of items
- Insert FileName - TabName and Date() - using VBA
- Question about http://www.sulprobil.com/html/vlookupall.html
- Code to stop a Macro
- compare two cells
- remove blank rows
- Error 91 while trying to save a workbook
- Multi select Listbox
- dll call in Excel 2007
- link comments section of properties dialog box to footer in Excel
- WebBrowser- connected combobox selection and function
- Excel 2007 UDFs result in #REF! errors
- a brief explanation of macro, when the cursor is over...
- Copy data from another workbook to any open workbook
- Object name on user form
- Treansposition - use arrays?
- Modify to write results into B2 down instead of msgbox
- Pivot Table Automatically updation problem
- VBA does not recognize Excel worksheet function "indirect"
- Make VBA wait for return from external function
- conditional formatting for a variable range
- Defining a range in many sheets
- statement not making sense
- VBA and insert question
- if the file is shared, do not execute macro
- Muliple formula conditions
- macro that does a find and then find next
- Variable Date vs variant
- Getting info from one workbook to another
- Change event
- Excel does not get diaplyed properly (child controls (ActiveX) )
- combine multiple rows of data into one row.
- cursor activat in textbox
- Copy Conditional Formatting
- Radio Button
- Multi window Excel
- Sneding email thru VBA (using Exchange)
- Access Coding Question
- How to put formulas into blank cells from VBA when something isentered?
- Print Code
- Excel file for deliberations on proper entry date into a retirementplan
- Copy Formula Code
- UDF Not Returning Array to Range
- How to auto hide a row if the first cell is blank?
- When excel is opened need to ask a question
- For Each minor problem
- Multiple Countif - i,j,l counters probably mixed up
- Using combobox to find column
- Run a macro only when deleing a row
- Code Formula
- view web page with links offline
- Combining PDFs
- IS THERE A WAY TO SEARCH FOR AND CALCULATE MULTIPLE EXCEL FILES?
- Delete Selected Worksheets Macro
- Using a filter when sheet has VBA code
- Activate Sheet
- Userforms
- creating new workbook from one sheet
- If statement in VBA to change formatting from % to numbers
- loop problem
- Combo Box Drop Down Button
- Active Cell
- Delete Rows
- Do a lookup with VBA based on criteria in three cells
- Personal macro workbook
- Hiding automated spreadsheet activity
- Step Into Macro when file opens
- excel 4 macro migration to excel 2007
- Macro to hide rows below
- Last key pressed
- Cell Auto Code
- Linkk Workbk to data source
- Scroll Event
- Writing a named range to SQL Server 2000 table
- Uploading files:Not sure if this is an easy or hard one
- SUMIFS with relative reference r1c1
- Summing data in one column based on date in another column
- Replace Underscores Between Words from an Object with a Single Spa
- Each Stakeholder of A File Must Select His Name (Only)
- VBA + Excel Performance: your feedback requested
- How can I automatically POST in a Public Folder?
- Conditonally format a text box
- Rename new worksheet with the current date
- Close msgbox automatically
- how do i show non-unique records (duplicates) using advanced filte
- how do i calcalate hours above 7am and >19:00am leaving 12 hrs
- Macro Error in Command Button
- Confused by CDbl behaviour
- Save Error Message
- File or Window is open
- Enabling add-in causes excel to crash
- Writing value to another file
- first column in row
- Replace
- Re: what is wrong with this code? (when used in the excel_addin)
- UDF to copy formatting as well as text?
- Last Day of the Latest Month Syntax problem
- How to run Solver while viewing a graph?
- RE: Volatile UDF evaluates to zero on opening workbook until I press F
- Re: vba solution
- RE: moving within forms
- Offset
- code to change font color of row
- control toolbox vs forms toolbars
- Format Total but not GRAND Total rows
- Format Total but not Grand Total rows
- Select range between column and row
- mapi.session
- XL2007 workbook with multiple users?
- VBA Coding Help
- Viewing/editing Macros
- Worksheet DESIGN - Prev. Balance
- Excel 2003 - Typing Letter in Dropdown Cell
- Can anyone correct this code ???
- Can you do user defined Menu Macros in Excel like in Lotus?
- Go to a given row number
- objMessage.Recipients.Add
- How to create "permanent" toolbars
- Indirect question
- Problem Using 'Mod'
- user editing cell when code runs
- Help with code
- Coloring a cell based on a formula
- How do I display the winner's name in a ranked list of names?
- Passing information between worksheets
- Excel Shared AddIn
- User Forms and Sending E-mails
- Format Looping
- Function for smooth curve on a chart
- Help with... Help
- vlook up Function
- AddDiagram Not woring in Excel 2007
- preventing comboboxes from triggering when sheet copied
- Getting Defined Name from Cell
- Search for Values part2
- hide and unhide worksheets when a set button on a form is clicked
- Problem with hide/show for userform where showmodal is set to true
- Sum two data ranges when met two conditions
- halt a subroutine question
- Sum of data ranges in two different sheets giving two conditions
- How can I cut and paste from excel to other applications, multiple pieces of info?
- find in workbook
- hide and unhde worksheets when a set button on a form is clicked
- error subscript out of range in commandbutton_click
- Where did my question go?
- An 'Insert' question
- Do not show this message again
- insert picture in microsoft office excel 2007
- insert picture in microsoft office excel 2007
- calculate vba userform type mismatch when decimal is entered
- Search for Values
- Copying data from one sheet to another
- SelectionChange Event Glitch
- #VALUE! Error from UDF
- Access form from Excel
- MSForms.DataObject Misbehaving
- date format
- rename worksheet
- copy & Paste
- Storing automatically updated data
- Export % from Excel to Word as %
- Filling out paper forms
- difference between range.text and range.value
- Save a file
- Timer question
- Distribute Cost by Month
- Delay in file opening in excel 2007
- Pause until MSNSTockQuote runs
- Barcode scanning macro
- Retain rows with Max values - Delete other rows
- what does =Print means in MS EXCEL
- Transferring of certain cells from one workbk to another
- export file and arrange
- Generate calendar column month headers in YYMM Format
- Conditional Formatting More Than three
- Identifying the worksheet and cell that contains a function call
- Hide WScript Command window
- Share a digitally-signed macro workbook
- Referring to a certain column in an array
- SUMPRODUCT for other Excel functions?
- Coping cell comments to another cell
- excel4 function descriptions
- Expand Event for Grouping
- worksheet change?
- CountIf
- If Range R Is Nothing Exit otherwise Copy Another Range
- Auto Filter Freeze Up
- Select and Print Dynamic # of Columns
- VBA coding for pasting a formula
- How to Strip Leading Spaces and Underscores from Object
- ChDir and ChDrive
- initializing an array
- [Black]$#,##0.00;[Red]($#,##0.00);[Blue]$0.00 (CUSTOM FORMAT)
- go to next columb
- Auto-Filter When Workbook Protected
- Unprotect
- looping thru rows of variable length
- Setting up Template without ROWS LIMITATION
- Over My Head Print Code
- Protection greyed out in Excel
- change variable type
- Excel to Word Macro help
- How can I automatically format a column as it is imported?
- how to extract a dataset to the active cell?
- excel addin
- Runtime error 438
- keywords, modifiers
- Code for Cut Paste each page to separate sheet
- Record Actions
- Suppress "Saving" window
- Computer ID
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.