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 |
- Legend entries dissapear
- Using the Match Function?
- Is there a way to do this without using notepad?
- Check cell for comment
- Status of Focus
- Remove excel macros from a file to be sent
- Using ImageList1
- Excel User Conference - Last day - Early Bird pricing
- Not allow to open file it do not accept macros
- Macro in Excel deleting specified rows
- Control Toolbox - Combo Box not working
- Macro VBA help needed
- Search String within String
- Concatenate a selected Range?
- ComboBox Date Format Problem
- Color Cell throw macro
- combobox filling problem
- how do i prepare reports for tasks completed
- stringtype returned
- QUERY: Excel's SaveAs so slow..
- Unique Formulas in Excel 2002-2003
- Excel 2000 printing 'issue'
- Adding to a range of cells for validation from a cell
- Using Excel Solver in VBA
- tricky excel formula question
- print preview enablechanges = false
- Need help with looping function
- Excel 2002 to 2003 problem
- Find Method
- What's in your Extension Menu?
- Face ID on main menu?
- AutoFilter
- stop a macro
- A formula or macro that determine the correct month
- Screen Resolution
- References
- Two different views
- Prevent multiple instances of Excel from starting
- Password field display in Cell
- MS Query imbedded Queries
- Counting Occurences
- Worksheet Scrolling
- Formula offscopy and offset
- Retrieving data from a ComboBox
- Help with print screen
- Code stops prematurely unless VB Editor open...
- Excel 2000, 2003 crashes on opening
- Can I disable a macro in "Thisworkbook" with true or false?
- Custom Menu Add Problem
- Private Sub Workbook_Open() event won't fire if workbook is hidden?
- Error Trapping
- still need help
- VBA Count most current 6 months
- Using cell name to call userform
- Custom Command Bar Erroring out when distributed
- hidden comment position
- Know when .cmd has finished
- If statement question
- Find last value in range
- Find Value searching UP
- Excel to Power Point slides
- Generate list in separate workbook
- Show range names in background
- Use a cell's content as part of Header
- inserting columns and pasting
- Assign button to clear all, "except"
- Export spreadsheet data into MS Outlook Calendar
- subtotal with vba(urgent)
- change code to work over multiple sheets
- Alert message in MS Query
- Do not save a checkbox value when saving or close
- single Email address from one sheet - multiple data from another
- use average in a userform
- Advanced Filter Question
- Screen view/Print techniques
- message box sometimes not being called
- ;;me
- Assigning a variable a value from a Cell in VBA
- Autofit issues
- Macro won't open original file?
- Excel VBA Selection.Delete Shift:=xlToLeft
- auto fill simple data
- Locate last row containing ColorIndex 35
- Streaming an Excel document to a client
- Modify range variable passed through Function
- Excel User Conference - Last day for Early Bird Registration
- Removing Single quite (') in character data
- Get IP address for a remote computer based on its hostname
- Passing Objects from Excel VBA collection to a VB6 DLL
- User form with looping doesn't start at right place.
- Sound Volume control
- Cleaning Data into easy to view report
- Looking for blank
- Need help running SQL commands in a Excel VBA Macro
- Application Event in Class Module
- importing a csv file into Excel
- input box text formatting
- Vlookup in a macro
- Workbook_Open event not firing for Excel2K
- Pb with textboxes font size in a UserForm
- Format Question
- Worksheets in an Add-In
- compare 2 sheets and extract only new rows
- Need an auto update formula macro
- Add-In Public Function Recalc Problem
- Why "object variable or with block variable not set" error?
- I would to create a drop down txt box in a cell. can you tell me
- CDO.Message seems to remove formatting from Excel file
- Only with a formula, how do I increase the months?
- Problem in excel macro
- VBA code to switch to other application
- How do I use the excel function ATAN in a module used in excel
- Deleting another workbook through code
- Crossing applications with macros
- Left Justify Rows of Numbers
- AutoSave before close
- Autofilter using a second column
- Autofilter using a second column
- 3 issues in excel
- Convert merged cells to centered across
- how do I get a page 2 with inseted text box
- DDE (VBA Excel) behaves differently in Windows XP
- Extracting time from strings
- splitting string in 2 parts
- Calculate Cells - Time consuming!
- Log Cell data
- Hiding Macro warning
- Control panel detection
- How to change Titlel of Dialog Box?
- Clipboard
- Delete last row in Macro
- Date Doubleclick Event
- Autofilter with 3 conditions
- Autofilter with date field
- Using a News Reader to Access VB/Excel Discussion Group
- Shortcuts for mneu created from an add-In
- VBA vs. VB vs. C++ vs. C#
- Using a listbox/combo box to show two values
- SheetCalculate (F9) does not reach the excel-addin
- really basic (pardon the pun) problems
- Join text
- Set condition of button on click
- Macro in 2000
- Populating multiple cells on other sheets via data validation
- Populating data to other worksheet via data validation
- Range Name from Another Workbook conflicts with INDEX and INDIRECT
- Macro
- VBA - 300 Columns Of Text
- MS Query changed Datasource
- how can I get the appeared value from the cell?
- How to get a cells' range name
- Images and use in excel
- Inserting a date when cell is changed
- compare 2 dates and give the date conditions are met
- VBA Stops Before competing the program
- Which folder - good practice?
- Impossible programming!?
- How come ?
- making toggle button in xl menu
- How to get range name inside fuction
- Scroll filtered sheet to top
- Save File without VB Module
- User Form calculator
- Auto Update in excel
- If Statement
- Run Macro until a condition is met
- Date Inserted in header
- Generate document folders for Excel list.
- Change Display Icon
- Display diff text based numbers in another cell
- NOT WORKING..Getting XLA files to work with Excel
- show different text in cell based on range of #s in other cell
- Changing Display Icon
- How to go through a series of folders without using "folder"?
- Summary All Worksheets With links
- How to not show save dialog after reading from excel file.
- Difficulties with a large formula
- Group, Outline, Protected Worksheets and Protected Workbook
- Delete blank rows in selection
- RE: Delete blank rows in selection
- formula to lengthen named range
- RE: Delete blank rows in selection
- OpenText
- RE: Delete blank rows in selection
- Saving as .pdf
- RE: Can I have a box appear to select the number of pages to print
- RE: Difficulties with a large formula
- ?macro help-insert copy-w/o overwriting what is already there
- need help to create multiple copies of sheet for different sales reps
- Dynamically create userform
- Opening an existing Word File from within Excel
- roleover my totals
- unlocking problem
- UnProtecting Many Worksheets in One Workbook
- Protect VBAProject from within the code
- VBA IRR and errors
- If function with text
- Change directory before File->Open
- Menu manipulation
- Display Zero Values in Only Select Cells
- Creating an Excel Database in Separate Workbook
- How to use function that returns array of variable size?
- Calling Function
- Decimal problem
- How to know
- Still Having Trouble with Combo Box
- FIND or SEARCH worksheet function
- Macro in File halted All Visual Basic Settings?
- vba to move and renaming data within a workbook
- copy multiple rows from a database
- Calender Pop-up
- if function
- vb SUM OF DUPLICATES
- vb SUM OF DUPLICATES
- Need help with delay/timer (milliseconds)
- Code for making a cell chage color by dbl clicking, with either a
- MERGE MULTIPAL WORKBOOKS INTO ONE WORKBOOK
- Count statement with several contingencies
- vba problem with non writable chart height property
- Drop Down List..
- beforeSave autorecover
- Set Visible Range
- Intercepting the file save prompt before close?
- Step down a list
- VB 2005 and Excel
- Need help with Time Stamp Code
- New at this...need help please.
- Extracting matching data
- Using footer to display a "document expiration date"
- problem regarding date conversion
- Last days for Early Bird Registration - Excel User Conference
- Enable add-in automatically
- Excel Links
- Removing Links
- Worksheet function
- Locating Query Errors in a Sea of Queries
- Hiding E-mail ID
- Problems with reading / writing ini-file
- Import long string (modified Tom O snippet help!)
- Short dates coming up in US format if day is less then 13
- update cell colour
- password protecting sheet when workbook opens
- copying rows using macro
- How to unhide a column after printing
- c# & InterOp & OptionButtons
- GetOpenFilename, MS Access 2k
- Change Label1.Caption
- Calling Cell (or ROW() and COLUMN() in VBA)
- macro copy problem
- Office 12 VBA
- Splitting a String
- find the number of unique formattings applied to an workbook
- VBA Excel/Access Find function (Ctrl+F) not working
- Delete worksheet without confirmation
- Named Range Refers To
- Macro Showing Formula and Result
- SumProduct problem
- Keeping a named range between two dates?
- Hide Pages
- Top 25 in a filtered list
- RE: Run-time error '1004': Method 'Range' of object '_Global' failed
- Dates using Data / Validation
- Problems using MS Query to access an Excel file
- Temporarily turning off the keyboard?
- search 2 Columns Please
- Copy Rows that have a Green font color to another worksheet
- Do Until macro that renames workbooks and keeps the original workbook open
- Qualifying Commandbars - Excel 2000
- Creating a Dynamic Named Range Using Sheet Name and Column Header
- Summary All Worksheets With Formulas - Ron De Bruin modified
- Compile error
- It's doesn't work with EXECL 2003 (it's OK with 97) why
- Change value in a string
- in object browser classes panel is empty
- Load multiple image with same form
- Matching athletes and scores
- ISERROR and UPPER
- Add in module problems
- Use vba to fill in matrix in excel.
- Usinf function in macro
- merging several files into one
- Re: Copy Sheet from One workbook to another EXISTING workbook
- Protected sheets - change error message
- select range from a value
- Format in a combobox
- Disable Cells- Protection
- Variable Question
- Message Box for Duplicates
- CSV formatting problem
- cells interior/color index
- msoControlButton to "Worksheet Menu Bar" ?
- Re: Run-time error '1004': Method 'Range' of object '_Global' failed
- Re: get these to work together....
- excel db, but because password
- custom commandbar questions
- Simple subtraction and color coding ?
- Problem with loading a template
- Personal.xls
- Convert Function key on Keypad
- About chart with a macro
- validation of textbox entries
- Conditional Formatting contains?
- Format word created from Excel VBA
- transparent button on custom commandbar
- Macro to Open the Menu Data,Refresh Data,filename,import
- Assign Macro to Command Button
- getting the adress on the last row
- Pivot Table
- Faster opening of Word files
- Faster opening of Word files
- Selecting a cell in a row just inserted in a range.
- Extract folder names only
- Printing Problem
- multiple list boxes
- Printing Problem
- Range in a row
- Conditional Printing
- Getting the columnmeads
- How to find a running Excel instance and access the worksheets in it.
- Copy data
- Can anyone show me how to do the logit model over excel?
- Parsing data
- transfer name from date filed into new column and than subtotal
- Run-time error '7': Out of memory
- Run-time error '7': Out of memory
- Userform Help
- Using Multiple Interfaces for a Single Class
- Comparing two spreadsheets
- Case Of Statement
- Cells.Find woe
- How do I unprotect/with password to run marco and protect
- Verify Active Cell is within a Range that changes as cell is delet
- List Box can you colour code items or make bold
- Getting Users Name
- How to replace vba code in one excel workbook from another workboo
- Copy formula - Tom Ogilvy
- Macro now opens up VBA editor - not intended
- How to approach defining where macro looks?
- "sneaky" way to set tab order?
- If(and) help
- access query/excel.exe problem
- RE: File sized in inexplicable way
- Protect sheet but still allow use of grouping
- Saved a workbook using xlDialogSaveAs, now it has a password ?!?
- Need to make things simpler
- Loops
- Need to insert line-feed in Excel concatenation (VB)
- A rather complicated Macro needed.
- formula after running a macro
- Random Number Generation
- Help with xlReadOnly
- Counting using a form
- Is there a reset shortcut
- comparing and painting cells
- Excel Automatically Clearing The Clipboard
- formatting headers/footers
- Activate Cells
- Select Listindex from column A on selected row
- Hide Range of Cells
- change cells
- Trying to move columns based on heading text, PLEASE HELP
- Playing a sound file from Excel
- Need a calendar plug in, to help populate a cell with date
- Selecting last row?
- How do excel document to xml document by programs
- how do excel document to xml document by programming
- Formula and data?
- Saving files. Please wait.
- Combo Box to Combo Box Selections
- Password protect not working
- Format dates again
- Please Help?????
- Save as not working
- Compare 2 columns for unique values
- Defining range for Advanced Filter
- can't print excel sheet using wsh script
- Excel User Conference - Reg. drawing
- Anonomise data
- Next Row
- loop question trying to bring excel into autocad text not starting in correct place
- Copy, delete, print in one step
- Function like =HYPERLINK(xxx) - Mouse interaction - "On Click Event"
- Restoring ToolBars/Commandbars
- Re: File sized in inexplicable way
- Getteing the collum name
- Variable into new file name
- Return Range Address from Active Range
- New value in a row
- Creating Macro code dyanamically
- draw shape based on cell values
- Delete rows Macro
- How to give the numberformat the systemdefault date format?
- Dynamic combobox
- saving custom macros & toolbars
- Run a macro with date/cell change
- Please help with this chart
- Can EXCEL show the picture from the database ?
- HELP ME?
- Cascading Combo Boxes
- Time to save a workbook
- Worksheet_change event multiple
- Dynamic chart
- Excel formula to increment the month by 2?
- generate a chart with asp.net
- Averaging dynamic cell data over a one hour period?
- Get data from few worksheets together into a new worksheet
- selecting row data meeting countif criteria
- get part of a file name from a cell value for use in a macro
- Loop row selection copy with blank spaces
- Select Method of Range class failed
- How to read Rows within a Column through ADO ...
- Unrecognized functions in *.XLA
- Disable toolbar drop down
- Selecting An Entire Row.
- Selective formatting of text on Label caption
- IF statements
- Generic n in For n To xxxxx
- Toolbars
- Search Cells
- how can I put a word doc with dropdown boxes into excel
- code to match and sort
- Date Ranges
- If...then
- Hyperlinks getting changed on save
- hyperlink macro
- Save Excel book as Html Page Using Macro
- Macro to open files using cell reference
- Cursor position after enter
- Determine Point Size of Text
- Determine Point Size of Text - Take 2
- Avoid any input from user
- Find And Replace
- Excel Page Setup on selected worksheets
- timestamp comments
- Save range in a new workbook as .gif
- autofilter colored cells
- find and replace
- Summary Sheet
- Linking Autofilters
- append only new SQL db records via XLS qry
- Maximum length Prompt in Application.InputBox
- Formula Creation via Add-in problem
- Systematically Identifying Duplicate Records
- Sum Fields with #NA ?
- Copy Worksheet Not the Macros
- RE: QUERY & HELP: so slow executing VBA code... :S
- New value in a cell
- data validation and forms
- Accessing Remote MDB Database from Local Computer
- Wait for FTP
- Setting Max Value
- ADO command.execute with a loop - only runs once
- Macro 'Code execution has been interupted' error after print?
- display data based on a combobox
- Range Selection
- Options and Combo Boxes
- changing image based on pulldown
- Highlight
- Error Handling - On Error GoTo doesn't trap error successfully
- Print PDF-files
- Access Database
- Copy and Insert Using VBA
- Generating, changing PowerPoint slides from Excel
- Delete Picture Objects
- copy different columns from sheet to other sheet
- Multiple VB Conditional Formats for Numerical Ranges
- Activeworkbook.save
- Pupulating Worksheet from word Using Word VBA
- import and search datas from different Excel Sheets
- not clearing second pulldown
- Copy and paste
- stop excel automated zooming
- Find first blank cell in single column named range
- pseudorandomization using macros
- Multiple VB Conditional Formats for Numerical Ranges
- Hot key to stop a LOOP
- creating validation list in VBA
- Update links in closed file
- Help with VB code - average of numbers over specified weeks
- Comparing data of two sheets
- Create Right Click Option to Copy Cell Address
- Copying a worksheet
- Broken Array?
- Extract data from String
- Copy range from 600 spreadsheets
- Path in formulas
- Excel 2003 Screen View
- Can somebody help me with this code?
- Weird issue with cell spacing
- Code for bring up the file->open dialog box
- transfer name from date filed into new column and than subtotal
- How do I link a macro to a customized icon button?
- Sorting issue
- Checking for workbooks
- Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a)
- Sumproduct with Range Names
- Multiple lines in single cell
- Dim sheet objects
- Macro--userinput
- Record Pivot table Macro
- Find All Embedded Objects in Workbook
- Save files to generalized location?
- how do you read a visual basic program codes
- Using Split Function on String with no spaces
- Running URL using VBA - but not displaying IE window
- Data Validaton Ignore Blanks
- Need a Dynamic Chart
- Random Text in a userform textbox
- opening csv files
- Error in VBA Coding in Macro
- function
- Format text in a textbox
- VBA programming
- finding values from duplicates
- Writing a program to archive information
- match and copy data
- Password setting syntax
- ListFillRange challenge
- How to handle passwords via VBA to Yahoo Quote Server?
- make sharing module
- How to set programmatically focus on specified Excel row?
- Creating new entries
- Stop from moving cells
- Auditing protected worksheets
- Serial Number
- Obtain domain name
- Macros not displaying under Tools>Macros
- Protection error when running VB code
- Multiple VB Conditional Formats for Numerical Ranges
- How to read CSV lines into different Worksheets depending on a date field?
- implicit file reference
- Reading txt file into the buffer
- Excel to Word
- Excel FTP
- ThisWorkbook/ActiveWorkbook
- Data Validation Limitation
- Programmitically accessing WSS via Excel 2003 Data Ret
- Current File
- assign value to range in VBA function
- using a variable in a function
- Using variable in a function
- example using DSUM worksheet function in a VBA function
- Pass function as argument to UDF
- Authorization for each worksheet
- Calling Oracle Stored Procedure
- duplicate listbox selection to range of cells?
- CommandText Property of importing external data
- Get value of "Zoom" on "Standard" Toolbar
- import xml using xmlmap WITHOUT linking to list
- data entry cell when viewing as a web page
- API calls, an Event handler, custom menu bar and modal
- xlstart
- Can this can be done???
- Customs views won't copy into new workbook
- setting DSUM criteria in a VBA function
- copying an array from workbook a to workbook b
- Selecting Cells
- Max value in Pivot Table
- howto click button using .net
- Help with syntax on IF-Then for CellComment
- call external macro
- Fonts in cells sometimes grow huge
- Signature object
- URGENT, help needed.
- Calendar
- Advanced Filter to another sheet
- Web Query imput/return data problem
- Problems with user created command bar
- to remove a custom Toolbar Button & macro
- Backup/Restore Clipboard
- Delete Code
- Determining Worksheet Edit Mode
- Excel Macro - Auto Update Links
- Absolute or Relative reference - no longer a choice!
- create a macro for copying certain data in cells
- Worksheet name syntax question
- General programming help
- Merge two column in one
- Close without saving
- Importing External Data - Selecting Table question
- Excel to Access extraction
- Why are macros creating so many "Activecell" words??
- Populating a combo box
- VBA to extract sheet name
- Progress Bar
- Combo Box shink and grow
- Newbie - Help with a macro
- copy columns to other tabs based on searched value
- The ultimate Reference Guide to VBA in Excel
- switching between modes
- Offset Method and Interpreting Absolutes in Range Objects
- Split field based on number of characters and space
- Converting Decimal Ft into Ft & In
- Dynamic Seach Values
- Selecting a range
- Best way to identify the "version" of your Add-in code?
- Parameters.Refresh
- 2 windows open when i click F1 in VB code
- Using WSH to populate a pivot cache with an ADO recordset
- lookups based on more than one column
- Don't understand why I'm getting an argument not optional
- Possible Macro Timing Overrun generates Excel Exception
- 2 Private Sub Worksheet_SelectionChange?
- Delete a macro with a macro
- Code in Excel macro to get all open Word docs?
- Fixed length file import??
- Two problems with userforms
- VBA Form MS Treeview Control v.6
- Macro still wont run
- Selecting a Whole User Defined Row Using VBA
- Fast export large 2-dim array to worksheet
- "Advanced Filter runtime error"
- Office 97 override commandbar /menubar events
- European vs English Issue
- External file VBA Vlookup code
- Error using CommandLineA
- CreatePivotTable error
- Bug in multiselect listbox?
- Copy cols from one excel file to another.
- More chart problem Excel 97 - unable to set propert of series class
- List of printers
- open image file from cell value
- Using a Macro to copy a formula into last active row
- Variable Storage
- Selecting random rows
- Selecting Rows
- sheet export removes custom toolbars.
- Week Numbers
- Item List in Excel
- Deleting a protected row
- Changing chart colours using VBA
- Macro to delete row with protected cells
- Exit Event with a single textbox control
- How to macro: 1.Search for string -> 2.Copy row -> 3.Paste in new sheet
- Store clipboard before "vba do cut&paste" then recover stored information to clipboard?
- Importing External Data Locks Source Workbook
- Any utility for joining two or more Excel or CVS files
- sum matrix cells based on value in a separate cell
- How do I isolate my Excel Server from the user's general Excel environment?
- DAO library
- Entering Chinese characters into VBA source codes
- Tab's in a multiline text box
- Variable Print Range
- Copy a specific of data of texts containing "IT"
- Copy data when enter text containing the filename
- How to do a line feed in a Text Box
- excel to check emails automatically.
- CheckBox
- Splitting String into Consitiutent Parts including spaces characte
- Image in Comment in Excel 2000
- Need help with VBA Macro
- multiple text colors in a cell
- Passing Variable length Space Characters to Variables
- Making sure users enter phone numbers in a particular format
- unmerge cells
- max row and max col
- Stored Procedures - First Attempt
- Creating a macro
- If statement for a combo box
- Formatting Question
- Using a macro to perform a mail merge
- VBA to make columns within a cell (99)
- how to unhide a hidden row in a pivot table?
- Stepping Problem,
- Data Validation Question
- Custom button on toolbar
- Evaluation of Conditional Formats
- Using macro to convert single level BOM to Multi Level BOM
- Macro Not Working Properly
- Populating a combobox within a form with concatenated data
- changing prices in multiple colunms based percentages
- vbModeless Question
- formula help
- Stepping through Code
- how to get the index for a two diemnstional array..
- 65000 Row limit - splitter help!
- set worksheet name to a variable ...
- Selecting Ranges
- Excel to Outlook VBA giving my Calendar Fits
- Formatting conditional on absence of comment
- Comparing dates
- Simplify this code
- Vb to set print area for dynamic pages
- Determining number of Outline levels
- Sort not working
- Counting SubStrings and thier starting positions within Main Strin
- Last Row - Select to end of sheet
- Error Box
- Form Err.Raise error not trapped by entry procedure error handler
- Dyn Named Range update from userform
- CheckBox check marks save
- Move from a function statement to VBA code?
- Another VBA Chart problem Excel 97
- Sum Column on Array of sheets
- Stop Macro if there is no data
- Dropdown
- Run Macro through an entire range
- Creating new Excel Application problem
- launch an embedded spreadsheet object
- List Box Value To Worksheet Cell
- Seperating Data from a cell to a row
- Pdf PrintOut and SendKeys
- error 1004 - application defined or object defined error
- delete sheet if it exist
- Passing multiple strings to variable in Replace Function
- Tracking Changes to Columns & Flagging Cell
- Version Control for Excel Add-in
- Just can't get the LEN/MID thing quite right...
- Loop with activeX optionbuttons.
- Update Only Specific Columns
- Formatting Excel Cell to a text field
- Think Tank; I Need Your Help!
- How do I auto-fill dates that are not consecutive across a row?
- insert dates
- Dynamic programming in Excel
- Dyamic Ranges
- Problem with assigining a macro.
- Pivottable Names
- Assigning multiple shapes to macro.
- Chart using text?
- Case sensitive and single character in cell
- Match and VLOOKUP from open workbook, storing values in Active wkb
- Text to columns by format type???
- Importing Long String - String Manipulation (EDI EANCOM 96a)
- Sort an array
- May I ask for a formula please?
- excel vba problem
- How do I set up an excel application for use over the internet?
- URGENT!!! RTD updates maximum frequency
- need to add string to txt file
- Inserting a column using C# and Excel 2000
- Question: Can an excel macro interact with acrobat?
- passing parameter to a ms query
- I need documents on VBA conversion from excel 97 to excel xp
- ADD,NAME, and COPY UNIQUE ROWS FROM UNKNOWN WORKSHEET
- Find missing dates in a sheet
- making a timeline
- How to retrieve value from MSSQL table into a cell
- Excel98 to Excel3000 pivot table differences
- Locating Invalid Web Query Data
- Need Help!!
- Combo Boxes
- Newbie TextBox problem - Please help.
- how in excel do we create aggregates of the sort an olap tool crea
- can an excel cell be given a number of values say 2 or more ?
- Grouping controls
- Templates not loading as xls version
- Object invoked disconnected from its clients.
- How to insert array into range
- Global array data got erased after removing reference in VBA
- How to calculate number of month from 2008 in Excel?
- look up a set of values,copy a range of data into 2nd file
- is it possible to covert formula commands from english to german?
- copy data when enter the file name
- VBA WebBrowser1 Scroolbars
- Extract 1st name & middle initial
- How to tell if multiple sheets are selected?
- get value from a database
- Identifying controls on MultiPage Pages
- Excel VBA job
- Excel VBA
- Naming cells using VBA
- HasFormula
- Putting decimal values in a cell.
- How to use ADODB in Excel 2003
- Find a Cell Value (Revised)
- auto update one spreadsheet with another that creates a file.
- Workbook_BeforePrint
- Extracting data from a closed workbook
- Excel 2000 subtotals with matching names
- Setting print areas
- Rename Files according to Excel
- Creating New Worksheets for identical cells
- How can I use a cell value to reference a row?
- help needed with multiple values
- need some select case guidance
- Message Box if sum is above 30
- How to delete a web query when it's no longer needed?
- constant reference to an xla function
- How to read external cell?
- Custom sorts - Multiple Keys
- AutoFill Formula with code
- RTD data source
- Chart "Name" Property
- BeforeSave and Close help
- Two double click events?
- change csv files
- =Count(two "n" in a row, c3:ad3)
- Quick menus not working
- PT.Format (xlTable2) removes data from pivot table?
- erratic listbox behavior
- Triggering a macro after Printing
- Excel 2003 SP1: CopyFromRecordset error if field above 911 charact
- Macro on cell click??
- RE: Runtime error 1004- application defined or object defined erro
- Runtime error 1004- application defined or object defined error
- RE: Runtime error 1004- application defined or object defined error
- RE: Triggering a macro after Printing
- RE: Macro on cell click??
- SpecialCells in Worksheets Functions
- autogenerate multiple rows from single entries in different sheet
- formulas
- RE: autogenerate multiple rows from single entries in different sh
- RE: SpecialCells in Worksheets Functions
- sort 2D array
- Macro Help
- Record Set To Sheet
- RE: Runtime error 1004- application defined or object defined erro
- RE: Macro on cell click??
- RE: Runtime error 1004- application defined or object defined erro
- RE: Macro Help
- Find a Cell Value
- sort 2D array
- trying to get formula in cell
- Guidance with creating a bespoke .txt
- Anyone familiar with BPCS?
- runtime 1004 on save as
- multi color background in graph
- Excel Performance Problems
- Suppress printing using button
- Validation data on exit Excel or save
- How to set named range in macro?
- Copying a formula
- Perform action on every workbook in a directory
- Search for "text" in description - if certain text - display "text" in another row
- Denies certain characters.
- Hide columns in multiple sheets
- public or global array
- Disable a cell in excel
- Remove all empty rows in a worksheet
- Ensuring Excel start macros complete before terminating
- import multiple files to excel
- Clipboard
- Why does this not work?
- Excel VBA Last Empty Row VBA paste Array elements
- vlookup, true false issue
- Return position of a sheet in a workbook
- refresh Query table using own password for each username
- VBA Forms - Add In Utility
- Hii All!!!! does anybody knows how can i cancel the save and the save as commands
- Ian
- Macro
- Excel 2000 -> Excel 2003 now throws 'runtime error'
- Minus signs after number
- Merged cells Value2 property
- Excel SaveAs() method
- Close Switchboard Form
- VBA vs VB vs VBA.Net
- emailing a text file
- Format(Now) will not work for Feb.+
- Help with Macros
- TextBox Validation - Time Format
- Macro Error message
- Changing the default print settings in Excel
- Excel 2000 to 2003
- Registration Giveaway - Excel User Conference - April 19-21st
- Write formula with code ...
- VBA Needed to remove graphs
- Reject Manual Input
- Public variable lost...
- adding email addresses to auto email
- Forms - Loop thru text boxes
- Override "Send this Sheet"
- Spooling and printing each name
- Inserting line numbers into the first column of an excel worksheet
- Re: Copy a record before deleting
- identifying range
- visual basic Mid() does not work with swedish version of excel
- scroll bars
- change linked cells to black, hardcoded to blue
- Restore formats in merged cells ...
- Oracle Connection Problem
- Adding custom graphics to excel chart
- Macro cannot be found
- Deleting a row
- Code that references the name of a cell
- How to add data Range property at runtime to excel sheet
- Reading Forms in Sheets...
- External web query from ASP
- Referencing date and worksheet tab
- Adding WorksheetData to a ComboBox on a form?
- If there is missing data???
- Missing optional controls in toolbox
- how to shut the hps i open in vba
- how to set an interval
- Re: script to change filename
- Calculate time difference and convert
- Variable not defined comple error
- sort an array
- How can I make a cell mandatory?
- Who is using my excel file
- Type mismatch in look up function
- Hide the selected range highlighter
- Writing Data to a Existing Word Doc.
- Finding a Workbook's Location
- Summary sheet
- Beats me!
- File to keep track of World Cup 2006
- clipboard full
- Reading Data from a User Form.
- RE: Disable Insert Column without protecting sheet.
- How to open/save excel file with Visual C++
- Copy (removing blank cells) without clipboard
- Re: Vlookup and Pasting
- Auto macro
- Need syntax for If user name in before save event
- Collection vs. Array of Arrays, nszim
- Data validation - List Box
- Registration drawing - Excel User Conference
- using Dirty Method
- close workbooks before opening another workbook
- Programatically making worksheets
- urgent! need to find "," in number
- Help with VBA Type statement
- HTML Document.Links Issues
- How to know the linked cell of a check box
- financial functions dll
- Temporarily Suspending Worksheet_Change() until other code is run.
- Function instead of formula
- Choosing pictures
- Declaring Data Type of Array
- close all other workbooks
- how do I print .doc files from a list of pathnames in a spreadshee
- generate multi row event from single entry
- What Is The Right Provider?
- Test
- Shading cells with If statements
- Dynamically add a Reference to an Add-In in VBA (Excel 2000?)
- how to update Listbox of sheetnames if user changes sheetnames?
- color text base of value of the formula
- form button question
- activate macro by values in a column
- Timestamp
- Oralce Connection
- Re: Copy a record before deleting
- Userform question
- "Flipping" a matrix
- Excel Programming Question - VBA + WMI
- help with syntax
- panes frozen, set visible part of screen
- tabbing through textboxes??
- Sumif problem
- Continouse Calc while userform is shown
- Hide/Disable Tool bar
- need advice
- List Box: Wrap text?
- Lock Zoom of Worksheet.
- RE: merge ranges
- changing one percentage, but total must be 100
- Re: RegEx Check password string
- Excel User Conference - Atlantic City, April 19-21 - deadline tomorrow - Registration Giveaway
- Problems encountered using the DCOUNT function to analyse large databases
- Re: File sized in inexplicable way
- Macro button
- Creating a macro to apply a formula to particular rows
- RE: If A Directory Exists
- How do I print a Word.doc from its pathname in Excel spreadsheet
- How to open a workbook?
- Delete Multiple sheets
- a webbrowser popup
- Testing for numeric value in VBA
- populating a cell will a value from a range of cells
- Re: defined names problem
- RE: populating a cell will a value from a range of cells
- odd problem
- Help.. Add an event to a sheet module
- RE: invoicing
- Start macro at a special time
- pop up menu
- Extracting value froma table
- Userform finding next row to place data
- RE: Excel VBA - How do I make the third column in a row the active
- Use A Cell to Choose A Date from a Calendar
- modifying a excel *.csv file problem
- Formula to calculate military time into hrs
- Find
- Find Window in VB Editor always opens at/moves to bottom of screen ...
- RE: Excel VBA - How do I make the third column in a row the active
- RE: populating a cell will a value from a range of cells
- Need macro to run when workbook is calculated
- Open subtotal detail with hyperlink
- Logging Table with PrimaryKey
- remove horizontal scrollbar combobox
- Highlight certail text in a userform Text box
- Hidden sheets
- row argument query...
- Allow cell formatting only
- Macro -Moving data from one sheet to another
- Calling Sub difficulty
- Applying formula when a particular value occurs
- Problem with CPU Usage 100% related to stored external queries
- vlookup - after exhaustive search
- Workbook_SheetActivate Paste Problem
- why does userform close after programming worksheet event with CreateEventProc or AddFromString
- Calling Private Sub/Function
- Personal.xls Macro Function for Everyone...
- operating notepad from VBA
- Highlight column heading of current cell
- Pick projects from sheet and create new sheet per project
- Copying sheets and PasteSpecial
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.