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 |
- Split Up Excel Table
- VBA help please !
- Problems closing Excel correctly by code
- How to Capture Edit Cell Event?
- Linking Data
- Opening a file without the macro start menu
- Override excel's printing dpi setting
- autosave
- Worksheet Custom Properties
- Using VBA Replace function for single quote
- Protect multiple sheets in one time
- setting format plot area in charts to white(automatic)
- Exporting data from Crystal Report to Excel - Need soln
- seprate and store string in arrays
- Changing Chart Colors
- Insert Rows
- Break all links in the workbook
- Declaring Constants that can be used throughout the Workbook :)
- VBA
- How do you add 1 to an invoice number in Excel. Formula for this?
- Can I disable Worksheet_activate???
- Best Way To Install Add-Ins
- clock control
- How do I use an Intellimouse to scroll listbox enteries in ExceL?
- creating function with multiple arrays in arguments
- sumif / countif question
- How do make it a connection of Access Database from Excel?
- Timing Issue??
- Need Help with copying and pasting with var.
- Need Help With Export Code
- Passwords
- can't update chart series unless its activated
- Looping Through Charts / ChartObjects
- Runtime Error on Simple Sort
- More used range Q's
- Delete Rows based on an external list
- Dealing with old higher versions in registry
- help again function >vector>function
- run-time error ‘13’
- Abort recursion
- How do I set a comment in a cell with VBA?
- Duplicate a picture image into multiple cells
- Suppress sub totals on pivot table
- How do I generate a list of 5-digit numbers in Excel?
- Copy data from 3rd worksheets and pasting to active worksheet
- advanced filter
- Printing
- Help with Macro
- Combinations
- Concatenate VBA results and an * in a cell
- IsNumeric("121d1") = True ??
- Help needed - seriously (looping? macros? formulas?)
- Yet another error
- Combinations
- Disable Paste Special
- array formula help please
- writing information from a userform to an excel sheet
- Macros with hidden sheets!
- I need Help - Importing name files to datasheet
- Creating First UDF
- Data Entered in Multiple Rows to One Column
- Error message for Imporint External Data
- Inputbox Question
- Microsoft Script Editor?
- VLOOKUP statement too long
- Create Microsoft Outlook CalenderEvents from data in Excel Spreads
- Copy Worksheet to specific row in another workbook
- Using LEFT in a Conditional Format
- Worksheet specific code
- Creating a hyperlink shortcut in the spreadsheet.
- Macro Error
- Export from Access to Excel
- ActiveX button on sheet too big
- Referring to Values in a seperate Worksheet
- Cut, Paste and Move to next Row
- NOVICE :!! PLS help calling function!!!!
- Declare at application level
- find next? urgent
- deleting rows, endless loop maybe ?
- Macros Written in Excel 2000
- Userforms Question
- Having troubles using visual basic to paste info from one workbook to another
- HLookUp
- Comments
- msg box
- Re: Blinking Cell (Worksheet restarts)
- Excel 2000 : Error 1004
- Financial Quarter from dd/mm/yyyy
- auto expand row hieght of merged cells
- During filling Excel Sheet copy/paste in Explorer does not work
- Else without if?
- create named range specific to worksheet
- while macro is running...
- Invalid watch expression
- Howto prevent automatic calculation when open a CSV file
- How to "update" SpecialCells(xlLastCell)
- Problem in compiling code containing "$" char
- Setting zoom of 2 sheets equal
- Working on interactive worksheet (need help with highlighting and blinking cell)
- Re: Blinking Cell (Worksheet restarts)
- Macro updates
- Enumerate form items
- Controlling dialog programatically
- Replacing Formulae With Values.....Continuation
- Print Selectd Rows
- how to run macro after changes in a cell?
- Late Binding to Word Variables
- Workbook/Macro/Worksheet Protection...
- Possible to see which user is editting/using file?
- InStr function question
- referencing a checkbox cell address in a worksheet
- Hide columns in a group on after VBA-procedure
- declaring a certain value
- If find is true then.....
- lock cells for editing-pawan
- Filtering by Cell Background Color
- Open Lotus 123 file
- Listbox navigation
- Module 1 - Subscript out of range error
- Linking files with variable directory path
- Last row as value
- Windows NT - Templates - UDF - Links
- Module1 vs Thisworkbook for Macro
- Detect if a file is in use or being modified
- Database
- Tabular to CSV style layout
- Creating a function call from from
- Problem of Crystal Reports in .NET 2002
- can we shrink images to fit?
- Passing Worksheet Names as Variables
- Difference between XIRR and YIELD
- Put items in combobox using VBA and toolbox
- send msg same as netsend
- Flashing command button
- What type of Array is this?
- Run macro from an excel file from another one
- Need help for a loop
- AutoFilter
- Using a custom format on the clipboard
- Menu-Item and worksheet deletion questions
- switching from one window to another
- vlookup for an approximat lookup value
- Problem with Remove Subtotal in Macro
- type mismatch
- Clearing a userform
- extract information from a spreadsheet
- How do i set up a rank function on a list of results?
- Union, intersection, join
- copy used range across books
- Speeding up a Data Validation macro
- COM and threading in VBA
- Activating the last active worksheet
- Do loop skipping
- F keys don't work, help
- calander control and copy command problem
- writing a formula to a cell
- Consultant In Atlanta
- Compare between String and Value using VBA
- Addding a combobox to a workbook?
- End Of Month Data Only
- Hide/Show Shapes on Worksheet??
- How do I run a macro program for multiple workbooks at one time?
- Something wrong in one line of VBA code
- Replacing VBA code strings by using VBA code?
- Align Right footer text to Left
- Print only desired rows
- Marco for Picuture
- Now()
- Confirming a deletion
- delete record based on a value
- SELECT CASE - Which Row am I on?
- Excel macro to name ranges.
- Trap a checkbox click
- prevent event procedure under condition
- TOC in Excel
- iValue Stops after 10 cells of data
- Intptr & Int32
- Download image in Source.xls and save it as result.xls
- Macro Still Won't Run in Excel 2003
- macros or code
- Switch names in cell
- After Save Event help
- Save and Save as Function gone
- Combo box problem
- I Know I'm Missing Something...but what?
- Home Stretch! *
- Max numbers of characters in userform textbox and cell
- ClearContent & 'Cannot change part of a merged cell' error
- keyboard event in user form
- More effective code
- Object Browser does what?
- Code Help ^
- Nesting problem?
- How to return rangename of selection with VBA
- If then and 2 cell values
- Converting String numbers into real numbers
- Converting String numbers into real numbers
- Count number of times a specific number is displayed in cells
- Count if with multiple criteria
- Macro Help
- automatically go to last worksheet inserted in a workbook.
- I need help with combo box
- Copying
- command button to calculate two cell values?
- paste in next availible column?
- SELECT CASE "Jan-03" confusion
- About NUM to CHAR
- How do I enable the spellchecker in a protected worksheet?
- press button "entra" in web page
- active cell in row
- Use of Interior.ColorIndex
- Cell contain default value of cell above it
- How to handle error 8007000e Memory Error
- Another way with cell comments.
- Removal of standard Delete msg from within VBA
- Re: Blinking Cell (Worksheet restarts)
- 2005 Excel User Conference
- Copy to next blank row
- Check for existing sheet in book
- Disable Copy
- Strange Cell Behaviour...?
- Create/Update Excel Objects in Power Point
- how entries in a column can be put into a row
- how entries in a column can be put into a row
- How to supply your own web query
- Keeping Prying eyes out
- "counting" through the alphabet
- CountIF on Filtered data
- how entries in a column can be put into a row
- renaming text in cell
- How not number ?
- To Display a figure while excel is ready to GO!
- Re: Checking if not equal
- Checking if not equal
- Naming worksheets
- Text replacement with VBA Excel in several files
- Tekst in een tekstfile wijzigen met VBA Excel
- Num convert to Char.
- selecting values form multiple excel files into an excel worksheet
- Controls on form disappear
- Default Printer
- adjust range size??
- Adding new columns from one sheet to another
- copying data
- Please help: Coding Problem
- Restrictoin of xp windows feature
- columnshead with listbox
- completely Locked Out
- Vary formula based on what another cell contains
- Search a Range for a phrase and Format cell if found
- treeview node tag hold array?
- RE: Create Macro using VBA / Macro
- return colmn number + index
- Copy web query across sheets
- Addin Issue
- Duplicates?
- Phone Dialer in XP
- Button that creates a back up in Excel
- time error
- Cell Value
- textbox character limits
- Page Selection
- Off Topic a bit... but to this newsgroup
- AddressOf Nightmare
- Runtime Error
- How to do it...
- Print - Userform Multipage selection
- Sum Columns
- How do I stop a macro from running within a macro?
- ActiveWorkbook.Protect password:=range("rangename") does not work
- MSCAL.Calendar Excel Cannot change Properties Using Macro
- Load data into a listbox
- Can you print user forms
- Re: Another error message
- Limit the Loop to 500 Rows
- Is there a way to cross data types?
- Dim mySheet As New Worksheet
- Create scenarios using macro and data in cells
- Memory In Excel?
- Can one use excel like a chat
- message scroll bar in excel
- make pivottable dropdown work like the filter.
- Insert cell anywhere
- On Cell change call
- Anyone know of a way, or have a script, to read a TOC from CD's?
- incrementing rows for matching debits/credits
- Input box and carriage return for chart title
- Variables- Multiple forms
- Drop list affected by previous choice
- looking for a way to make a form Txtbox only visable on Mondays
- EnableEvents=False doesn't work? or does it?
- Need to identify a column within a range that meets criteria
- Don't understand why this formula is not working - Help Please!
- How to get a return value from a user defined function
- treeView -- multiple selection
- row location....hopefully simple answer :-)
- How can I Write this to a CSV File Please
- Save As "something" then date
- Excel-Form to file.txt
- Another Error Message
- Combining Modules
- Control disappears from form
- need some formula help please
- Pivot Table Macro
- form in excel to be attached to the emails address in the form upon sumission
- Find Within Workbook using VBA
- Excel Dialog Box/Sheet
- I get #VALUE in the cell - sometimes
- Toggle change control button face id & caption
- Reference to ActiveX control on worksheet requires full worksheet name
- incrementing every two rows--the sequel
- -Help- Sigh...
- Enter current time into cell hh:mm:ss
- incrementing every two rows
- New to Excel Programming
- Convert '6/23/2005' to '062305'
- VBA code for IF statement with OR?
- Copying Chart with Chart Series from Worksheet Name
- Code Problem
- Recording Changes Made to Worksheet
- sendkeys and the "+"
- Open Specific Sheet in Workbook
- How can you update an array formula using VBA?
- Message Box
- Lacking in Macro Building Skill...
- Extracting parts of a cell
- Transfer data from XL into Access: best practice
- Getting excel to show mm/yy in Funcation bar like it does in the c
- vba for hiding rows
- formating military time
- deleting rows
- Capturing a file path
- Re: working with two sheets
- Re: Static variable
- Problem with running macro on Mac computer
- Adding to acurrent Excel menu
- numeric calculation in logical formula
- active cell issue...
- Deleting all dropdowns...
- Re: Linking a Summary Workbook
- Skipping cells in a Do Until loop
- Find & Replace / Loop & Vlookup
- export cell value - Date Format
- Re: Linking a Summary Workbook
- Re: working with two sheets
- "Object Variable or With Block Variable Not Set" error help request
- Blinking Cell (Worksheet restarts)
- Changing Windows Registry from Excel
- Removing cell borders on any cell
- Sum ? / Numbers with Text
- Step 1: EOMONTH Function
- VBA Function results in #NAME?
- VBA to proctect locked cells in sheet
- open pdf files with a certain bookmark or page number
- HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE
- copying row information in a table to another location w/criteria
- Run-time error -2147319784 (80028018) when executing a simple macr
- If Then Statement in VBA
- dynamic pull down menu
- removing word for column
- Link Increments
- SendKeys in VBA
- Error 91 on Second Error
- Size a check box
- Excel seems to hang and cause asp script to timeout.
- Efficient Code
- Excel not updating
- Redirecting macros ...
- locking check boxes using a macro
- Transfering data to external application
- Show / Hide Columns in multiple sheets
- IDing cells in one worksheet, find them in another, and copying respective data
- C++ to Excel
- Hiding Tabs
- Cope worksheets and save to location
- Time Stamp for specific macro..
- Activating / Closing workbook using part name and a wild character
- Continue line of VBA code on the next line
- Macro for hyperlink -pawan
- Date format problem on export to CSV
- Pivot Table Selections
- calculatedfields
- Excel Queries
- Macros available to several workbooks
- Control Word through Excel
- Currency Formating
- Moving range to array
- can not restor FormulaBar when i close yhe file
- wrong date returned on ws.Cells(r,c).value
- I'm loosing it: rows in filter
- Excel limitation or bug or what?
- Show/Hide Columns
- Select Case on different worksheet?
- printing vba code in color
- removal of circular reference error on excel workbook load
- Another Question Concerning Replacing Formulae With Values !
- Macro-pawan
- Multi Sheet select and hiderows
- Macro which finds data? help?
- Incremental number field with User ID
- How to search a value with two criteria from a database?
- Custom save as pathname and filename
- Getting series name
- 2 if statements
- loading com addins with automation
- VBA Error setting Font.ColorIndex
- Pivot table autoformat info
- Validation from list in different worksheet/workbook
- getting rows out of a data base
- commands button
- colour text in validation lists
- Progress Bar in Cell
- Adding a Trendline or similar to a 3D Column Graph
- Merged cells text > 255 chars causes "#" to be displayed
- Graphs
- Combobox Change On Save As
- Deactivating all events in ThisWorkbook
- Data Validation from a database query ?
- copy and paste graphics into comment boxes
- Bundling Solver with Excel File
- outline...hide levels
- macro security
- macro works differently when using the Step Into (F8) feature
- HELP!!! I give up!!! Help with formula
- Sumif problem
- vlookup relative reference?!!??!!
- How to set range
- dee
- scrolling in VBA Edotor
- VB worksheet function parms
- Running an external Macro
- XMLSS href attribute
- Copy data from excel to a defined table in another spreadsheet
- Macro Copy and Pasting
- Conditional Formatting Not showing without editing cell
- Want row to stay hidden
- Help files
- VBA acting weird, advice plse.
- Hidden Row in seperate worksheet.
- Retrieving Active Directory "Full Names"
- How to Kill a vba macro from a Function//
- Userform always visible
- Need VBA code to terminate a find loop
- Writing Single Dimension Array to Active Sheet
- Creating a search button
- Help with a macro
- How to Open txt File and Import it to excel
- Connection with SQL Server generate "Timeout expired"
- Working on the wrong sheet
- opposite of IsNumeric
- range property of range object
- Connection with SQL Server - "time exceed"
- While ... Wend
- A Simply ComboBox Selection returns value to TextBox
- Run-Time error 57121
- Retrieving Web Data
- Need Help for Help!
- Need Help for Help!
- maintaining a link
- Copying range from another file
- Private Sub - Hot key?
- Getting Month Name
- Macro with manual file selection?
- What does "\" do in VBA
- making cells bold
- time format
- VB Help does not display Excel information
- Page Break Automation
- Working with data from several worksheets
- Excel command line
- How many hyperlinks can be in collection?
- Autofill Function
- Msgbox if Inputbox entry contains character
- Help with totaling a columns in VBA
- Adobe to Excel
- Blank lines
- Toggle command buttons
- Microsoft Office Web Components 9.0
- sorting worksheets and charts together
- Hidden Row
- format partial formula
- How to get Autocorrect Listing out of Excel
- Open excel and workbook with VB6
- Format portion of formula
- command button for vba module
- Tranferring Text from Excel to a Header in Word
- Create and write XLS using OleDB
- Open a VBA Macro when Excel Opens
- how error-trap "no cells were found error"
- Enable - Disable Macro Dialog Box
- Control disappears from form
- Inserting a Row after a name
- Email Single WorkSheets from a Workbook
- Variable List Box Range
- Loadin ADD-IN programarically
- Schedule a Macro To Run on cartain day
- printing excel worksheet
- Calls from sheet module to ThisWorkbook module
- Lookup from multiple columns....pls help...urgent...thanx
- List of Unique Values
- XML Files
- Saving excel files as jpeg
- Open a file with a macro
- Selecting text
- Return Current Column Letter and Row Number
- Creating a PivotTable with VBA
- Import grafic
- Working with XML Files
- fill cells with colour if content of another cell has CR
- ADO Connection Help
- How to scroll data in a chart?
- Excel 2002
- form in fullscreen v.s Screen resolution
- how do I remove quotation marks from .CSV file
- vba for lookup and autofill
- Cut - Paste in xls file (c++ code)
- onAction with parameters
- Another coping and pasting macro
- text is deleted when cell is edited
- worksheets feeding to other worksheets
- How to represent an empty cell in excel formulae?
- Using Dialog to select a Workbook, Worksheet and Range
- Code Help
- Listbox Help
- Stopwatch query
- Indirect and Offset argument
- Autoexec Macro
- Can you use worksheet names in macros
- Spreadsheet Performance
- AutoFilter: Loop Thru Visible Rows?
- Help with code...
- Help needed on program
- Controls auto resizing with scree resolution
- Worksheet Change code not running when you just delete data in cells.
- I need to return the name of a worksheet in another worksheet cell?
- Storing column references in a variable
- Find a Value Pass Row 99
- Loop
- scroll bars in comment boxes
- Please help / Named range help
- Data Validation Drop-down List Limt?
- Can this be done? If bn=b(n+1) and cn=c(n+1) then delete row (n+1)?
- VBA Program to Email-able Toolbar
- VBA Excel Macro - One File Auto Create Multiple Excel Worksheets!
- Autofilter and Listbox how to acomplish?
- Re: VBA/XP/2000 On Error Resume Next problem.
- Controls on form disappear
- Help with find and replace macro
- set up a command button or macro for open file to "save as"
- 13 type mismatch help
- Web publishing question
- How 2 Execute Sheet1 Button_Click Code from a module function
- Textbox question
- Range value cells with Sumif
- Newbie
- how to Detect paragraph in cell in string?
- Ojbect required error msg
- Printing a Report
- autofilter
- Safely automating any language version of Excel
- Parameter in Macro Call?
- Publish method failing, can't understand why
- Text to Value
- Re: Splitting fields from commas
- Macro problem
- Splitting fields from commas
- On Error GoTo If
- move down 23 lines and make the 23rd line height 92.25
- Highlighter
- Solver GUI works fine, but the VBA macro won't return any results
- Query on Date range does not qualify the Year
- Excel in VB.Net code
- Microsoft Excel Expert ????
- Slow Performance Hiding Rows
- objectos
- Closing Excel from Script
- ScreenUpdating Question
- The case of the missing buttons
- Sheet / Hide & Unhide for editing only
- Virtual Memory Macro
- Memory Management
- Disallow Paste
- Coding problem
- Page Breaks when data is NOT on column "A"
- Modify VB for a Runnning Total
- Programming to delet padded spaces
- Changing the Colour of an Auto Shape (Line)
- Display "Does not exist" upon search no results
- form
- Problem adding a range in Sumif function.
- Password
- Insert column
- macro problem
- Make a button disappear
- Totals
- workbooks.open without triggering event
- Comparing 2 workbooks
- How do I add help info to a user defined function?
- refer to cell using the value in Row 1 and column A
- Help required to run simple macro...
- deleting objects
- Hiding and unhiding columns
- vba help
- AdvancedFilter in VB
- Skip blank cells on transpose in a macro
- Using excel as a database
- Reg: Incorrect RecordCount when opened a Excel sheet in ADO Recordset
- i have problim with my excel VBA
- close excel without saving
- Launching Excel wb from Lotus Notes document
- How do I get the address of the cell that is being calculated right now?
- Have Excel VB Read from two sheets
- Cutcopymode problem
- Delete Sheets
- Self destructing code
- Searching 1 column for data
- Filter Excel bases on the current user
- Omit page with no data when use "show page"
- Copy command
- Screen Positioning of a Dialogue Box !
- Assign a macro to create a pivot table
- Worksheet SelectionChange event
- Formula for timecode duration
- Code to list users that have changed a spreadsheet
- Input two cells with one selection
- Problem programming the Sort command
- Get Range, that user marked
- Pointers??
- Accessing Menu Options from VB Code
- how to filter first column only in range
- good book
- Send Email from Excel
- Way to Link Tab Names
- VB Code Location; sheet, workbook, module
- Quit without saving
- How to search a range for a suburb in a large range
- Excel Function Help
- How do I use the ActiveCell's contents as a string for a web query
- VBA Security
- copy cell after resize method in VBA
- Bad File error: Need Help
- In search of VBA script
- excel problem...help!!!
- Copy Code needed
- Activating/De-activating buttons
- Help with named ranges
- Help with Named ranges
- C# worksheet function poor performance
- 2005 Excel User Conference
- SaveAs Crashes
- Combo Box to return a value
- copy data to each worksheet
- Header Font size
- Creating an Autoexpand in Excel Combo Box
- How to delete cells ?
- Could You Explain the difference?
- VBA newbie needs a little help
- remove Worksheet using Sh.Delete without prompt
- Re: base formula calculation on whether different cell has formula
- Creating Excel Addin
- Selecting more than one sheet
- MAX in conditional formatting
- Table Help
- Use Excel Macro in Access
- Help with following code creating chart
- Macro to move text from one field to another
- Trouble with ActiveControls and Forms
- macro to find if the Excel file is using by other user
- Count If, criteria is greater than
- Simple Cut & Paste Macro needed :)
- Row Selection or Column Selection or other ?
- export excel spreasheet into a text file
- changing variables?
- Screen size
- Copy information down specific cells
- How do I use the AutoSum?
- Delete PivotCache
- Determining Which Page of MultiPage Initially Shows
- lock and unlock cells programatically
- GroupWise integration
- Send Mail Script Help
- Hyperlinks
- Screen size
- Copy from two files
- Delete a workbook
- How do I track frequency of occurance in data table?
- Can an Array Formula Solve This?
- VLOOKUP
- How to make user forms FULL SCREEN?
- selecting cell range in other worksheet without switching to worksheet
- VBScripting syntax for Autoformat
- Information about ATL functions
- Code that can't be seen/modified by users
- Userform - ComboBox fills TextBox not working
- Inconsistent macro behavior
- Max value in 1 column when all values format are text
- Re: Close file without saving
- Re: Macro to delete sheets and saves remaining file does not properly delete module
- Hiding Tabs
- Re: Macro to delete sheets and saves remaining file does not properly delete module
- Is there a way to programatically resort the sheets in a workbook
- Auto Adjust the Width of a Column
- Re: Macro to delete sheets and saves remaining file does not properly delete module
- Re: Macro to delete sheets and saves remaining file does not properly delete module
- Re: Macro to delete sheets and saves remaining file does not properly delete module
- Re: Macro to delete sheets and saves remaining file does not properly delete module
- Linking List Boxes and Textboxes
- Re: Macro to delete sheets and saves remaining file does not properly delete module
- Read Only Problem
- Auto-Enable Macro's
- Re: Macro to delete sheets and saves remaining file does not properly delete module
- Visual Basic Tool Bar
- Summing a range depending on cell background colour
- Having difficulties with For If Next loops
- Re: Accessing personal macro's all the time
- Macro to delete sheets and saves remaining file does not properly delete module
- command to show top of worksheet?
- Saving Multiple Sheets to Another Spreadsheet Without Leaving the Initial Workbook
- Formula Help
- Help for ATL functions
- Select the last Cell of a selected Cellarea
- Problem with xlCenterAcrossSelection
- Excel 2002 Workbooks.Open failed.
- Need vb application to print first Worksheet in excel files
- Does some one has a golfscore in excel sheet format
- Select range -- convert formulas to values
- Alignment
- how to stop a macro
- Determine last row in columns 1-4 to copy a formula in column 5
- trying to get a row to break....
- searching on more than one field in VB
- searching on more than one column in VB code
- i losst my VBA excel Passwerd
- How to add an entry in the Excel Right-Click Menu
- Combo box control Drop down list moving
- Print splitting...
- Populating List Box from SQL Server
- forget my passwerd
- Workbook Bigger and Bigger
- how tot open VBA Protectoin
- wrong positioning of data in sheet after clearcontents()
- Why!!!!!!!
- Object variable error
- Drawing Objects with duplicate names problem
- problem when inserting or deleting cells
- Find the last row
- Dating Problem
- Formatting Y axis values based on other chart
- after clearcontents() new data is positioned below the cleared ran
- Re: return text not index for property
- Page Setup Macro
- How to open new instance of excel if excel is already open?
- Summing a range if a certain background colour
- Copy/Paste charts
- Flexgrid Control
- Macro to copy columns from 1st sheet to 2nd according to mapping-p
- Merging Pivot Table Data
- return text not index for property
- Sort and Specify that you have a header row
- Print 3 Worksheets
- Textbox Format
- Max number of worksheets in a workbook?
- Report for Conditionally Formatted Cells
- Anyone in a really good mood?
- Macro to find text in all worksheets -pawan
- reliability of macro results
- Excel VBA: Move Userform Based on Active Cell?
- Find and change external links to point to the same workbook instead
- Help me migrate
- How can I use values in two separate cells to select a new cell?
- excluding text entries in calculations
- Code for Conditional Formatting with Five Conditions
- Timed loop
- Save to sheet 2 in workbook
- Re: Accessing personal macro's all the time
- savings files with the use of variables
- protection
- Search a text file for a string
- Have chart lines take up full area of chart from left to right
- Using List Boxes and returning Value to cells
- Deleting Pictures
- Help w/Insert
- How to force Excel to complete one statement before executing othe
- Worksheet has to set to visible as it is not visible after saving and closing Excel by VB.
- Opening item from Listbox... Need Help :P
- functions
- names of areas
- how do i chk is sheet exists my attempt included
- opening a file
- A math/algorithm puzzle!
- Importing Data from the Web
- Personal file slows navigation
- problem with text from macro?
- Countif for a string
- Maximum value of two variable
- ADO connection retrieving data to Excel using EXCEL-VBA
- How reference columns numerically (not Cells() )
- Help with If/then macro in VBA
- Wrong result returned by UsedRange.Rows.Count
- Mouse-over content in bubblecharts
- Throwing an error ... on purpose!
- Loading array into list box
- Automatically transfer selected data to another sheet on print
- Inclusive/Exclusive List
- Worksheet too big
- Subtracting Dates VBA
- Subtracting Dates VBA
- Invalid qualifer
- ms query - from statement
- multiple line two accumulators
- How to check for an open network connection?
- Help using a cell ref. to go to another page for data
- textbox scrollbars disappear
- macro for formatting
- Group cells and sort
- Looking for a 'Contains' Formula in Excel
- XL 2003 TOOLS/Macro/security level inactive
- can i use formulas in calendars in excel?
- If condition
- Userform retain data after closing and reopening
- how do i convert a number stored as text to a numb in a vba loop
- Macro works for me but not user group
- notify drop event of excel/word in C# add-in
- Which control is the one selected?
- Excel Application Level Global Variable
- Delete Row if text or empty
- delete row base the value of certain column
- SAVE AS MACRO
- Unprotect workbook without password
- Split() method
- Macros problem with XP
- incomplete code
- MyRow error
- Link cell show zero when source cell is blank
- Static variables
- offset function
- Application.Mode
- HYPERLINK link problem in Excel sheet using VC++
- Executing a macro in a closed workbook
- What formula can I use to compare items in two columns
- Read Only
- Data extraction... (Pls Help)
- searching cells for a string of text
- help with code
- time line
- RowSourceProperty
- normal distribution of random no.'s
- Textbox values
- fao patrick molloy
- MACRO
- "Can't find project or library" error message
- Autofill formula to last row with data when rows will be dynamic
- import fixed width text file
- how to attach macros to excel permanently - pawan
- How do you generate random numbers in a normal distribution?
- macros
- How to use Tools, Data Analysis, Regression in Macros
- Automatically starting a macro
- send email from button
- macro to paste data in alternate cells-pawan
- Restricting access to ceratian cells
- Steam Leaf Plot in Excel
- TextBox Color Change
- telnet without sendkeys
- X and Y Screen Coordinates of a Range !!!
- help again, last line required
- fast range copy (without clipboard and with formatting)
- Out of Memory Error 7
- Checking for empty cells in a range
- Checking for empty cells in a range
- "... whats this??? am puzzled
- Word Mail Merge and Personal.xls problem
- Automatic Printing
- Macro for delete row with "vlookup"
- PictureBox in Excel VBA
- Passing a Sub's name as parameter
- Data copy from a seperate sheet to data sheet
- Re: eliminate header&footer for spesific pace
- Reading mail attachements
- Get value from combobox
- Very Basic Excel Object Questions
- how to create chart by VBA coding?
- Macro Won't Run in Excel 2003
- Coping numbers only in cells to other worksheets.
- Solver rounding
- Re: vlookup with closed workbook
- Do Until
- In desperate need of assistance
- international excel issues
- copy a worksheet - but not the value (text)
- Variance formula - is this correct?
- Re: Problem with Pearson Code
- base formula calculation on whether different cell has formula
- Pushing results HELP!
- Histogram Bins Created From Sum Of Two Cells
- Sending email from Excel vba problem
- Re: Simple Moves
- Re: Combining data from multiple workboods into one
- Re: Combining data from multiple workboods into one
- Advanced Filter
- Save File with Date and Time Stamp
- Macro ?
- works in Xl2000 but notXl97 - help required
- Named ranges and variables
- working with data from several worksheets.
- copy equation to new row
- command button question
- Removing & Importing a macro module
- I refuse to be let down by the experts
- Running macros from shortcut keys
- command button
- Advice on three dimensional array (difficult?)
- How can I query the 'indent' level of text in a cell?
- ToolTipText
- 2 values in 1 cell
- Help needed to consolidate variable ranges in excel vba
- hyperlink a cell to an email message
- Re: Matching values in 1 column to data in another
- Matching values in 1 column to data in another
- Find specific cells
- excel in the foreground
- Switch board
- Ping - Bernie (or any other sage)
- List Box or combo box into a cell
- cell locking via VBA
- Named ranges and variables
- Repeat Entries
- Finding the last non bank cell in a column
- Looping with Excel Forms
- copy the drop down list value and paste to next column
- excel auto-formatting - help
- XP Styles on Excel Form
- Update on Worksheet_change with data from other sheets?
- Capturing Excel Copy/Paste/Cut events
- How to check for an open Network connection in Excel VBA?
- Excel and .NET
- vb dummy - two routines
- Comparing values in 2 columns - Help needed
- How do I call this function?
- can I compile excel as a stand alone programme like access
- can't copy a sheet within same workbook
- Automatically run macro on sheet change
- Auto Row Height for Merged Cells
- Problem with Named Cells
- is there any way to create a formula in excel for amortizing
- .NET, CAS and Excel Development
- stop web query
- Vlookup in VBA - Driving me crazy
- Making Cells Automatically Add #'s Instead of being written over
- Data Validation Listbox and the Worksheet Change Event
- I'm trying to disable a clip board
- Print Macro..
- specifying ranges using cells
- Add a Range to an existing Range in a loop?
- HELP-- Filtering and copying data to a new sheet (w/ macro)
- Print Macro..
- redo CommandBar("cell")
- Publishing Workbook or Worksheet (HTML)
- Copy columns to free space in diff wrkbk
- Removing Duplicates
- Event to trigger when form is scrolled
- Referencing an opened Workbook
- Validation help
- Range for a single cell
- Excel -> Word: Problems copying/pasting shapes
- get data from one sheet list in another
- Run Access Macro from within Excel
- Extract Data From Multiple Excel Files -> One File
- percent of total with partial items
- Procedure not working, and I do not know why
- Rounding Ranges
- Selecting cols and doing a formula using variable offsets
- SheetActivate
- where put code for automatic execution upon opening workbook?
- Saved seems not to work
- Buttons Moving around page or shrink in size on Excel Worksheets
- ExecuteExcel4Macro Problem
- displaying times in combo boxes
- Excel 2003 - Error Running Macro
- count a value in cell if the cell to the left has a certain Value
- Numerical Breakdown
- Save from a template to XLS only visible sheets
- displaying time in a combo box
- How can i get autoformat name of range in excelsheet?
- Copy columns to last populated rows
- Chart Objects
- Multiple line, two cell accumulators
- EZ Formula Syntax Question
- formulas are not working on my spreadsheet
- How can I disable the save function depending on one cell?
- Deleting Shapes in a worksheet
- Finding a value
- data entry to next blank TextBox
- User form and text boxes on charts
- saving to two folders by selecting one
- formulas and colorindex don't work after opentext
- Macro copying macro code
- saving to two places by selecting one (VBA)
- Quick Formula question..
- Fixing SSN's with a macro
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.