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 |
- size of file
- Can I "sign" my own macros? or some other fix for the message about security and macros?
- text to values
- RE: Programming Excel in Windows 98 Second Edition
- 50 workbooks
- Passing data between spreadsheets
- Identify Forms DropDown as it is triggered
- Macro selecting the last used cell does not work
- Link a macro to a cell value
- getting the Weekday from serial
- Use of the "OR" function
- Find active Windows()
- formatting a worksheet
- Random function
- Minutes vs Hours
- determinate if pop up menu exists
- Differences between Excel 97 and XP
- User form trouble
- problem with selection when calling macro externally from VB6
- Button, Button, which Button?
- Testing Closed Files
- Transferring data from on excel spreadsheet to another
- automation macro
- Setting Spreadsheet control data source to Excel file
- SaveAs syntax when using a variable
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- Remove a reference
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- Duplicate Rows
- how do i ignore cells with font color?
- Re: PasteSpecial problem
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- Excel - add to "Worksheet Menu Bar"
- Combo Box addItem question
- Excel Writing speed
- Copy and Paste to New Workbook
- access X ecel
- Open files in directory
- data validation vs. locked cells
- Create an Input Box in Assistant
- NT Domain Logon
- Timed Automatic Refresh of Cells
- Change Printer
- Formating Macro
- Run-time error on command button
- Copy Worksheet Help?
- Logical Functions
- Logical Functions
- Grouping & collasping in a protected worksheet
- Adding reference in code
- My Autofilter is overzealous!
- converting a number to a date
- "Each Row from there to here"?
- Run Time Error 1004
- FillRight
- Assign code to shape
- Copy rows to different worksheet destinations
- Count Function in Date Field
- How to hide row range from code?
- Responding to cell events in Excel
- Worksheet name in order
- On Enter and On Exit events of MSFORMS controls?
- Need help with algorithm
- Run-Time code refuses to work in Windows XP
- secure a sheet
- OCX Error in Excel
- Com Port and VBA from Excel
- extracting a stringvalue from filename
- Get external data not working properly
- command buttons
- Can I create in VBA a class with instancing type different from 1 and 2?
- Global value does not retain value when UserForm is hide
- Deleting rows with specific value from row 1 to 200
- EnableEvents and DisplayAlerts problems
- VBA Object (External) for EXCEL
- Help needed coding a macro to adjust the source of information each time it is run
- VBA Copy Worksheets
- Excel Custom Function with Select Case
- Delete cells - auto move
- Books Excel
- Tom Ogilvys Code
- Leading characters
- Sheet Name
- Sending Emails according to sheet name
- Repeated application of AutoFilter
- Code Modification(From previous post)
- copying and pasting loop
- Protecting Sheet
- Inserting and arranging sheets
- Time a sub routine in thousanths of a second
- How to find the first blank cell in a range
- How to find a value then select that column
- Change Font Type
- MIME multiple Excel spreadsheets
- Detecting if a userform is loaded
- query info based on dates
- Using variables for row index
- Sending print commands to the printer
- Cell limitations?
- Hiding a hyperlink!
- Merging 2 Excel Documents
- how to delete empty row in vba
- Change to existing macro
- Linking cells to a field on a website
- Custom Footer using ThisWorkbook.Path?
- Range of Cells to populate in a text box on a userform
- Disable Excel Prompt
- Replace ActiveCell w/Query Results?
- Email Array
- Best practices pivot using SQL-sourced table?
- User Form
- "This macro calls that macro, which calls .."-how many?
- Worksheet Protection
- Hidden worksheets
- Hiding macros
- Re: Delete records using excel Macro
- Get external data with password
- Make a file read only
- Making a macro references relative
- Re: Delete records using excel Macro
- Indirect addressing
- Once criteria has been met, delet the same row.
- EXIF information
- cells in a diagonal range
- $6 to $6000
- Dynamically changing a calculated field in Pivot Table
- Enable/Disable Worksheet Change Event code
- Requesting return reciept in Outlook 2002 from Excel
- Copy & PasteSpecial
- Help with unprotecting worksheet in Excel 97
- delete record using Macro in excel spreed sheet
- Cancel Exit on duplicate
- Animated gif
- Array Formula (I think)
- Re: Help with calculating elapsed times and formulas
- Writing a formula in a variable
- Re: Looking for VB code to test for "RING" , "BUSY" disconnects or other signals
- HyperLink
- Can Excel support Multiple Users
- Excel 2003 not compatible with Office 2k Web Components -- HELP!
- echo off?
- Access AutoFilter list for use with input box?
- Excel "integrated" in VB6
- Pull Down Menu's
- CommandBarButton click event
- Cell Formatting - Continued
- Count Down in Cell
- How to sort pivot table?
- Shortcut menu on worksheet tab
- Analyzing code speed
- CHIP PEARSON - THANX
- Non Contiguous range and loops
- Help on the Assistant Balloon
- Balloon Assistant
- Change "relative" to "absolute" (database)
- populating a combobox on a worksheet
- Backup file in folder
- delayed worksheet.activate
- Cell Formatting
- Min Max function
- show a value of X in worksheet
- HOW ? Running a different Macro if value reached
- Deleting worksheets in a procedure
- Accessing document properties of non-Microsoft product files
- Preventing use of buttons on the taskbar
- Returning a date as a serial umber
- Input from Text file
- How to export a picture or chart from Excel to PowerPoint?
- Excel Security
- Problem while fetching Excel records?
- Excel Visualbasic
- Need lookup formula
- Trim Special Characters (Japanese Environment)
- How to get data from pivot table with multiple column fields?
- How to sum value from master worksheet taking value from other close worksheet
- More Visual Basic Syntax
- Help: Visual Basic Syntax
- Updating data automatically using macro
- How to show only 1 series in pivot chart?
- How to hide filter buttons in pivot tables?
- File Read-Only Status
- Creating new sheets (more detailed)
- Another simple little problem
- Sort command
- paste as values syntax
- XLODBC
- Macro to Play Wave File
- Excel macro to get stock quotes off the www
- Dynamically Creating Sheets
- How to locate a cell in the absolute A1 position
- Unhiding Rows: bug in Excel?
- Set Expiry Date in exel file
- Percent progress
- Global file reference change
- Problems with permutation
- automated macro's? and macro limitation to a worksheet
- Change Numbers to Dates
- Positioning the cursor programatically
- Writing 2 macros to sort names and numbers in excel 97
- Trying to limit .Find to a specific range
- Combobox in a Message box
- Copying Variables in VB Editor In Excel
- Copy and Paste part II
- Cut and Paste macro based on criteria then delete empty rows
- Pop up messages
- Sending files by e-mail
- A real challenge...can anyone solve this !??!?
- listbox
- index
- Customised Interface
- Help on subscript out of range error (VB6/VBA)
- checking if worksheet is blank
- Copy & Paste values macro...almost there?
- Excel hangs on close when using Web services in add-in
- Fill Color each Row based on a Condition
- Can anyone recommend a good book?
- How to get Formula Tips to appear?
- Query & Write
- How to get Formula Tips to appear?
- Sheet event doesn't work in '97
- returning cell value based upon 3 criteria
- My code replace the data by the line number
- where is References dialog box?
- Selecting multiple rows from listbox for reporting
- Import File with browse and select (even from Pocket PC?)
- Calling a sub from a addin in vba
- Way to automate adding pictures in a series in Excel?
- For Each Loop
- Making a media library for movies, cd, book, so on
- Background color for 50,000 odd-numbered rows
- Excel97 versus Excel95
- macro to copy and paste between 2 workbooks
- dissallow characters
- Recalculation of a spreadsheet
- CodePane
- Conver text to number in VBA
- Transparently updating another workbook from the current workbook
- Screen Flicker
- Locking/Unlocking a VBA Project in 2000 vs '97 - Difference?
- Export each worksheet to csv
- Rookie question: placing a value into one cell based on a forrmula in another
- create gif of selected area that is not a chart
- Detecting VBA code
- Worksheet Change event and Links?
- find columns
- Selection of the range filled in
- function "count if color"
- generic data entry form
- can variables pass values
- Detection of VBA code
- QUESTION ON "OFFSET" !
- Sample workbook
- Simplified Help
- Substitute Range Question?
- protect / unprotect worksheets using VBA
- userforms and worksheet help
- use find twice to find cell on a specific row
- Altering UI Programatically
- find row
- Sheet Event
- display statusbar, scrollbars and formulabar
- Read/Write data to/from text files from a spreadsheet.
- Selecting a file path in Excel VBA using FileOpen dialog
- How Can i sum hectars ?
- Testing for open workbook
- Please Correct the mistake
- Pivot Chart - how to hide buttons?
- How to add images to custom toolbar buttons?
- Problem with custom toolbar
- Changing a range number to a variable
- VBA Row(line) No Syntax?
- Removing an Item From a Collection
- Excel no longer allows new formulas with division "/" operator
- Re: Hiding a Combo Box.
- Re: toolbars
- Function to create a collection
- Changing Data order in Cells
- Returning the Number of Rows in a Recordset
- OLE2 problem with the "formula bar"
- UserForms setting radio buttons
- Outlook
- AutoSum button
- More to Error in code
- Error in Code
- How Many Arguments?
- controlling date entry in a text box
- Need a method to extract the Date from a cell to a new cel
- Finding if a cell is within a Range
- Hiding a Combo Box.
- Find and Replace - Auto Cell Formats
- random numbers
- Excel spreadsheet sort
- VBA - Protecting from Save
- Macro to use find command
- VB and Excel in win98
- Looping
- Remove empty rows
- Automatic next number in a series
- File folder dialog
- Combobox
- Add event code through a macro
- Finding Function
- Dynamic range in graphing macro
- Handling Excel Events in a Designer form in an ActiveX DLL
- Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range
- Controlling the position of attachments and Body Text in Outlook
- Hyperlinks from UserForm Controls
- duplicate #'s
- Exporting Charts as GIFs
- Problems deleting custom menu => double entries
- Using Macro to update formula
- Cut & Paste
- An Add-in question
- Need a function that finds a value in a table range and returns the cell number
- Protection
- Export values in a text file
- Display a Recordset in Excel
- Excel-Microsoft Visual Basic File Not Found
- Import Text File Location
- target address
- Delete rows w/o criteria
- Strip Modules from Workbook - Code Organization
- Finding Excel Macros
- Paste Values
- Delete Cells in Workbook
- Cell formats keep changing
- Macro
- Repeat the contents of a cell
- Cell Address
- Find a value a post data to another worksheet
- Word doc opens, but not in visible window?
- macros across multiple worksheets ...
- Program a combobox/dropdownlist to create
- Moving CommandBar using VBA or C#
- How to Avoid Printing Blank Rows
- Range.cells.calculate give error 1004 only in XP
- Assigning add-in function to custom button
- Checking if worksheet is blank
- Create a Acrobat PDF file from VBA
- Excel Crash
- Font and Fill ColorIndex
- 2 Questions ?
- copy sheet1 from all open workbooks to one workbook
- Merge Cells
- CALENDAR
- How to make it a Concurrent (Multi-user) spreadsheet
- Excel data recovery
- Merging two och more recordsets
- Code for locking windows
- Saving one specific worksheet in a workbook
- Spreadsheet opened by user or programme
- Taking a subset of a string
- secura a macro
- Using Drop Down List Then Creating Saved File (with formulas intact)
- Error 1004: Method 'Cells' of object '_Global' failed
- a Formula for a culomn in all recors
- For/Each iteration for collection class
- How to change type of the cell?
- urgent: no connection to excel
- getting the column name
- using vba copy data from .csv file into an excel spreadsheet
- events
- workbook open()
- Anybody translate VB for PC to VB for Mac?
- "like" string
- vba macro for getting external data
- Gathering info from a set of excel files
- Count occurances of text in a cell
- Problem with drawing graphs
- Returning an array from a UDF to a column range
- Filter
- ComboBox
- Subotal feature without labels?
- Jet Ole DB With Excel
- hex conversion
- Calculating Elapsed time in a macro
- LastRow issue
- Send mail with attachment
- Re: recherche et affichage d'une image
- Filling alternating rows in a worksheet with color backgroud
- HyperLink problem
- Use code to cancel printing
- Multi-variable Equation Solving
- Lost File
- Macro's scip Files!!!
- Dynamiclly generating PDFs from Excel
- Program a combobox/dropdownlist to create textboxes dynamically
- Queries and Macros
- Calculate years between two dates more precisely
- Option Buttons on User Forms
- Invoking Mail Merge from Excel
- Increment sheet names
- Excel Code Module
- Turning off macro disabled pop-up
- Disable Change Event in Form
- XLA and strong typing
- Data validation in a MSG box
- Formatting Cells
- Update Links
- Excel 2003 and Peachtree
- Unique Tag for Printed Excel Spreadsheet
- Macro to convert date cells
- Macro to convert date cells
- Macro to convert date cells
- Macro to convert date cells
- Macro to convert date cells
- Some simple code
- Excel, VB DLL and Macros
- selecting cells
- How to create a message box to keep track of progress
- XlPivotFormatType ???
- Keep large numbers from truncating?????
- Mining an array
- Program a drop down list to show a specific response depending on the selction
- Function that emulates FIND(find_text,within_text,start_num)
- Assigning Macro To Shape
- Unpaid overtime?
- variable that refernces the values in a text box
- Personal.xls
- oops!!!
- Generate XLS on server without Microsoft Excel
- How do I protect my hidden Excel.Application object from unwanted user interaction.
- flashing screen driving me bonkers!
- creating a hyperlink in a shared workbook
- how many combinations in a list equal a certain total
- Deleting sheets
- MACRO TO UPDATE DATES !
- .net, excel, extended properties and dbnull
- insert validation in sheet
- How can I hide the code??
- Deleting Many Cells on a Sheet
- Circular References, what a nightmare.
- Hide rows if formula result is zero
- Delete #N/A rows Formula
- Re: Selecting cells with a particular formula
- Re: Selecting cells with a particular formula
- Re: Selecting cells with a particular formula
- default printer
- Easiest way to automate spreadsheet merge?
- In Excel VBA, open .txt with Word?
- program activation
- Name field value
- date extraction howto?
- print form orientation
- Date Validation
- Selecting cells with a particular formula
- Zoom problem
- dates in dropdown
- edit default excel template
- [excel 97 vba ] Reading ranges into an array
- Report Question?
- setting up a workdirectory
- Error 50290: Error writing to Worksheet while using an ActiveX Control
- Empty toolbars
- Calling macros width arguments in winxp
- ByRef not passing address
- start a macro when file opens??
- Using Find & Replace in macro
- Protected worksheet and macro
- Find "." (Full Stop) in cell then all text after colour blue
- extracting string from value in cell
- Paste Cells in Column A to Columns B-K
- Dir() limited to 48 files?
- xlDialogSendMail Error
- Replacing a value within a string using a formula
- extract a foldername with a formula-update formula does not work
- Code security
- extract a foldername with a formula
- SaveAs,csv
- autorun userform from worksheet
- Excel cannot update web page
- Programming Xml Source Pane of Excel 2003
- Saving a graph as .jpg
- Add-in auto updating
- copying rows
- no connection to excel
- file extension problem
- Macro run slow when turn on ScreenSaver
- question on button event
- Text Box for Numeric Data
- Delete rows after used cell?
- Convert Excel to PDF via VB code
- Changing color of cells
- Countdown to Retirement
- Closing a Window
- Point of departure...
- XLA & COM files
- Import Text file into multiple columns
- Copy insert rows
- Menu commands - overruling with macro - How to do it?
- Detecting non-supported files using Excel.Open
- Proper method for Excel/Query/Macro reporting
- Re: Looping
- determinate if a range is empty
- Excel error message in protected sheets
- Referencing other workbooks
- removing unwanted characters in a cell
- Re: Looping
- how can I lock a file after some days of using it??
- Sum of cells spanning several worksheets
- Workbook references
- merging templates into workbook
- xlDialogTextToColumns arguments
- excel control button
- Sorting 100 rows of 6 records horizontally
- Re: recherche et affichage d'une image
- application.worksheetfunction.mmult help
- Replace return of line by a space in VBA
- Run time error '1004'
- next avaliable range
- Visible Rows Indexing
- Closing Excel
- File List Creation
- Control IE popup from excel VBA instantiation
- Accessing External Data
- Macros
- work schedule formla's
- Setting Excel toolbar or menu icon in C# WITHOUT using builtin icons
- protection sheet and code ???
- Unable to suppress warning message...
- recherche et affichage d'une image
- Add-Ins and Pocket Excel CE
- How to Retrieve Last Used Cell In Column
- Range.Select with variable cells ?
- Exporting to Excel, Then Formatting Columns/Cells
- Excel to Access
- embedded objects
- Changing Event Subs of Controls On Air
- Open Menu item "Print" from VBA
- Re: Access to Excel
- Re: Display a message whilst a macro runs
- Adding toolbar/menu command to Excel using C#
- Preventing opening workbook inside active workbook.
- counting occurance of a name in a cell
- Pie chart programming
- Help with a macro. Let's eliminate a loop...
- Creating Boolean Functions
- Protect macro code from viewing/editing
- makro that sums every new number entered in cell
- WEB BASED EXCEL REPORTING
- TCD Format du Tableau xl???
- Auto Open won't die or go away
- Uploading Problem
- User form question
- unprotecting a combobox in your spreadsheet
- check font colour
- VBA code to open a specific worksheet
- Case sensitive data
- worksheetfunction.vlookup?
- xlDialogSendMail problem
- Delete #N/A rows
- Button
- Improving code.....For Next
- Moving Vertical Page Breaks in Excel via VB
- Minimize the VB form
- Copying a named range of cells
- 'Floating' UserForm
- Add control at run time.
- Open workbook without activating it
- Minimize the VB form
- Searching unknown number of cells for a value
- Toggle Button
- access function description from c
- access function description from c++
- access the function description
- Print Excel Workbook When Open
- Automated Printing
- spreadsheet calc
- deleting variable number of rows
- Renaming files
- Disconnect a spreadsheet from its datasource
- Compile Error in Code
- Excel Test Formula
- Stock quotes:Excel
- How to update pivot table items?
- Need FASTEST way to get data from a large closed Excel File
- Reading specific digits from a numeric variable
- Using "Find"
- Delete columns
- Determining range
- Application Process-Shell Command
- Re: Display a message whilst a macro runs
- file name
- worksheetfunction
- Print multiple worksheets
- events
- How to change image by function?
- ASSISTANT FILENAME
- Macro to play wave file
- autofilter using macro
- Yes_No
- Excel and preparing email
- macro & combobox
- copying and pasting not adjecent cells
- Code slows on subsequent run
- assigning a formule to each cel in a column
- Path Not Found Error
- In a Cell, How Can I Make The Cursor Go to The End?!
- vba multi threading
- Get Last Row
- CONVERTING A LOTUS MACRO
- VBA code to insert images in excel sheet
- multilple sheets using days of curr month!
- Conditional IF statement
- Auto Refresh/Format a PivoTable
- Ontime questions
- Macro execution refers not to the active sheet/excel file
- VBA Code to convert Excel to PDF
- How Can I Use SendKeys in MAC EXCEL?
- Templates and CreateObject
- Assigning formula using a macro
- code lost after saving
- Updating form labels from code in a module
- Application Size and Location
- Excel Marcos and Programs
- proprietary protection
- Transferring data entered into a Text box to another Cell/Sheet?
- hlookup in VBA
- list worksheet names within a notebook
- Need Looping Help
- followhyperlink failure
- How would I modify the following?
- Worksheet value to user forms
- Setting attributes for controls
- Automating Excel (XL2002)
- Form Resize
- Worksheets.Add method
- ONACTION macro tries to open another workbook
- How do I use a Combo Box to change values in a Cell.
- Disabling Toolbar Buttons with no open Workbook
- PRINTAREA
- detect worksheet
- copy a mocro to another pc. HELP!!!!!!!!!!!!!!!!!!!!
- Open WinZip from Excel
- Selecting single column with merged cell at top
- Looping Find
- Delete Rows below a certain cell
- Set variable = nothing?
- Creating a Dynamic Function
- TextToColumns Dialog
- Saving VBA Toolbar Customisation
- Help with Macro
- MESSAGE ALERT
- Random Number Formulas
- Printing Mutiple workbooks....
- Printing to Generic / Text printer
- Visual Basic to reference value in Excel cell
- MACROS
- Help Excel for Second Edition Windowns 98
- UserForm remembering Settings
- Listbox9 does not support saving.....
- Executing a Script on an Oracle DB
- Counting files using Loop
- Counting files using Loop
- Counting files using Loop
- menu in excel
- Start recording macro
- Anomaly, can't format cell
- Changing cell formulas with a macro or VBA
- Load Macro at start up?
- Re: @ Round Formulas
- What is InBufferCount?
- Re: Delete Rows above a certain point
- Conditional find
- Re: @ Round Formulas
- Linking Excel to the Internet..
- List Box Visible Rows Only
- Maintain Target Porperties in MS Excel
- Insert rows
- Sort to Various Sheets in Workbook
- Send file automatically
- Tuning Off Toolbars
- sumif
- Loop through sheets, deselect charts
- adding a listbox to a spreadsheet
- code Help - Routing Recipients
- Comm 1
- Can anyone solve this!?
- Comm1 not opening
- Help Retrieving Cell Values
- Paste a Range from a variable
- Printing to Adobe without getting promt for name
- macro & comobox
- Web service reference Tool 2.0 -
- VBA code slows to a snails crawl when screen saver activated
- Revised Question on Page Numbering
- Offset Formula Question
- excel 2000, vba and msquery(sql)
- Annoying "virus" alert when using code to send mail
- Excel 97 automatic cell format
- how to trigger macro or force autofit
- Calling Macros oustide current module
- Holloween Mystery: ghostly blank cells
- Email from Excel..please help!!
- Formatting a date as a serial number
- For Next with step
- Re: Page number question
- Re: Page number question
- Re: sheet collection
- Check activate sheet
- formatting ques...
- How to force a recalculation of values based on custom function
- How to write an importer/exporter for excel
- Another Tuesday Task
- Tuesday Treachery
- Creating a Master Sheet
- Pb en VBA Excel
- Problem with Legends in chart
- Cheque Writer in Excel
- Before DoubleClick
- OLE
- toolbars
- Insufficient memory Caused by Pivots.
- Compare Worksheet's
- Autofilter hides totals I want to see
- Problems with ungroup
- SQL Multiple table joins in VBA
- Problem hiding/unhiding columns using combo control
- Create customs define event
- Making arrays outside cells
- ActiveWorkbook keyword seems to fail
- Specify a folder for saving to?!?!
- Cell format
- Excel formula
- Format column auto. to "hidden"
- VBA code 'find next'
- Rounddown problem in VBA
- question on the definition of refer to
- vba or function
- Difficulties in VBA ( User form and option button)
- Running Access MAcros or VB modules in Excel
- Flickering of the Screen when the Macro runs.
- Adding Modules
- Userform question
- Global variable
- Pointing to the Correct Directory
- Pivot Table: Hide Items Poperty
- Custom Menu
- Form question
- Import External Data incomplete
- Help with a Combo Box Change Event
- Over ride double-click handler?
- Run-time error '430' / Class doesn't support Automation
- References in VBA macros ?
- Help - Change Event triggered on File Save As
- Any difference between Sheets Activate and Select?
- Using Excel through COM
- using mappoint in Excel VB
- ATTN: VASANT
- How to display contents of a cell in UserForm and take input
- ranking the bottom of the table
- Automation
- List of GUIDs and other properties for future references
- Create named range
- Getting to the Function Explanation Programmatically
- Opening a CSV file
- delete rows
- Copying Cells
- message when saving workbook
- Automaticaly Emailing A S/Sheet ??
- Nedd help on my function in VBA
- Templates
- Still Stuck
- SQL Statement
- converting 16 digit number to text
- Re: Macro 'Automation error' with ChemOffice Excel macro
- Changing a cell color....
- Excel 2002 and Excel 2003 VBA help screens
- Collectiong data from SQL server / Repeat!
- SP3 removed Macro Security option in Excel 2000
- How to set a time for the next 1/4 hour
- Operation Is Not Allowed When The Object Is Closed
- Add columns of data in Excel workbook to fields in MS Access
- My Macro keeps stopping??
- Filtering
- vba programming
- Detect workbook events from .XLA
- How to conditionally sum values depending on values in other colums
- storing numbers within the macro
- Date/Time - String or Number!
- Re: vb to copy conditional info.
- Using Excel to generate Word macros
- Connecting to comm 1
- On Error
- Connecting to comm1
- restrict entry in a textbox to a range of values
- Is there a better option than Getobject to access a .xls?
- programming font color on select items
- Conditional number format of cell
- Using VBA with Shared Workbooks
- Pivot Table Macro in Excel 2002
- run a DOS .bat files under an excel macro
- Excel vba printout method
- Importing data from text files
- User Defined Addin - Urgent Please Help!
- Macro Monday Blues
- Determine active file size
- Linking Cell Comments!
- Using VB to fill a formula down
- Associating a macro with a button
- Emptying the copy buffer
- ActiveWorkbook reference fails
- Maximize minimize and restore button
- Run command when hitting ENTER on list box item
- Modify generic dialogue
- Print data from FlexGrid
- argh, can't get it to work
- Msgbox help
- how can i copy a macro to another pc
- Sum Function
- Range.column
- variable range: l just can't get there!
- Populating combo box with a function
- AutoComplete in a List
- calculation multiple row & colums
- User access to the VBE
- Ending a routine
- VBA code to change the Print - "Number of copies" to 3
- Prevent users from using AutoFilter
- Excel help + VB
- #DIV/0! criteria
- worksheetname in a cell
- Spreadsheet documentation
- Option Button and forms
- MACRO QUESTION
- Sendmail Macro
- Working between Worksheets of the same workbook
- Excel on the Web
- Why doesn't this work...??
- link a cell into a vba form
- Worksheets.Add
- looping with formula inside
- Stopping a macro without using Ctrl Break
- VBA: how to force another instance of VB to run
- Difficulty hiding check boxes
- Formula
- Shapes.. trying to print a square square
- How many CR's in a multi line texbox
- Array Formula
- Restricting use of menus and toolbars
- Re: Publicising Benefits of VBA
- Use VBA to open an Excel cell for Edit
- Last question I promise
- Disable ALT KEY
- UsedRange & Formatting of Cells
- tabbing round a userform, whole field is selected
- Userform Textbox Currency Format Problems
- How do I remove toolbars and specific menus items to restrict use?
- Formulas
- REQ: I need help working out this function.
- AutoFill Method
- Looped process
- Changing cells temp.
- ActiveX Warning Message
- Wordwrap wont!!!!
- Resizeable Rectangle
- Add & Delete Records in Excel using a form showing a scrollbar also!
- refedit query
- Too Basic A Question
- Using Solver within Macro
- Creating a Function that references cells to other cells...
- Run time error 1004
- handicap predictions
- Sum at point of change
- Row Heights
- true 3D bar charts possible?
- Is it possible to set a class member to be another class member?
- Re: Customisation of Chart Dialog
- "Run Time Error 1004 Application Defined or Object Defined Error."
- Windows Media Control and VB6
- Newbie : Combo box on cell ?
- MACRO TO REPEAT FORMULA
- Page Setup for multiple sheets
- Excel Data Sort - doesn't. HELP please
- How to make a sheet the active sheet?
- Missing Security option in Macros
- Assign a variables value to a TextBox
- How can I avoid a BLANK cell being interpreted as a ZERO?
- setting tab order by code
- Printing with reference to current PC
- Let me have another try
- Determine range with VBA
- Macro slowing down after a while...
- Inputbox to return address of cell selected by mouse
- Inputbox used to return value of selected cell
- Sum
- Array Help Needed
- Reliably get sheet 1 of the active workbook
- Append new row of data to range
- Create Excel Macros
- In unten stehendem Prozedurausschnitt soll an Stelle des Feldes 'name' jenes Feld eingesetzt werden, das in der Variablen sortierKriterium steht.
- Ambiguous Name Detected
- Comment Box
- A very simple question....
- Disabling Minimise/Restore Down buttons
- Format text in Outlook from Excel
- Code for modify a column
- can we start form by clicking hiperlink ?
- How do I use Workbook.Add
- Attention: Leo Heuser
- queryinterface error in vb.net
- Disable "Save" &/or "Close"
- Not sure how to tackle this
- RE: C# and OLEFormat.Object
- Count Cells containing Text only
- Is this NewsGroup Operational
- How to return a XL97 spreadsheet info to the requested web page?
- my script wont post, unless i hit a key..
- auto open a workbook
- making a cell fixed number to a input number
- Opening a workbook minimized...
- ReDim an Array
- Export to text with custom delimination
- Code For Expiration Date
- Basic VBA question
- Add-in installation on Excel 2002
- How to uninstall XP PIAs
- Grouping Option Buttons
- VBA: Userform Access
- Cell Edit
- unwanted concatenation
- Pausing a macro for user input
- Excel/Windows 98 second edition
- Activating workbook with variable Name
- Changing PivotTable source
- Maintaining Column Widths in CSV Format File
- relative reference
- How to keep Excel sheets on a database?
- DataCombo control...
- Tab Stop Broken
- macro for conditional formatting
- test
- Publicising Benefits of VBA
- "Not Enough Memory" new macros problem
- Changing the Hyperlink in a cell
- Open all linked files and close them.
- Selecting Rows by Column Value
- Dialogue Boxe
- Excel outline showlevel
- Error 1004 - unable to set the orientation of the page setup class
- More Macro Madness
- VB backwards compatability to 97
- Copying sheets
- SPSS Excel
- Excel Compiler - is one available?
- skipping text formats
- Wish to parse through a text string to find data
- How to Insert Picture in Excel?
- Can anyone find what is wrong with the following?
- Modifications to Permutation Macro
- Macro warning when no macros in workbook
- offset property to define range
- utility
- Link .xls cell formula to .xla function
- Autocomplete (?) in code not working
- Parsing Full Names of varying lenths and parts
- Library missing..
- Excel won't quit
- Proteting against a button press
- Combo Box - Can I Concatenate the list?
- macro for timestamp option button
- DATEPICKER CONTROL
- How Do I...
- Parsing Shell Command with Parenthesis
- Delete rows if they are empty
- Simple macro - help please!!
- macros disabled after apply SP -3 to excel 2000
- Dropdown Rowsource
- Disabling/Enabling Macros
- I need to validate with a formula
- Having trouble with formula to automaticly enter data
- MS QUERY w/out querytable
- Saving CSV files in Excel macros
- MS QUERY
- Gray background is shown when loading a workbook
- Documentation & testing
- Path
- text in listbox
- "TEXT" numbers - count problem
- Referencing Cells in Macros
- Combo Box becomes blurred
- If value betwenn 0% and 50% than yes
- excel problem
- How do I use Workbooks.Add
- repost: Listbox text align
- Msgbox
- Formula using VBA
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.