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 |
- Opening a sheet at a certain time
- Assigning Style to ActiveCell which is part of Merged Cells
- How do I return the name of a Range?
- Re: running Word/Excel in silent mode with Office XP PIAs
- Retrieving User of Last Save
- Trouble w/ ActiveX Controls (no userform) Excel 2002.
- Referencing funciton to workbook
- compare names and delete duplicates
- Numeric formats
- custom icons
- Deleting specific rows
- Range to combobox- forget the blanks?
- Help on Run-time error after "Save As"
- insert row below activecell
- Recording Macro -- find max value --- create chart
- Insert Rows
- Unable to read file
- Range name box
- Use of Selection.Find & ActiveCell
- 3D Range Parsing
- Conditional Formatting
- Workdays
- =proper
- vlookup
- How to program multi-select list box?
- Nesting a formula in a macro
- Macros not running after Upgrade to Excel 2002
- Preventing users from deleting worksheets
- Disabling Macros After A Save To A Different Filename
- Re: Help: HTML Table not displaying full text
- Alias for a Pivot Table Column
- Accessing Pivot Table's Data in VBA
- Accessing Pivot Table's Data
- Upgraded to Excel 2002
- Importing and Finding Matching data
- Stepping through code gives different results than running it!
- "Invalid internet address" during ADO
- How to pagebreak
- rounding up
- highlighting only filtered rows
- How To:
- Code advice please...
- Auton open
- Re: Ole automation with Excel 10 from Vb.net
- Import to Access
- Create Printing Macro
- csv to xls date US/UK format
- How Do I Automatically Detect Cell Changes In Excel
- win api function
- Toggle Macro with KeyStrokes
- "Object disconnected from clients"??
- Expenses claim form
- How can I insert a space before the last character in a range of cells
- Unlikely Error Message
- Function Vs. Sub
- .ListFillRange as Variable ? in Listbox
- Merging Data
- deleting duplicates
- Deleting Rows
- Work around Calculated Field limitation
- Row insertion macro
- help
- Distinct Data In Combo Box
- Access menu item from VBS
- Newby question: use a worksheet but not show?
- Function
- compare value in cell and copy cells A through S of same row to a new worksheet
- Declaring variables
- Autofilter
- Re: DEclaring variables
- Login ID over a network
- exporting spreadsheet to GIF or JPEG?
- Trimming Excess Data
- Macro to delete duplicate data in row
- Detrmine which command button was clicked
- determine cell is part of pivot item or pivot field
- One more question...
- Where am I going wrong
- Colours in Drop Down Menus
- a script/macro to copy a block of cells next to specified cells
- heres one for ya..
- How to calculate a page number
- VBA: Writing an array function (like MMult)
- Chart question
- Worksheet Password Recovery
- DEclaring variables
- Worksheet_Change function
- Formula property of a series in a chart
- Sumproduct with Or
- calling modules
- Function LoadResPicture ?!?
- Time Between 2 intervals
- Launching Excel from a web page
- Changing a scrollbar value to 0
- How to change shortkey in a complementary macro ?
- Copying multiple tables to single worksheet
- Summary Help
- VBA code to show a save as dialog does not work
- Accessing PowerPoint datalabels from excel VBA
- Copying and Pasting Formula
- Excel printing
- Can't access to a Workbook
- Select Columns based on cell value
- Import module with vba
- VBA shortcut
- Increasing the Data Refresh rate for Web Queries for Excel 2002
- Catch-22 with Error 59
- "Jake Marx" - Thanks!
- Highlight Cell Macro
- Macro on a data validation list
- changing focus
- Help with ADO and VBE
- button focus
- VBA or MACRO to prevent someone from printing the contents of an Excel worksheet
- userform1.activecontrol.name
- workbook creates desktop shortcut...HELP
- Advice for a newbie
- Macro to add a number of rows after being prompted
- Click event on cell triggers a macro
- how to create a user form programmatically
- Add-In Manager
- Visual Basic
- Importing data from an Excel file on a web server using ADO/VBA
- Dont intersect
- Not very printer friendly
- Disable the name box
- access violation 0cx0000005 in vba excel
- Help with Macro error
- Copy and Paste Between Workbooks
- blank userform
- Referenced Workbooks
- Arrays
- Macro to delete duplicate data
- Combo Box Inside a Form
- WorksheetFunction
- DDE Formula To Look At Cell Info
- Range.Copy and error 1004
- Hide Worksheet
- Finding and Deleting last row
- List of Macros
- macro cuts off decimals!?
- Duplicate Project in VBE
- Microsoft excel is waiting for other program to finish OLE Action
- Print Area Resizing
- Excel locks up
- Delete a module in VBA?
- Microsoft Office 2003 issues with Visual Basic
- Color in Cell
- ActiveWorkbook.Close
- Customized symbol ?!?
- Path and Acrobat ActiveX
- Hiding my macros
- Sorry, But Getting Desperate
- Intrastat reporting
- Excel / VBA / SQL DB
- combobox
- How can I Merge Worksheets from different Excel Files into one Worksheet?
- Inserting Rows
- Early vs Late Binding - Word
- Excel Addin
- Value of Combo Box
- accessing text import wizard in VB
- Plz help me ...
- Is entire row empty?
- Save sheet as .TXT out of Workbook
- SendMail File linked error
- IF(ISERROR(MATCH - need value where match was found
- Question Using SaveAs Method
- ODBC error linking to Sybase database
- #VALUE!
- Simple yet.....
- DateAdd function
- Testing for a currency ..
- copy-paste in a userform
- ADO Issue
- Re: Cell range selection after calculation
- using a range with isnumber property
- Need help saving as tab-delimited file
- xlDialogSendmail (bug?)
- Execute a batch file from inside Excel
- Button macro from filtered data
- Simple VB question
- Is it possible write a self-defined function in excel that connect to SQL server to get data?
- Application.Path in Excel 2k and 2002
- I N D E X menu via Tabs Popup
- Calculate cell reference
- Excel Textbox limitations
- Application.Path
- duplicating macros
- Opening workbooks from UDFs
- Range in FindMethod?
- Grouping Data
- Detail on formula language bug
- Set a Range to all of the first row
- Pop Up and Audio alarm running as background tasks.
- Copy & Paste
- Filter specific information and format
- Macro to change a number to text
- Loops to delete rows
- putInClipboard errors on mac
- Can I launch the Calendar Control from a Comand Button
- send attachment using file path from hyperlink
- How to select a row to delete
- Excel Language bug formulas
- ADO and text file
- data range box
- Conditional Formatting - number of decimal places
- VBA in excel to update Powerpoint
- macro works on F8 but not auto
- VBE Issue
- Find & Format Using Macro
- Conceal functions and subroutines?
- CopyPicture
- Custom menus
- Combo Box
- AutoSizing TextBox
- Cut and Paste Macro
- VBA SUM
- Automatic SaveAs Worksheet Name
- Need interpretation
- Bar Chart
- Help with Data Extract
- ByRef question
- Findformat
- Can anyone help, me and my bud here in school?
- Summing last row in list
- VB Round( ) function
- compiling VBA in Excel2000
- Highlighting last available cell in bold
- disable pivottable refresh message
- Re: data validation help neded asap
- data validation help neded asap
- Application.OnTime and Visual C++
- Appending data from one sheet to another.
- default number format in pivot table
- customize right click
- finding variables in a column
- automatically create another spreadsheet from template
- Macro
- Entering mixed font strings
- Help Im crap at VBA
- Please do my homework for me
- Delete Worksheet
- I can't see a Workbook in WorkBooks.Count
- ActiveCell.FormulaR1C1 = "=RC[-4]-RC[-2]"
- find method?
- How I can determine a base class of a procedure's incoming parameter?
- Make a graph with for cycle
- Userform - dispaly graph as image
- Checkbox
- Help -- Loop or Array? How to identify?
- Form buttons and macros
- I need Help in a form
- Shareware Edwin's Power Tools decompiled and became Excel PowerPlus Tools
- Shareware
- Implied Option Explicit in XP??
- Generate numbers for labels
- Excel Macros help
- Setting a range using VBA
- Comment Boxes
- Combo Box Help?
- Getting specific cell to be in upper left ?
- ShortcutKey assigning in VBA
- Urgent: VBA Command Button Caption Problem
- Autonumbering Formula for Columns
- Why is it that RTD is only applicable for Excel 2002 and 2003 and not Excel 2000
- Macro adds 1 to Cell in excel
- How do I Add an Addin to Toolbar
- File Names
- nonduplicative merge
- FIND Command
- Hiding columns in VB
- using forms and modules in multiple workbooks
- VBE Issue
- Instr function problem
- record of records count for display...
- Count of workbooks in a directory
- First blank row in a column
- Sum visible rows with text and numbers
- Filter Refresh
- Run-time 1004 error on range select
- Macro shortcut from XLA
- Drop down menu
- Formatting on more than 3 conditions
- How to use Excel formulas in VBA
- Getting rid of warning messages
- subfolder Loop? But, only one....
- locating charts
- UserForm help
- help with database connection - urgent
- LinEst embedded in VBA Function
- Can a workbook be 'Tagged' as follows:?
- Finding last non-empty column in row...
- Macro to paste to other sheet
- VB Script Help
- parsing field
- DDE and VBA
- Limit on Number of Lines of VBA Code?
- Check if (part of) a row is blank.
- counting
- Problems with event handlers
- ADO
- VBA Code- Row Insertion
- vba - check if cell is empty
- Changing betwen workbooks
- Easy way to edit Name Range formulas
- ScreenUpdating not effective
- Command Button Code Stream lining
- Assigning VBA code to a Toolbar
- Adding + 1 on each click.
- Help Retrieving filename without .xls attached
- test if a control has or doesnt have focus?
- Macro to change a number to text
- Re: Macro to change a number to text
- Handling CSV Files
- Assessing File's Properties
- Query Results
- Find and blank cell then Do this.....
- Calling a module function from a class method
- Add-ins configuration and startup
- Count Cells
- Macro Help. Please read...
- Code for Opening a Closed Workbook
- Shared workbook inactivity warning
- DataList or DataGrid link to Recordset or External Data
- Excel VBA to VB
- Picture in the cells
- Rescue Me
- Annoying hidden names
- VBE Issue
- dynamic average for cells
- Unauthorised Use Of Macro
- Maximising Application
- Export to Excel
- Forms Display
- Macro for copying entire raw
- How do I do a HTTPRequest "get"?
- shortcut key not not running macro's all of a sudden
- Using .NET in Excel 2000
- how is use worksheet function mina( ) in macro?
- how to fill gaps in Current Region?
- Forms and Modules
- USERFORM in Excel2000
- Out of Memory Error
- Out of Memory error
- Creating Object Variables - and passing them as arguements
- newbie - how to save macro for use on another machine
- Saving And Checking
- Encryption to change contents of a cell
- Call Object_Exit : Type mismatch
- Countif to use like sumif
- New sheet from the cell contents
- Macro to go a WEB site and enter a password
- PivotTable, Pivotfield selective invisible, too slow
- Update Inventory
- Displaying a Message and a Beep
- Help: foreign key reference in Excel
- How can I avoid excel saving xla combo data?
- Excel automation - formula
- Excel 2000 - Which VBA project is ActiveProject?
- Select all the unlocked cells on a worksheet
- Looking for 2 values in a data table? Please HELP!!!
- Holy Macro!
- Code
- Function
- Create macro for formulas
- Function
- Display selected rows and columns in a pop-up window.
- Speed Issues again
- Copy with criteria
- Validation question
- Environ()- help
- Checkboxes
- Repost:replacing data on a non focused worksheet with calculated data from the same sheet
- Macro for forms function
- How to get rid of string which contain a substring like 'PO BOX'.
- Max Size???
- Change Excel Menu
- Fill Array from a CSV File
- Taking focus off a Control Checkbox
- Using a "Data Analysis" add-in function in a macro
- Total No of Columns in Worksheet
- Cut and paste cells
- Find the smallest number in a column and change it to red
- OfficeXP PIA compatibility
- Can you place a combo box in a custom toolbar?
- Function Problem.... Return Value
- Combo Box
- Select rows contain Xin Column Y
- Excel XP macro problem
- How to validate in code the contents of a cell?
- worksheetFunction isblank
- Re: Macros and Outlook?
- Userform Image help
- Greying out(disabling) textbox from being typed in
- bring up dialog box from command button?
- How to 'click OK button' automatically in excel
- WindowStyle not working in shell command
- Closing a workbook by a button only
- arrays
- Median of an Array
- Command buttons
- Sum cost column based on date column and vlookup cost
- Note Code Help
- Re: Texbox values based on Combobox Value(more detail)
- Editable Excel Spreadsheet Online?
- Using Outlook98 with Excel97
- Trim string vII
- Access Recordset with Built-In Function
- Export Personal Macros
- VBA
- Truncate last five characters
- Chip Pearson
- Disable Macro at open by an external macro
- Good guide for Excel/Query/SQL
- moving to CLIPBOARD
- Printing an error report
- Insert comment command
- Specify date range
- Auto-entering the start and end of a month
- Data ranges for Graphs & pivot tables in macros
- help with excel macros getting daily averages from 10 minute data
- Excel Menu Dissapeared
- "delete" key activates Sub Worksheet_Change
- formula help please
- data problem
- Select All and copy and paste
- Avoiding Run-Time errors when sending emails from Excel
- ".printform"
- recalulating when hiding rows
- Splash Screen
- saving excel workbooks
- Re: Select a range of columns based on active cell
- macros
- Rogue vertical pagebreak
- Convert row data to Column data...
- Re: Use VBE Sheet names in code
- automatic notify
- If statement with multiple conditions
- Replace sheet formulas with value
- Concat + dates
- Sum Calculation
- MaxRows 65536 in a sheet - A Code Snippet
- vba array question
- Copying custom views from one worksheet to another
- I'm new to excel and need help
- Refererence to a value in a cell
- Save As - Multiple Sheets fails to save as text file
- Right Hand Column on Screen
- Sorting by highlighted cells
- Newby question: how to add icons to message boxes?
- Possible to assign an array to a SeriesCollection
- Excel menu programmed in .Net through PIA
- Offset Problem
- Opposite of Auto_Open
- Format + Data
- Zoom Not Resizing
- Adding/removing rows in Excel
- Window Errors
- Remove Cut & Paste Options
- Save "Range-Value" to variable?
- Open Access
- Add Formatting Code in Macro
- bad file name
- Open Workbook from VBA
- Use macro code from external xls file
- Books
- Date...
- Stating ranges in formulae
- macro buttons
- Vlook accuracy
- Automatic Macro Start
- Range Class falure
- EXCEL LINKS
- how to run macro of closed excel workbook using VBA
- Hiding/Protecting vb code in excel
- Excel-SQL Connect
- how to add 2 ranges
- Macro to "Stop Playing" wave files
- VB how to connect two sub's
- legend display in a graph in excel
- caption sensitivity
- print with data
- Thanks Trevor Shuttleworth
- Display a Message box while opening a XLS file
- How to display a msg box while opening a sheet
- Excel custom plots and custom trend lines
- Can't update the data from internet while running macro
- Sheet Protection Oddity
- Maximum file size
- Excel Scheduling Calendar
- impossible to change the activecell???
- importing a module
- Pivot Table - Multiple Pivot Field Selection
- Using IF Formula
- Microsoft Excel 97 Reinstall Question
- Time Lag
- VB Code that will copy color coded cells to an invoice when activated
- Add control to the Chart menu of "Chart Menu Bar" commandbar
- Question about ).End(xlToRight)
- Texbox values based on Combobox Value(more detail)
- Combo box controlling visibility
- 3 textbox values based on value in ComboBox1
- Combo box match required
- userform image from picture in worksheet
- French Password Encoding - cant open workbook!
- "Sheet" versus "Worksheet"
- Error in using "Frequency" function in VBA code
- Labels in a user form
- Using Macro to convert > 240 to PRN
- auto close while MsgBox is open
- Save file to Web Server from Workbook on Web Page
- Having data populate text boxes based on Combobox Value
- A Thank You note to Pio Sjoblom
- CurrentRegion Failure. Please help!
- Search and replace 9000 times?
- SQL queries with Excel in VBA to populate a spreadsheet
- Sending Emails according to sheet name
- Is range a valid address?
- Are you sure popup box
- Combobox populating based on Option Button
- Formulas with Counters
- Insert comment command
- Determining Office Version
- Devious multiplying Forms DropDowns
- backing up file in directory
- Transfer Range to Array
- excel 97: if then and for next loops help
- send file by e-mail
- Changing font of part of text in a cell
- Move a drop down via VBA?
- Excel - huge file sizes
- Scrollbar settings in a UserForm
- repeat post
- GetOpenFilename w/default starting directory
- Re: Excel 2000 math question, repost
- Debug Step vs Run Mode
- Closing Wookbook with items in clipboard
- Auto Numbering
- Deleting Worksheet - No Confirmations ?
- If Target="" error
- Looping a solver
- Printing Question?
- code in VBAProject will not run
- Excel programming problem
- Password to access a worksheet
- Delete zeros in light yellow cells
- How to Close Telnet Session using VBA
- additon of values automatically
- Launch a Sub Worksheet_Change Event from inside a macro
- C# - Excel Hangs When Opening Workbook
- C# - Excel Hangs When Opening Workbook
- split a cash amount into two separate cash amounts
- Formula with quotes and ampersand
- Columnwidth of a merged cell
- Simple use of Len?
- Controlling Word template from Excel
- Automatically including the Form and Code in all the user file
- Reference last entered value in a column
- Defining Range Question?
- Excel - Web Save Problem
- Select Text in Text Box
- Sending array data to Word with DDEPoke
- Saving files with names from ranges
- xlfTextref
- Shortcut for the "Custom AutoFilter" window.
- find sheet from list.
- overview of postfix vb variable notation
- toolbar macro for esp. worksheet
- Re: Move selection after Enter
- Circular reference and Naming sheet
- Creating something like a file manager in Explorer with Excel Dara
- Application Problem
- Why Excel 2002 crashes on simplest Workbook_Open events?
- Worksheet_SelectionChange stops working
- impossible syntax??
- Is this done within Excel
- proteger celula
- Counting a colour that is Conditionally Formatted
- Canīt Convert Formulas to Values with Deactivate event
- Can't insert form objects
- Go to the Last Row for Counting Purposes
- 2 Copy Sheet ?'s
- Confused on MS Products to Create COM addin
- Using Basic Excel Functions
- Launching a DOS box from VBA
- Re: Excel Com Automation
- Excel to PDF
- How to Delete a VBAProject
- Re: Sheet names in VBE
- how to step thru only one subfolder of a folder to find like files
- Protect Macro Coding
- Color Rows Automatically
- Updating Infos
- link to Perl/Java
- Disounts Help Please
- Search, find, copy from sheet1 and paste into sheet2
- onditional formatting
- printing window pops up when Visible field is false
- Precedents Property
- Read List1 and write List2
- Basic Offset Function Usage
- VB code
- testing cell value
- email OLE objects
- How to make toolbar buttons larger?
- Excel's database features
- >_< investigating the programing for 'combined cells' >_<
- Help with Time formula
- Creating an Excel Database!
- truncate data on cell ?
- range("myrng"), names("myrng").RefersToRange??
- Call up a Windows Message from Excel
- Protecting VBA Code
- Whats wrong with this VBA statement -ActiveCell.FormulaR1C1...?
- Switching Selections
- VB code for disabling
- Editing Comments
- using Cells.Find between 2 sheets
- How to stop Excel help auto tile
- Using variable to call worksheets
- MACRO OR VBA CODE TO PREVENT USERS FROM PRINTING THE CONTENTS OF A WORKSHEET?
- Trace Precedents
- Manipulate all DropDowns on a Worksheet
- Re: Identify Forms DropDown as it is triggered
- Connection issues
- Re: xlfArgument?
- Help with data sorting - macro?
- Code for a progress dialog??
- intercepting password routines
- Referencing Procedure in Personal.xls
- Dynamic Selection of Pivottable Drop Down Items
- Excel VBA Question
- Splitting Rows
- importing mulitple files
- COMBINAISON
- Getting Column width using macro..
- Re: Excel binary file format
- After OpenText all pastes from external apps use format from OpenText
- Alternate row coloring
- check range for certain value
- code librarian
- Enter key text symbol
- VBA: using ignoreblank property
- Excel 2000 and Memory
- Mixed variable problem
- size of module
- Send array data from Excel macor to Word Doc using DDEPoke
- Name of Event for Sheet
- Solver won't work in macro, Excel 2002 SP1
- How to access ACCESS from Excel!
- Listbox--moving items up or down
- Re: Get a part of a filename
- Re: help with macros for getting daily averages from 10 minute increment data - MS2000
- Is it Possible??
- cell, vlookup, same values
- Re: help with macros for getting daily averages from 10 minute increment data - MS2000
- Thanks
- Locked Sheet
- How many rows fit a page
- piggyback cell from formula function
- Macro Help Please
- Counting checkboxes with a true value
- open workbook by VBA
- Double Subtotal Problem {Excel 2000}
- Sum formula
- Calendar Control
- save on exit message box
- save on exit message box
- Dynamic charts with VBA & graphics?
- Selecting File and FilePath
- calling an external vbs file on the worksheet close operation
- reference vlookup cell
- Pivots using other pivots and dynamic query problem
- Re: Insert rows on multiple sheets
- highlighting row
- Input Box Drop-Down List
- Can't run workbook with a macro from an 'at' command
- is it possible for an html/asp page to access Excel directly
- Screen Area
- Unable to get the NormDist of the Worksheet Function
- Automatic Macros
- Funny macros
- Switching between worksheets
- Replace
- linking text box with seperate combo box list
- How to read data from xls files?
- Generate .txt file from 2 cols of data
- Looping question
- finding macro containing excel files
- combination box to cell
- File Attributes / Save As New File Name
- Pivot Table Copy Paste
- Code mod to add name
- settings and resettings
- Automating a date field to change on certain action
- Pivot Table Strange behaviour
- Hiding macro
- Re: Combo Grief
- Select from table and listbox
- Excel programming
- Looping Question?
- formatting text in TextBox in UserForm
- treeview drag drop
- Hyper-Threading Technology for XP with Excel 2000
- annoying bell when trapping errors
- Date format when using combo box
- Sort by Manager
- Compile Error: Next Without for
- Setting Pivot Table Page Field Names using VBA
- Setting Pivot Table Page Field Names using VBA
- Linking drop down lists
- cells protection
- sending one sheet by e-mail
- Modules and Forms II
- creating Shapes
- Deleting Cell Name from Macro
- Macro assistance required please
- MZTools install help
- open workbook problem
- Running a Excel Macro from Windows Scheduler
- extracting unique values with a formula or with vba
- closing an excel worksheet inside vb .net
- Reading from file
- MsgBox Useage
- find & replace help
- Putting a Border On a Partial Row
- Cross Referance
- Excel Query and Cell Formats
- MSVBVM60.dll HELP!!
- Here's a good challenge for someone to work on
- Combo Box question regarding range
- Calculating a textbox on a userform
- Do you know how to create a new sheet in a file by macro?
- How can I send data from excel thru smtp
- Inserting # of rows depending on value in Column
- Inserting Object in Excel Footer
- distribution curve
- Non-contiguous Range limit?
- Re: REPOST: Software recommendation (Recording software)
- Range Names
- DATA LINKING MACRO !
- Bad DLL Calling Convention (Error 49)
- Specific question
- Can I prevent users selecting multiple cells?
- Security Level wont change...
- Serious design problem
- Data management for csv file
- transpose: long column -> many rows
- I would like help on my function
- After Workbook closes all my combo boxes do not retain dropdown list.
- protecting a csv file
- Open Method of workbooks class failed
- Re: Autoexecute Macros
- Retrieving URL
- Re: Range Names
- SQL against AS400
- Pasting to new worksheet with formats
- something like autofilter?
- replace a number with a string from database
- Rotated Text and Line Spacing
- Non-Functioning Scrollbar in Excel User Form
- Cannot install MSOffice XP SP1
- working with positive and neg numbers
- Delete/Collapse Rows Not Selected
- Non Working Cells after command button
- Formula Referencing Problem
- Adobe PDF Writer error
- Highlight the bad stuff help!!
- cell value
- msoBarNoCustomize
- Problem with VBA Help
- "Proper" string function
- Color Coded Cells
- Get rid of deleted macros in Excel
- adding sheets together
- Combo Grief
- Populating combo boxes
- how get rid of upper left green triangles?
- Tracing method calls
- VBA Autofilter Criteria
- Class Question
- Can I set a spreadsheet so that when it is opened, a particular toolbar is loaded.
- Need to modify one small peice of code...
- The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc
- Re: how get cell value from different worksheet?
- How can I find Duplicate Cells or Rows
- how get cell value from different worksheet?
- Network error
- deleting workbook names in excel
- If formula question
- Duplicate entries
- Modify cell from function
- Re: Help with "if" statement formula
- Any automation calls gets hung when the Excel workbook has an active cell.
- URGENT - Need date format for SaveAs code
- Re: Help with "if" statement formula
- Patch Panel Matrix
- Copy button images
- Excel 97
- Date format when opening a .CSV file programmatically
- automatic macro execution
- HELP relative ref command is gone
- Restricting Menus
- Hyperlink --- misswritten....
- Irregular areas of numbers
- Branching Macro
- Excel - SQLREQUEST - #N/A
- Find a String
- value interpretation
- lookup and vlookup
- VBA - VLOOKUP Sub
- VBA code to automatically close file
- What have I got wrong? (Macro),,,
- how to break passwords
- Using subfunction in a function
- copying rows one at a time to another sheet ones a criteria has been forfilled
- Is there a way to turn events on or off?
- Hiding macro execution
- Modules and Forms
- loop problem
- Different colors for combo items
- VBA Report How?
- excel 97 HELP
- Creating a SHORTCUT to a file in XLSTART
- Selecting a random number from a set criteria by clicking a button
- code to find dates
- MACRO TO LINK DATA !
- inserting sub rutines
- Combobox Visibility Problems
- Date Formats
- Listing the contents of a directory in a spreadsheet
- Help me please...
- Re: Using VBA to rename Pivot Table Query
- are these groups monitored by MS
- Edit/Find
- Hidding rows with 0 as the value
- make button - assign to cell
- EXCEL automation ACCESS VIOLATION vb
- Possible to automate Powerpoint from within Excel of Visual Basic?
- Using worksheetfunction from macro?
- Using Sub-procedures w/in a function
- Finding max value
- Copying Formula's
- CopyFromRecordset - Is there a way to filter data that's copied?
- copying selected cells to another sheet
- Workbook Protection
- Print Preview Causes Crash
- Tom Ogilvy - Request for follow-up on previous help offered
- Can I make some thing happen if I get a "reminder"
- Count Records & Display MsgBox
- Drop Down box displays only first list item
- Reading an Excel file after upload
- Multiple joins in an Excel Query
- V-Look Probrem
- MsgBox Popup in Excel
- Hyperlink written to worksheet produces error
- PivotTable columns not going Invisible
- populating multicolumn listbox with an array instead of...
- 0 "0" ""
- Automate the Userform option
- macro usage in Excel through a VPN
- Design Q: XL XP, 97 and multiple users submitting data over intranet
- Transposing one column into three
- Re: Open text files as Worksheets in a workbook
- Newbie : Find / Find Next
- Advanced filter
- Dynamic Filename From Macro
- How can I get into VBA for a custom toolbar - Excel 97
- assign paste to "cntrl b"
- Auto Expand Combo Box
- Dynamic Macro Input
- Limiting Data Imported from Access to Excel
- import email from Outlook
- PivotTable question
- Determining new category number
- Excel ignores VBA commands
- YIELD Calulations
- Cycling through worksheets
- Re: Problem with SheetCalculate Event
- Data Refresh Errors
- Locking Visual Basic Cell References
- Processing a UserForm from an AddIn
- merging excel program with tdc finance program
- Worksheet_Change
- No match on Advanced Filter -- how to detect?
- RE: Resetting Screen to Full
- Minimizing application from VBA
- RE: Resetting Screen to Full
- User Form Initialization
- changing directories
- Page Tabs
- IsInArray function speed
- Chart & ms Query issue
- Help Stop Resizing Excel!
- Re: Resetting Screen to Full
- Re: Hidden Columns
- Re: Resetting Screen to Full
- Re: Hidden Columns
- Launch an external telnet application
- Re: Remind me to set Error Trapping to Break on Unhandled Errors
- Help with Select Case or Best Method
- A question about Nothing
- Calendar Control 10.0
- Why, when I create workbook-level name does it jump it to Sheet-level ?
- Protect workbook for Excel 2002 and Excel 97
- Why is my clipboard empty?
- Code to search the Internet?
- Excel function wizard categories
- Exposing Class Module from VBA Excel 97 SR-2
- How to update Access Table with Excell Data
- automation error -2147467259
- replacing data on a non focused worksheet with calculated data from the same sheet
- Using the Microsoft Spreadsheet Control as ActiveX
- 430 Class does not support automation
- Units for Application.Height?
- SaveCopyAs - Userform disappears
- Check For Open Workbook by another User
- Control ComboBoxes & Worksheet Protection
- simple count or sum function??
- PivotTable and connection string
- formatting results from mysql query
- libXLL now available for .NET
- help to get output from message to the current cell
- Answers please to my query
- Total by Selection by Column, Help Please.
- Excel solver addin.
- VBA: rename a variable
- Linking Text boxes on worksheets???
- How copy format, font, color and border without copy/paste?
- external data with a password (take 2)
- 16384 bug
- Form lists influencing other lists
- commandbuttons properties
- Formula for Subtotaling
- Prioritised listbox
- Macro run order
- HTML TAGS that format Data for import into Excel
- how do i ignore cells with font color?
- Check to see if cell value exists
- How do I open an Excel file in the Web components spreadsheet control?
- Macros
- VBA Date Function formatting
- content coloring
- Autorun macro on opening spreadsheet
- Textbox on excel sheet do not update with VBA
- Horizontal aligning of more than 1 excel sheets
- countif (problem: text, number)
- Getting started with a User Form
- Validate Alphanumeric
- VBA code Help needed
- Export extension
- VBA Syntax Question?
- Sorting a date range of data
- USer Defined Function
- Crash in excel.exe
- Colour cells with dupilate numbers
- group cells.......
- Excel Versions
- formatting headers
- How to cycle through pivot table column labels?
- Help in classific a group of numbers
- automated import of csv files into excel
- two identical scripts, one with problem, the other with NO?!
- How to package macro/VBA for commercial use?
- How to package macro/VBA for commercial use?
- Request password during Protect macro
- Using VBA to rename Pivot Table Query
- Adding events to newly add Menu
- Make a cell into a Macro button
- Need help with advanced filter
- How to display a message box
- simple question workbook size
- Keep display steady while macro runs
- Macro doesn't start up
- Macro doesn't start up
- Alternative Text for shapes
- Excel Macro Program assistance required
- Setting up Reference Library using VBA
- How do I make a button to PasteSpecial Values only.
- Messagebox: Alert user Worksheet is Unprotected
- Opening Excel Workbook from Word using VBA - Always Read Only
- Re: PasteSpecial problem
- PivotTable and connection string
- RE: tracking user activity on worksheet
- Enter a constant into Ten Workbooks
- Tab backwards
- Custom dialog box on protected sheet
- Edit table to have more of a DB structure
- Code to check for active worksheet
- formatting headers
- change a cell formula
- Password set/clear macros - help!
- Passing ARGUMENTS between event procedures of a USERFORM
- Highlighting locked or unlocked rows, Searching cells
- Chart.Export throws COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC.
- How to merge excel using vba
- Modal User Form
- extracting info the best way
- Excel COM Addin
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.