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 |
- Determine If Pivot Table Exists
- Excel 2007 Problem
- Error 429 ActiveX Component can't create object
- User input to calculate specific column
- Using txtMy_GotFocus or txtMy_LostFocus in MSWord or Excel
- For Tom Ogilve re File check
- Error Trapping saving file to network drive
- Copy formulas from row above...
- Checking if active file is correct version
- Ignore Blank Cells
- Screen update?
- Returning a list names from a schedule
- Please Help with Combining worksheets
- Exel.Exe lingering in Task Manager
- Launching solver in new Excel Instance
- How do I gray out worksheet tabs in EXCEL
- Applying custom data labels to an XY series
- List Box
- Macro to create charts?
- Sheet Selection using a Ranged index
- Can I apply automatically the same filter on many pivot table ?
- Can I apply automatically the same filter on many pivot table ?
- global variables
- Spreadsheet ActiveX control help file
- Bug in Excel 2003 involving ActiveX Controls on worksheets
- Format Cells with date format
- Retrieve Text of Data Point
- Getting at Windows File Created date with VBA
- Returning cellvalue from closed workbook using a function
- Averaging Letters and Numbers
- import data with microsoft query
- 2006 West Coast Excel / Access User Conference
- Macro's not working
- How to make a Macro run after every cell adjustment
- how can i calculat time(hh:mm)*(number)...(09:00)*100 $
- Writing VBA code in Excel to Print Power point slides, and a PDF r
- Excel 2007 beta TR VBA still MUCH slower than Excel 2003
- DDE error
- cut and paste specific record on same worksheet
- how to auto update sum?
- publishing semi-PROTECTED excel workbook as a dynamic website
- variance array
- embedded messaging script in worksheet
- User defined function: All
- Count value if not Number
- Changing Cell Color with macro
- how change characres to stars when somebody is writting password
- Null Values
- XML Spreadsheet Warning in Table - Cell off grid
- Creating N worksheets
- Detect if font installed- Hiding column
- Macro compatibility with Excel 97
- Matching Case
- ShowDetail on PivotField rather than PivotItem??
- Conditional format between two cells
- Putting contents of an Array into a Cell
- determine range for printed pages
- picking the best 5 out of 10
- Select control on a form after calling procedure
- Reading Data from workbooks without opening them ...
- Selecting record to edit using ADO
- Timestamp Saved
- If a prog is running stop and restart
- repeating a macro for a specified range
- Code from Acrobat
- editting pushbuttons
- Ref a Group of Controls
- Input programming decision time ??
- create hyperlink cell in excel using VB
- Picture on Form (VB)
- change chart type on pivot refresh
- compiler error: public object module
- Using a file name to get the path where the file resides
- Merging worksheets
- Slection of Rows on a Condition
- Using data captured by Inputbox
- Creating Outlook Appointment
- Entering a hyphen
- Late Binding with Outlook
- Prevent user from copying pasting at run time
- All possible Alpha character combonations
- ODBC connection question
- ListBox Question
- linked cells
- autofilter question
- Printing labels from excel worksheet
- Printing labels from excel worksheet
- cascading 3 cboboxes
- Copy CSV to variables
- How to use workbook is a database?
- Help with list of values
- best way to test a row for 0 values
- Hide the spreadsheet
- general lookup/vlookup question
- Excel 2003 vs Excel 2007 addins
- Dave and/or Tom
- Sorting Worksheets Numerically
- Started something simple - Now really confused ??
- data reading/writing question?
- Relative Cell Reference [How To]
- Building a string
- moving cells
- Hide row is no cells are bold
- How to AutoClose and Save
- 2000 vs. 2003
- How do I show a sheet programmatically?
- Excel 2003 book
- CheckSpelling
- Help using FileDialog with OpenText
- Run all web quiries in a worksheet
- automatic column width
- Pivot Table Autoformatting without collapsing columns
- merge 2 columns
- Conditional Formatting - Pulling from worksheet to form summary page - only non-null fields/sections pulled
- mONTH cOMPARISON
- count blank cells in a dynamic range
- Pivot Table - data results that equal zero to be hidden
- sending parameter of another cell value
- Hyperlink focus and default email program ?
- Advanced Filter with Non-Contiguous Ranges
- Determining if a file is open using VBA
- Changeing Collections Indexing
- Control Toolbox Button - need to activate
- AND if syntax
- How to format column 7 ?
- Retrive Data from Closed work book
- dynamic chart range with VBA
- function call paramater question
- Combine Multiple Sheets: Complie Error, Expect Array
- not allowing users access to spreadsheet without correct names
- ADO - recordset find performance slow
- Delete Unused (4000) Rows
- docking a form in Excel
- autofill range class failure
- doesn't compile, thinks HPageBreak method is a variable
- Variables in a cell reference
- Combine Worksheets: Works Well in Test Mode, Locks when running no
- How do I move cursor to next empty space??
- Data from Access to Excel
- VB Works in test mode, but Stops when doing normal run.
- Need Help calculating a highlighted range
- Detect tabular list in VBA
- Choose File To SaveAs
- Toggle Read Only
- Cell Restrictions still
- Hiding a form
- Cell Restrictions
- This is wierd!
- Calling a sub from a different workbook
- lookup combined with search to find keywords and then assign a cat
- Calculating maximums from data sorted by SKU and date
- Programatically increase the size of all named ranges
- Variable upper and Lower row selection
- Need Help with pivot table
- TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS
- Data_Forms
- remove space
- Cell Restrictions
- Recorded macro opens, converts comma-del file and saves
- number of pages
- Excel file security
- Generate Excel files with Graphs from ASP
- AddressOf limitations 2002 vs. 97
- Sum if
- macro "text to column" for excel
- Looping problem........
- Show all formulas on sheet
- Right click menu problem
- Worksheet Tabs - Names & Numbers
- Problem with handling on error when file is already open
- stuck in a function
- macro that takes data entered in a user form textbox to go to a ra
- city st zip cells
- group of values with the same
- Drawing with loop, loop help!
- Grrrrr.... can't access Server object ??!!??
- copy specific records to new worksheet
- Printing selected Data
- Copy and Paste from WEB SITE
- auto suming
- Looper blooper
- Sort worksheets
- links on network needs redefine path whenever open
- automatic referencing in excel between two spreadsheets
- VBA to check if checkbox is toggle-on
- Automating Input during a macro....
- unit testing
- Seek input on a Transposition: Can Excel help do this?
- FreezePanes from VBA?
- Another Filter Question
- UDFs needed I think they're pretty easy but I can't figure them ou
- Filter Question
- Hiding Rows
- ExecuteExcel4Macro ...
- Excel SQL and listbox
- Filter Question
- macro assigned to print command button
- Blank Lines
- User defined function gives #NAME?
- runtime err 76 on some laptops
- VBA Help
- Formatting Dril Down Reports
- Turn off "Do I want to Save"
- Macro to format different range of cells each time
- Trust access to visual basic project is grayed out
- schedule task
- vba excel - lien sur onglet
- Choosing window to follow hyperlinks within workbook
- Text Problem
- Excel Paste and VB.NET
- [Q] Protecting a formating against Copy Paste
- Userform to calculate Distances
- Save Changes Prompt before Close, when no changes were made
- Form Dropdown: click event macro
- number of decimals
- cannot click button on sheet
- Picking numbers from 2 columns - need help
- FILTER USING MULTIPLE CRITERIA
- Plz help :)
- Sheet Referencing?
- add a hit counter to excel files?
- How do I build a Soccer position/lineup template?
- Sumproduct
- aligning data
- Small yet annoying
- Underline with accounting format
- rediming dynamic 2 dimensional array of user defined type
- Way to display result at the end of the sub only
- Procedure Limit ??
- Replace and Substitute Functions
- On Error
- compile error - expected an array
- creating a macro where the values entered in a text box on a user
- Database (or the like) from Excel Sheet
- How do I delete data,formula,and formating PERMENENTLY?
- Events for Enter/Exit Textboxes on Userforms
- Triple Criteria Formula
- Spell Checker
- Need Warning Box before deleting cells
- Array Question
- Excel Named Range
- Identify OWC11 spreadsheets
- Application Path
- Automating Macros for CSV files
- remove duplicates macro ending sub
- Template to track employee vacation,sick & funeral leave time?
- ODBC query excluding headers
- Testing modification time of file
- is there a #?
- Command Icon
- Current Date & Save on close
- Comment bug ?
- setup for userform printing
- Is string
- delete row with criteria (vba)
- Object required
- Command button code
- SEARCH function
- Excel diagram
- SEARCH function
- Filter & Print
- Hide Sheets
- How to change date format in VBA
- Excel Access Security Question
- Excel to powerpoint
- matrix size
- Importing TEXT file from web
- how do i write an if/and/then statement to compare adjacent cells? TIA greatly
- Does not support automation or does not support expected interface
- If cell contains any of the following letters, then..
- OWC and Chart in UserForm
- Current file name in ConsolidationReference FileName
- RightClick Range
- FaceID not available
- Toggle Button in a Toolbar
- to display content of worksheet on a user form in visual basic
- Previous Sheet
- Private Sub Workbook_Open() & Workbook_BeforeClose(cancel As Boolean)
- Macro speed decreased now to great extent
- Rounding formula question
- find a sum number from 300 number in Excel
- c xll add-in callback when closing sheet
- Keeping Track of Excel RTD Data
- Protecting a worksheet which has button controlled macros
- Importing text files using macro
- ToggleButton Value in a macro
- DropDowns and item values
- Referring to a worksheet in another file.
- copy value
- only a portion of my data is being imported to excel from access
- Taking an average of ranges
- does file exist
- help message
- Format a cell to give quarternumber from a date in Excell
- Series Object and Values Property
- Linking Range to Another Spreadsheet
- TRANSPOSING
- I need help to show the contents of a range in a listbox...
- Range refernce question...
- Macro Hogging Memory - what to do?
- WORKBOOK_OPEN event
- emailed content with InDesign or InCopy
- SpinButton/TextBox - Large Number
- Intersect Function Problem
- Excel to Acess transfertext issues
- Submitting form variables to Excel sheet
- Time Hog
- Finding string and color the found string
- do until end of list
- Step thru Dates
- autoupdate ppt embedded in excel file to which it is also linked
- Issue with creating a specific macro where two conditions exist
- syntax error in case statement?
- Assign variable to a worksheet ?
- Delete Sheet event?
- Defined names in Macros
- Defined names in Macros
- Chart VBA
- Protecting Cells
- Msgbox Close Button
- Fundamental problem with Indirect function
- count of items in columns
- Overrule/Replace
- how to select a sheet by name
- VBA Worksheet Function Question
- Cell Format changed from General to number
- Macros Excel 2003
- count value with filter...
- Refreshing ROWSOURCE
- conditional statement to return greatest value
- web query doesnt copy the essential part.
- Add Borders based on ByVal Target As Range
- Warnings in Excel
- State Map, Mouse Position Question
- make a "selection" in a word document from a module in excel
- Blank rows at Bottom, over 60,000 of them - how to remove ???
- Excel VBA Macro
- Highlight text on Mouse over
- Open Worksheet
- Excel + BBL
- Works on my pc but not others
- Selecting range programmatically
- newsgroup advice re: "selecting"
- Array formula
- QueryTables.Add and XML
- .net, hooking Worksheet_Change event to sheet
- C# instead of VBA
- Distribute Lengths without loss
- Time entry macro (entering times via the keypad)
- Evaluate time spent on macro running
- label.refresh error
- MsgBox taking a long time to clear from screen
- using VBA in the function bar
- Disappearing Public Variable
- Problems with conditonal formatting
- After pasting a Chart in Word, excel makes a "restart"
- Emailling sheets via VBA
- Copy/Paste doesn't trigger macro (again)
- % completed box
- Text string divided into 4 columns
- Macro to load JPG image
- WILDCARD CHARACTERS
- Need Help With VBA Problem
- Load userform & deselect it
- *Between*
- Rounding
- Copy Excel Worksheet to another workbook
- Events with diniamically added controls
- Macro to Enter Formula in a Cell
- >> Picture Compression
- syntax error for counting the number of columns end.
- Custom Application Code checking
- Adding Code to Command Button Added At Run Time
- ISTEXT evaluates to 0 ? (not FALSE)
- range color formatting
- Adding Code to Command Button at Run Time
- VBA Help files
- error routine
- Validation list changes don't fire an event
- string conversion problem
- European Date does not work from a textbox
- determine if value exists
- userform printing
- fornat UserForm field
- Calendar control (mscal.ocx)
- Data being saved in error (?)
- before right click problem
- Hyperlinks(1).Follow then open as .html
- Change an empty cell back to a blank cell ...
- pop up
- C# Visual Studio connect Excel to AS/400
- Getting result of formula instead of actual formula
- User form to sort data
- activex controls?
- Sending the current row number as a parameter to a function
- VBA Inserting rows conditionally, how to work with shifting range
- Shortcuts for a listbox selection
- on error resume next
- Holding off on screen updates
- Fields in recordset from Access with value Null (empty fields)
- ODBC connection string Excel to AS/400
- VBScript to center Text
- INDIRECT Function
- xlDialogPrinterSetup
- determine selection.Address of cell from inactive sheet?
- How to know an alert should have displayed ...
- Need Help with Deleting Rows
- Checking when target.values are empty. What am I doing wrong?
- Refresh Problems
- Selection.Find a value Greater Or Equal
- user defined function return #value!
- Excel, how do I write a macro to convert the date value to text?
- Two-Color Gradient Fill?
- pause
- Open Worddoc from Excel via VBA -> Paste
- on paste, go to another worksheet
- Using a checkbox to activate/deactivate input option
- Grouping Option Buttons
- Column location
- ControlSource Errors with 2-Column ComboBox
- partial search
- External Commands?
- send data to excel from c#
- Isolating words and numbers to a different column
- file operations
- Split cell info via VB problem
- IsEmpty
- how do I change a web query's field length?
- checkbox with two macros
- BreakLinks method works when Stepping Through but not when Running!
- vba page breaks
- Error with Calendar object and CommandButton
- Formula problems
- Calendar in Excel
- Custom formatted cells
- Giving some feedback to user, when waiting on SQL SELECT query to finish
- Comment Field
- How to import an xml directly in userform ?
- Naming worksheet
- Font Colour Macro
- Formula problems
- how do I programatically edit formulae in MS Excel?
- Create new worksheet
- chats help
- charts fucntion help needed
- ListObject binding
- Excel links break on network
- excel links break when access from network
- running code when vba project is opened
- Connect to MS Access with Password via VBA
- Excel Beta 2 Tech Refresh DrawingObject Status
- "*BETWEEN*"
- CONCATENATE
- how do i fill an array? tia
- userform Enabled property behavior changes between excel 97 and 2000/3
- My code is still not working -- Excel 2000 Worksheet protection
- return sheet name
- The name of the textbox in userform keeps disappearing
- One Cost Divided Among Multiple Date Ranges
- Need Help Editing Cells
- Merging Files in ListView
- Reflecting changes on multiple sheets
- Right click menu
- Referring to a Worksheet with a variable
- Excel 12 and BIFF Format for new .xlsx files
- Comment help
- redim preserve the second dimension in a two-dim array
- Text to Columns in VBA
- Sending strings to a webpage
- Macro to Create New Date Tabs in Worksheet
- Auto saving & closing a file after inactivity
- Q: Automated coping of data to other worksheets
- stumped
- Chart Creation using VBA
- Renaming tab name-# of code lines..HELP
- Run time error 438
- Automatic Updates
- Macro to create workbooks and pivot tables
- next logical number from list of about 2000 random numbers
- save
- COUNTIF across multiple worksheets
- Change Procedure
- Copy values from multiple sheets
- XMLSS export format for import to Indesign 2
- If .value <> "some text" Then not working. Pls hlp
- import XLMSS to Indesign
- Enabling the Filter button in a class module/protected worksheet
- After Creating New Tab I Hit <Enter>, How Do I Make it Go Immediately to a Given Cell?
- Auto Add to WB saved Name
- excel help with time sheets, not in military time.
- Weekday Function Returns Wrong Number
- Error 1004: Application or Object Defined Error
- Saving Excel Sql Server Image Field
- count filled cells
- Subtotals function offset subtotals summary
- Macro to copy Excel charts to existing Powerpoint file
- workbooks.open
- Currency Data Type and automatic cell formatting
- Conditional Formatting
- Register MSCAL.OCX using Macro
- get distinct data from multiple sheets & then consolidate distinct
- Stepping through gives different result than running
- Virus scanning feature
- recalculation of a custom function in excel
- Remove leading spaces from excel worksheet
- parse cell contents
- Prevent typing in a drop-down list to run macro
- #1) value vs. formula #2) personal.xls and xlstart pathway
- Code to remove external references from range names
- Date macro
- excel 2007 blog regarding udf authors
- Hard line break displaying as rectangle on import from SQL
- saving with a date
- Autofilter (in a macro) problem
- Copying worksheet to all workbooks with fixed references
- Export folder/file listings from Windows Explorer to Excel/Word.
- Loading dates from spreadsheet into array
- Word wrapping merged cells
- On Error Goto ... Error
- using sum function after offset
- VLookup Question
- Help with a macro, please
- Insert Duplicate Sheet From Closed Workbook
- Excel Marco Fill Down Dynamic Range
- Program actions on word doc from excel?
- A better way to do this?
- Sum rows above me matching critiera...
- find-record combo box
- conditional formatting based on proximity to date
- Printing certain pages within Active Sheets only
- Restricting values in a cell that already has a dropdown list in i
- How to get data from CMD line
- How can a hyperlink be inserted upon checking a checkbox?
- format autoshape
- Conditional Formatting
- Can 3D Reference Update to New Position?
- Simple flex grid
- How do I detect cell mode?
- Can I mail merge into Excel?
- Unable to fetch values from Excel Worksheet in vb.net
- comment positioning
- Personal macros not available when workbooks.open
- Changing design time properties at runtime
- Turn Filters On and Off
- External File Paths
- listbox help
- pass data between workbooks
- format cells
- Paste Options
- Macro Update
- How to program FIFO inventory in excel ?
- Print in cell
- Newbie: how to show the checked symbol in a label control
- Changing object properties permanently at runtime
- How To Sum
- Formatting calculated number appearing in the text in message boxes
- Array Formula
- Make excel check external file paths
- Save a copy of particular sheet minus VBA, CommandButton of parent workbook
- code to go to start of line
- procedure call
- RANDOM HIGHLIGHTER!!
- WordWrap in TextBox on a UserForm
- Date Problem
- Much frustration...
- Excel throws -2147417851 (80010105) The server threw an exception. for no apparent reason
- User form to comments
- find last record in macro and delete all after
- searching array for text from array
- Dynamically creating Non-Contigous Ranges
- creating a dynamic graph
- write a macro like the /file copy combine named range in lotus 12
- VBA Macro ActiveCell.Offset
- Exporting to CSV without text qualifiers
- Sum for last calendar month & year
- Visible Screen
- Sum for last 90 days
- Proper way to export custom Toolbars ?
- Filtre value from date and filter advanced...
- show userform when response = yes
- show userform when response = yes
- Fill Area Between Lines
- Entire Workbook Search
- How to Find&Replace with MatchWholeWord?
- Excel VBA code for find/replace
- Comparing cells
- MACRO FOR COMBINATIONS !!
- Corresponding Range in another column
- match
- Sum with Date Span
- Newbie Question - Is it possible to run a dll from excell
- retain result
- Removing duplicate rows
- is this an acceptable way to pop up a form?
- Sum within date span
- convert formula to vba
- Late night I guess - makeing a new range from an old rangename
- formula copy question
- My screen tips boxes donnot contain anything what do i do?
- Cursor gone Mad
- Password not working on exported Workbook / Worksheet.
- loading data into a listbox faster
- Making a collection of EntireRows for copying and then deleting
- Matrix multiplication of more than 73 X 73 entities in VBA
- Including a variable into formatconditions
- Userform textbox help
- Userform textbox help
- address of min or max result
- text manipulation in change event
- Shell to another program from Excel
- how to determine vba wise if a cell has a hyperlink
- Excel web applications with VBA
- Userform.
- Macro call, one workbook to another
- CountIF formulas
- deleting repeating cell values
- How do I use a Macro to define a Named Range
- Day and language fomat
- How can I create a worksheet in a routine and set the code name at
- Mention the Day NOT the date please
- How to Autoopen Search/Find dialog box ?
- Excel Worksheet not fetching values in vb.net
- Excel Worksheet not fetching values using vb.net
- Curious - What is Implements used for
- Question
- merging sheets
- Naming range question
- Opening the Macro "Stop Recording" tool bar
- Is there a way to use VBA to set up a VBA password in another workbook?
- Converting text to yy/mm
- wildcards with substitute of replace
- Trying to use Excel to "program" word doc
- check box value
- Foolproof way to trap Worksheet Change?
- How to delete Excel worksheet using VBA without delete dialog?
- just file name no path
- permanent/programmatic changes to VBA Project References
- Set Range error
- Missing OCX or DLL...
- Page Setup Not Fitting To One Page Wide
- save as text crashes Tom Ogilvy
- Delete rows based on value...
- Count Empty Cells in Range After Cells with Data
- Go to from reference in VBA code to actual cell?
- xlSheetVeryHidden vs xlSheetVisible
- Restricting files to a single computer
- how do i convert from feet/inches to decimal?
- Return Sheet# Sheet Name
- How to calculate total for a column with not all values filled
- Cyclic Error replaced by blank or something ? would Macro help?
- Error hiding a combobox with a checkbox
- How to deal with no Workbook_Open for add-ins...?
- Need macro copy above cell to current
- Reformatting text....
- ini file 2
- programmatically adding a break in a menu bar
- save as text crashes
- Worksheet_Change from a validated list
- Want to displays lists items in separate colors
- save as text crashes
- Writing to Notepad from VBA
- BreakLink
- how to get data from cell a1 and paste in cell b2 in another workbook.
- Verify protection status within a macro
- Joining an Excel spreadsheet to another using Access
- function to figure out which procedure
- comapring cell values
- Macro skipping
- Update a range reference change
- preventing special character from being entered in cell
- Disable save & save as then return message...
- Identify unprotected cells in protected sheet and clear their cont
- If cell value equals today
- End(xlDown) won't work
- Cell references when creating charts
- Excel, Fullscreen, Taskbar
- Setting the category Label source for a Pie chart
- Excel UDF Description, Help Keyword, Help File
- preferred method for summing
- How do I find Control toolbox in Office2007
- Select Current Row
- filter a matrix
- Using found variant within code
- Searching for a substring inside another string - there has to be an easier way!
- Maintaining relationship between 3 variables
- popupmenu
- Window Movement
- Automatically run a choice of macros based on cell selection
- Protecting a Range in a list
- Hiding unused columns
- Selective linking items between two worksheets
- Why "expected function" on such basic VB?
- Hi Bob
- Delete entire row if two cells are duplicate
- Info on xml files
- Background color for every other row
- Where's the Personal.xls in Excel 2003?
- a "cell is renamed" event?
- A COM Add In must handle WorkbookOpen event
- Major Error
- Using known arrays to calculate an array of new values
- limit on hyperlinks
- how to read dbf file using macro?
- Re: Troublesome Code
- CONVERT A MICROSOFT EXCEL SPREADSHEET INTO A JPG FILE
- Multiple Command button programming
- Spreadsheets or workbooks - can they be accessed as a network application?
- scope of public variables
- macro to move and save all sheets to seperate workbooks
- delete workbook if not authorized
- Sort by rows...
- "cancel" caption doesn't show up on cancel dialog
- MacID VBA
- combo box problem!
- Pivot Table: Locking Certain Features
- Microsoft Common Dialog control, version 6.0
- Display Cyclic Error as Blank ?
- Follow Hyperlink in Excel 2000
- textbox to return User Name
- runtime 1004 error
- 2-Column ComboBox Issues
- Sort Ascending or Descending using Option Button
- Change the range for a recordset?
- custom format cells
- when encountered Zero/Blank CF issues ...
- Control on different sheet than the executable
- FORMULAS
- How to make a File READ ONLY
- Copyright or Secure a workbook
- macro to insert function without parameters
- runtime 1004 error
- Error Message Copy method of worksheet class failed
- INI File
- Tweaking a current formula
- Find / FindNext Methods
- How do I remove an old command button from an EXCEL worksheet?
- Trying to search a block of text for presence and frequency of terms in Excel
- Delete entire row with a positive number
- Trying to make Date Range variable in VBA SQL Query
- 2 nice requests
- Updating all graph links in a workbook
- Update multiple rows from listbox
- Why does this work?
- how to copy line above when XXX occurs and move on?
- Excel Macro find non zero value in cell and insert row beneath
- Clarification in vb excel programming
- listbox - How to reset the values
- pivot tables
- Counting number of rows that are not N/A
- Sum values based on Text
- Setting external data location for a pivot table
- Lotus to Excel
- Checking list for contents
- Protected Sheet and AutoFilter
- combo box
- Wrong with macro naming sheets
- SUMPRODUCT...with text values within array
- Checkbox to Hide/Unhide Columns Based on Value in Cell
- View Details in OpenFileDialog
- countif formula
- how do you create drill-down detail?
- Append One Array to Another, and Consolidate
- Active X Command Buttons Disappear
- Open book, copy and paste from sheet, and then close....
- Pivot table programming
- How do I add a drop down calander function to excel?
- Protecting an Excel List
- Function with offset
- UPDATELINK problem
- Using variable in CopyToRange:=
- Selection.Find a formatted date
- Closing files by a macro
- Sum Formula
- SUMPRODUCT (I believe??)
- export to a text file
- empty cell instead of 0's
- Idiot proofing my spreadsheet
- Comparing visible values in two arrays
- Moving your selection over a couple of columns
- Using a marco to update my spreadsheet.
- Using a combo or list box to select a statement
- VBA searching
- Colors Shapes vs Cells (Excel 2007)
- Automatically create a chart
- sum at each page break
- Insert row after a page break
- Add Line break to string for Excel (using c#)
- Combining Formulas
- How to print...
- Strange format problem with textbox
- sumif statment
- Time Stamp
- Shapes & Drawing Object Bug Excel 2007 Beta 2
- query table macro
- Changing Multiple Cell Colours based on Drop Down option Selected
- Need help with named ranges in VBA
- How to hide certain pages if a page is dispayed
- Using Command Button to Hide Columns in another worksheet
- ChangeLinks routine stopped by Update Values dialog
- Use VB to get group of cells
- excel 2002/03 vba changelog
- How do I implement if-else functionalilty for a cell in excel?
- How to set row color
- locked cell issue
- How to sum subtotal with blank line
- Why it doesn't work
- run time error 424
- Excel date bug?
- Excel crash as the result of file look-up
- Create univeral pivot table macro - use with varying lenght data sets
- List all (complete) codes from a workbook?
- Displaying help for an addin
- What is the right function
- Counting columns with >1 instance of a specific value
- Pastespecial with Late Binding
- Countif Function
- How to select a font with a strange name?
- How can I use Visual Basic to access Solver?
- Multipage forms imported in XP
- Trouble exporting ado rs to Excel
- How can you use data validation for a cell with a formula
- formulas derived from cells
- cell contents into an array
- REPLACE formula
- Simple Parsing Question in Excel 2000
- disable save and saveas from menubar and save via command button
- Dynamically create procedures in a sheet module
- Alternative to hardcoded password ?
- Help with a macro
- Excel setting which prevents printing?
- To save a web page
- Simple problem with code
- run time error 91
- Check if Any workbooks are open
- Setting a list box to a value
- Encryption - Public Key - what the....???
- Range does not work
- compile error method or data not fount
- Data Validation and Filtering
- get some user info and store as constant
- error "macros disabled, refer to online help?"
- Code Usage Question
- Check if the first sheet is the selected sheet
- "Select" and "Activate" failing?
- Range syntax with variables
- shape range help
- Create a macro to run autofilter based on contents of 2 cells
- Disable Auto Refresh Dialog
- WORKING WITH COLORINDEX AND MULTIPLE WORKBOOKS
- Hide sheet via codename
- .FreezePanes
- merging 2 spreadsheets
- end command not working
- Next available row
- Linking information in individual cells spanning multiple sheets
- "Save" macro problem, still prompted to save when closing workbook (?)
- ActiveWorkbook is nothing in Workbook_Open
- Turning off merge-warning
- Sending email from Excel with a twist
- Find and Find Next problem
- Macro Not Working
- fix worksheet color
- Nesting For loops
- Need one more thing
- How do I track multiple daily individual payments over month/yrs?
- userform to search by entering data into a textbox
- Multiple range names
- initialise declaration
- Auto spelled number
- Use CDO to send e-mail
- How to detech same data in one sheet
- Combobox items determined by the selection in another combobox
- How to print...
- Hide same rows on new sheet as on previous
- vlookup
- Method or Data Member Not Found error, after connecting to Microsoft SQL Server
- Combo text value disappears when wkb opens??!
- ??? How to get list of Color constants
- Basic authentication UI for web-services
- Can using If Formula differentiate number with decimal or do not
- Upgrading Add-Ins to Excel 2007 -- Compatibility & Bugs
- TREND WORKSHEET FUNCTION
- Combobox Rowsource
- how do i create a template for certificates of completion
- Sorting Check Boxes
- Toggle Toolbars in Excel2003
- CODE Function equivalent in VBA
- using VBA in Excel it changes the dot of a number to a comma
- hypertext
- hypertext
- Condition Formatting - Work Sheet Event Code
- Merged cells
- Dynamically setting Dimensions in a VBA loop
- runtime error
- Macro to refresh data
- split function for Excel 2003
- help! pull text info from separate worksheet
- Maximum Number of times
- Need to link to various websites
- macsplit function
- 2 CONDITIONS FOR CONDITIONAL FORMAT?
- smallest
- Insert Listbox in Essbase Form
- DataLabel Manipulation
- macro to save named range as text
- Extract email from excel worksheets
- Column names for dump of text file to Excel
- error in userform?
- How to create a disapearing drop down list
- Change default button
- deleting duplicate entries
- Named ranges on other sheets
- round number for unknown num_digits
- Compile Error: Expected Variable or Procedure, Not Project
- How do I swap every two rows in a spreadsheet?
- scrolling textbox
- Printing with macros
- אקסל 2003 תפריט אישי
- how do I print a named dynamic range
- Getting From UserForm TextBoxes To Lastrow On Active Sheet
- Working with Incative Workbooks
- Macro to hide rows/colums by value
- xl2002 - AutoFilter from Criteria from Other Sheet...
- Creating a Fomula in a Pivot Table
- Excel 2003 is converting weird to Excel Viewer Version 8?
- sort doesn't sort numerically 2nd request
- Speed Up Macro
- Test Printer for Colour/BW
- Add 2nd Column to ComboBox
- dynamic charts
- increase range programmatically
- Prevent Saving From Web
- Undo function in Userform
- How to activate original workbook?
- separate mixed data
- Date problem in Pivot Tables when using SQL as a Data Source.
- excel "name is not valid" when naming a cell
- How to copy a worksheet from one workbook to another in vb6
- References to cells in other files
- Delete duplicate rows
- Querying an Excel Sheet via HTTP????
- Consolidate data on different sheets in a changing range
- text boxes on forms
- Pasting ADODB recordset into unopened workbooks II
- Naming and referring to charts
- Row of references to same cell in several worksheets
- OLEObjects, adding a picture problem.
- security warning
- update then move down
- Creating a total line
- conditional formatting
- choosing column heading given a criteria?
- formatting cells loop
- formatting cells loop
- Help with my cut and paste code
- Automaticall disable Protection menu
- Only allow users to enter new data
- IF else statement
- Split Text
- lastrow question
- no sheet in workbook
- Sub Auto_Open() - Sheet name - error code
- MS Office Outlook 2003 & MS Excell 2003
- FindFirst
- Force Excel to Refresh Screen
- Football pool
- Changing a Number in a Column Using Arrays
- Excel OLEDB reading Chinese characters problem
- In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
- Show "Go To Special" Dialog Box
- Complicated VLOOKUP
- Matching CELL text (full word) to full word in string in another
- How to sort a list of telephones # by every 10th, 20th number?
- command buttons
- Pasting ADODB recordset into unopened workbooks
- automatically run startup macro in new workbook
- Maximize all collumns and rows (evenly distributed) on 1x1 page la
- separating info in one column to different fields
- WHY DATE FORMAT??
- Change Formula
- Capture date for =MAX(a1:a250) formula
- Popup Comment Box if a Certain Condition is Met
- Macro for hiding columns not worling
- Excel code convert to Access code - Concat & eliminate duplicates
- Import Data From Landscape Format
- open an excel file
- number not a number?
- Allowing user to select a cell in another workbook in VBA
- http://jcd.sytes.net/DEMO.HTML
- If sheet exists, then...
- Problem with worksheet_deactivate code
- find an empty cell or null value
- Question using the excel find method in vba?
- what is the R1C1-style notation in Macro Language?
- Question on Find method in vba
- Formula Help
- VB to copy a sheet to active workbook
- Simple VLookup Question
- issue running in Excel 2003, not in 97, error 9 subscript out of range
- Name ranges based on criteria
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.