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 |
- Lookup
- Locked form: {End} key with arrows doesn't work as normal
- No more new fonts can be applied Excel 2000
- Referencing error
- VB Project Protection
- Cell address from Vlookup
- Trying to find Item with in a sheet
- Highlight a row without losing background colors
- Properties transferring from excel cells to word file properties
- Create a pivot table via VBA code
- is there any way to avoid displaying alert pop-up in DSOFramer?
- Hexidecimal Editting
- Open workbook name size
- keypress event on a userform
- Print array based on menu choice
- Printing automatically
- Amending Cell formatting with VBA
- Problems with .Refresh BackgroundQuery:=False
- print area poser
- Insert information to multiple similar files
- editing the web query through a sub
- printing issue
- reading the hyperlink
- Is filtered property?
- RE: FileSystemObject help please.
- how can I arrage file in folder into worksheet
- Code
- copy sheets of cell length is more than 255 char
- Need code to copy from "code modules"
- mscmctl2.ocx ... calendar and date picker sometimes not available
- why the method "show" invalid?
- I cannot close a workbook in vba, I think because it odlinked to
- how to write macro that filters odd & even numbered data ?
- Change the range of a pivot table data source
- Test For Macro Security Settings Level
- Applying names to ranges of cells for formulas
- Calendar Control
- Exporting EXCEL Graphs as .gif (image file) using VBA or VB
- How to refresh the data in a Pivot Table?
- open some txt files ,find text , copy the text before that to a single cell
- What are 'cls' files? VB, I know, but how are they used??
- UDF user assistance?
- Delete all row data EXCEPT
- Copy a single cell to a cell in a range
- Determining the number of cells with data in a column
- Autofill cell to right
- Help with code that finds a sheet's name
- counting filtered rows ...
- Turning points
- referencing months
- Changing code that set's print area...to active sheet only
- Date limited
- ByRef Cancel in event module
- copying data from one book to another
- newbie question. abt cols and rows.
- Opening *.txt by code with varible path
- how to include special characters in a formula?
- copy from unopened workbook
- compare TIME in IF statement
- test
- VLOOKUP from another sheet VBA programming
- more sample for illustrator
- How to filter out multiple occuring partnumbers?
- Formula VS Formula R1C1
- Variable within the code
- Referencing Libraries through code.
- Focus In Modeless Form (spare me the grief)
- How to create a toggle button on the menu?
- Testing for an open file
- filter with special forrmating
- how to extend columns pass IV
- combo drop down code problem?
- Using part of an autofilter?
- Copy rows and move on
- More help on setting print headers via code
- vlookup result
- Wrap Text in Merged Cell
- is there anyone that has successfully sent a page or a copied range using outlook express?
- Software purchase advice
- Creating Leading Periods
- VBE (visual Basic Editor) variable
- mortgage loan spreadsheet
- Can a CommandBar Control Caption be Formatted ?
- Save As
- Global Macro
- Trying to set Option button values in macro on protected sheets
- Run macro based on cell condition
- Setting printer header via code
- making list, selecting empty cells
- Logging Data Single Input
- VBA Excel Solver ValueOf: Reference Problem
- a fomula that tracks the highest level a stock reached
- multiple file names in macros
- Ability to filter comments in Excel
- FIND method doesn't work in UDF. What's wrong with this code?
- Protect Formatting
- editing a dynamic array
- Delete (Kill) Active Workbook
- Bolding Row from VB6
- read all the files after choosing a directory
- Inputbox error? 10 divided by 100 equals 0.100000001490116 ???
- Visual Basic and VBA Forum
- Find troubles
- Component not correctly registered
- need help with togglebutton
- send a outlook template message from excel
- Macro based Import Data Inserts Cells, I want Replace
- Triggering an excel menu using macros
- Adv Filter Formula Criteria
- Re: Filter name and copy to another sheet.
- Send Userform results to worksheet
- Printing in reverse order
- macro to save as
- nooby here:D
- copying some cells
- Movve data from rows to columns
- refer to a userform in a formula
- Export TXT from wksht selected in ComboBox
- how do I...
- Please help!!! Using code to password-protect and unprotect...
- Searching the row that contains the same two columns
- Searching the row that contains the same two columns
- How to delete a row and the contained <forms> checkbox?
- show all columns in a worksheet
- How do I use a cell value as the filename in an external link?
- Averaging Values from Sheets in Array
- Sequential numbers
- open another workbook in vb
- If cell is checked, then list ondifferent worksheet
- Text Box
- Hyperlink Delete problem
- Last cell in column (with hidden rows)
- Excel/Outlook Inconsistent results
- Re: Insert Date that Macro runs
- Insert Date that Macro runs
- Access query to specific cells
- SQL syntax in VBA for Access
- PERSONAL worksheet problems
- Open Batch File For Processing
- Dynamic Range for Data Validation
- Select Cells in Print Area
- Workesheet Calculate - strange behaviour and theoretical question...
- Assign a macro to a command button
- Identifying Unique Rows
- DDE Question
- How to aviod Toolbox Items move their position in Excel 2002?
- sum if statement
- help to change data in cells
- Re: [beginner] create macro to insert symbol
- Re: Paste works sometimes?
- Excel Error
- Re: Find & replace
- Re: FileSystemObject help please.
- Re: FileSystemObject help please.
- why do I see this runtime error?
- Re: Pausing macro for user Excel input
- Re: How do I use CountIf formula to count a within a range of numbers
- Re: [beginner] create macro to insert symbol
- Re: Find & replace
- Re: Pausing macro for user Excel input
- Re: Pausing macro for user Excel input
- How do I use CountIf formula to count a within a range of numbers
- RFT conversion
- Old macro breaks!
- Taking range as input from the User
- "method 'Copy' of object '_Worksheet' failed"
- break link problem
- Formulas are skipping a row
- Exporting to CSV or Text files with variable ranges on a worksheet
- Exporting to CSV or Text files with variable ranges on a worksheet
- How to reshape data sets between long and short form as in stata?
- Search for text, change font color
- Currency changer
- Type Mismatch when running query on SQL Database
- Excel User Conference Update
- Macros
- Password Protect Indicators
- what the problem?
- Set buttons to own workbooks, but not to general workbooks.
- Set buttons to own workbooks, but not to general workbooks.
- SaveAs Issue - different approach
- Report number
- editing filename
- Automatically send e-mail with Lotus Notes
- Skipping Auto_Open
- find and return fixed value
- Cannot change SeriesCollection.Values! Why not?
- Help Please
- "Unable to get the Pivotfieldsd property of the Pivot Class"
- Trig on drag and drop event?
- counting number of entries for a date
- How to control the UserForm's position?
- Executing a macro in another spreadsheet?
- Moving Cursor & Sheet back to the Original Location
- Save excel file as another format file
- Open file with open dialog box
- Strange Worksheet Protection
- Prevent Paste into a cell
- updating a form for next use
- doesnt become Hyperlink
- Pivot Tables
- Cells Program
- Confused about ranges and arrays in worksheetfunction.* functions
- I only want one checkbox to be allowed at a time
- Arrow Keys disabled after Sheet Protection
- how to use VB code to define vlookup in two workbook
- Positioning
- Copy range lead to lost data
- mouse macro trouble
- Need code to sum a series
- Custom function valid in Data Validation/Conditional Format?
- Tricky hour calculation (re overtime spreadsheet).
- Copy filtered range
- Change IP address with macro
- reset me
- URGENT!! Use macro button to hide empty columns and rows...HELP!!!!
- Worksheet_Selection Change code will not allow cell contents to be copied and pasted onto the sheet it's running on
- copying from one file pasting in another
- unwanted copy
- Putting Data & Time in file name
- Buying Tips - I am all ears ...
- referencing ranges using R1C1 format
- referencing ranges using R1C1 format
- Call Stack disabled
- TextBox calculation
- TextBox calculation
- Filter name and copy to another sheet.
- Filter name and copy to another sheet.
- Help: runtime error "method seriescollection object_chart failed"
- Setting file names
- Help: weild checkbox problem
- preference question
- Retirement Savings Last
- Run Time error 13
- Save As "Cell A1"
- Change VBE Project Password
- Setting more parameters with Print area code
- advancedfilter blowing up with runtime error 1004
- Help with Excel ActiveX listbox controls
- vlookup?? trying to get Excel to tell me a value
- Deleting cell borders before file opening error occurs?
- filename insertion in cells
- When writing a macro in excel workbook, how do I refer to ea cell
- Trying to reference ranges in another workbook using index in conjunction with match
- Something about the scroll bar
- Closing the Print Dialogue box
- need some help with selecting a sheet in a loop again
- Selective formula pasting
- OnAction-property of cbbutton in VBE editor
- collection usage/syntax please
- Get Install directory for Excel
- text conversion problem
- is there a before_worksheet_deactive sub
- work behind msgbox
- Adding Button to Popup Control
- Filesearch in Remotely Called Macro
- List Box Selections
- Looping problem
- Saving Files
- Re: xlstart .xla automatically opens when starting Excel 2003
- VBA for saving a file to a specific location
- Reverse the order?
- Error when deleting sheets
- Read Only
- Making a list box of checkboxes
- Find Function
- Take action after entry in a textbox (or after tabbing out of/into it)
- Workbook Change
- xlstart .xla automatically opens when starting Excel 2003
- Can't seem to get an answer to this problem.
- Counting Conditional Formats
- what am i doing wrong
- Need help with "save as" macro
- run a procedure in 1 wkbk from another wkbk
- Filesearch 1004 error with XL 2003
- Macro assistance
- Macros from Add-in?
- Exporting Excel Schedule to Outlook Calendar Subfolders
- Format row from c6 to ?6
- Break Chart Links
- Opening a document without adding the path
- Pain in the ass macro Part 2
- Opening a document without adding the path
- Sorting texts and numbers as if it was all numbers
- line not accepted ?
- Add hyperlink to body of email thru Excel
- Formula ?
- Shooting a Bullet character in Excel cell.
- VBA for tab order/moving cursor to a certain cell
- blank value for row and column in msgbox
- Horrific news from London
- changing result worksheet of macro
- a little more secure login
- Email from Excel; MS warning "program is trying to send mail on your behalf"
- Update
- Find firse cell.address that will prin on page 3
- Random numbers not using randbetween()
- Userforms submit button to clear after it enters data?
- How do I retrieve the column names in a ADODB recordset from MS SQ
- ADO SQL: Im getting CRAZY
- Excel gets slower and slower....
- SLOW CODE!!! . ........ help (maybe due to unsound BINDING)
- Loops
- Forecasting value of an used car in Excel
- Starting Point of macro
- Conditinal format of cells within a worksheet + woorkbook
- Printing Recto/Verso
- getting to the web link Excel 2003
- Modify sub to swap text phrases in cells
- How do i know how many rows has been selected?
- Autoformat - customize?
- International HTML Import Problem
- How to write to a template txt file
- Excel & Chr(133)
- for each cell in range....direction problem
- Populating a main and 'regional' sheets
- Split a workbook into several using cell value for filenames
- Creating workbook from a "template"
- Insert Character in a String
- how to increase size of diagram lines?
- how to load chart in user form
- Compilation error in Excel 97
- Can Excel hide a row automatically based on value in a cell?
- Closed Excel but Vba project remained
- automated file loading and saving
- Scope and Lifetime confusion.
- VBE( Visual Basic Application)
- emailing worksheet
- Macro 2 Extract Data 2 Paste in New Wksht
- Search Macros in closed file
- Flagging duplicates
- Need help with code for Excel Macro
- Spreadsheet Programming
- 2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
- string concatenate
- Can't 'SaveAs' Directly to Network Folder
- another chart question
- Problems setting Application.DefaultFilePath
- Weird clipboard behavior
- GetOleDbSchemaTable: Exclude named ranges from Excel
- Turning on/off the Hourglass pointer in Excel
- copy and paste to another sheet based in cell color
- Macro to save Macros
- Excel XP SP3 and linked files prompt
- NEXT LEVEL OF ScreenUpdating
- erroneous "save changes?" message appears
- Control Toolbox Controls keep resizing ??
- form_unload problem
- Exporting embedded OLE objects to file
- Event macro firing twice
- Update multiple locations when changing a value on one worksheet
- Send Email from Macro VBA Excel
- Send email from VBA
- Pivot table
- Delete Non-bolded lines only
- Accessing controls in excel using vbscript
- I need a text box and can't find one
- searching for a better way to hide rows
- Simple +formula not reading value from the reference cell
- debug.print range "full" address
- Excel VBA macros and real time data calculations
- Paste Using CommandButton
- Excel Error
- Trying to search web via macro - possible??
- Printing same table on reverse side of all pages
- a new error message
- How to display an open file?
- Re: Incrementing times and dates
- Macro Recorder
- cant find a macro
- Excel 2K3: Opening spreadsheet, also opens book1.xls?
- How to use a subroutine stored in an add-in
- printing a receipt for eack row
- multiple cell conditional formatting
- Extracting (copying) modules from one workbook to another.
- Multiple Cell Conditional Formatting
- help with chart
- How to set excel column width from visual C++ using COM automation?
- Weather data Sorting with formula
- hard coded text
- Progress Bar
- Extract a hyperlink from cell value
- Pain in the ass macro
- Search for worksheet
- Macro - Modular fill function
- Changing Feild Color via value
- Exclude cell from average calculation
- set a column length
- Assign a worksheet name to a variable
- Data Manipulation
- Keeping Textbox Values After Reopening Userform
- Excel 2003 - Update or Don't Update Links Problem
- Removing User name at Comment
- Scheduling application based on Excel
- Submerged text in a sheet
- Cannot change part of a merged cell
- Copy sheet without Code
- Lotus Macro
- vba help...ranges in new sheet etc
- if numbers match then color row
- SLN - Straight Line Depreciation
- Best Technique to clone worksheet
- Analysis Toolpak Translator - Anyone got it???
- Analysis Toolpak Translator - anyone got it?
- Please Help
- Please Help
- Please Help
- Excel User Conference - US Location
- Copy/paste from Excel to a password protected intranet application
- Please help me
- Advanced Sorting\VBA Code
- forgot password
- how to insert a chart in a userform?
- forgot password
- go
- ListtBox
- create a discount function in excel
- Special cells format
- Return to column A
- open excel spreadsheet with password
- vba excel help
- Changing footer programmatically in multiple sheets all at once
- error handler not working correctly
- How to record macro for Solver in Excel?
- Printing an entire workbook
- How do I go to a specific column?
- Multi-conditional sum with VBA code ??
- Text selection macro problem
- Help with Mr. Peterson's Code.. Print serially from a Sheet
- Copy worksheet excluding defined name ranges
- Office 2003 / UpDown Control
- Code works for any WBK except the PMW
- On Error Resume Next
- Chart: Use range name for source data
- program drop down menus
- Automaion Addin not loading properly!!
- How can one open a protected excel sheet whose password is lost?
- Copy cell macro
- Print data in footer using _BeforePrint
- Worksheet_Change Errors
- Passing variable to Access
- email help please!!
- Allow ONE checkbox selected in a group
- out of range error for range value
- ++HELP ME PLEASE++ ComboBoxes as a Variable to Select Sheets
- Validating Dates
- Excel 97 error: 'Copy method of range class failed'
- calculate commission $ based on total sold and commission percent
- changing merged cells from code
- Worksheets Exists Code...
- Dynamically creating formatted tables from raw data
- Array formula with AutoFilter
- trouble "locking" a portion of a formula..
- New Registration Key Generation
- Use a macro to create new sheets
- Find red cell in macro
- Was Delete Key pressed?
- Macro code to change tab name
- Searching for a variable field
- Option Explicit
- List boxes
- Making a combo box user freindly
- Date Range problems
- How do I set up a form that narrows a data set w/ each menu select
- alert
- block variable not set?
- automatically copy values of worksheet into new workbook
- setting ScrollArea problem
- Help (cesar code)
- Delete records from 1 list that are in another?
- Find exact text?
- battleship code
- Printing problem with amalgamated cells
- How use summation?
- selecting a range
- Excel CreateObject on server
- help
- count pages programmatically
- exponential growth & Break-even
- formatting & programming
- Data source for Pivot Table
- grouping
- command button
- Automating data import and separation
- Printing differant rows
- worksheet calculate - how to run it line by line?
- Am I missing something???
- What's wrong with this picture??
- copying from one file paste in another
- exponential increase
- clear checkbox
- Insert text into filename
- Highlight if ?
- ODBC/VBA?EXCEL and ORACLE database
- Macro Language
- User form error when opened
- Using excel through vbscript
- Date format
- Combo Box ListFillRange causing save prompt
- updating cells which containing formulae via odbc
- Break-Even (or Payoff) with inflation factor
- Calculating Non-Constant Values in Cells
- More help with setting print area to last entry in columns A thru AA and last entry in row 7
- Maximizing a workbook
- Using a formula result to reference a row
- Why doesn't this work ?
- Data validation and application.volatile
- Date formatting
- publish one (and only one) html file?
- Excel Macro mousePointer control
- Choosing printer in a printing macro
- Choosing printer in a printing macro
- last cell plus one
- HEEEEEEEELP
- Demonstrating mouse clicks with Macro
- Problem with List Validation
- Path problem
- sorting
- Message box during data load
- Bar of Pie chart - Need Bar creation
- Re: Blinking Cell (Worksheet restarts)
- Preserve Formating
- Copy data from a worksheet
- Worksheet_Change and Application.undo
- Excel vba script extremely slow
- Adding Username and Password facility
- Check relative / absolute references
- Software Expiration Code Sample
- deleting characters
- Access query does not work in Excel
- Registration Key Sample Code
- VBA for charting
- VB code + Data Validation query
- Running a macro outside of Excel
- Copying cells from one sheet to another if document has been saved.
- How to check for Bolded character is a text Box?
- Select shape leading to Out of memory
- private variable: same module, other Sub/Function
- Problem with calling .dll from excel VBA
- Comment Box Adjustment
- How to depress confirmation dailog
- exiting excel takes ages if any add-in loaded
- Matching
- Writing a Procedure to print non-contagious area on the smae page
- Problem with playing sound code
- need some help combining a variable
- Non-blocking calls to Excel Macro using OLE Automation
- Listbox Help
- Access/Excel data to compare and sum conditionally
- In Excel my autofilter? is omitting some data rows from output
- Program vb to do something in case of an error.
- Problem with File.Search
- Changing ListFill in a shared WKB
- Adding Time (hours and minutes)
- Helo with excel marco
- Changing data in footer in VBA
- Sorting a single column
- Circle Reference
- Runtime Error between Terminals
- not sure what functions/code to use?
- need help with hpagebreak
- On Save Procedure Conumrum
- overflow-how big a file can Excel handle?
- Help with macros
- Programmer's Companion
- Latitude/Longitude conversions in Excel - Please Help
- Asking users to Enable Macro's
- Locate and Move Specific Cells
- displaying selection data from a listbox
- ComboBox Problem
- dataset to exel issue
- Duplicate Lookup
- MsgBox question
- OLEDB Error on Excel Macro
- prevent change sheet name
- How to call a procedure when a cell value changes?
- Using VBA to disable macros when opening files
- Auto_Open/Workbook_Open subroutines showing SCREENUPDATING
- How to compare two columns for a specified string?
- Inexpecting slow execution when writing to .PageSetup.Leftfooter
- Quit
- UserForm/If Help
- Efficiently Pausing VBA Execution.
- "writing" to a range
- Developing custom secure Excel add-ins
- Error changing protected cell
- Outlook Address Properties > Excel
- Clearing references?
- lookup functions?
- automatically open a spreadsheet for the current day's entry
- OnSheetChange or OnSheetCalculate Event Handler
- Comparing date to string
- Writing saveing date in cell when saveing.
- Deleting copies of a spreadsheet
- UDFs
- Run a dos batch file as soon as I exit/save the spreadsheet
- ideas - Query table refresh
- Updateing worksheets when openening workbook
- What are my variables ... ?
- Re-run solver when some inputs change
- Adding a Control programatically
- Array error
- how to calculate Standard deviation of product of numbers?
- Simple column moving code needed
- Find problem
- Z-test using excel
- This is easy for you people!
- Can I assign a macro to each item in a drop-down list?
- Using VBA to find the author of a workbook
- Replace application.RTD property by Application.RTDServers collect
- Chart Area
- No Macros but Macro enabling message
- It's not CommandBars("Cell"), right-click menu!
- How to remain formating in Pivot Table?
- VBAProject
- hpagebreak and vpagebreak
- Macro to insert formula result into range with zero values in cell
- Keypress
- Sound Alarm when time expires
- Help: Excel 4 macro suddenly no longer working
- Message Box
- Deactivate Events not Firing
- Storing the results of a list box
- Searching for files that contain ???
- surpress zero-values in specifi columns (not complete workbook/window)
- listbox remove Item
- Select case
- Correct syntax for Active Worksheet
- Fast Consolidation
- Historical Stock Quotes - Yahoo Finance
- Run-time error '13':Type mismatch
- Opening files
- Is it possible with my chart?
- How to compare the contents of two rows is the same?
- How do I add a number according to a specific condition ?
- does code for this exist? help please
- Larger Number
- command button()_click
- help needed with LOOPS please
- MOVE Worksheet to another workbook ?
- Bypass an
- Populating a listbox from range xl2003
- Re: Shade col. up to used cell
- Openning a file using the password from VBA
- source of good vba examples for newbie
- Bypassing File Version Dialog on Save
- MultiPage Component Property
- Open File Dialog Box
- Deleting all buttons in a collection
- Help with Error Messages
- how to check if range contains particular word
- Custom Functions in Personal.XLS
- networking
- Insert date automatically
- Re: Open File or Switch Between Windows if File is Open
- Input Box Processing troubles
- Re: Open File or Switch Between Windows if File is Open
- .find with merged cell not working
- Add new vaue to a different sheet
- Change cell format based on condition.
- vba to edit outlook contacts from cell entry
- No duplicates from range to an array
- How to make Hyperlink jump accordingly
- Simple IF statement
- How to prevent deleting certain rows
- Macro to Change a Range
- Create a dynamic chart with code
- Data from web page
- Workshoot Menu Bar Hijacked!!
- Data from web site
- Access to Office
- Download .png
- "Processing" Pop up box
- VBA code disappeared when open workbook in other computer
- Retrieving list of worksheets programmatically
- Where is the Worksheet_Delete event?
- break excel links
- loop macro
- Print in continous serials from a Sheet
- REPEAT SOME ACTION IN MACRO
- links question
- send email in VBA
- VBA Macro to copy an column from one Excel file into another file
- Excel as a dabatase, please help
- YAQ (Yet another question)
- To find number of non-empty cells across columns
- digitally signing excel doc
- If/Then with Dates
- Invalid property value.
- UDF argument problem
- Not Book.xlt
- Macro to Count Rows
- Saving Excel VBA code to Personal.xls
- refering to a workbook name within vba
- Compile Error: Strange happening
- Sharing WBs with Macros
- global function
- Re: How do I seperate a alphabet and number in a cell-in Excel
- finding the source location of a result
- Using the ENTER key to move between form fields?
- Array questions
- Subroutine question and public variables
- Changing Phone Number Formats
- Re: Dynamic arrays and type mismatches
- Copying worksheets to remainder of workbook
- clearing unlocked fields on a protected sheet
- Re: calculation on excel
- EnableItemSelction on Page Field in 2003 VBA not working
- Using a macro to remove a macro
- Interesting Code
- Can VBA be used to list macros
- Setting Property Values of Text Boxes within Forms
- Deleting sheets without confirmation
- increment cell reference whilst reading numeric contents
- Visual basic unlock "SORT" function in an EXCEL spreadsheet
- Location of "My Documents"
- Dynamic conditional formatting
- when setting Imagelist for ImageCombot, Excel crash
- Get the path to the directory that the active workbook is in
- Automating Access / Excel with batch file
- For Each statement
- Worksheet_Change not throwed when adding a row
- Re: Running the same macro to multiple workbooks
- Opening linked spreadsheet file in Access
- Arrggh! If help
- click data point in chart and delete
- Arrange and Tiled
- Re: Database Connection
- Re: Big Question?????
- VBA Password forget
- Web Queries
- assign onkey to 1 worksheet
- Transpose data
- xlVisibleCellsOnly Help to copy only Visible Cells/Rows
- SelectionChange event
- VBA to rename sheet WITHIN Excel
- VBA to hide a column and unhide it
- Declare API call to Windows GetFile
- Worksheet wide vars
- Error Handling
- Multiple checkboxes, one macro?
- function to return days
- Grab name of folder
- input box
- Image Controls
- Re: VLookUp in Macro not compiling
- Can anyone help? Please?
- Interactive Chart/ "Method Cells of object '_global' failed"
- Re: VLookUp in Macro not compiling
- Re: scheduled hours total
- Re: Screen Res change macro leaves me in VB Editor instead of work
- executable to install macro into personal.xls
- Removing Smart tags
- why merge cells in a blank sheet are look as a new page?
- OnAction?
- ListFillRange not working
- Adding to Multiple Column combo Box
- Run time error '429'
- Paste Special Values
- Set a file's modified date?
- Automatic Row insertion code
- create new book and copy sheet into..
- Shade col. up to used cell
- Worksheet Exists? Invisible Worksheets?
- Excel Macro or other script
- loop through a certain group of worksheets only
- info in Excel import into Access to combine multiple records then.
- Autofill applying untwanted formats to protected sheet
- Worksheet Dimensions
- How do I copy cell values in VBA
- Noncontiguous Cells or Ranges in a Formula?
- VBA code for cursor movement without leaving scroll area
- fixing code
- Help with copy an array from one workbook to another
- I don't want to use Send key
- VBA to Concatenate Two Fields of an Array Element
- Excel Goal Seek vs. Solver
- Excel Making Me Nervous
- Data Selection using Vlookup
- ActiveX Progress bar initialization in Excel 2003 problem
- differentiate between a visible and a hidden userform
- 2D array to recordset.
- Formatting a cell
- Coding ? pull information from one Workbook to another
- Passing argument to Excel
- Short question:Background picture in excel
- Complex problem involving VBA in excel
- Controlling Access with Excel VBA
- Getting error unloading Userform??
- CheckBox question
- Marco from XP not working in 97
- Macro for Graphing Current Sheet?
- Formular1c1
- Wait time before next command
- Do I need a Macro?
- export excel plots in to word using a macro
- Run Macro after initial cell edit?
- I can't insert a Command Button into my spreadsheet
- autorow height
- How do i find items selected in a list box ?
- Next blank line
- Visible rows copy to different worksheet
- Screen Updating
- Calculation of row count
- Drawing lines to cells with VBA
- Filling in Feilds via a macro
- Disable event macro while Auto_open() run
- Sheet Name help
- msgbox as a progress indicator...
- My Sort has Issues
- How to delete worksheet with specific criteria
- sumproduct error
- Create and Rename workbook
- MUST BE A SOLUTION OR WORKAROUND FOR THIS FLICKER
- Major linking problem
- Userform opening
- Find and copy across multi-sheet work book
- TO Bug or Not TO Bug? That is the question.
- Calling sub routines
- ComboBox in a Userforn to display a column...
- SaveAs defaults...
- Drawing lines to cells with VBA
- Selecting multiple ranges using 'Cells' notation
- Trap a checkbox click
- save details to xml
- Error 13
- Loop/copy rows variable times to new sheet
- ROUNDing on a MAC - conversion error
- Excel and IE Active Workbook Problem
- organizing sheet
- Execute a CTRL+ALT+F9 command (Array Formulas)
- Office Excel Add-in for SQL Server Analysis Services
- FORMAT COMMENT TEXT WITH MACRO
- Checking for all blank cells in a range orcolumn.
- Checking iorAll blank cells in a column.
- Multiple VBA IF/Then Statements
- Comparing Two Cells on Two Different Worksheets
- VLOOKUP/MACRO using dates for NXT WK
- Make Function Public
- SumIF and STDEVIF is there a such thing
- Creating An Application Event Handler
- excel2000 pivottable macro
- Send e-mail automatically from excell
- forms
- Moving a file from one folder to another
- Where is file which contains macro List ?
- ClearContents does not work...
- msoFileDialogSaveAs problem
- Date not Saving As Expected
- Autofilter criteria based on cell value
- Adding a folder
- creating sheets with names from cells
- Trap New File name before saving
- AUTOFILL with specific range
- Able to access VB code on a protected workbook
- inputbox loop
- Best way to manipulate CSV files
- define range name, use on VBA selected sheet
- Select Folder - Simples Method
- Select Folder - Simples Method
- Returning custom errors from UDFs
- Horizontal black line in VB editor
- Macro to set the colomns width
- Mehrere Variablen gleichzeitig erfassen
- Type mismatch error problem when dealing with Strings
- cell position
- Easy Print macro needed
- Not sure if this can be done in a macro
- Managing Modules/Macros - More than one Module FOLDER?
- Help with problems
- Macro to translate values based upon data in another worksheet?
- Re: =FORMULA(CELL(A1)) ?
- Program execution prob
- code to save the whole folder with a workbook
- Save & Execution Problem
- code to save the whole folder in which is the workbook
- Read txt file for input error handler
- running macro step by step different from normal run??
- Range - > GIF
- =FONCTION(CELLULE(A1)) ?
- Check for missing invoice numbers
- Macro assignment disappears
- Pivot Table - Multiple Worksheets
- macro to colour empty cells (cells not recognized as empty)
- Copy 1-4 sheets to a new workbook
- Linking code to a cell
- subroutine to get all of the Named range properties
- macro to delete a closed workbook
- How To enable the Sort function for a protected Excel sheet
- FIND in only one column
- How can I identify what cell was clicked on when I click on a butt
- Problem in Excel 2002 vs Excel 97
- Refer to Ranges using Cells notation
- append data to other workbook
- Open files
- VBA code to itemize range names and associations?
- Macro Listing Question
- Catching "no cells were found"
- Excel Paste Special Link
- Looping down a Range to delete entire row
- Reading dbf files
- Validate social security numebrs
- Before RightClick event change
- How do I copy an entire worksheet to another instance of excel?
- DisplayAlerts (Which Ones?)
- Boomarks
- quick lil macro
- develop a macro to perform calculations and plot graphs based on .
- If statement to stop macro
- Accessing file properties
- SendMail Function in Excel 2003 not working properly
- Cell Activate Event
- refering to cell data within a macro
- Export two overlapping charts to .gif
- Collating data from one worksheet to another
- Importing/Exporting Blocks of Data
- File Save As Using Macro
- Interior color based on dates
- delete button is grayed out
- Writing to a text file
- Imported data... the incredible growing/shrinking spreadsheet
- Newbie-need menu of names
- how do I hard code a variable range for a pivot table in vba?
- Run Once Only
- Send Email Based on Spreadsheet Criteria
- create macro - allow user to scroll down drop down items w/ mouse
- Manipulating chartobject while workbook is shared.
- Addins causing problems
- worktime function
- Picture Painting
- Macro Exit or Link
- Automatic running of Macro for the whole spreadsheet
- Array formula and date value
- Two problems. HELP
- Getsetting and Savesettings
- Make a macro run automatically in Excel 03???
- Subtotals
- Redundant Subtotal Level
- 'On Error' question
- counting folders
- Hyperlink HyperTension
- can I use GO TO results in a formula?
- Can't compile, module empty?
- VBA Sum....
- Paste Method
- VBA Sum?
- Accessing Windows clipboard during runtime
- Complicated VBA Conditional Formatting
- Type Mismatch
- macro to save as
- For Each - loop doesn't work.
- looping thru the worksheet
- Change ABC$DEF into two lines in same cell ABC <nl> DEF
- Search Cells
- Sub Worksheet_Change(ByVal Target As Excel.Range) Questions
- Removing concatenates for VBA calculs
- Clear contents of unprotected cells in entire workbook with a macr
- opening a folder then creating links
- writing macro
- Send cmd to com1 record result to new cell
- Search & Replace Formatting for part of cell
- open last modified worksheet
- dropping whole numbers
- Code for conditional formula
- Borders Object
- Accessing multiple workbooks through a macro
- putting formula in cel gives #NAME error
- AutoFill doesn't work when used in Excel com object!
- Result from a combo box
- VBA Macros that don't steal focus?
- Change data range in charts
- Save OL Attachments Programatically
- Inserting rows in protected sheet
- Count
- Date Question, not sure which forum
- Code to hide and unhide columns, with certain condition?
- List to manage employee code
- Re: Blinking Cell (Worksheet restarts)
- Sort Feature.
- VBA Macros that don't steal focus?
- How to display all levels in a multilevel dimension when report is refreshed
- Query
- automate copy and paste whole workbook to new workbook
- Finding and Selecting Specific Ranges
- automatically insert row
- Product of "time" and money
- Links a cell to code
- Worksheet_Change(ByVal Target As Excel.Range)
- toolbars
- how can i make an excel calculation engine?
- Excel Function Bar
- Compound File
- active cell
- 2005 Excel User Conference
- active printer
- Lost Toolbar
- formatting numbers
- Hide And Un-hide Excel Toolbars
- Getting number of value changes in column with count of each durat
- Sales with quarter and annual totals
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.