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 |
- Using drop-down list in Excel 2003
- Licensing policy for Office Web components
- autofill values
- Newbie question on deleting duplicate rows
- multiple search criteria to find and copy from sheet1 and paste into sheet2
- Another loop & sheet question
- Read security level
- Underscore character _
- Crash on save
- How to shift address info. from rows to columns?
- Loop worksheets
- ATTN: KEEPITCOOL
- Button Enabling based on check in checkbox
- Compile Error, Can'f Find Project or Library
- Conditional Button Enabling based on Checkbox
- Return the column of the next empty cell
- Semi-log graph?
- Algorithim to generate/check valid serial keys
- Strange Module line
- how do I stop the find at the end of the sheet
- is this formula possible in excel?
- Control tip text - can you have a new line?
- error trapping
- Naming objects on creation
- Change a date in text format xx.xx.20xx to a recognised date format
- VBA generated command buttons
- beginner text box question
- Updating sheets to include new data beside old data
- Project Window
- Need help with sorting, please.
- Close and save macro
- Excel VBA and XML
- mail merge
- Getting list of open workbooks
- Last cell within an address
- Converting a string date into a Excel Date
- Adding items to the second column of a list box
- Array Help
- Calculation
- Hide Columns That Contain Checkboxes
- option groups, formatting
- How do I?
- Limit a macro
- scroll bar
- scroll bar
- MAPI create object error
- VB String Comparison In Excel
- Searching Columns
- Public Function IsStrikeThrough(rng As Range)
- VB Find
- In VB, get Auto Filter Range
- Format row based on cell value
- Remove Formatting Apostrophe
- save command bar into an excel workbook using vb
- Fillright
- Control Excel
- Simple Variable Question
- Portability of early bound code - clarification
- Starting Excel
- I am a little confused with the VLOOKUP results I am getting....
- finding cell info to rename sheet(s)?
- Help : Code for selection non-contiguous cells
- Copy ranges (columns) instead of whole row
- Problems with Match function
- Read a single column text file
- VLOOKUP Problem
- Copying a sheet to new work sheet
- dynamic arrays as an argument/result in programmed functions
- Insert Page break in Word
- Passing data back from a form
- Re: Passing data back from a form
- Updating (Adding Rows) To A Second Worksheet
- Calculating # Days in a Date Range
- Validation from a list
- Re: Create controls dynamically
- Re: breakup spreadsheets
- breakup spreadsheets
- Formula Explanation
- excel VBA or VB6 -which one
- Making a macro run when the user closes a workbook
- Re: Making a macro run when the user closes a workbook
- Re:
- vba gridlinecolorindex question
- Seperate columns with a tab??
- many workbooks in one.
- Re: Turning macros into executable code
- Import output from mailmerge
- Reading Userforms
- What is the easiest way to setup a 'global' macro which is always available to Excel on a PC?
- Currency
- Importing Access Data and formatting it in Excel....!
- PivotTable DefaultVersion
- I post the same subject.please help me on this
- Inputbox or UserForm
- File directory into a listbox
- Excel 2003 VBA Help for TRanspose is missing
- Deleting name-objects
- ListBox array
- Checking database field
- VBA function returning the value EMPTY
- First four columns lose formatting when DAO macro is run
- conditioning 'find'
- Sort cell values
- Scope of a public variable
- time indication bar
- Pictures in file
- Delete worksheets
- Prevent Users from switching worksheet
- Maybe a little off topic
- Calculating total days from 2 dates
- printform vba
- Validation from a list
- vba problem
- CDO email questions
- error message
- Automation SaveAs HTML
- Help with text box and time
- Autofill months in cell
- Procedure kills copy and paste
- macro? clearing/ transferring info to another sheet
- Userforms - Dealing with zeros and non-entry of data
- Opening Text File From internet
- Excel to Zip
- Conditional Cell color change
- Moving worksheets
- Colorvalue of cell Z1
- Digital Signatures for Excel 97 Macros?
- Scaling controls
- Location of control button
- Longer loop than expected
- Enable/disable page on multipage
- Restricting scrollig by arrows to certain area
- Disabling standart menu options
- Locking the Application Window size
- Preventing users to move object in the sheet
- selecting multiple sheets
- Copying workbook contents to another workbook
- to find next data
- If then statement
- ms query xp issue
- range onclick?
- Eliminating Excel msgbox from popping up while macro is running.
- Using controls in excel to store data
- Printing with coordinates
- Some helps Please
- Peek at data in open excel sheet
- MsgBox
- Array questions
- Is it posible to set up some code to Filter Worksheet on Colours
- Call to custom function appears as typed not as result
- External data queries within applcation collection
- RGB of highlighted Excel button
- Using VBA functions in Worksheet cell data validation
- error 1004 "Cannot edit a macro ..."
- Calculating with textboxes....
- Find Metohd again...
- Stopping an animation macro
- Listbox help
- AutoFilter Problem
- object or structured orientated??
- Working with lists
- MultiLine/WordWrap usage
- vba that give you folders size
- Putting Listbox data in cells
- Worksheet menu bar using code????
- Pivot Table Formatting
- Loop Edit
- Do While, OnTime and CommandButtons
- Excel increasing slowdown, in multiple versions
- file writing
- display message upon open
- VEENLR3.HLP
- Auto Filter use
- Storing non-user data
- reducing file size when done
- Sharing custom forms
- Links in Excel Files
- Convert List box from excel file to VBA list box object
- Help with some code please
- Excel shared file
- Jump to duplicat entries
- UCase Help
- ActiveX control
- forms in excel
- Development hours (off topic)
- Range Reference in Visual Basic
- Help
- read last line of a file
- AutoFilter
- OLE Embedded File Link
- Find Method ; search area
- embed excel in ie using vbscript
- VLOOKUP : how to use defined name in it
- Simple copy and paste
- Columns and Rows Values
- Reset Combo Box back to Null
- Stop a loop with a keyboard
- COUNTIF()
- Help with creating CLEAR button
- Help! What's wrong with this simple copy and paste
- VB File Controls available to Excel VB?
- data check
- MultiPage Error
- MACRO TO LINK DATA !
- modules
- cancel a print
- .FileSearch
- Prevent smearing of treeview when scrolling
- Pivot Table Problem
- On Error Resume Next
- VB Help Errors Out
- Running macros from another workbook
- "AfterPaste" event again
- ADO Link does not work...help
- Copying RESULTS of a FORMULA to another worksheet
- Excel data validation multiple lists
- Autorun a macro
- Can't get Excel to quit
- validate list xl2000
- protect a macro
- Reformatting question
- Which event puts *white* handles around a chart?
- Word positioning from Excel
- Copy ranges of data from Master worksheet. Thanks
- excel to manage access data file
- Array-problem
- Defining an auto-open macro that prints specific worksheets
- help needed with excel macro
- Find Empty Cell
- How to change cell colors based on an IF statement formula?
- Need Some Practice
- Userform Capabilities
- Trying to set validation range using string yields error
- line breaks in a variable
- Getting values from a closed file
- Worksheet_Change Event
- Buttons
- need to split month out from date formatted cell
- Calling Macros from a list
- 'Properise' text strings using VBA
- auto format of info in footer
- Passing values between 2 subs ?
- How can I update the userform?
- It was SLOW, now is FAST!
- miscro excel
- how to get to Miscrosoft excel
- Excel main window close event
- macro and wildcard
- Deleting Files From VBA
- Update Region, Anyone?
- Creating a pivot table from different sets of data using a macro
- Excel Textboxes
- Command Button Problem
- Using Arrays as Data for a Chart Series
- running VB code
- Start Macro / Stop Macro / Restart Macro
- Pivot Table: Complex printing issue????
- Cell Change activating macro. How do you make it happen?
- Tools-Options
- Replace Loop
- GetAttr giving unexpected results
- Form Button with 3 Userforms Help
- Book on how to write VBA code in a fast/efficient manner?
- Formatting number in VBA
- Getting Copy From Range
- Dropdown from 5 years ago question
- Sheet locked by owner
- Printing Form Component information
- VBA / VB Numeric base changing function
- reference to .dll file
- Find OnAction property
- "AfterPaste" event
- Office 2003 Registry Installation?
- Re: Quarter date format
- Macro
- sort column A with "strike-through" values come first
- Hide all toolbar buttons
- Using Time Criteria
- formatting cells (borders, patterns, etc.)
- Exporting data directly from Excel to an un-opened Access database using VBA
- Excel 97 VB Print Tray commands
- Adding a custom function to the default excel function list
- ChiInv function
- Can you check the last update property of a file?
- Progress Bar Help
- Disabling looking for link file
- Variable Button Name based on Data? Can it be done?
- Multipage programming
- Modification history
- double quotes around string in formula craeted in vba
- Change formula based on color
- Show blank and not zero
- NT Domain Users
- select and delete sheets
- Who has used CIS with RTD?
- Instant messaging
- truncate text using VBA Excel
- Sharing a workbook
- commandbar
- Pivot table -conditional formatting (color)
- Mandatory cell check before closure
- Clipboard data at closure of a workbook
- making toolbars with a macro
- Delete macros in another macro
- Explanation of code
- Unable to save workbook within WorkbookBeforeClose
- Countif function
- RTD with DCOM and CIS
- Procedure too large
- RE: Apply conditional formating to color pivot table cells
- Autofilter help
- Create a Pivot Table based on From and To Dates
- How to Copy & Paste selected Range in Excel (MFC)
- Font color
- Can't Exit Design Mode because Control can not be Created
- Conditional Checkbox Creation on a UserForm
- Worksheet Function COUNTIF
- Help
- Compare values in 2 workbooks
- Percent Format
- Protecting Cells
- Speedup choices from a long list
- Want to move records
- Brackets in Excel filenames
- Print Area vs Print to fit
- How to Programmatically Insert a Page Break Every Nth Row in a Range
- best way to add worksheets together
- BeforeClose, Auto_Close, and ActiveX Server
- Changing Customer Styles in Code
- How to open a workbook from a template without hardcoding the path
- Investment performance tracking
- Very specific invoice auto numbering for the gurus
- Follow up with sound question- need more help
- Bolding some words in a MsgBox message?
- Publish Sheet AND Chart
- logo to top right of printed page
- Making certain a cell contains numerics
- countif(Range, Criteria) > 0
- can i have VBA & forms etc load then unload?
- How to extract data through ODBC with date criteria?
- Countif
- Determine which button
- Excel VBA Bugs
- A function that returns a Range with entries reversed
- Building a dropdown from a worksheet
- Help with AdvancedFilter method
- CSV String to consecutive cells
- Active Cell
- OLE switching <-> Apps
- How to open workbook from template without hardcoding
- Evaluating cells for items in list
- editing cells...
- Disabling the minimise button in Excel workbook
- Extrapulating Information on current population from a worksheet
- Current consecutive streak
- array filling: cell addresses
- TRACKING CORRECTLY LINKED CELLS!
- Code Needed - new user
- User form question
- Validate text box entry on user form
- Tolerances Logic for Excel
- link a vc application to excel
- Automating PP from XL
- Passing a value and getting results
- Automatically Sorting Columns into Worksheets
- Macro Buttons
- Toggling worksheet tab names
- Control Project From Excel
- SWITCH BETWEEN APPLICATIONS
- MSCOMM
- XP saves differently than 2000
- Cell Value Depends on Other Cell Value
- Workbook is saved on close - why?
- What does an ampersand mean in VBA?
- SaveAs Filename Help
- Unlocking a locked Spreadsheet
- ADP to Excel and Formatting
- Exclude AM/PM from time format
- EMAIL MESSAGE ONLY
- HELP!!!! -- (Method Range of _Worksheet failed) ERROR!
- How To Hide Code?
- Creating a tournament program in Excel 2003
- MACRO FILE
- Creating a function to test for the filters applied...
- Return Information from Functions
- Userform control
- range setting
- Excel Work Books
- conditional format depending on time
- Benchmarking: 3rd (and last) try?
- Command Button Tip
- Summarizing data in multiple excel files
- Macros on protected sheets?
- Form Letter in Word from Select Excel data
- Grouping Shapes
- Shortcut for Paste Special Values
- Print one page per row
- Restoring Toolbars
- Summing inv in list
- Identifying cells with external links using VBA
- MsgBox Help!
- Excel - RTD file wont save
- How does a macro access its OWN workbook?
- changing the title of an 'application.dialog(xldialogopen)'
- Macros
- why can't 'Do While Each Cell in Range...'?
- Formula Help!
- User Defined Functions
- grid control
- Functions
- Declaring Variables
- ADO-Excel link to iSeries
- ListBox question
- truncating and rounding
- Add-in Error , code help
- locked vb projects
- MoveFirst
- unable to save current workbook within WorkbookBeforeClose
- Re: using visual basic to access a protected DB
- Toolbars and Crashing
- Re: Is this a macro or a function?
- Is this a macro or a function?
- Hämta uppgifter från flera dokument
- Error with Excel Solver Add-In, Need Help
- macros for calculating a new average after inserting a new row
- Intersect Excel 2003
- Does a book like this exist?
- Evaluating a range
- A Simple Timer
- Intersect with decimal
- AUTO START
- Passing Variables
- Oblect not found in macro - bypass
- Copying a cell to another cell using a macro
- FormatSSN
- Refreshing data from ODBC automatically?
- Getting Excel password using vba
- Sequential Sub Procedures
- Sharing a workbook
- Comparting two excel sheets ...
- Is this possible?
- Filters on Protected Worksheets
- Is there a last update property of a file.
- Dialog box on the fly.
- icon in menu toolbar
- Using VBA to Protect sheet(s) with Autofilter
- Copying cell value to clipboard to paste into adobe pdf maker
- Launch Excel in another instance
- how to open workbook without hardcoding path
- Moving cell values from sheet2 to sheet1 using UserForms and ListBox
- Cell Protection
- sheets(count) code
- Re: Changes are saved to workbook even though I chose "No" when selecting close
- Small macro
- Pivot Table
- MACROs involving scrollbars
- error handler
- Delete Entire Rows
- Re: Changes are saved
- Do Until ? I think
- Goto next used row
- How do you get a Selected Range address into a variable?
- IF statement Help
- sort based on color in cell/column
- Hiding "work" taking place on a worksheet.
- Can I create a msgbox that is asking for a string to be typed in?
- How can I protect my work?
- Re: delete rows without numbers
- Re: Downloadins Access to Multiple Worksheets
- PasteSpecial - Comments and ColorIndex
- printing multiple report
- Compare Worksheet Values
- msgbox
- Range Variables
- Hiding and Unhiding work sheets
- Protect Forms
- A range of values transformed
- Downloadins Access to Multiple Worksheets
- Delete rows with text and blanks in column A
- Changes are saved
- Combo Box & Unhide Rows
- Adding calculated fields
- test a cells type
- VBA? VB? C#? Which to use?
- One worksheet into two worksheets
- Combo box issue when attached to projector
- Copy&Paste and Selection Change
- Filling a combo box from another workbook
- AutoNew
- How can I track down where a value is getting lost?
- Scrolling in VBA
- Conditionally Bold a row
- Insert data into a seperate worksheet
- What is causing a #Value!
- Opening Open File Dialogue box from Excel97
- Oracle to Excel to Eudora/Outlook
- named cell value from closed workbooks
- Problem with invoking project specific Sub in Excel????
- Old report suddenly not running
- Programming a console application
- Cell Updating with formulas
- Array Problem
- Help with Vlookup code
- Counting names thru code
- Inserting Columns...Redistributing Program
- Programming IDE
- XL97/Win2K - lookup and return listing
- Passwording Macros
- Incrementing dates by one hour returns bad result
- Create main switchboard and forms
- Invoking "#REF!" without hardcoding it
- Increase/decrease decimal code
- Favorite Error Handling Mechanisms?
- Another basic question... CASE with a range
- Coordinated Auto_Open/Close
- Autoscaling of axis on Excel graph
- Vlookup Conundrum
- VB.NET and Excel2003 COM Object and PIA
- MsgBox question
- export/deletingdata from Excel to access
- Picking data from another workbook
- GetOpenFilename Folder specfication
- Basic question: how do I change these in to functions?
- Code ends subroutine in error
- Command Line Arguments
- Error in loop
- Vlookups
- Removing Duplicates & Summing Quantity
- how shall i define the path when using export?
- DisplayAlerts property is not changing to False
- syntax
- search and replace within macros across workbooks?
- xla question
- How do you replace an existing file, saying "yes" in a macro?
- Active Cell Position Using Go To Or Hyperlink
- References
- Graying Out Some Rows
- Copy data where some cells exceed 256 characters
- Calculate average pay from highest five consecutive years
- supress Solver message
- Advanced Conditional Formatting
- Launching Excel
- Does sheet exist?
- Formulas
- context sensitive help
- Convert reference style
- Benchmarking
- How to change resolution of monitor/screen
- Selecting range
- Remove opposite/almost matching entries?
- Opening a Worksheet Dependant on Date
- Automated cell copy depending on cell content?
- Why Can't Unprotect and write value into worksheet before close.
- formula troubles
- open Access DB that is password protected
- Unprotect VBAProjects using VBA
- Updating Links in Excel
- Auto_Close() needs help
- Excel Formulas
- Cannot Paste into Textbox
- create wizard with Excel
- Array multiplication addition
- Extract data from different webpages
- how select block w/unknown last col and last row?
- Disable 'Add or Remove buttons' functionality on a toolbar
- Common Dialog Error
- Hide worksheet
- CommonDialog Error
- CommonDialog Error
- to textbox
- Tolerances Problem
- ActiveWorkbook.ProtectSharing
- Could Not Load an Object
- Unique generated Alphanumeric No.
- export a text file which more than 65536 rows into excel
- Warning prompts disabling
- Giving the String expression for Numeric Values....
- Replacing DirectPrecedents in a Formula
- Help! I can't figure this riddle out
- macro clearing cell content
- Execute a Macro when specific value is selected in a Range
- appending to second worksheet from a Master Sheet
- using hyperlinks to navigate around a protected worksheet
- Control Exit event
- how to tell which hyperlink was clicked
- Report Generation
- Macro to randomize a range
- Having a macro interact with a dialog box.
- VBA Password prompt on file open - 1 machine only
- code for creation of multiple pivot tables
- Using Filtered values as values for a chart
- Time Capture cont...
- ADO
- Create formulas with $Rn1Cn2:$Rn1Cn3 format
- Macro to convert specific Numbers to Letters...
- Open Webpage and then Run Code
- Updating from another spreadsheet
- Message Boxes.
- Subverting autocomplete
- vba - format
- userform
- Time events to trigger VB (corrected)
- Tim events to trigger VB programs
- Re: Time Capture...
- Formatting Dates
- Re: Time Capture...
- Cleaning Text
- Color Code
- Obtain memory usage?
- Time Capture...
- prompt when saving as .txt (Tab delimited) format?
- special formatting (for social security numbers)
- Code not Working - Help please
- find and copy data from one sheet to another
- Using VB.NET w/VBA
- AUTOMATING CHARTS W/VBA
- Copying Worksheets from 1 Workbook to another
- Exposing a function to other workbooks
- Option group and Combobox
- vb code to export data into existing Access table
- Find and Replace in XP
- Combo Box in userform
- How to Open A File with Visual Basic
- Add ins
- Programmatically Format Comments
- Programmatically Format Comments
- i really need help w/ this please...
- Re: Search acrross Workbboks & Worksheets???
- remove unused Rows (with 0 qty)
- Capturing user name
- Searching for VB Code to Link to Program
- Find row of date of previous year
- Writing to a excel spreadsheet is slow.
- Counting Days
- Pivot Table Connection
- Sorting worksheets alphabetically (code)
- edate function in VBA
- Programming to go between Access and Excel
- OnAction command failure
- Using Message Box to Open/Import Text File
- TEMPLATES
- Cycle thru & format all columns
- how to set activecell?
- Copying Row Data From Multiple Sheets To Master
- VBA from Excel 97->Word 97 tables
- SaveAs
- Deleting Macros
- Correlate selection row with worksheet row
- Macro Line Inoperative
- Macro button
- How do you add arguments to an OnAction event?
- dynamically creating check boxes
- click cell and open matching value in next sheet
- Find Method doesn't work
- Cell Referencing
- Getting a handle on Userform controls
- Open Ms Access database with excel macro
- Passwords
- Selecting Columns
- Cell Tab Order
- Autofilter More than One Worksheet
- FillDown
- Chart Names
- Sorting worksheets in a workbook
- Diff. btw Open [path] For OUTPUT vs. For INPUT
- ThisWorkbook.Saved does not work!
- Exporting data to access
- plotting
- plotting
- Sorting and delete records with macro
- Passwords and protection: wordtlengths?
- Crash upon using RefEdit
- Column heads for list box - how to do it
- Columncount
- Getting a file name using a built in dialog box
- Excel 97 & Pivot Table
- Autofilter contains vba strDept
- How do I count occurences of data entered in a column??
- formula for changing cell color
- Short VB code for PasteValue
- Testing for existence of range
- Printing Chart and UserForm on same page
- busy screen
- securing your vba program
- Copy Modules from One workbook to Active Workbook
- webbrowser control error
- How to number unique entry values in excel
- Deleting a file on C drive using VBA
- sheets.range and adding cells that are out of the range
- selecting a cell in sheet1
- Web page to worksheet
- Auto Filter and Criteria1 variable
- Picture
- How do I get a filter to "UPDATE" the rows selected?
- After Close Event?
- Referencing a cell for a value in VBA code
- worksheet collection issue
- Clipboard Data Within Macro
- Make a directory on the fly
- Onkey
- how to open a url in a new window from VBA on Excel
- Return the number of Sheets in a Workbook
- Line Chart Macro
- commandbar hunt
- adding and removing style properties
- This can't be the best way to do this
- QueryTables Interrupt if URL is Down
- Copy from active workbook to new workbook.
- eliminating "newer version" message when saving
- RE: Cell Referencing
- Re: Color Cell if range values
- XLA calls dll
- Selecting Active Cell before Text Import Routine
- Color Cell if range values
- History Archive
- Concatenate from J to Q column using VBA
- build dynamic table
- Delete/Replace Newling Charecter from all cells.
- Is it possible to change the Input Range of a Form Control programmatically?
- Cell Referencing
- format social security number as XXX-XX-1234
- How to get the highest average from a database-type list
- Passwords on macros's
- Cell Formating
- Macro
- math question Excel 2000
- Excel Worksheets
- cell values copied!!
- Help with some code please
- Adding Custom OCX to Excel in Add In
- Delete entries that match second sheet.
- HIDING ROWS
- Compile error in hidden module
- QueryTable with Copy/Paste Functions
- Format Problems using Copy/Paste with QueryTable
- worksheet loop
- Re: Differentiating Text from Hyperlink Data type
- VB Editor module
- Screen Update Dilemma
- Exporting to Excel using ASP Problem
- Selection is too large
- dynamic graph data series
- List box
- VBA to trigger a sound effect
- How to open workbook in the same Excel app
- subtotal
- vba: isempty
- Graph Excel Selection, Open Word File, Embed Graph Into Word
- Change default police size on a workbook
- How can you hide the macros ?
- Changing link to textfile in Pivottable
- Deleting Macros
- Toolbar button To Run a Macro?
- macro for order forms
- Excel workbook size random evolution
- A macro to export a sheet as UTF8 encoded Unicode file
- Using Copy/Paste and QueryTable Operations
- Synchronize network login/password
- Using VBA Copy/Paste and QueryTable
- Chip, I solved it
- Grouping Option Boxes?
- web search with excel data
- How to add 0's in time cel
- vba: setting font color to entire sheet
- Re: List Open Workbooks in VBA
- Syntax for using the full path to get a value
- Cell Changes in Excel - How Do I Capture Them ?
- modify formulas with dropdown
- Disable Cell
- how to automatically insert blank lines in between non-blank lines
- Saving GIF images from worksheet using VBA
- Formula Modification
- change of button properties upon activation
- Arguments and brackets
- how can I ..... ?
- On error goto 0
- pagenumber
- Check if more than one font is used in a cell?
- excel calculate problem, (try to refer to defined names?)
- VBAProject Protect
- Create a marcro that changes number of decimal places in a field according to specified criteria
- Lost Personal.xls Workbook for Macros
- Asking user to print and error message
- e-book on vba
- conditional written statement
- OR function
- Userform & Excel window
- Function to extract element of a complex delimited string (Pick D3 database)
- Reference a Column in Code
- stuck on final prat of spreadsheet "macro copying cells"
- Disabling Print Preview but allowing Print
- Stopping the use of enableevents
- autofit function in excel
- how to specify the no. to print?? (possible? how?)
- secure your worsheet using vba
- need excel macro
- Last Row As Range
- Can you build in a delay...
- Excel 2000 / Graph
- Conditional Formatting.
- Problem with Merged Cell Line Height Macro
- Add Attachment
- Excel as a development Platform? pros and cons?
- Sending emailswith CDO
- Counter linked to Registry
- Links to other worksheets on another workbook
- Problem getting a msoButtonDown status
- import outlook task to excel
- Inserting from a list box?
- refferencing named range in different workbook
- Running a macro if msgbox is yes
- Sending Email using CDO ERROR
- Array Problem, Help Please.
- Macro or script
- Dynamic Text boxes in UserForm
- Change ReadOnly State
- Browsing to URL and reading contents
- How to pass ListBox into a Sub?
- Focus on combobox
- More on VBE syntax line question
- Extract file names last save info from a Folder
- VBE syntax line question
- Folder Nanes
- DIsabling Escape Key while dialog active
- Recalculation Speed After Editing Macro Code
- formula help
- Quitting Excel without saving
- Disable controls on spreadsheet
- How do I create a summary page?
- place an embedded object into an RTF e-mail message in Outlook 2003
- Creating a Toolbar with a macro
- Last cell in a range
- User name & password access to Excel files in a folder
- Emailing Sheets Code Edit
- Vasant - Thanks for your quick help
- Calling a Custom Function within a Procedure
- value of variables do not show when I hover.
- syntax
- Spinbutton grays out toolbars
- Is there a way to get a portion of a WEB
- How can I ensure a message to the computer user is aknowledged?
- VBA for applications help files are incomplete
- Saving sheet as a UTF8 file
- how to read multiple workbooks, collect a few cells from each?
- CommandBars
- Excel97, VBA menu programming by ID Number.
- Worksheet Name
- Emailing Sheets
- Prevent Excel creating new instances of Excel
- Problem with formula in VBA
- Automate Access
- How do I delete rows and columns in With With End Loop?
- Worksheet Selection Change
- Poking Excel data into a Word Documnet
- Copy chart sheet without links
- Calling a Fortran dll from Excel
- I could really need your help on importing contacts into Outlook (Please?)
- Filter Function
- worksheetfunction.match
- Command Bar
- Macro
- Workbooks(). close intermittent failure
- SQL combo
- Import multiple text files into excel
- VBA Long data type overflow
- web site on excel VBA
- A count function or macro needed
- textbox result to label
- Merging duplicate rows
- Copying Visible Cells
- DateLastModified property date extraction
- Listing html Title tag in a spreadsheet.
- Copy Cells from columns to rows
- Insert HPageBreaks
- wait
- Playing a sound base on cell value
- activate control
- shortcutmenu
- copy, paste and save file
- xlMaximized from excel spreadhseet in LotusNotes
- MAX of Multidimensional Array
- How to use VBA
- Help with Combo Box code
- Auto Filter in a macro
- Goto next empty cell in a range
- delete empty column in VBA
- Command Button not working once sheet is protected
- Equivalent Method to Control + END
- Iterate columns
- How to toggle
- Textbox number formatting
- Add-in query
- Variables in headers
- Deleting Files from Within an Excel Macro
- Loop macro help.
- Loop macro help.
- Landscape Orientation when Footer set using mso-footer-data Disappear
- Printing problem with terminal server
- I want to read data from WEB-pages into EXCEL
- copy a range of cells (a row) to the bottom of a "list"
- VB question on ComboBox
- Dialog Box - User hits cancel
- Index of Cells in a selection
- Index of cells in a selection
- running a VBA sub from a hyperlink
- Excel Slowing To A Crawl
- save failure
- Popup message
- resizing an image on a form
- Userform Help
- Using ActiveWorkbook.Names.Add Name:=
- XML and Pivot Tables
- err
- Bizarre Behavior referencing a sheet.
- Worksheet change
- Entering functions in code
- Excel.exe
- Using a Public Variable in a cell formula
- Worksheet Change Sub problem
- TreeView control
- Automate the 'Camera' function in Excel VBA
- Missing Reference
- Comparing two worksheets
- VBA macro step-by-step
- XLA Link Issues
- cells with formulas
- CSV Files
- AutoFill Question
- getting a macro warning, even through there is no code
- Ranges in VBA
- Converting text to value
- Excel 2002 Spin Button
- Spin32.ocx control tab not visible
- Distributing a VBA app across different systems, help please
- Transfer multiple columns items form listbox to range
- subtotal at the end
- Navigating
- MS Excel macros on Pocket PC?
- How do I get the sheet name?
- How do I get the sheet name?
- insert row and range changes problem?
- xls Cell reference in an SQL statement
- copy data from a list to another sheet
- Custom Add-In?
- Querying dynamic web content in excel
- Chart range
- Count data per row and more ?
- Query Parameters
- Re: Row deletion debug
- Macro to open a file
- Distributing a VBA app to clients... licensing?
- referencing different workbooks
- vba pastespecial
- Macro for Customer response time
- Highlighting a Block of Cells to Define the Print Area
- password madnes
- Is it possible to include Excel worksheets/workbooks into COM Addins ?
- What type of script???
- Macro Calls
- macro
- Change date format to text format
- Macro to display a menu item - possible?
- hyperlink onto an msgbox
- Personal.xls
- Cancel button in Inputbox method
- Add text in am macro bellow the already entered text
- Status display
- running a sub when found
- undoing a VB action
- Before_Close problem
- What is brest way to flit between two spreadsheets
- Setting row & column sizes
- VBA building stand alone application
- Creating a printers list
- macro to send data from word to excel
- Batch file in Shell Function
- Complex Combobox problem .
- Pasting to Sheet
- Reminder in Excel 97
- Plot where mouse clicks
- Use sheet name as search string or autofilter criteria
- Can't access to a WorkBook
- Cleaning up excel & Digital signatures
- Multiply range
- Help needed !
- Stopping screen tips from displaying for Excel hyperlinks
- Automatically moving a chart range at the beginning of the next month
- RE: VB help please!
- Discussion: VBA Project Code Protection
- deleted item
- Conditional Row Deleting
- Deleting unwated control characters at the end in a particular column
- combo box
- Re: File list
- Re: The Error That Stumps Me
- A mouse with a mind of its own
- Re: VBA charting Question
- Re: Use excel as a searcher
- Re: Help with dumping data
- Hiding Columns
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.