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 |
- Macro Toolbar Button
- How to use macro?
- "unexpected error" when running solver from a macro
- On entry
- screen updating
- Determining path to document template
- Function to display a cell containing an underlined number
- VBA Array Formulae
- Work sheet function -average
- Dynamic controls
- saveCopyAs
- problem Excel VB Macros
- Convert no. to time
- Worksheet_change Target Address is Reference Cell
- Word from Excel
- How to Rewrite these Code?
- Worksheet code if-color-statement
- Active printer
- Check File Name before Save Event
- Searching a range and copying values into a new range.... **Please help** :(
- change colour on value, 4+ colors
- Worksheet_change Target Address is Reference Cell
- Random Sorting
- Problem in setting Cell Interior Color filling.
- Using the sum function with a blank total
- Hox to control Comment Shape Sizes?
- VB vs VBA ??
- Worksheet_change Target Address is Reference Cell
- Copying Worksheets
- ComboBox, referring to content
- html markup to add comments to excel cell
- Copying Worksheets
- password protecting macros
- Query on the Use of Absolute References
- Add-In
- How to cycle through a series of similar objects with a for-next loop?
- Date
- Search and Replace With Formatted Text
- How to Rewrite these Code?
- Access to Excel Automation ADODB Problem
- VB Programming, trying to save as lower version
- Excell FileOPenDialog from another App, and listbox multiselect problems
- how can i retieve stock data in an excel worksheet?
- Defined Name
- Open all files question
- How to Rewrite these Code?
- Query Automatic Refresh
- Edit Excel TextBox using C#
- Combine .textorproperty and select case
- Use variable across workbooks
- Using rng.Value & RefersToRange to pass data between worksheets - SLOW!
- Error# 11004, Unable to set the property error
- XP activesheet.paste error on VMware servers
- Prevent control & break
- How to Rewrite these Code?
- reference to a cell within a string
- Re: OptionButton
- placing formula in cells
- Finding an underlined character among several characters in a cell
- Union across multible worksheets
- Autofilling from one sheet to another
- Delete row macro/VB
- Copying files in VB
- Find, Copy, Paste Into Different Workbooks
- MDX Query
- textbox not updating when controlsource cell changes
- File created with VB is hidden
- Re: OptionButton
- Windows message text font
- Paste Problem
- Sheet Formatting
- Comment Font Size
- Calendar Control
- Preserve Formatting crashing excel
- sugestions
- Combo Boxes and Tick Boxes
- Run Macro
- pastespecial
- conditional formatting
- Please, help! Anyone? ImageCombo’s BorderStyle OR images to ComboB
- Beginner programmer problem
- get cell's print sheet number
- HELP, dont know how to describe this in a subject line
- Adding a table to an excel form
- unique values
- web query data post to ASP
- Listbox Properties totally blank
- Worksheet_Change procedure question
- Value translation
- how to remove double quotes?
- Data Consolidation
- no puedo
- email shortcut to active workbook as an outlook attachment
- change Company property
- protect add-in after workbook closes
- Import and run Macro
- aligning a form on the screen
- Need a Special Sort Routine
- If Then to Add Row
- check to see if sheet exists
- Passing a string aray as an argument to a function ?....Help!
- Using the VLOOKUP function
- help with vba please
- Page Headings
- vba to count
- The equivalence of EQUIVALENCE
- File Open Dialog
- Changing Default Module Location
- help with vba please
- multiple sheets into 1 pivot table
- Find data in Column D, add L in Column A
- User Defined Functions
- Mouse Position
- "unexpected error" when running solver from a macro
- Visual Basic for Dummies
- Generating content on the spreadsheet from an Add-on issue
- token/type count?
- change colour on value, 4+ colors
- copy and paste
- coding question
- Code to add today's date in subject line VBA
- Programming A formula
- Formula help please
- Check File Name before Save Event
- Who has read/write
- Worksheet activating
- controll and skip duplicate...
- Special printing
- Execution speed for UDF
- Help with macro!!
- Check boxes
- User defined functions
- Excel causing exception error upon opening the document
- Excel causing exception error upon opening the document
- Programming A formula
- Macro buttons disappear when I print
- select method of range class failed
- Find Command
- Please, help! Changing ImageCombo’s appearance or alternative. Tha
- Need help with file opening formula
- Worksheet activating
- Populating column N where is is blank or null
- Passing Solver a Macro
- Comparing cell values
- Sort Routine VBA
- Ron, Send Mail, Desperate
- Shade a region in a X-Y plot!
- Event class doesn't fire in embedded VBA
- Pivot Table help
- Help with Array compare
- Problem with post-style web query
- Common Controls Color Dialog Box ...
- Default File Path
- Excel, VSS & VBA ... = problems
- MFC Automation
- Saving an array
- Add file name somewhere in worksheet?
- select method of range class failed
- Reverse link ComboBox?
- Creating a Function
- Run an excel macro when a cell value is changed
- Use "Data Validation" after data are entered
- Stopping the screen drawing
- Stopping the screen drawing
- Seeking example code
- select method of range class failed
- take Active Sheetname
- stubborn macro
- Macro to select Quantity Printing
- Clearing Clipboard
- Modeless for in Windows XP
- Jump to next sheet if not found
- Spell Check Within a UserForm?
- Stop until Calculationstate = xldone
- VBA to "answer" spesific msg box
- Data Consolidation
- Excel Print Macro
- Excel Print Macro
- Unprotect and protect sheet in a macro
- Retrieve File Name before its saves
- Unable to use the function Left in VBA
- Populating column N with a formula if column A is Null or Blank
- Spell Check Within a UserForm?
- Prevent Particular File Name during Save
- XL2002 / XP : Crashing problem
- Compile Error
- Private Sub Worksheet_Activate()
- sendkey problem
- CopyFromRecordset method
- Stop until Calculationstate = xldone
- Excel and MapPoint
- Calculating and copying data into new sheet
- Compare 2 cells in 2 worksheets, rewrite one of the cells
- Jump to next sheet if not found
- looking for autofilter with code
- Public variables and separate library files
- Worksheet events - when are they triggered!
- XP activesheet.paste error on VMware servers
- How can i write TSR code
- DBL click over an excel file
- Range.delete method
- How to password protect several excel workbook pages using a macro
- date range vba code
- The TEXT function in Excel 2000 VBA
- Put file name in column
- The TEXT function in Excel VBA 2000
- Transparent user form
- Command Button OnClick
- Print Excel Form In Landscape Mode?
- VBA (or other) worksheet function parameter insight
- Store text file in workbook?
- conditional copy data from workbook to another workbook
- Parse database into several files based on column D
- Help with OnTIme Event Issue
- How to create a macro
- Removing (trading) an item in a listbox
- Excel Query
- Save a Range of Cells as Gif???
- If, Then, Cut, Paste, Delete HELP
- Help with code
- Test if Active Cell is in a named range
- Colour shade an area in an Excel graph!
- Add-in toolbars
- FR - Reprendre le format d'une cellule
- Need Help
- Find and Delete Blank Cells Formatted as Text
- need help in writing a statement
- How to deal with an error question
- Shade a region in a X-Y plot!
- Using a VB.Net interface to turn excel spreadsheets into a working
- Finding Real Worksheet Name After Access Export
- Using a user form in various workbooks
- Urgent - Pl help code for assigning a shape to cells
- AutoFilter and copy
- Stop message to UnProtect
- Re: ListBox filter
- HELP, dont know how to describe this in a subject line
- conditional formatting & a loop
- VBA code not working...
- Counters
- please help simplify
- add worksheets
- Excel causing exception error upon opening the document
- Remove duplicate rows and sum cells
- Runs fast then slow
- Hyperlinks in Excel
- listbox question
- Vlookup in Multiple columns
- Clipboards Overloaded?
- Data Consolidation
- Macro to list files
- Removing references
- Move worksheet
- Calculating and copying data into new sheet
- Calculation bug or is it me
- exit sub after insert row
- Delete Filtered Rows - without deleting column headings
- How do I code a "self-destruct" triggered after a certain date?
- Calculating and copying data into new sheet
- Changing button appearance on custom toolbar.
- Re: for next loop not working
- Conditionally Delete Cells From Named Range
- Macro programming
- Converting Excel Formula to Macro
- Linking graphs with macro
- worksheetfunction
- Calculating and copying data into new sheet
- Pivot table help needed
- storing / appyling pivot chart formatting
- Duplicate value with blank space
- Export to MS Project
- Entering static Date/Time
- OLEDB Help Excel 2002
- Macro to activate all cells in a range
- Calculating and copying data into new sheet
- Entering static Date/Time
- Variables From TextBoxes
- please help simplify
- Entering static Date/Time
- Spreadsheet web component
- How do I automatically change currency depending on another cell .
- Setting cell borders
- File Path Macro
- Restrict Sort on a Particular Sheet
- Using a macro to populate a cell with a formula
- Dick K - Move e-mail to different folder
- An 'event' of zero activity?
- Hyperlinks
- Automating the summing of columns
- Error Message "Formula is too long"
- Calculating and copying data into new sheet
- Link to Pivot Table with specific page value
- Series Collection Points
- Remove Userform Deactivate Button
- How do Macro to EDIT cells?
- Redraw Application Window
- Expected:= ???
- Expected:= ???
- graph
- Is this possible ?
- [VBA]Inserted value does not get formatted
- Collection does not work with strings?
- Sub, not function!
- Sub, not function!
- Sub, not function!
- Options
- Hyperlink TexttoDisplay
- advanced summing
- Delete rows from activecell
- paste as device indep. bmp in powerpoint
- excel truncating leading zeros
- ActiveSheet.Protect
- Is it possible to automatically run a macro upon a spreadsheet
- Save Macro
- Copying Worksheets
- How to insert an address from Outlook 2003 address book ?
- Problems with auto_open
- Save a Range of Cells as Gif???
- Create a menu to List the Name of worksheets in a Workbook
- Sub, not function!
- Spaced out
- Can it be Done ??
- Data (entry) form - expose properties?
- fileformat not working with Object
- error!
- Macro within a Macro help
- error!
- Sorry for the vague question
- RE: Replacing cells that have 2-3 letters: Sorry for the vague question
- Replacing cells that have 2-3 letters
- activating the cancel button on Input boxes
- ClearContents not clearing :(
- Replacing cells that have 2-3 letters
- Accessing VBProject Property
- ClearContents not clearing :(
- Convert Cell References in Formula to Values
- List Data to Single String
- Suspending MAcros
- ClearContents not clearing :(
- Returning actual page field changed in pivottable
- returning pivottable object from a range object
- interest rate when compounded daily for 5 years
- Finding Values Too Slow
- Stop 'Disable Macros'
- Move a row to the centre of my sheet Excel 2002
- Assigning a shape to cell
- Simple Macro - I Think?
- Need Help with a Menu Item .OnAction property
- Excel97 Userform to be system modal/equivalent
- Date Problem
- Sloooow loop
- Copying Temp List to cell
- Writing a .txt file
- HELP, dont know how to describe this in a subject line
- How are Marco Stoaged
- Bank Formula for CD that is compounded daily for five years
- HELP, dont know how to describe this in a subject line
- UBound not in Intellisense. References problem?
- identify the name of the activecell not its address
- Error on printing
- Excel case
- Clearing DropDown Lists & Removing External Links
- Looping through text boxes
- Excel case
- Retrieving data
- inserting a date in a form
- Re: Calling subs from different workbooks
- workbook_open
- keeping track of a range of cells in another spreadsheet or access database
- Late binding with VBIDE
- OnAction procedure
- web queries
- Excel case
- Cutting Data from cells changes Cell Formatting
- VBA Security
- Excel - Protection
- referenced file
- Inserting Picture into protected Sheet
- Looping through text boxes
- Looping through text boxes
- saving files
- Ant ideas?
- Close a userform
- Creating my own undo
- Showing a calculated Date as a string
- Please help me with this email from excel
- How do I hide an Excel module or macro from other users
- Sort & Subtotalling isn't working?
- Extracting Data from CSV files
- all chr()
- MArgin in printform
- Alphabatizing Combo Boxes
- Macro that copies range to new sheet
- setting Select (Un)Locked Cells in Worksheet Protection
- Need macro to set duplex option
- Looping through text boxes
- Comparing Two Columns?
- Ant ideas?
- Can't get userinterface variant to work on mac.
- UserInterfaceOnly on the Mac
- How do I set up an Excel file to save automatically and give a fi.
- Run time Error 1004
- Re: Formatting code for a spreadsheet
- Excel should calculate and display numbers properly, but doesn't.
- Interdependent flow scheduling
- Shapes question
- Runtime error 13 type mismatch ?
- CheckBox1_Click()
- Runtime error 13 type mismatch ?
- Runtime error 13 type mismatch ?
- hr,min,sec
- Range objects in a collection
- VBA Help Problems
- Runtime error 13 type mismatch ?
- UserInterfaceOnly on the Mac
- Extracting Data from CSV files
- Moving Code
- Football Predictions Spreadsheet formula problem
- Runtime error 13 type mismatch ?
- commandbuttons on worksheet move to the left
- Macro or excelfunctions
- Looping through text boxes
- Email
- Username
- Copying multiline textboxes from userform to worksheet cell
- remove excel-icon
- Header Row 1 is displayed in split screen - Way to keep
- Copy values to multiple destinations
- Outlook vs Outlook Express
- OnTime function
- HELP, dont know how to describe this in a subject line
- reading data from com port into excel spreadsheet
- Email from Excel
- macro help
- Newbie needs help with if statement
- HELP, dont know how to describe this in a subject line
- Newbie needs help with if statement
- Extending Named Ranges
- HELP, dont know how to describe this in a subject line
- Looking for a way to run a macro when the workbook is opened
- Re: for next loop not working
- 2 things
- Windows XP default path for temp file
- HELP, dont know how to describe this in a subject line
- using the Find method in a VBA macro
- last cell on row
- Assign macro to toolbar custom button?
- Splitting cell contents
- Supress certain 'cells in Pivot Table
- Summing loop for multiple worksheets
- removing duplicate rows
- ?Application.Evaluate("max(len(A1:X20))")
- Range question
- Converting Excel Formula to Macro
- data feed text delimited
- Tom Ogilvy or anyone that can help
- Help with macro!!
- Conditional Formating of cells based on value in another cell
- update links (ignore previous post same title)
- Link updating
- VBA Excel - changing series source.
- VBA Excel - changing series source.
- Opening a workbook if not opened, going to it if already opened
- How could it be?
- Inserting Picture into protected Sheet
- Excel replace text.
- change event procedure
- Problem with .CreateField in DAO
- Checking if value is a number
- Re: wait for user action in VBA code
- Count of results in AutoFilter
- prevent duplicate results (database query)
- How maximize open excel workbook
- Re: Checking if integer
- ListBox selection
- Checking if integer
- How can I do this?
- Re: Calling a procedure in a protected VBA Addin Project
- Mission Impossible
- Excel replace text.
- need help
- Dynamically setting Print Area
- On error End Sub
- Opening a workbook if not opened, going to it if already opened
- What's Wrong?
- Re: copy to another wb and name the target sheet (XL2000)
- Newbie question: function call
- Userform List Boxes Load Very Slowly
- Summing Cells with a BLUE font (or any other color)
- Error - End If Without Block
- RE: Looping through Sheets
- RE: Looping through Sheets
- It worked!
- It worked!
- Programmatically detect a syntax error in a macro?
- Re: column hint
- Re: Trapping Insert Row
- Opening a workbook if not opened, going to it if already opened
- Re: sumif question 2
- Re: Find Command
- Excel replace text.
- sorting code problems
- quick question on a checkbox
- sorting code problems
- Filename changes daily, anyway to link to most recent file
- sorting code problems
- Userform data to Excel sheet.
- RefreshTable vs PivotCache.Refresh
- Value of a cell
- XL remoting issue...
- ListBox drag & drop
- sumif question
- Why "Worksheet_Change" dont work under DDE link?
- how to delete cells without shifting and rows/columns
- Find Command
- RE: Why doesn't this work?
- keeping rows together after query
- look up
- DISABLE CLOSE MSGBOX ON CLICK "X"
- sorting code problems
- number ZERO in a cell
- Adding TextBox to UserForm via code
- Moving a range to end of list
- quick question on a checkbox
- Macro to save as using two cell values inside worksheet
- Inputbox "choose password"
- Add a column to a selection
- sorting code problems
- Excel2003 and xlListSeparator...
- Master to Report Tabs
- find open workbooks
- Serious Crashing Problems in Excel 2002
- Delete Empty Rows
- copy to another wb and name the target sheet (XL2000)
- can you hide macro code??
- VBA Error Message
- help with rowsource
- Removing item from combobox with vba
- sorting code problems
- VBA and FormulaArray Runtime Err <is not more than 255 Char>
- carraige return within a cell & capitalization
- Macro protection
- Removing item from combobox with vba
- Remove .xls from selected files
- Data from listbox to Excel sheet
- disable or hide the close window icon 'X' in the corner of a userform
- Removing item from combobox with vba
- Minimum route from two nodes
- Can you get a Merged Cell with Text Wrap to Autofit?
- copy only from a cell with data in it
- Can you get a Merged Cell with Text Wrap to Autofit?
- Minimum route from two nodes
- Minimum route from two nodes
- Disable Right click
- Run code after entry
- Insert a line in word from excel
- Conditional Formatting adjacent cells
- How to go to a predetermined sheet on opening
- Userforms/Macro search
- looking for autofilter with code
- Email Excel File Automatically using Outlook 2000
- Serious Crashing Problems in Excel 2002
- row reference from selection
- Looking in 1 list and copying from another lfile
- IF referance multiple criteria Formula Help
- open workbook
- Add Menu to a VBA Form
- Enter a "checkmark" in an AutoFiltered cell
- Need help please
- Re: VB solver
- VBA help file not found.
- Help! Overflow Error 6
- copy only from a cell with data in it
- open workbook
- transfer data in listbox
- To include Depot
- To include Depot
- data entry with userform questions
- Unprotect via prompt
- Word VBA Code to Excel Code
- Apply Macro on Multiple Worksheets in a Workbook
- validate a directory or file exits
- looking for autofilter with code
- Call from a Main program
- prompts for the user defined functions
- copy only from a cell with data in it
- Check for any data changes in a form with multipage object
- SUMIF
- In Excel 2000 can you write VBA code to pull data from a webpage?
- In Excel 2000 can you write VBA code to pull data from a webpage?
- Gross Faults/Errors With Put and Get
- Change from Numeric to Alpha
- Scanning Text files for specific words
- Call up Powerpoint using Excel 2002
- find command using variables
- Error with Activecell.paste
- How do I get my Excel to act normal?
- Need xlodbc.xla in Excel 2003
- Worksheet change sub procedure
- Pl help - Graphical Indicators in Excel reports
- What are the cells in a Pivot Table range?
- help with choosing and calculating time data
- Executing sub procedure when Excel starts
- Selecting Last Worksheet
- help writing macro
- Pivot Table from VBA or VB6 - Field Settings
- Why does sort always default to include a header row. I want the.
- Max worksheet exent width
- Info Only: Formula Freeze Module
- How do you Sum the range of two lookup values?
- cell ref w/ varaibiles
- Master to Report Tabs
- web query
- Iterating through Page Fields of a Pivot Table
- how can I write ascii code in Excel?
- Initiating a macro from a control button
- validation date
- Recommended Read-Only Property
- position mouse cursor in msg box
- Web page
- RE: External Queries - Excel 2000
- Printing PDF from Excel Error
- Enter Key
- xls filename with a number in brackets
- Waiting for OLE action
- VBA auto fill problems
- Import Access records to excel (parameter is a called funct) v.20
- custom menu bar doesn't work
- blank rows macro question
- Late Binding help, Please
- select populated cells
- help with code!
- Choose several sheets in VBA
- Data Validation Question
- Templates
- Collapse Dialog Box
- View previous cell value programmically
- Export Entire Excel Sheet with headers, footers, etc, to Word
- Replace conditional formatting to use 4 conditions
- View previous cell value programmically
- How do I define the same name to a number of different worksheets.
- Object Name
- Object Name
- Userforms/Macro Search
- insert lines into CODEMODULE gives error
- Object Name
- Rotating a Table
- Can't seem to create a Pivot Table with VBA ?
- Apply Macro on Multiple Worksheets in a Workbook
- help! code for a cell
- Object Name
- How do I resize a named array in Excel from a MxN array to a mxn .
- Copying files from PC to PC
- Date selection loop
- Macro to Search and Replace
- Validation
- Help Please! Macro Error on Select Worksheet
- Help! Animated gif-image in form does not show animation when form loaded
- Help please! Animated gif does not show animation when form displa
- Excel Copy/Search/Paste Help Needed ASAP!
- Validation data
- Wild Card Path
- increase the size of a worksheet
- Serious Crashing Problems in Excel 2002
- Excel should let me change format of the cell when it contains for
- How do I automaticaly update the current day's date each day?
- copy Excel worksheets into one text file
- Moving a range to end of list
- viewing code
- Copying meaningful data only into new worksheet - VBA
- vba routine in Excel 2002 to create varying size email in Outlook
- RE: OWC version control
- Need help with loop to import data
- Re: Master to Report Tabs
- Master to Report Tabs
- Need help with loop to import data
- Date.
- Macro's Flicker
- 2,560 cell limit???
- Save & Install AddIn with VBA
- Need some help
- count the number of times a value updates in excel?
- VBQ and macros executable in Pocket Excel
- validate phone number
- Sorting data automatically
- combine two records
- Save CSV File without prompting
- Simple Paste Question
- Deleting columns based upon the value that appears in column A
- UserForm code help needed.
- VB Is a workbook open
- Visible Property Pivot Item
- Userform to be always on top of all Applications?
- Remove reference from code
- PivotTables/VBA
- Convert -1 and 1 formula
- UserForm code help needed.
- Error loading DLL
- preventing use of F9 (recalculate)
- If Statement based on Alpha or Numeric
- Change the properties of a non selected cell?
- Looking up two conditions
- Pivot Table problem
- VBA - Insert new sheet as the last sheet
- Vlookup on named range
- 10% Match
- Copying spreadsheet data to WORD
- some final help
- VBA - Insert new sheet as the last sheet
- preventing use of F9 (recalculate)
- simplification problem (only for expert!)
- timer
- Deleting columns based upon the value that appears in ROW A
- Automatically Add Foorter with full filename in Excel
- communication with MS Project
- Activex control security message
- Sorting data automatically
- color index
- Caption
- finding a cell
- UserForm code help needed.
- Re: Extract a table from Crystal Reports into EXCEL
- Adjacent Cell Value Theorem Help
- finding a cell
- Using defined names in VBA...
- Using Excel softwware to draw construction mappings
- VBA Help
- Using a variable file name
- vlookup
- determine row reference from button
- Sarbanes Oxley 404
- RE: fill randomly cells that verify contion
- Setting WEEKDAY function to Exclude Friday in Calculation
- vlookup
- Copy visible rows with data to new file
- Ignore Blanks
- Change Form Size after Click
- New Workbook
- getting value of range problem
- Unprotect via prompt
- fill cells, merge cells
- fill down to next change in value
- texttospeech
- texttospeech
- excel formulas to count and sum
- Re: datalabels collection crashes Excel 2003
- mismatch error in returning concatonation of numbers and characters
- Incorrect code...
- copy only from a cell with data in it
- fill cells, merge cells
- Draw Buttons
- Calculate the time difference in minutes
- check if item exist in olap cube
- mismatch error in returning concatonation of numbers and characters
- Selecting Sheet1 by index rather than sheet name
- Apply Macro on Multiple Worksheets in a Workbook
- looking for autofilter with code
- Hide font in formula
- How do you round to 0.5 in excel
- Test if Sheet Exists - Tom Ogilvy
- Row # of active cell
- Writing strings to a text file ?
- Apply Macro on Multiple Worksheets in a Workbook
- Open File Read Only
- Help with VBA
- To their respective sheet.
- VBA Code to identify contents of a cell
- Re: how do you combine worksheets
- automate sending graph/pivot report in body of email
- how do you combine worksheets
- Path to a dll as a variable
- RE: Find method
- RE: Why doesn't this work?
- ? for Ron de Bruin
- Conditional Formatting
- Re: Find method
- Selecting a worksheet from a macro in a different workbook
- RE: Find method
- Why doesn't this work?
- Re: Find method
- Password window popping up when saving
- Find method
- Why doesn't this work?
- RE: Run Array.. run array... (Which to use?)
- DSN UserId and Password Prompt
- Control Deletion of Range Names
- Task Scheduler
- Creating connection documents
- Conditional formatting
- Re: Workbooks.Open(URL)
- RE: VBscript
- Cell selection code
- Workbooks.Open(URL)
- Properties information
- VBscript
- blank rows macro question
- Userform text box query??
- OnTime problem.
- OWC version control
- Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook
- Return MS-SQL database names to excel?
- Function not visible
- Re: How do I show number of hours as a negative using formula?
- blank rows macro question
- Re: Absolute cell references
- RE: Run Array.. run array... (Which to use?)
- Re: Application.Match problem
- Date question over 3 years
- Is it possible to update XMLMap's schema?
- Re: Run Array.. run array... (Which to use?)
- RE: Creating References To Excel Objects
- DSN UserId and Password Prompt
- Timestamp from Outlook
- VBA calculate manually
- Re: Auto Fill Option button
- Comment créer un TreeView dans une Toolbar Excel ?
- Application.Match problem
- Run Array.. run array... (Which to use?)
- a challange for the "real" programmers
- Deactivating Insert/Delete Row/Column
- fill randomly cells that verify contion
- Auto Fill Option button
- Workbook Open Event
- macros create temp files
- Error Handling driving me crazy. Please help
- Creating References To Excel Objects
- How Do I Make multiple Pie Charts
- Trim function in VBA
- Saving question
- Moving a range to end of list
- Display Clipboard in Excel
- Need some help
- Inserting 10 Rows
- Error in Excel 97 when running Excel 2000 macro
- Creating connection documents
- distributing xl with vba code - how to know what's needed
- RE: Absolute cell references
- How do I show number of hours as a negative using formula?
- Absolute cell references
- Why this don't work
- Getting a Proxy Class into VBA
- How do I show number of hours as a negative using formula?
- VB UserDocument on Excel sheet
- Updating High/Low Values from a set of streaming data
- Help in saving a formula.
- How do I get rid of my form from the screen?
- Multiple criteria Filesearch function
- timer
- Moving Columns only
- UserForm code help needed.
- list date in the form and vlookup
- That "out of memory" error
- RE: Extract a table from Crystal Reports into EXCEL
- Error in Excel 97 when running Excel 2000 macro
- code to convert date from TEXT format (03-02) to DATE format (200203)
- copy range on every worksheet (diff names) to a master worksheet (to be created)
- Error in Excel 97 when running Excel 2000 macro
- Re: Exporting excel worksheet to access table
- VLookup Not Picking Up Entire Phrase
- Re: Userform text box query??
- VBA coding
- Re: AutoFill of empty cells
- Userform text box query??
- Multiple criteria Filesearch function
- OnTime problem.
- VB message
- Protected cells
- Subscript Out of Range
- stopping an excel application from vb 6.0
- copy range on every worksheet (diff names) to a master worksheet (to be created)
- Error in Excel 97 when running Excel 2000 macro
- AutoFill of empty cells
- Add a category to the Insert-Function category list
- Group Dates with Code
- Re: What is the Visual Basic command to select an entire row in Excel.
- Re: What is the Visual Basic command to select an entire row in Excel.
- Re: What is the Visual Basic command to select an entire row in Excel.
- Re: What is the Visual Basic command to select an entire row in Excel.
- Re: Cannot Query MDB!
- Re: What is the Visual Basic command to select an entire row in Excel.
- Re: Task Scheduler
- What is the Visual Basic command to select an entire row in Excel.
- How to change worksheet direction
- Chart properties
- Conditional Formatting
- Excel - using VBA
- Showing built in dialogue boxes
- Re: Pick Lists
- looking for autofilter with code
- error message
- VB command in the "Control" file
- RE: Pick Lists
- Fine tuning if statement....
- Re: insert page breaks
- Pick Lists
- random number generation
- What are ....
- Pivot table doubt
- Date in Pivot table
- insert page breaks
- How to creating certificate for the compagny only
- Control Deletion of Range Names
- Numeric data being ignored
- Excel 2000 - Files corrupt after saving via VBA
- ActiveChart.ADD Fails
- fill cells, merge cells
- auto open text files
- copying and renaming a worksheet
- Re: debug
- how to copy entire row into next row
- How to copy entire row into next row by macro
- RE: Print problem
- Need some basic help
- Deactivating Insert /Delete Row/Column
- debug
- macros and pivot tables... help please!
- Working with Pivot Tables in VBA
- Help: VBA macro for worksheet formatting
- Hide font in formula
- User form upon opening
- Add click event with code
- Draw Buttons
- excel office web components
- Hide font in formula
- Excel 2002 closing by itself???
- Opening Multiple Workbooks
- How can you create a Pivot Table using vbscript
- Error Handling with Nested Loops
- Custom Function on Personal.xls
- VBA Help File search not working
- Re: calculate weekdays only
- Find cell and paste data
- Plotted data changes in XY Plot if first cell is in X data is blan
- find a path
- Simple Macro - I Think?
- Nudging controls in UserForm Design Mode
- image edit control
- Re: calculate weekdays only
- Re: Print problem
- Re: Sorting with Drop-Down Menus
- RE: Print problem
- Building an Array
- How can one test against merged cells in VB.NET?
- Sorting with Drop-Down Menus
- Cannot Query MDB!
- Re: HOW DO I CHOOSE MULTIPLE ANSWERS FROM A VALIDATION LIST?
- Re: 1st line is the header, how do I have it print as the first line
- calculate weekdays only
- XL2003 "paste method of worksheet class failed"
- Re: calculate weekdays only
- Missing Data in a Range
- Re: HOW DO I CHOOSE MULTIPLE ANSWERS FROM A VALIDATION LIST?
- Re: 1st line is the header, how do I have it print as the first line
- HOW DO I CHOOSE MULTIPLE ANSWERS FROM A VALIDATION LIST?
- 1st line is the header, how do I have it print as the first line
- GetSaveAs Method
- Searching for keywords
- Preserve formatting setting in VBA crashing Excel
- Problem coding a Sort
- VB error message
- Cycle through a folder of excel files
- calculate weekdays only
- Sending e-mail - Ron, you still there?
- Re: Custom Views based on sheet name
- X bar chart in Excel
- Comparing two lists
- Custom Views based on sheet name
- Check to see if sheet exists
- Re: Trying To Store Shapes/Objects to an array ??
- Parse Data - Bernie
- Form Error & Q's
- Underline font not reporting properly
- Importing data
- export/import excel data to word doc. properties
- Re: Excel Freezes
- Trying To Store Shapes/Objects to an array ??
- Print problem
- e-mail links follow up T.Ogivly
- Variabel and caption in userform
- RE: Variabel and caption in userform
- VBA deleting Macro
- Need to make this simpler.
- Re: Variabel and caption in userform
- Macro help
- Variabel and caption in userform
- e-mail links
- Task Scheduler
- RE: Exponential Growth
- RE: Exponential Growth
- de-select range in other workbook?
- Re: =Why AddIns.Installed can be out of range=
- CSV Excel 2000
- RE: Code instead of foumula.
- RE: Please help me with this error
- Enter simulation-related HLOOKUP formula in cells
- Re: How do you sum values in a coloumn when it contains #N/A in a ran.
- Please help me with this error
- Re: Can I use ISERROR with VLOOKUP function?
- Re: Update SQL db directly from Excel
- =Why AddIns.Installed can be out of range=
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.