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 |
- Macro for several worksheets
- File...Send To...Email Recipient
- Explaining an addin
- One macro for many controls?
- Payback period macro
- VBA Code to wait 50-150 mS
- Detecting Macro code behind a sheet
- Making splash screen
- math powers, fractions and editing ASCII characters
- 7 segment LCD display
- Set an Access field "not" required w/ADO
- SpinButton Problem
- Macro
- excel for each ..next
- What's wrong with my NextRow code?
- Beginners plea for help
- Parse
- Removing the right click capability
- Printing
- Pull Data from a closed workbook, without opening it.
- Closing an Unsaved (but Changed) Workbook
- Changing a formula that is copied and pasted using vba with excel 2000
- Syntax
- Removing the rightmost digit
- Format comment username
- Re: Print Control in Word/Excel
- Get Object
- Message Box
- How to Copy worksheet to new workbook with dynamic name?
- Print Control in Word/Excel
- Tab support for worksheet activex controls
- Floating Command Button - How to???
- Can't Update Links
- Help modify simple existing code??
- Code to edit code
- Selective Protection of a Worksheet
- Is there an easy way to replace list A instances with list B instances (sorted lists).
- SQL string to return top row
- Using 'SAVE AS' within macro with mutliple files and keeping default savename
- Function Library Creation
- Strip Alpha Characters out of an Alphanumeric Dataset
- Class module
- Populate array
- macro that copies controls
- Record Count (There has to be an easier way...)
- Automation
- Dynamic list box
- Display problems...
- Left three text characters
- Special Cells to Loop back
- Pre-numbered forms, I think its impossible, but...
- Problems with combo boxes
- UserForm ListBox
- Pattern Files
- new error when try to load userform
- Image on heder at VBA
- FormatProblem
- Why an error?
- Re: Activate new window
- Functions and Ranges
- Re: Activate new window
- Re: Optimize Time In Filling Cells
- Re: Functions and Ranges
- Help Please
- Re: Close Open Workbook
- Re: How do I make an open workbook the active workbook
- Re: Optimize Time In Filling Cells
- Re: Close Open Workbook
- Weird double selection
- Show user form
- Web Query Failure using url.CFM with xl97
- Access field order using ADO
- Putting text in a cell
- Far too many "IF"s for my own good
- Automate printing. Some help please!
- Excel data format problem (Urgent)
- Excel data format problem (Urgent)
- OLE Object -TexBox Properties
- Testing to see if a Workbook menu item exists
- Get the name of a group given the reference to a shape within the group
- Use "VLookup" function
- VBA code to open file?
- Error
- Macro for selecting a row
- Making output go to a worksheet
- excel project
- Autoload custom menu on Workbook Open
- Access values from another workbook
- Problems creating "line and bar chart"
- Printing Ranges
- Testing for a open worksheet from Outlook
- How to get column values from other excel file in VBA
- SendKeys command not focusing on the correct open program
- How do I read text file in an EXCEL SHEET
- VBA Script in Excel
- Interactive Macro
- Printing A Range
- User Form
- Export Excel data to Access Security problem
- Fix InputBox - Returning Empty String
- Regular Expressions in VBA & Excel including an interactive tool
- Routing Slip Question
- Name define
- ListBox Result to a Specific Cell Location
- Changing font size in row and column headers ?
- Subtotal + Conditional Format Question
- Offset not working
- assigning macros
- Formula
- Text importing problem. Please Help!
- Stripping out non-numeric values from external data source
- Get List of Keyboard Shortcut Bindings
- Insufficient Memory Error.
- Range selection code in a macro
- Protect sheet while enabling outlines and custom views
- Control Order on User Form
- VBA Names madness
- Padding Numbers
- Assigning Macro in another workbook
- Runtime error Permission Denied
- Disable Macros for Template
- Using With to speed up macro
- Printing
- error 57121
- Moving a sheet from a closed spreadsheet & making it part of an open one.
- Creating a List Box on the fly
- Excel to Access using ADO
- Disable item in combobox
- Excel XP removes AS part of statement
- combo coding
- Lines in a Module(Procedure)
- Using VBScript to create Excel SS and sort by column.
- Help? Inverse factorial?
- How to set multiple filter values for a filter in the page fields
- Name manager version 3 Beta
- Saving only current sheet
- Using a command button to insert a new row.
- XLSTART default
- Text in Formula
- Number format as condition for not deleting a line
- How do I return to newly created worksheet?
- how to create an outside border using vba
- Upgrade
- Need strip out data from column A using VBA
- Pick Several, Add All, Remove All
- Macro for creating folder
- Highlighting text in a textbox
- Query Problems
- Microsoft Queries - copying and changing criteria PROBLEM
- Task ID for App
- Constraining custom toolbars to one file
- Spreadsheet to calculate payouts in tournaments????
- Excel Macros Slow in XP
- Performance tradeoffs of complex worksheet functions vs VBA? when to switch to a UDF?
- save data , images and hyperlink between two workbooks
- Search, find, copy muliple cells from new sheet and paste
- copy range from one sheet to another - basic doubt
- search/copy/paste macro
- Try to change the path of the Query of pivot table in Excel 2000
- vlookup problem
- Extracting info from a database
- Update on Current Selection
- About RoutingSlip
- Load Windows Explorer
- offset problems
- Last cell with data
- Change focus from Userform back to Sheet
- Populating word document from userform inputs.
- How to stop Excel from accessing the net
- Inserting Module into Workbook
- Close Workbook Programmatically
- Determining Last User Action
- save picture in worksheet into certain folder
- Disable Events
- AUTO-CHANGING THE DATE
- Impoting a text file - Excel 2000 VS. 2003
- Worksheet Mailing Conditions
- FAQ
- How to refer to a blank/null value?
- Viewing built-in functions
- Only Show User Form Once
- Viewing built-in functions
- What does F1 mean???
- Start and end criteria macro
- Selection.ColumnWidth
- Problem to calculate cells
- Naming Chart
- Showing PERSONAL.XLS
- VBA and X10
- Saving button on all workbooks
- Incompatibility between Excel97 and Excel95 macros
- Attaching a macro (module) code to button
- On error goto 0?
- Check Selection
- Re: VBA/Macro Help Needed
- ListBox problem
- Print windows opened with FollowHyperLink
- Editing code
- Using a Varible inside of a proper address
- Budget System
- Arranging cells to create a database
- Compiling a macro as a .exe?
- Spinning Numbers
- Freeze/Unfreeze Panes and window display
- how can I read date and time from ascii file?
- Making a Msgbox popup
- Pivotitem count
- Bloodhound.ExcelMacro
- Combining variable names
- Progress Bar
- Tabbing to Checkboxes
- Concatenate different ranges
- Open up rows
- Problem with Excel 2002
- convert text to number
- Can I sort without activating / selecting sheet?
- Help to modify macro please
- List macros for user to select...
- Can't get the logic right
- User enters data in popup box - its entered into desired cell
- Input Box
- Determine if Workbook is Open or Closed
- Data sorting macro
- TotalEditingTime
- Passing parameters to UDF
- multiselect listbox
- New Product Announce: Convert Doc to PDF For Word
- summary by date
- Excel percent adding macro
- ChartingQuestion
- Selecting Range After AutoFilter
- User Form / List Box
- Linking textboxes to cells with formulae
- return values rather than formula.
- ComboBox or what?!?
- Installing Files
- Compile VBA code
- Addins
- Creating 'yes' or 'no' option in a designated cell
- Complicated Time Formula
- VBA question involving numerous additions
- PlotArea picture from wbk?
- Controlsource
- Installing Personal.xls on other computers
- defined name question
- Define a name question
- Changing Data and Charts
- Linking a workbook to an add-in
- Linking Cells to ListBox - How?
- Opening Excel in my program
- counting cell conditions
- Writing to System Application Log
- Time intervals below 1 second.
- Selecting a range
- save on leaving a cell
- change chart source from range to raw data
- SaveAs...
- Shortcut to toggle active Worksheet
- VBA online help script errore
- Excel 2000 Macro
- How can we share more projects?
- second combo box will be dependant
- find in access database
- copying sheet
- Exporting data
- show userfrom from another application
- Reverse of Hlook up
- Cells values included in personalized e-mails
- Introduction to excel programmin
- VB PasteSpecial when range changes
- Update VBA Module Code
- Macro to copy a range
- WRITING TO A TEXT FILE WITH SPECIFIC FORMAT
- String Question
- MARCO to import text by selecting columns
- File Not found
- Strip out data using VBA
- Workbook Path
- Cant find workbook
- If Error
- Q) Last row/column ------ excel formula query
- ignores hidden columns?
- cell number in collection
- Combining names
- PivotTable Dynamic Range
- Debug Error
- list Workbooks in Current Folder
- Userform and Worksheets
- More help on closing Excel.Application
- Undo Please?
- HELP WITH CHART SETSOURCE DATA!
- Keping a UserForm open as VBA runs
- Images and Userforms
- move the cursor to a button
- Asign Array Variant to Column
- Option buttons to select a row of cells
- if then clause in a cell
- auto format 5 worksheets out of 6 when opening excel spreadsheet.
- How to build build a macro that automatically imports>
- read Access table from VBA
- Creating formatted Outlook Msg from VBA
- Simple help with macro please
- Creating e-mail in Excel
- BASIC VBA QUESTION
- Sorting
- How to run a Sub while opening the xls file (what event to use)?
- Multilpe Checkout problem in Office XP Dev
- Spreadsheet snapshot in UserForm
- How to paste data?
- Macro to paste a copied range
- Finding column Letter
- How to enable multiple selection for combo box?
- How can I know if a sheet exists ?
- Loop
- Listbox
- OFFSET problem
- Differences in formulas using HTML between 97 and 2002
- How can I set encoding in EXCEL
- How can I set encoding in EXCEL
- How to determin a Excel file has Macro
- Determine if a cell has datavalidation
- Sql query on a range in the opened worksheet
- Sort buttons by caption?
- Checking to see if a Workbook is Open
- time
- Basic Excel Question
- count Worksheet using Wildcard
- Where can I find TAPI code/reference for VBA?
- Executing code with opening target workbook
- Executing code with opening target workbook
- How to check for next empty cell in list
- intersection? of two cells
- Defining a discontiguous Range object
- Search/copy/paste Macro
- read from 1 cell read to and other using vba
- An Interesting Excel UserForm Question
- Window's System Menu, can't remove menu
- Change VBA Code,Stock look up
- C++ Com Addins for Excel
- Report: Copying pagebreaks of a reference sheet to other sheets
- Macro recording box
- Offset & Combobox's returned Value
- Printing using Acrobat
- vb code in excel
- Detect Comment + Happy Christmas
- My Add-in causes problem with opening a file twice
- Performing code without opening the Workbook
- OLE DB Query Table to Oracle using Parameters
- ListBox Result
- Form will not refresh without an unneeded msgbox
- Set range statement
- evaluation of a cell with a formula
- Trying to import data from many closed excel workbooks into one: Please Help :-)
- Merry Christmas To All
- How to get out of loop ????
- Cannot Type Text Into Excel VBA Help Index
- export method not working properly
- how do i set an entire row or column to a range?
- excel2000-question
- Need help Selecting, Sorting, Autofitting a range
- button to update cell
- FileSearch using VBA
- Running a Macro Automatically
- Excel 2002 - VBA code to insert copied cells??
- Macro won't run from CommandButton
- excel97: runtime error 1004 select method of range class failed
- Top left cell in used range
- please explain
- dumb question
- Function and needing to Refresh
- A simple problem...
- Slow Down...
- pagenumber of active cell (vba)
- Funny shade of green
- Save As Boxes and VBA
- programming vba in vb
- Practical Excel Range Looping Project
- Spinbutton sorting
- Add worksheet
- RaiseEvent from a class contained in a 2nd class collection?
- DDE very slow with Excel 2002, repost
- VBA searching a row
- activecell offset
- SOS:Know Deleted/Inserted Range in Excel 97/2000
- passing a range to a user defined function using a form
- "Out of Memory" when import text file
- Right formating with an ident
- Spinning numbers
- Copy and Paste from One Workbook to Another
- can I call a procedure using a variable
- User Defined Function description
- fso delete folder
- How do I figure out what I need to do....
- Manipulating text - 2 queries
- Proper Programming
- Pop Up icons
- Margin of Error Formula
- structure of classes,objects,properties,methodes,events...
- Formatting a workbook for database import
- FP2000 Publishing problem
- Excel VBA Examples ( Book or Program)
- Excel 95 Dialog -> Excel 2000 Userform
- Delete modules programmatically and save
- Trying to find string in a column or row
- Re: Highlight non- contiguous rows
- Define a range globally
- Remove Save Button from toolbar
- Help on closing object properly
- Argument with onAction in a menu.
- Many Sub Worksheet_Change(ByVal Target As Range) In One Worksheet
- Find / Replace / * -1
- Calling Bubble Sort Function
- Highlight non- contiguous rows
- Range Search
- Status Message
- reference new sheet in same workbook
- Run code from one worksheet to populate another.
- Exit Sub?
- Macro for worksheet to workbook
- How can I ?
- Templates Ignore Protection Settings
- Method selection of object _Global falied
- Chart Setting Xvalues
- XL97 - Command Bar Removal
- Flushing a File
- Footer word wrap
- Capitalization in Declarations
- Help printing to PDF file
- VBA application; Subscript Out of Range
- close window trapping
- Passing a named varaible to Excel's Autofilter
- "Enter"on keyboard problem
- Chart created in VB generates 2 additional meaningless series
- Counting names in a column
- Moving Rows
- SaveAs Macro Help?
- Cleaning up data
- Index / Match - desperation
- Run a macro when cell changes (due to calculation!)
- Passing Selected Sheets' Names to a Macro
- Searching range for value (code written but needs 'tweaking'!)
- How to disconnect when WebQuery done
- unknown combobox name
- Range objects (?)
- Surveys
- Close Open Woorkbook and Quit Excel
- copying and renaming sheets
- Attaching cells to word documents
- multi tab selection prohibition
- Retreiving info from a web page table
- DDE very slow with Excel 2002, 2003
- DDE very slow with Excel 2002, 2003
- activecell.formula syntax
- ADD-INS NOT WORKING IN XP WHICH WORK IN WIN 2000
- Locking cells in Excel
- Assigning Macro's to control buttons.
- List boxes, Arrays and Sorting
- Finding a date in a sheet
- Highlight Track Changes with VBA Code?
- dot 2 koma
- EXCEL FORMULAS
- unknown menu appear when installing an AddIn
- Excel Formatting
- Help in VBA programming
- Summing undetermined colums
- Finding the name of the pagefield clicked
- Excel & Custom Menus
- Programming help
- MsgBox Question
- Image set transparent becomes opaque on clicking it
- Delete Macro After Running
- Limit entry in range
- How to create transparent objects on images in Excel
- Working With Worksheets
- Make 2 long columns into 8 shorter columns
- registration
- AutoFit Selection
- Is there "pointer to a function" in VBA
- Vlookup to Access Dbase
- How do you combine lists
- Setting Conditional Formulas
- Moving a file
- enable / disable macros
- WHY?
- security for my macros
- Variables and range problems
- Disable save, but not save as
- Copy and paste isn't that hard (is it?)
- Deleting blank cells in a selection
- Run-time error 1004
- Open a new instance with a shortcut
- autofill range
- Automatically run macro when opening file
- changing the application name in the title bar
- Running Macros
- Help needed (idiot onboard)
- Longs losing accuracy
- macro code for sending e-mails
- Macro Question
- Changing the Style of a Combobox Via It's Name
- Cannot type text into VBA Help Index
- Random Selection
- Macro Question
- Memory Leak
- Fixed Width - Opening Certain Fixed Width Files
- File Path Problem
- Conflict
- Working with ODBC and filtering data
- auto-launch a MACRO?
- Disabling Selection of multiple worksheets
- Problems with a Form's behaviour
- simple excel VBA programming
- Excel crashes when .Net framework installed
- Loop within Excel Formula?
- String Manipulation
- VBA Editor SetUp
- Trouble with Excel Charts
- Deleting series of repeating rows
- Newbie: How to Print by VBA a Single Page in a Worksheet
- Syntax to define a variable for current file
- vba code to sort data?
- PDF
- VBA beating me up.....again
- Multi-column Combo Box
- textbox - format for dates (mm/dd/yyy)
- checkbox - default checked or un-checked
- Autocorrect in VBA
- Use VBA to replace 2002 by 2004 in Date
- Enable and disable worksheet controls?
- Username
- Delete Specific Range Names
- attach custom toolbar to spreadsheet: how?
- Charts
- Code Tweek Needed
- Insert Page Break in the Worksheet
- Re: variable name based on calculated info & iteration formula
- Security...
- Passwords
- Comment
- Feeding Date Values From C++ Using Automation
- CheckBox values
- refresh of screen -- commando
- Text Boxes
- Does anyone know how to do this?
- Linked worksheets
- Problem with named Range in ADO extract from Closed Excel File
- Excel Crash only if VBA not open
- Concenate (Kjede.sammen)
- refresh van uw screen commando
- How to use macro to enter password?
- Underscore in Excel Title Bar
- Group Function on a Protected Worksheet
- Refer to Hidden Sheet from VBA?
- Extend Excels range
- INDEX MATCH
- Opening a file
- Excel Macros Getting Cleaned
- Reference oleobject within shape group
- running macros in downloaded files
- Protection lost on Open
- Engineer calculations
- Before Right Click event
- Is there an easier way to address ranges??
- Macros in Template
- SpinButton Rounding Up
- How to find the current pagefield of a pivot table?
- Universaly available macros
- Excel as RTD server?
- Please confirm the following bug in Excel
- VLookUp.
- Browse Button for File Save
- Disable the Edit menu command 'Paste Special'
- Why doesn't my loop work?
- just copy the data, not the fuctions
- PasteSpecial macro
- Run time error
- re Password Change again
- Setting Cancel = True in WorkbookBeforePrint
- Advance Filter
- Enum
- spinbutton.enabled = false not greying out
- commandbar with own textfield for datetime input ??
- Conditional Sheet Attachment
- Worksheet Code Expansion
- List Box on worksheet
- Protect Destination Formatting
- Pivot Table question
- Excel 2000 Chart & VBA: why oh why?!?
- Re: passing strings
- input template
- Before right click in a sheet
- Find and replace '
- password change again
- Bank reconsolidation/Transaction Matching/OS List
- VB scripts from Office 97 that no longer work in Office 2003
- Sheet naming question
- Excel VB, Workbook.activate
- Outline Performance Degrades
- Printing a user form landscape
- Calling from C#.Net App Office._CommandBarButton.Execute() method in Excel 2003 throws a COMException
- Vba code
- Pastespecial via vbscript not working - REPOST
- Pastespecial via vbscript not working - REPOST
- help button
- Date Highlighted on Calender Pop-up
- Re: How to Get records from a query in access and put them in Excel
- get filename and filepath
- Slow Looping
- Question about VBA?
- FileSearch gives unexpected result
- using ranges to determine input
- Workbook_BeforeSave
- Re: How to Get records from a query in access and put them in Excel
- "running..." message
- Email a sheet code modification
- Populating sheet names in combobox
- User Form
- Setting range of cells format to currency
- PDF
- Delete Entire Row.
- change password
- Compatibility with older versions of Excel
- copy down to all Vlookup "#N/A" cells ONLY (in the same column)
- Switch images in VBA
- Re: Expanding Code
- Excel VBA - Web Query causes Excel to run out of Memory
- Re: Expanding Code
- Expanding Code
- Transferring ranges to/from arrays
- Re: Creating regressions with more than 17 data points...
- Re: Trapping warning message
- Screen off during Macro execution
- Code malfunction
- Amount of code in UserForm
- how to make sure the file is saved on a network
- combobox matter
- Changing "Cancel" in SaveAs
- CustomDocumentProperties
- Printing worksheet
- Macro in Excel
- HELP - How do I disable Excels menu items so others can't use
- modify cell references in a formula programatically
- Re: Time Calculations that roll past 24 Hrs
- Looping
- How to get Control M to move cursor down
- Re: Time Calculations that roll past 24 Hrs
- ListBox Question
- SubScript Out Of Range.
- Re: UserForms to deactivate workbook
- Stop open file through Document Property
- Named Array
- Updating worksheet problem
- Duplicate sheet error handler
- Variable scope question w/combo-box, 2ND try
- Running external programs
- Excel file
- Re: Excel Gurus = want a macro in 1 workbook to get info from another workbook = Read please
- Re: Worksheet Position
- Re: Worksheet Position
- >Message unavailable
- Re: Updating links
- Need some help
- Is this correct?
- Disabling Screensaver
- Excel VBA - Web Query causes Excel to run out of Memory
- Creating small "recordset" or sorting a numeric 1-dim array
- ColumnWidth not working...
- passing strings
- Excel schema using Jet OLEDB Provider?
- "Multiple-step operation generated errors"
- Pastespecial via vbscript not working
- Calculation Options
- formulas refer to columns that are deleted
- Automation and Add-Ins
- Work schedule help
- UserForm
- variable name based on calculated info & iteration formula
- ODBC errors with new pivot table
- excel macros
- On Paste
- Office 2003 not able to run wscript??
- Turning Colored Cell's Off
- Another little ? on CommandBars("Cell")
- Clear contents of row but preserve formulas?
- Cycle through a list (Part 2)
- Excel VBA and multithreding
- Weighted Average Question
- Forcing users to enable macros
- Excel to Access
- formula?
- specifying chart size
- Preserving Previous Formula Values
- FollowHyperlink
- What's this button?
- vba for excel
- Command for recalculating macros
- Transposition of data
- CommandBar("Cell") additions
- How to find out how many rows do my collumn have?
- Conditional Formatting script
- Excel and Windows Eventlog
- How to determine if instance of Excel is running
- Routine??
- delete rows with certain condition
- Userform and checkbox....
- VBA Index / match type formula copying formulas, not values
- How to insert a lot of values into cells?
- concenate or vba or sql
- Question about using AND or OR with If-Then statements
- Close second instance of excel
- Can this be done in Excel?
- Find text and remove row
- Excel 2000 Web query not returning all Table Data
- Sub Error with Sheet Protection Enabled?
- How can I get the worksheet name use micro function?
- How to check a Variant for its data type
- DB query syntax
- Find all formatted cells
- Macro Runs if Template name is .....
- Decimal Symbol
- External data query - need to use SELECT * (ALL RECORDS)
- show message
- how to specify the filename
- macro in excel to copy from excel to word
- Stepping backward through an array
- Create a HYPERLINK with a macro?
- Use Your Brain
- How to split text?
- New to this thing
- Use Your Brain
- Renaming Sheets in a workbook
- Define Range in Deleting Empty Rows
- help me...
- SaveAs and relative path
- Application.Close
- Send Sheet as part of macro
- Urgent info. on opening a mail merge with the datasource open
- Validate Appointment Times?
- alphabetic order
- How to change international decimal separator
- Scrolling a lstBox automatically
- deleting array element
- Run Query w/Function from Excel
- Sheet module VBA not copied
- Paste Code
- Creating properly formatted text file from vbscript using excel data
- Adding new rows to spreadsheet
- Range selection in a sheet module
- Easiest way to add functionality to ALL Excel spreadsheets
- Filtering for exact text
- Getting data from web site to excel
- autorefresh display autofilter criteria question
- Prevent Locked for Editing on a network
- bulk mailing problem
- ScrollBar1_Change() problem
- Can I edit .iqy file from code?
- "Out of memory" when running a Web Query
- "save as" macro
- lock out menus?
- how to validate a combobox?
- Pass a filename to a query
- Formula Modification Needed
- checking value in column
- Activate Workbook in Separate Excel Session
- Formatting of workbook window
- Macro Ceiling & Floor Calculation Problem...
- For Loop in Filtered List
- How do I delete ExternalRata range names?
- run macro in book1 from book2 - how?
- Word Search from Excel results in Duplicates
- Calculating number of days in month
- time/date formatting bug
- Rename wrksht tab from cell info w/Macro
- setting a chart size
- copy without formulas
- Import PDF information into Excel
- Directory browser in Excel VB
- Converting file formats
- Padding out reference numbers
- How to concatenate a range?
- Run Query w/Function from Excel
- Scroll selection into view
- auto enter date in cell on data entry in row
- new comer problems
- .CurrentRegion in Excel functions
- Go to record found by Criteria in Data Form
- For | Next ...OR... Do | Loop
- Howdo I password protect a list entry
- Check status row (hidden or visible)?
- followhyperlink
- Deleting Sheet
- Declaration?
- Check for Excel version before running?
- Invoice autonumber with mulitple number sequense
- Calling up a specific Help topic?
- comparing text
- Accessibility of Custom Functions
- Problem in activating a sheet
- import CSV file at location D7
- Counting items
- erasing checkboxes
- Help with Sorting tables
- Runnig a macro when excel opens
- Find a certain word in excel and select the cell
- How to code a timer to trigger a sub-routine ?
- Problem due to password
- Open Html file i Excel
- Office Clipboard: Clear all with VBA-macro?
- excel caused an invalid page fault in module excel.exe 0177:3003b3fd
- Unspecify Error in Range count
- Disabling Ctrl, ALT keys
- open excll from network
- Loop across Sheets and number of sheets
- Missing Numbers
- vbAccelerator sGrid control- spacing columns.
- Random Number Generator
- Connumdrum #2
- Connumdrum #1
- Type mismatch while running If statement
- Transposing numbers
- Best Way Question
- mass changes in formulas
- setting row in macro
- Excel Basic
- calling an Excel Add-in application
- Anyone successful taking data into Quickbooks?
- Help with this Find code please
- Macros - Range Selection
- Array Formula Question
- Import .BMP File From Web Using VBA
- Turning Off Cut & Copy in a Workbook
- Excel version comparison
- Format Cells ?
- Create Worksheets Based Upon Changing Column Values in XP
- Resetting variables
- Macro for dropdown
- bottom right cell on screen
- simple help needed please
- Close VB in Code
- ENTER key
- UserForm Result Posting
- Form display errors
- Editing Query Parameters
- Converting Range.value(error)
- URL String
- Excel 2000 VBA Question
- Creating a new Excel Addin
- setting cell contents to text using C#
- Find and Replace Data from one into another
- Display Saturday's Date
- Sub A1 Line Malfunction
- SQL.REQUEST - controlling refresh frequency?
- Copy Rows to Existing Worksheets
- using vlookup, but error #N/A
- Help with getting rid of unused cells or ranges
- RegisteredFunctions in C# fails when trying to get the list of addins and function
- Macro to insert hyperlinks
- Excel Shapes
- coloring a tab
- Problem with Find function
- Printing fixed columns and rows
- Dynamic Creation of rows in Excel
- ADO from Excel to Access
- Restore toolbars
- VBA conversion confusion
- Format when opening .CSV file in Excel
- Can you save an external macro?
- change a macro so that it copies and pastes data as values rather than references
- Summation of rows
- I have posted this message before but did not get any response can anyone help me?
- Call a macro in other workbook
- RTD Server disconnectdata
- check 2 speadsheets for diference
- Autofilter across Worksheets
- print a form landscape
- Log File for Excel Spreadsheet
- How to open a merged word document
- html tags with a cell
- Excel the best!
- MVP Challenge. Erratic Userform Compile Error
- heure
- Seperate numbers from letters
- Comparing two rows
- Restricting access to workbook
- Moving the Active cell to the left of the screen
- How find character position # in string from right end? Or how get range row num
- conditional format for vb code on pivot output
- ADO and Checkboxes
- AddInError Excel97 --> ExcelXP
- Please Help
- Creating "Plain Text" mail message in Outlook from Excel VBA
- Email Text Message
- Canned VBA Date Validation
- Add In Locations
- Cycle trhough a list of names
- Outline numbering in Excel?
- Autosorting and working out medalists for data.
- Using GetSaveAs
- Copying a selected prn file to printer.
- rows that dont want to be deleted!!!!
- Chart "Automation"
- Start macro on cell change
- Change the appearance of a built-in menu
- Test a file to retrieve format
- Change from a sum reference to the number
- Changing font size, bold and underline
- How to force repaint of popup commandbar?
- Copy selected columns only
- Excelmacro - Office -97 --> Office XP
- POJSDF
- How can I use a worksheet while running a userform?
- Help on cell formatting
- Worksheets and arrays
- Calculating a range in VB Excel XP
- Pie Chart formatting
- unable to set the colorindex property of the font class
- Excel Object in VB when running under scheduler control
- Create a new menu in VB
- Code to hide rows based on cell contents
- Help ('IF' Statements) Please !!
- Sheets ("").Copy not working
- xlR1C1
- Shortcut key
- Open a XLS from a Module
- Problem opening a komma separated file with Excel 97
- control in excel 2000 does not work any more under excel 2003
- Marco vs Lotus Note
- Acquiring filenames for multiple files with GetOpenFilename
- Autofilter and protection
- SendKeys problem
- Paste Error
- Email Attachment from Excel using Outlook.
- excel - count sleected items in a listbox
- FileSearch Hangs Excel
- Creating a MailItem in Outlook from Excel using Late Binding
- Macro not with a file
- VBA code need help on CopyPaste
- Use SUMPRODUCT to find duplicate rows (not one column)
- Dget in VBA gets Object required run-time error?
- Extract row based on a criteria
- Really Dumb Question
- printing and groups
- Input Command with Mainframe file and multiple variables
- How can I optimize this code?
- Help in conditional SUM
- For each loop
- Problem with logical sentence
- How to get right URL for a Web Query
- Help appreciated
- Possible to write Excel macros in JavaScript?
- Fill down range
- Copying and renaming worksheets
- Where is my syntax error?
- sending email within a macro
- saving .prn with more than 240 positions
- parameters in treeview
- Disable selection of shapes
- vb script to add names to tabs
- running macro upon a spreadsheet's startup
- insert 'x' number of rows???
- need help to for macro
- parsing words in a cell separated by commas
- Rank and Cell colour
- saving .prn with more than 240 positions
- Deleting data from Shared workbook
- This does not work: Range("A1").Select
- VB
- Inserting Functions
- Add Sort button
- Why Prompted To Save Again?
- FindMethod 2 col range
- ComboBox - Excel
- breaking out of a loop
- Help with setting range limits
- how to get hwnd from application object?
- running a macro saved as a string
- Excel Macro
- Adding icon to standard menu
- Set the elements of an array vertically to the cells
- Excel Help
- Urgent Macro help needed
- UCase in textbox, help
- Run time error 2147417848(80010108)
- Calling sub programs
- Inserting blank rows
- execute a macro from another macro
- moving folders
- Getting Window Owner in .NET
- MS Query Limit results
- Forcing Date Entry
- Need help with VB code for saving cell data
- Matrix Multiplication Function creation
- aligning entry in text box
- .Net and Excel
- Business hours calculation
- Column-replying macro
- Controling a dialog box after I've selected the datasource
- Help with IF statement
- Re: How do I Delete Lines from VBA Array?
- Macro to only change selection
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.