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 |
- How to set variable to nothing
- Dynamic Outlook Form with Access as datasource
- Interactive Excel Web Page save updated data
- changing font colour of row when cell contains date
- Print Several Pages as One Job?
- Difference between .text and .value of a textbox
- Cells.Find > error Object variable or With block variable not set
- Copy entire file using VBA
- Function/VB Code for finding pattern blocks in number sets?
- VBA - inserting text as link (email to)
- 2nd attempt at excel VB commands
- Check to see if variable is duplicate.
- Excel Constants for maximum number of rows, columns?
- Text Box Link to Cell & Reviewing Toolbar
- trouble returning a workbook level Name object
- Save As
- Re: Can a macro write a macor
- Using function from vba add-ins: looking for a solution
- So close yet so far - combining workbooks
- How to disable an other subroutine temporary?
- Excel 97 Pro: VBA5: Illegal Error
- Inserting dates in a worksheet
- Conditional popup
- functions across sheets
- Repeat Entries
- Correlation of Variables
- Re: Move Folder Contents
- Add bold font to Totals row?
- Users on a Shared workbook
- Date Filter?!?
- Return US State Name or Territory from USPS Abbrevation - an example
- Can a macro write a macor
- New Main menu item
- Auto opening macro when loading a workbook
- Re: Visibility of a command Button
- Re: Bummer2
- Re: Visibility of a command Button
- Workbooks.Open doesn't open file in ThisWorkbook
- Displayed value in a combo box
- Visibility of a command Button
- Multiple column listbox syntex question
- Inporting data from a group of .prn files
- Disable sort function
- Re: Conditional Formatting a range of cells
- Re: Conditional Formatting a range of cells
- Copy file and closing original
- Open workbooks with different names
- Code to Print to certain Printer
- Can You Query Specific Access Records from Excel?
- Better code needed
- Check if a directory exists and if it doesn t...
- Ftp an html file generated by an excel macro
- newbie question
- Bummer
- I know VB, but how to use in excel?
- Excel Macro & Virus
- Data management error?
- Can ActiveX controls be "disabled" and "enabled"?
- HELP!!!
- Detecting If An .xls File Exist
- Automatically Insert Sheet
- Delete Shapes
- Cells as customer footers
- Limit printing to certain 'pages' based on value
- More 1004 Errors...
- CountIf: Syntax and Examples?
- Opening zipped *.xls from Excel
- Does Outlook interfere with Excel memory assignments?
- ActiveX control name change?
- merging
- a funny problem
- Formatting returned value in TextBox
- Conditional Sum Help Please
- VBA Worksheets() term
- Apply VBA function to multiple excel files
- mailing new workbook in VBA 255 character problem
- Modify date of a file via hyperlink?
- Re: Custom Menu
- Populate combo box for Userform in Excel 2002
- Find duplicates
- EASY - Excel VBA Problem
- merged cells problem
- drop down list sorted and selected by first lette
- Hyperlink problem
- listboxes
- Web Brower control question
- Cut the umbilical cord? Access connection to Excel
- BeforeUpdate event for Combo box
- CutCopyMode = False
- OnAction to show a userform
- conditional formatting under a condition...
- returning a spreadsheet from code - ASP, OO4O Oracle Database connection
- Setting OnAction of custom menu item?
- Compile error using Call
- How can I improve the find method?
- Changing a chart source data in code.
- referencing another workbook
- Help: How to Get Fields Mapped (using .Net ?
- display quarter and fiscal year
- Passing Execution Control Between Workbooks
- API to draw borders
- New Menu/ toolbar distribution
- Replacing instances in word with data from exel
- Hey Bob I mean Don
- Weird VBA problem
- Can you turn Conditional formatting off in macro?
- counting spaces in a string
- Conditional formatting not working!
- Listing macro categories
- Changing the text in the top excel window bar to display your own. (Tip & Question).
- CumulativeFunction
- SaveAs and Replace File
- how to add a combo box in to a excel cell using VBA dynamically?
- Delete Entire Row in Excel if specific column does not contain a 7-digit number
- Averaging in VB
- AcitveX with admin rights only
- Screen Tips
- Frustrated - List Box
- the vba book
- Add-in help files - where to put them
- dynamic ranges getting invalidated
- Listbox's and retaining data when closing
- Excel VB - Macro for mixed fonts
- autosave workbook
- generate chart with excel
- Invalid Name in Macro
- Creating a CrossTab Report using data in variant
- Deleting a negative sign from an amount in a list (not trailing negative)
- expanding IF
- count days between dates
- Excel & MS Sql
- VBA macro easy problem!
- Open a File "Quietly"
- Making A Nacro To Change The Contents Of Many Cells
- Can xl 2002 not have multiple icons on the taskbar?
- Retrieving a deleted module from VBE in Excel
- referencing a named range using a variable
- xlFill
- Validation through VBA using string has 255 char limit??????
- Excel: Paper Page Width
- Close without save
- .AddComment
- VBA Password / Program freeze
- How to hide pre-defined columns at the touch of a button
- spin button
- search for date fields
- Adding a border to a jpg image
- Sheet tabs with Date and Time
- chart menu bar vs worksheet menu bar
- SelfCert.exe error
- Create an EXE from a spreadsheet?
- Create an EXE from a spreadsheet?
- Combobox Selection
- work with strings/numbers and dates
- Sending an email to more than one person.
- Is it possible or is it impossible?
- Re: VBA Question - Canceling a 'Save As' command from a user form
- Sorting embedded fields - control box
- Combo box help
- Prevent adding rows
- Automatic Percentage Calculation
- Error 1004, "select method of range class failed"
- Search Page for Inventory Workbook
- Embed Excel Spreadsheet inside an HTML page(IE)
- speedy way to set values in a range
- variable range definition
- Specifying cell reference relative to active cell
- Userform Close button
- Please Help.. copy,formatting issues
- HLookup function question
- Creating a new workbook.
- Printing multiple sheets.
- Drop Down Lists with "variable" ranges?
- Re: how to disable a macro by calling it from another macro
- Filtering Text File Import
- Pivot Table Question
- VLOOKUP in textbox
- Re: VB error message
- Summation
- Re: custom menus
- Automatic updating
- turninf off macros
- Custom Functions
- Pivot counting error
- Re: Sub-Totals within timescale
- Form/Listboxes -- problems
- Help with "Autofill" Destination Range
- Capture mouses X &Y position on a worksheet
- Re: Sub-Totals within timescale
- Re: Saving Information on Userforms
- SQL and Excel
- Select in Listbox using keystrokes
- Data Series
- Re: unassign a macro from a graph
- Calculating times under the second
- Multi Column Lookup
- Re: Printing Sheets that only include data
- DAO text database
- delete blanks
- Search Box & Button for Workbook
- Hyperlink problem
- Macro to search from one file & place on another file.
- Create toolbar with VB (notVBA)?
- Count of all non empty "records"
- Using VBA, how to write unique solutions only?
- Re: Sub-Totals within dynamic times
- Make a column two columns
- Re: Check if a range is a sebset of another range
- Deleting worksheets containing ActiveX controls
- Problem with ADO with Parameter Object
- Copy Recordset into array?
- ADODB
- Re: Check if a range is a sebset of another range
- Re: Make a column two columns
- Excel VB
- User form manipulation
- Challenge
- Date and Time
- Re-create source data from pivotcache
- Closing Excel down with a macro?
- unassign a macro
- Scheduled task hanging
- Static Variable
- Excel97 CopyWorksheet Problem
- stop calculation
- Copy range without changing sheet in view?
- Coloring Cell if Data is present
- Calculating Time
- Prompt For User Mouse Input In Macro?
- Wrong Macro opening
- center picture over cell-Help
- sort of mail merge in Excel
- Copy Cell Data from one Worksheet to Another
- Opening Word Ducuments From Excel Macro
- A hundred of series in a xlScatter Graph.
- Save values only before save
- Select pull down menu
- Disable Access to VBA Code in XLS File?
- Pivot table - Ghost data
- Rearrangement of reported data
- Input box to formatting????
- Printing Worksheet only if data exists
- File in use by ? WHO ?????
- Novice in exel macros needs help
- % and $ formats in excel
- Option Button Quickie
- Finding difference between two cells
- Save .csv file. Decimals separated by commas
- Code-signing certificate problems in Excel 2000 with Windows 2000
- Incrementing a receipt number in Excel 2003 VB form
- Application.Undo Problem
- Problem with Microsoft Query
- How to interpret a path to another workbook and use in formula bar
- Help needed, Input box doing 2 tasks?
- how to consolidate list of qty under within date columns
- Counter
- Re: Formula
- Send link to Excel spreadsheet
- Using Excel as a Server for Web Application
- Avoid Deleting a Shared Workbook using VBA
- Date problem
- Unhide sheets based on NT login
- Chart window - excel
- Round problem with sorting
- return from subroutine
- date...
- very urgent
- Checkboxes on a Shared Worksheet!
- XLA help files
- Copying VBA modules from one workbook to another with a macro?
- Macro to format selected cells
- Question about saving a *.dbf file
- Open/Close files from Hyperlinks
- User forms
- merging two excel spreadsheets into a new one
- A Challenge! Can you handle it???
- Error 1004 help
- User Form maneuvering
- Why can't create Excel.Application using CreateObject?
- VB6 + Excel Objects 8 = 100% CPU on Win'NT
- Hidden hyperlinks giving me a problem...
- Change Icon of a Shortcut with VBA?
- WinXP: Solver: An unexpected internal error occurred ...
- How to copy data from excel to Word? Thanks for your help!!
- Export Picture
- Re: open with full screen view
- First and Last cells with data in a range
- updating paths to linked files
- Protection
- File Open Macro
- Re: InsertRowsAndFillFormulas
- Re: InsertRowsAndFillFormulas
- Userform - VBA Programming Question
- Area Charts, area colors and series
- Using a function from a vba add-in: is that considered an external link
- Code compiles but Excel ERROR
- deleting worksheet
- very big problem..Who can help me?
- How to position form in same place with different screen resolutions
- How to hide a workbook and to detect a hidden workbook in visual basic
- Macro Close 2
- Referencing Macros
- Application error with VBA code
- Send email with Lotus Notes
- Count Print Jobs
- Pivot Table Page Field
- Cell reference question
- Unique Excel Web Page / Macro situation - HELP!
- Excel Pivot Table Problem
- Here's an interesting one...
- Illegel Error on a Function Call
- Printer Dialog Box
- Array Help?
- Importing CSV file into Excel
- Which graph?
- Re: Color rows
- Thanks!!!!!!!!!
- Irfanview
- How to specify a Range which includes an integer variable
- Close Macro
- external file counter
- modules that run modules
- DDE Troubleshooting
- Copy rows and paste to new worksheet
- Reference Library
- Run time error '-214741848 (80010108)
- Do you give memory back?
- slow sorting worksheets
- Specifiy Printer (Location/name)
- Print to PDF with given filename
- how to enter 'CTRL-SHIFT-ENTER' in vb
- Dynamic Range Selection
- Excel 2000 Web service programming help
- Sending an email from a macro
- Replace first part of SS# with x's (XXXX-XX-9999)
- Issuing DOS command in VBA macro?
- Populated Cells In A Named Range
- Re: Creating Loops
- Save file as text pipe delimited
- Re: Find and replace thousand of cell values
- I'm looking for a macro that opens directly to the Pivot Table layout
- Program Files Folder
- Adding a border to a jpg image
- Print Setup
- Custom validation criteria!
- ActiveX Combo
- why this code doesn't work?
- declaring active cell inside a for loop and offsetting from it
- Printing in a list box
- Viewing PCX Files
- set up page numbers
- Calling Procedures from another excel sheet by passing objects
-
- Loop through cells
- Selection.Sort not working?
- Last Cell Code
- Re: How retrieve GUID and Document Properties
- Directory Search
- FormulaArray..... HELP !!!
- userform variable as global
- Running a CommandButton in Excel I get this error
- Run Macro on cell exit
- Re: How retrieve GUID and Document Properties
- Using User forms to enter data into lists
- Imports
- Re: Focus on Control before UserForm(s) pop up
- returning a chart series formula
- Declaring arrays
- autonum field
- Latest 24 hours avarege
- Insert Picture in Worksheet Question
- data validation problem
- Create CheckBox from a row
- Why Loop only happens once? Baffles Me...
- Excel Macro sharing
- Help needed selecting left cell same line
- Guru Challenge
- conditional formatting formula
- list ODBC source
- Colours
- If Debug then end with msgbox
- Minimizing Excel from a Macro
- Where to get a visual tree-like object like the one used in the watch-window?
- How can this be done?
- Automatically transposing
- How to create Dynamic interrelated ranges in excel
- Another last cell detection problem
- Excel2000 VBA problems
- Identifying Excel version
- Searching for worksheet
- Send Excel File With Outlook
- How to escape the Workbook Save?
- Automatic importing of a macro
- Open Access document whilst in excel
- Preventing Excel opened through webbrowser "taking over" other instances of Excel
- Finding all Similarly Named Ranges?
- Print macro for Excel 2003.
- DATE Functions???
- Copy Values, not formulas
- Validation
- Use of Offset Formula - problem with blank data
- short cut
- Cell validation!
- Undo button
- Use file-status in IF ... THEN
- Characters Object limitation?
- Is There A "Choose Cell " Event?
- Calling Alert message!
- Automatic Dates
- Read in Array
- Drawing a semi-circle in Excel
- how to know the column/row of a selected cell in vba?
- Disable shift from ignoring autoexec
- macro and button to open a word document from within excel
- Olap Pivot Table
- External images
- Excel AutoFill
- Another Time Calculation Question
- Data comparison
- Protection
- How can I skip a (Sub)Folder in a Scan?
- For and If Then loops, and remembering a value
- Set value for range of cells!
- ocde in a different workbook
- Saveas
- deleting data in vba array
- Sharing Workbook Nighmare
- Changing code with code
- Font color
- Dates test
- Relative Reference
- lock tabs
- To number/print pages
- Don't prompt to Update Links
- How to prevent links to ouside sources?
- Sheet Tab options
- scroll bar incremental change size
- Control Cell Link for Option Button based on value in a cell
- Creating a Macro
- Put Autofilter in VBA long to run
- Selecting worksheets without hardcoding
- Question on using Form's Button in Excel
- The "i" prompt when opening a worksheet containing links
- Re: Selecting worksheets without hardcoding
- Help with Excel
- declaring varibles looping probelm
- Max Row height
- Quick Pivot Table formula question
- L14=total, if P14="text", L14=0
- Re: linking sheets
- Re: Question Re: "Save As" dialog box... (-:
- Re: avoiding duplicates
- Re: Question Re: "Save As" dialog box... (-:
- Fun newbie stuff
- help needed offsetting until text
- Protecting cells if they are not blank?
- Recording macros
- Graphical plan
- Copying Sheets with Option Buttons
- Excel VBA
- option buttons
- capture text typed in Combo Box
- data disappears when I press F2 to edit
- Protection + Macro = NOTHING!
- Convert Chart Series Formula to Array Via VBA?
- Dynamic macro parameters
- Count Visible
- URGENT! Find and delete row macro
- macro protection
- empty clipboard using macro (vb script)
- Sheet Naming, and code trimming.
- Responding to prompts automatically
- Need code that requires password every 120 days
- Printing macro error
- Removing invalid characters from proposed sheet name
- Deleting macro
- VBA - Option Button
- Re: Does RangeFromPoint Method return ranges?
- Re: Workbook Open macro/& Pivot Table Calculated field query
- search formula for 1st space
- Printing multiple ranges on one page
- Search function for a workbook
- Set cell value!
- Re: HOW TO: Get cell address from a range
- Filtering
- Re: Workbook Open macro/& Pivot Table Calculated field query
- Workbook Open macro/& Pivot Table Calculated field query
- Overwriting a file automatically using saveas in a macro
- coppying nested if statements
- Macro speed - SLOW in 2002, FAST in '97??
- Re: HOW TO: Get cell address from a range
- Re: Is it possible to insert an Access Table object into Excel?
- Re: AutoRowHeight refresh after ScreenUpdating suppressed
- Textboxes on a worksheet
- RE: Quotes
- Treeview Control populating
- Can't get Excel SaveAs dialog to show
- linked cells
- Quotes
- Is it possible to insert an Access Table object into Excel?
- thanks Dave Peterson
- text comparison
- reset a pivottable
- Set Focus on Control at Creation in Dialogs, I mean UserForms
- Comparing lists nad printing new/ old in a list box
- VBA - No Duplicate Sheet
- Excel Ranges
- creating a master sheet that totals values from other sheets
- Silence cell movment during processing...
- ctrl-end in VBA
- Why does hasarray return null rather than false?
- Reling Pivot sourcedata to network drive
- Re: Pivot Table Totals
- modeless userform
- How to find the cell given x and y worksheet coordinates
- Option button controlling text box
- How to check for availability activeX control
- CHANGING PRINTER DEFAULTS
- #REF error
- Userform animation
- No events when changing the color of a cell
- replacing Offset with []
- Exceeding the maximum of 30 arguments of functions like STDEV
- Xla comparison source
- Workbook Last Write Date Time
- find the possibilities
- redim of a double dynamic field
- Invalid picture Error?!?
- Module name
- splitting a cell into 2
- UDF, dependency sequence, IsEmpty() & Multi-areas ranges
- Adding Pivot Tables Dynamically
- VBA to change excel caption picture
- Re: Cycle Number Lock
- Accessing result of sort
- Setting a reference to an object library - do our customers have to do it too ?
- Text Box Currency format with two decimal places
- Start A UserForm By Entering A Cell
- Control Cell Link for Option Button based on value in a cell
- Adding a Custom Toolbar to an .xla, not to Excel globally
- What to Charge for Custom Programming
- urgent
- Merging a number of rows
- Worksheet shakes like Rock n' Roll - A command like Cells_Change would have been nice
- Help Vlookup from Validation List
- Need help with data from coding....try to create an update button
- Reference spreadsheet rather than table name
- Is Array Empty | Boolean Answer
- Using multiple user forms to perform Calculations
- using array with Windows().activate
- array use problem
- pivot table error:Cannot open PivotTable Source file!!!!!!!!
- extract values
- Column width fixing
- named ranges, I think
- Macro to Change Sheet
- Assign values to a cell in sheet A, from worksheet_change event of sheet B
- R1C1 seems to effect listbox fill in VBA
- Divide Expression stops in Macro when Can't divide
- Excel
- test
- ampersand operator unexpectedly trims?
- Making a function somewhat volatile.
- autofilter macro causes #VALUE! error
- "No more new fonts may be applied to this workbook". Say what?
- create a dynamic Range()
- thanks
- How to populate a multi-column activeX listbox on a spreadsheet with an ADO recordset
- formatting a column in excel sheet with VB
- make string variable reference VBA sheet name
- Help! Extremely Difficult Sorting Problem
- Running DOS .bat file from Shell in a small vs. full window
- Concerning Userform
- Merging Workbooks
- Application.AlertBeforeOverwriting = False
- How can I still go to the error-code after a On Error Goto?
- VB IDE always activated when I unlock my computer.
- open a word file from xl
- Cell not null value?
- macro to make different tabs in a same sheet
- How auto EnableEvents again on code-break and errors?
- Is it possible to programmatically add a multi-column list box or drop down box to a sheet?
- What Are Effects of Choosing a Large Chart End Limit
- Inserting an Access database into a spreadsheet?
- macro to delete entire rows when column A is blank ...a quick macro
- What range is a cell in?
- Customized cell validation!
- What range is a cell in?
- Limit Printing of Worksheets.
- Hyperlink base and internal links don't work together??
- Select from first worksheet without knowing it's name
- VBA ATP arguments
- Code deleting values -- not as intended
- Changing Print area
- Re: Efficiently transform variables into range address
- Copying images from Excel to Access
- Macro icons on menu bar disappearing
- How to close embedded excel object?
- Caption of a button
- Restrict User Input
- Using an Activex DLL to apply formulas in Excel
- macro which changes the name of tab in an excel sheet
- save a csv file with SEMICOLON delimiters
- Change from all CAPS to only the 1st letter
- Function not performing copy
- Code instead of copy n' paste the conditional format by hand
- Checking for an open file in Excel
- Efficiently transform variables into range address
- Excel VBA - Selecting hidden worksheets
- Macro related question
- Help with Macro Please
- How to eliminate % totals
- API
- using macro IE turns error...
- Selecting & Copying a Changing Range
- application displayalert not working?
- Changing reference to Word in Excel project
- Question about hyperlink behavior...
- Create a Dialog Box
- Where is hyperlink pointing...File or Folder
- Get cell of broken Hyperlink
- Working with PDF files in VBA
- running a word macro from xl
- check for "#VALUE!"
- Help creating pull down list with unique names and no blanks
- Capturing text in active cell to clipborad (Excel 95)
- Time Difference between two dates
- Remove Hard Return
- What of these commands ruin my copy - paste operation between workbooks?
- xlend syntax in VBA-guru help needed
- Matching 2 Variables
- Excel To Access - Problem with last column
- Hiding critical cells
- Getting "Save as PDF File" Dialog at end of printing to PDF using PDFwriter
- Autofill & Lookup Function
- add new category
- Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work
- Search for existing values in woorksheet!?
- Excel VBA-Protect and unprotect sheet with BVA
- macro to calculate percentage
- xla and automatic links
- to open acrobat file in excel
- Excel Cell Formating in Visual Basic 6.0
- Load On Demand Addins
- Check or a file exist give wrong result
- Formulas returning errors when reference columns are deleted
- Opening Excel 2000 Workbook in asp
- Macro to play wave file in current directory
- Programmatically inserting a row with Excel 2003
- If ActiveSheet = .. then - I get an error
- Exporting text to a Word document
- Still Split Data and Concatenate
- Name sheet tab by today's two digit date
- VB won't recognize function in Analysis Tool Pak
- textbox counter probelm
- Code Interpretation
- Sending SMS from Excel
- change txtbx font
- Split Data and Concatenate
- XP Inactivity Logout
- How write to hidden columns with VBA?
- MsgBox -change vpOk to VpOkStop
- Clear formulae
- Macro Security Dialog - Document has no macros
- opening a workbook
- Help figuring out how someone did something on a worksheet...
- getting focus on an optionbutton
- Programatic Data Validation
- Macro code
- Weekly, Monthly Sums
- Filling the first empty cell
- Using a function from my own c++ add-in in vba.
- Persistent data in an Add-in
- Code Contribution
- Loop
- string sorting problem
- excel - can all the macros be protected?
- excel - macro code to open a protected sheet, enter passowrd, and then protect sheet
- Cell Value
- excel - modifying toolbar, keeping it unchnagebale, then re-setting it to original
- Macro to navigate between sheets
- Excel VBA - macro to recalculate random numbers until target reached
- adding components in VBA
- Protecting Embedded Spreadsheets in a Word Doc
- Program cell background color
- Macro closes all coluns and not just the programmed ones, why?
- Searching for a substring in a range
- Are You Ready? New Adventure In My Project!
- Inserting rows and saving formulas
- how to automatically highlight a row?
- Save As
- Help Page in Excel_VBE
- Fitting long text
- Unhandled Exception Error
- Populating TextBox Value--using ListBox
- Excel 2002 Data Forms runtime error 1004
- hide/unhide
- Lottery Analysis
- Open two new workbooks with macro
- Error 1004 in Excel 97...
- Adding Items to a ListBox-Unique Items Only
- Controls on worksheet
- macro - hides everything and not just certain columns as recorded
- check to see if cell contains a string = to member of list
- Write to closed workbook code
- Display in Macro when editing the value of a Worksheet range
- Don't understand External Data message
- Concatenation...
- Deleting charts on a sheet
- IF statement problem
- constant array
- Excel 2003-RND() vs Rand()
- Problems with callback from DLL invoked from VBA
- Defining Cell Row Value Remotely in Formula not Code
- VBA - not working
- Removing focus from a Modeless Form?
- Selecting cells for code
- VB .NET Excel Builtin Property Access fails
- Properties not visible in design mode
- Adding Items to a ListBox-Eliminating Blanks-Part II
- Assign names to R1C1 referencing
- Selecting Range
- Automatically Increasing Chart Ranges
- VBA - using Goto - Please Help!
- Adding Items to ListBox-eliminating Blanks
- Adding Items to a LISTBOX--eliminating Blank Lines
- Links work inconsistently
- Sorting cells with formula links
- userforms
- VBA question - Percentages in text box
- Color Indicator
- Show date in cell if data changes
- FTP Accessing remote files where filenames are unknown
- lookup,copy, paste macro??
- ç (c-cedile)
- excel - macro - automatic initiation of a macro at a pre-specified "system time"
- Excel 2000 Load Userform when clicking cell
- Entering Worksheet range Value into Macro Scrpt
- Is there a smart way to select multiple rows based on #2 :)
- Is it possible to export each row of data to a seperate work book
- Execute a menu command with VBA?
- Hyperlink won't work...help please
- Help clean up this code...
- Is there a smart way to select multiple rows based on column...
- Check Box Format!
- Codes
- Print BMP in Header/Footer with VBA?
- From HTML open a specific worksheet within a excel file
- Duplicate posting.....
- Thanks!
- Macro - Playing Macro if cells are locked
- Macro Recording
- Adress formula nested in an IF...
- Dynamic Print Range
- How to set footer and header for all sheets?
- Transform columns with VBA
- VB6 with Excel Objects: Please review my code
- Vlookup With Indirect
- Prevent non "validation" user entry
- How to return the row number or column letter as a variable?
- Searching in excel
- All Projects Code
- HELP PLEASE
- learning vb / macros
- html not showing corectly
- Address in IF formula.. doens work..
- Help with named constants in Define Name dialog box!!!!
- running a word macro from xl
- Range("temp").Calculate - ERROR
- SpecialCells Method selects valid records
- All open projects
- sort data in a single cell?
- Dont show msgbox again
- Using the And formula in a VBA macro
- Difference between range.formula and range.formulalocal
- VBA help - worksheets and range questions
- To join some sheets of several files in one file
- ChangeLink error
- How to change the color of a row using VBA
- rookie needs help with replace formatting and case change
- having things happen when spreadsheet opens
- Re: Setting a timed event in Excel - Please Help
- Re: Setting a timed event in Excel - Please Help
- Macro slowing down gradualy... (duplicate post - use this)
- Change Font size in Excel VBA
- Re: Check if workbook has been changed
- Test for Worksheet
- Application.CheckSpelling Error in Macro
- Formula based on one cell, pased in another range
- Find and display information
- listbox not dsplaying all records in a named range
- Error message When running Macros on MS excel 2002
- How to open an Excel worksheet in the webBrowser control
- DataChecking
- repeat code until row 24
- Find and delete
- Tri
- Comparing rows in three sheets
- Extract data from web page to specific cells in excel 2003
- Code for manipulating Lists
- Runtime Error
- Read previous line of textfile
- Writing to a closed workbook
- How to bold a range of cells using macro
- vbCancel
- AcitveX only runs with admin rights
- Excel - Access
- excel problem
- subtraction
- vlookup question
- Speed xl-2k compared to 2003
- Using VBA to enter info on external dialog box
- Using VBA to enter info on external dialog box
- remove rows with the same reference
- Word features in XL?
- ActiveX component not correctly registered error 336
- Find & Replace in XP
- Calculating values to column D with formula based on values column A
- Re: Determine the Row in a Range
- Word features in XL?
- Passing information from VBA variable to Excel range
- Using timers within excel
- Deleting Rows
- Excel macro !!
- User Form
- finding unique items quickly
- Web Services desde excel!!!
- VB Code needed for Sorting with constraints problem-Tough One
- How to display a chart where number of periods vary
- Refreshing an Excel spreadsheet
- sumdivide array formula
- Excel Macro for building up OLAP CUBES - Analysis Services
- =ISODD Behaving Oddly
- Refer to a sheet by (Name) rather than Name from an addin
- Finding duplicated entries in a llist
- macro to find date format in a cell and delete that entire row
- VBE code in a loop
- automated email for functioned cells
- macro to re-order sheets based on cell value?
- Three graph into one
- macro to find something in column A and delete 5 rows below it
- VBA question - sending e-mail
- msoControlButtonDropDown
- EnableCancelKey with On Error Resume Next
- Finding tabs in a string from a text file
- Copying Sheet with Formulas
- RasGetConnectionStatistics
- SOURCE CODE
- Array Formula Index Match formulas in VBA problem
- Activecell value
- Open a window / box showing a selected range of cells only
- Excel macro
- Tab to Certain Fields
- Capitalise Letters
- Automatic Advance
- "cannot insert object" in Excel (even a button from Control Toolbox)
- Automatically highlighting rows which contains certain data
- Global module
- insert rows
- Late Binding
- Open excel file at a certain date and time
- PivotTables Refresh not work
- Hyperlink to images
- Extract the value from a cell, and add it to a chart title
- Getting the value from a cell, and then using it as a name or R1C1 reference
- Overwriting an existing workbook without having to click yes in the prompt box
- How will I do Excel user-defined function to extract letters from string
- Slight adjustment needed
- Clean up code using WITHs
- insert to hold data
- PasteSpecial not happening
- Help with reading comments.
- Help using variables with Hyperlink
- Re: Compare two lists
- By-passing clipboard message
- Find then select to the right
- Grouping Control Changes on a UserForm
- Sensing actual format background color
- Creating a .bat file that opens, pauses & closes MS Excel
- Import and Export
- Customer menu Item
- Peculiar Runtime Error 1004
- Copy data from one worksheet to another
- Programming Colors
- Advanced Filter Copy Paste Blank Line Hell :(
- disable the windows 'minimize' & 'file exit' buttons
- Activate user form upon condition
- Imput box - Multiple Lines (\n)
- XP Screen Saver
- NEED HELP! Macro didn't survive XP!
- Re: Compare two lists
- JE McGimpsey web site
- ListBox size change on different PC's
- I'm stumped, Function that leaves a comment
- AcitveX only runs with admin rights
- AcitveX only runs with admin rights
- Night shift hours dilema
- My current code
- Question With Macro
- Need to adjust formula accordingly
- application.displayalerts is not working
- Trim "\" Value
- Run Macro Every 30 min
- a macro which finds last cell in a column
- inserting an object in Excel
- Inserting an Object in Excel
- Importing all components in a folder
- Password in Visual Basic - Help!
- Export just one sheet from a workbook
- User-defined chart type deployment
- macro to find out the last cell in a range
- Adding the values of 2 textboxes
- programmatically Set Reference to Library
- hide / unhide details
- unique values
- Deleting file while in use
- Export a file with today's date
- File not Found !
- InputBox
- Comparing, Sorting,countig Mac address and vendor names
- Open Workbk/Close Workbk Done Asynchronously?
- Write over existing file with no Prompt
- Help With Macro
- Copy from sheet and paste to last row used
- Using VBA Change Cell Text
- Which Macro Is Assigned to a Button
- Office 2003 General Problem
- Save a worksheet as an Htm file
- Randbetween puzzle??!?
- End of file marker from Text File - Delete?
- Excel Hyperlinks on a web page
- Change text in a Cell
- New to Excel VBA
- importing a lot of text files to excel sheet at one go
- Using Select Case Statements
- Get the name of a newly copied worksheet
- Please help, I've been working on this for days
- Change Cell Entry To Uppeercase
- Tab Stops
- Text won't Trim
- How to work =row(Cell_Address) into a macro
- Using different print code
- Working with other files
- Range.Sort in VBA
- macro to combine data from 2 different excel workbooks
- Automaticully copy of data
- Summing from multiple worksheets
- Prompt for a range to apply code to
- Refreshing / sharing an Excel spreadsheet
- copying hyperlinks
- Re: Routing Recipient
- help please! need a macro which can combine data from 2 excel sheets
- Is there somewhere I can access Excel-VB code at once?
- External data sources in Excell...
- Using macro to change printrange / fit-to-page
- any clue?
- RE: Error in VBA code to save workbook
- worksheet function calls between worksheets
- Password in VBA
- Emergency! Can I use Maco to export excel data into word forms
- Re: Error in VBA code to save workbook
- Create Folder and Text File in folder
- problems with Add-In event procedures when moving WB files between computers
- Help in macro in excel.
- sharing an array between worksheets
- different cellcolor depending on cellvalue
- Downloading a file via FTP in code
- seting a workbook to a varible name
- USERFORM
- What is wrong with this function?
- Popup login dialog
- Reference a cell on a worksheet
- Best way to create a workbook template that allows data entry and purchase order req to be created from it
- Add Workbook with specified name
- Macro for linked drop down boxes
- Changing formulae for series in line charts
- Function not working correctly
- RS-232
- Re: RUNTIME ERROR '1004' --- Select method of worksheet class failed
- Filter Code
- Problem with UsedRange.Rows.Count
- EXEL Math - need help
- Why?
- Recalc versus enter
- activecell.formular1c1
- Date format
- How to prevent anyone from viewing the code
- Re: Forcing Data Entry in Certain Fields at Certain Times
- Reading, Comparing and Writting
- Calendar Gridcells
- Problems converted comma seperated CVS file!
- Function help needed
- TreeView
- VB excel Null values !! Please help me !!
- Search/Filter to find values in another range based on two cell values
- Copying non-blank rows to another sheet...
- Working on a macro
- Percent Format without Percent Sign
- Excel VBA - Skipping #VALUE! error
- Making All Checkboxes Run the Same Code
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.