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 |
- pause macro
- VBA problems
- Range
- moving thru a noncontiguous range
- UDF programming... PLEASE HELP!!!
- Toggle Autofilter
- manipulating SQL data through Excel
- VBA compy base on range
- Sending Conditional EMails from Excel Which Copies Information from One Worksheet
- Run-time error '424': Object Required
- "Excel cannot complete this task with available resources"
- VBA Class Modules
- Formula is evaluated as a constant instead of a formula
- Selecting Each Row and Creating a New File
- Automate PDF creation
- Various error 1004's associated with copying ranges. Excel Gurus please help!!
- Multiple Sheet Help
- VB to go across and then select columns
- change in combobox not firing
- Delete Blank Rows
- Consolidating data from many spreadsheets and comparing results over time
- Ending an automation session between Excel and Access
- Late Binding to a dll
- Context menu for chart is missing
- RE: Transferring data from Access to Excel in VBA very slow
- Reply to different address
- Tom Ogilvy - Need a little change
- Dispersing a value over multiple cells using a macro
- Use of Range Property
- VB code for selecting all rows below filled column
- Reduce Flashing
- Error finding match looking for intersection
- Add borders to certain cells using VBA
- Picture Size Variation
- Worksheet in Userform
- Digital2k Poster
- Link cell contents to a Macro?
- How do I set up a date to update individually on each worksheet?
- MS Query Problem
- Shared Add In Project, Cannt get it working in Word or Excel
- Combobox Error Handling
- Check if file exists / open it
- Change name on modul
- Get external data by dynamical url -> no update
- Refering to another module
- How to Change External Link to Internal Link
- Shockwave Flash ActiveX / CallFunction method fails
- Multiple Active Worksheets
- Hide Window Caption Bar
- Sorting points
- Cell reference
- Defining a function to use multiple places in code
- listbox
- EXCEL MACRO
- Sheet array based on cell value
- Importing and splitting large text file
- Adjust charts dynamically
- Selection Column
- VBA syntax
- Detect lines in specific sheet at load time
- Change variable permanently
- Visual Basic programming in Excel for conditional formatting
- UnauthorisedAccessException
- Cell format changes when a saved sheet is opened on another machine
- Need some help with excel
- slow macros when sharing workbook
- Stop select and copy of excel sheet in protect mode
- Search and Display
- How to SCHEDULE A EXCEL file usign Windows scheduler
- Send emails through VBA but skip outlook "Yes" button
- what is difference between "=" and "=+" in excel function
- Unable to release Excel COM object
- NEED HELP - Auto Email file from diff locations, I donno server na
- how to enter another language word below the English?
- make macro "invisible" to end-users?
- recognising if a number is in a list
- recognising if a number is in a list
- Which is faster... or better programming
- How do I run a macro when cell value changes? WorksheetChange?
- Color Pallete in Active X control Properties Excel 2007
- Enabling/Disabling SubMenuItems on the Menu Bar
- Changing cell values in a range to Hyperlink to sheet in workbook
- How to use a Range in a Loop
- Get Add-in Description with VBA
- Find Range>>Copy>>Insert into Sheet
- How to bypass Excel error message
- Problem with a selection in a matrix-function
- Remove emty values from a array
- missing red brackets for formatting
- Loop & Calculate
- Excel dosyaları arasında bilgi paylaşımı
- Include/Exclude Holiday - Repost to Programming Section
- change label on multipage
- inputting text to textbox in cell not userform
- Calendar range and date intersect
- Web Queries in VBA
- Erratic behaviour of [Sh+F10]
- apply a discount
- lookup problem
- For Next loop faster with counter after Next?
- Shrinking buttons
- How to put values instead of formulas into matrix?
- Footer Date and Time......to include seconds.....please advise
- Hiding the userFormDuring Print Preview Advice Please
- How to move pictures to the center of window?
- How can I monitor CPU time of algorithm I developed in Excel vba?
- Exit Event
- Click an Optionbutton
- Runtime (Latebound) control withevents
- Help replaceing input boxes the custom forms
- Enable False
- HELP WITH AN EXCEL PROBLEM
- Syntax error
- Pass Info Between Macros (Re-Visited)
- excel macro
- scroll lock?
- Preserving HTML Column Widths in Excel
- Working with multiple workbooks.
- Looping Macro Doesn't Work
- change colour of Excel title bar
- Object Required error
- Quite the challenging question
- Show Format Cells Dialog Box?
- Writing Batch File
- What is VBA programming code in 'Excel12' format?
- Create a new function...
- Status Bar does not display in Excel 7.0
- Validation is not working
- macro to download a csv file
- Go all the way along a row and then delete...
- UDF's Problems; Is my Fundamentals Skewed
- Sub unexpectedly jumps to another sub
- Can't watch userform code
- Query while Importing web page table
- Faster way to loop through two ranges
- Hide column if particular cell is NOT a certain value
- Help on xl* and mso* Help ?
- Formatting Textbox
- Import text file
- Why is this so ?
- Date Math if then
- Passing Info Between Macros
- Control size of input box
- GetOpenFilename type mismatch
- Web toolbar comes on by itself when opening a file
- Error while moving sheet
- i need to learn how to do pivoting in excel, how?
- Macros to copy formulas
- Mileage Chart
- Input box cancel
- ASP.NET - can i use it to build dynamic Excel forms?
- How do I "if statement"
- How do I get the content of the cell left of the active cell?
- Opinion on Size/Length of Macro/Function/Sub
- Find Text in VBA if it is IS Nothing then...
- How do I copy data from a closed file.
- automatic cell comment
- converting formula to text
- need help replacing string with "."
- Functions
- Restrict Recorded Macro to a Particular Worksheet
- date criteria with SUMIF or SUMPRODUCT
- Find and offset in named Range
- Custom Function
- AVERAGE formula. PLEASE HELP!!
- Macro Help: Word doc into Excel
- Problem w/ Code- Error 91 @ run-time
- Listbox Event for selection/scroll change
- alphabetically sorting an array
- Problems checking for an Addin
- string.matchPattern ???
- workgroup access connection from excel
- How to get the user name
- Copy Formulae across...
- Curious Find/FindNext Behaviour
- Macro to clear range contents when cell contents are changed by us
- Canceling the rest of a Sub
- ENTER keys to execute code to add menu
- Timing VBA code
- Can you help me please
- SolverOK / SolvOK function does not compile - SOLVER library is referenced
- Error opening another excel file using vba
- Listing/Selecting/Viewing Range Names
- search and delete unwanted text
- Copy and paste from several Workbooks
- Copy and Paste all workbooks of a file
- Macro to delete specific rows above selected cell
- Chart Sheet/Axes
- Error using 'Union'
- Beginner Array Question
- using excel on a website
- Clearing/Resetting UserForm Values
- Error handler resume
- Passing a value from 1 userform to another when you dont know who called it.
- Pivot Table Nightmare Urgent help required
- Check difference
- Format Problem
- Is there a faster loop than this
- Error in Excel VBA Code (Error 91)
- Refer to worksheet
- Get info on toolbar button by clicking on it
- Referring to a cell(Newbie)
- Problem with 2-dimensional array
- hyperlinks
- Newbie: VBA problem when copying cell range
- Loop through range issue
- Removing an Addin from the Tools Addin list.
- Name sheets from a list
- Office 2000 Automation Events.
- Global variable destroyed when form closed
- HRESULT: 0x800A03EC exception when trying to hide a sheet.
- Add cell value from cell above when cell is empty
- calling data from access
- Text Dates with 2 Digit Year
- data from cell
- =WEEKNUM
- Assign keyboard short cut to subroutine
- Newbie question: show value from drop down in another sheet
- Automation Error: The system cannot find file specified
- Display ALL Names of Drawing Objects
- Macro Skipping a column?
- put the company logo in "A1" of sheets 4 to 44
- buttons
- Make form controls private (ie. hidden from intellisence)
- working with ranges
- Database ?
- Changing cell color based on cell value
- Stop showing the Folder explorer bar?
- text box data entry
- Help with runtime error 424 Object required
- How to cancel the Edit status
- Refreshing web query that is password protected
- Setting focus on User Form Listbox
- programming
- programming
- Returning to the last sheet used
- Almost there. Help printing multiple sheets as one print job..
- Poblem with a macro
- Simple Question
- how to select ALL named shapes in range
- macro to delete rows on condition
- Need to convert Characters between Unicode and ANSI
- Changing file formats while saving
- del dupes in a split cell, outer loop
- CONDITIONAL FORMATING/COLOR CELL WHEN FILLED
- Conditional Formatting
- Integrating data into VB code
- RE: CONDITIONAL FORMATING/COLOR CELL WHEN FILLED
- Run-Time Error 91
- FILL ARRAY ONE ROW AT A TIME
- Excluding a string
- Insert rows in linked table that are added to secondary table
- Trying to figure out IF formula
- Extracting Data from Multiple worksheets to a single worksheet
- Save file with new name(Save As)
- Need help Refining a Macro & make more Robust.
- Conditional Formating Bug when using HasFormula UDF
- Conditional Formating Bug when using HasFormula UDF
- How can I add macros and/or key shorcuts to VB Editor?
- Does rounding work at all?
- Number of lines
- How to call adobe acrobat file conversion from within Excel VB mac
- VB Study Material...?
- Range selection
- i have a good tool to add to excel
- how to import a 2-d array into excel using vba?
- Macro to Save worksheet to new document
- Universal CommandButtons Accross Worksheets
- replacing dynamic currency amounts with a character
- Distinct Query
- VBA Code Help
- Paste values from TextBox to ListBox
- Problem with Setting Bar Chart Colors (> 56 bars)
- Macro to record date on sheet data is entered in a cell ?
- Copying a Worksheet from an Addin
- Show/Unload Userform
- How to bypass startup form of access db via visual basic app/XL
- Access DB sub instantiate from excel vba
- RE: Programmatically Adding Code to a Workbook
- Gather data from multiple excel files in mutiple folders
- Passing a Forms Control to Function
- Why doesn't this color set work?
- Re: How to avoid rounding when comparing numbers?
- help with vba code please
- Cell click
- Still trying to find the date
- VBA Calculation Button
- Need some help with more effective range manipulation
- Comments and Pictures
- RE: Programmatically Adding Code to a Workbook
- Basic Spin Button Code
- Need help writing do loop
- looping puzzle
- Copy contents of one file to multiple destinations
- Application-defined or Object-defined error
- update links not being removed in when open in excel 2000
- IF Function
- Class Module?
- Define a range end based upon current cell location?
- Security Question
- OLAP: Security Error when updating a Cube
- copy selected cell
- 'equals' for non-numeric data
- Results of Advanced Filter to Array
- format text in imput box
- Creating a list of Subfolders and sizes
- How do I insert a HTML file in a VB Form?
- Validating Cells
- add a date in a row from row above
- VB and Excel
- Populate form combo with unique values
- Grup and subtotal in VBA
- How can we tranfer data from iSeries in MS-Excel 2003 with SP2?
- Hiding Row and Column Index in a Worksheet
- Is This Possible?
- Ogilvy or someone else please advise me!!!, KeyDown event
- Excel to Play Flash Animation or GIF in User Form???
- Validate user input with specific date format
- Create a comma-delimited file to be opened in Excel
- Javascript Question
- Import Text File Directly to an Array
- How do I set up a "Unit" conversion system in EXCEL
- Recalling a previously active worksheet
- Page Break After 7 Inches
- RAM Question
- lock cell after value is automatically placed when workbook is ope
- verify a path exists
- Entering Data into a spreadsheet via a UserFrom Advise Please
- How to create seperator in Right click..?
- Call up build in excel command using macro
- Pausing and resuming a running macro
- To use AppSentinel to set-up XL Macro for a dll; still need VBA 6.0?
- Execute macro for weekday
- Dynamic Charts between Files
- Cell = variable+1
- display userrform label for x seconds
- Create an array of all open workbooks
- Need to revise this Sorting code a bit.
- Extract Data From Active Directory
- Hoping
- show form for very short time
- Shared Workbook with user code lookup to display sheets
- change cell color based on a tab color
- Re: If Then condition on Values
- Prompting for a Directory Name
- need help w/ macro prompting with info and pasting the info based on user input
- Formula if Column E in Sheet 1 equals Column M in sheet 2, = Colum
- Mess-up When Exporting to an Excel in Query Analyzer
- File Size Problem
- If Cell equals "XXX" Then......
- How do I change a number to a written number?
- SolverSolve return values
- Macro to Transpose 1 col into 3 cols
- Code Reference Issue
- Is it possible to prevent error message displays?
- Force a cell to display as Text
- Public Const to refer to a range name
- Using a macro to locate a user given value
- Condensing Code
- Select Distinct from Array
- Detecting scrolling in listboxes
- Trouble with Advanced Filter
- Function to Return File Name of Active Workbook
- Why does my formula bar display a lengthy string, but my cells display #####?
- Macro to toggle text orientation
- Manipulate Excel file via scheduled task?
- DDE link to outside application
- Formula using Days (DDD) in worksheet name
- RE: Formula using Days (DDD) in worksheet name
- Using a Macro from one workbook within another
- How Do You Pronounce "Jelen"?
- Macro to merge open workbooks
- Macro to merge open workbooks
- Check Box Moves
- refer to worksheet by index number in formula
- Errortrap for WorksheetFunction.CountA - "No cells were found"?
- excel data to word table
- Looping solver for recursive optimization
- find word
- userform initialization problem
- move within ss by active cell position, NOT by cell names
- finding cells excluded by autofilter
- I need a Macro for Sorting workshhets
- 'OR' in Formula & # of Parameters
- Add workbook variables
- Excel sheet to PDF Macro = security question
- Transferring Data from a UserForm to a worksheet
- Backup only one worksheet
- String Comparison using Like Problem
- Force Calculation
- Force Calculation
- is there a basic profit sharing formula available for a sml office
- programming to the vbe question
- Run-time Error 9: Subscript out of range
- Check date and act on it
- ParsingFullName
- Setting Data Validation Programmatically
- Bob Phillips Excel Site
- Creating a macro to formatt data
- Redundant
- Run time error '9'
- What am I doing wrong?
- Text from within a sheet into right header
- Programmatically detecting presence of named macro in workbook
- closing all files
- If Sheet Exist
- subtotals
- How to make a llistbox selection to open another listbox?
- excel wont let me create a formula between worksheets
- Preserving Comment Box Formatting
- Referencing Excel Cells
- Consolidating ROWS instead of columns HELP PLSE...:)
- Changing code to Consolidate ROWS instead of columns
- Possible to link servers with ADO or others?
- format time in messsage box
- Number Combination
- Loop through Columns
- Hand Cursor / Disabled Mouse When Sheet is Protected
- how do i covert number to words in excel?
- tab order related
- Need Help with Call Shell("cmd /K netstat") Function!!!
- Joining Text from two Cells into One
- Credit Card Calculator
- How can I use SUM in a user defined function procedure?
- Emailing Worksheet with VBA Code
- Formular Is Too Long
- Excel File open
- show multiple rows on a user form
- vba for paste special
- Store Multiple Cell Values (Cell History)
- File Saving macro ?!?!
- delete row syntax
- How to reset checkboxes from control tool box?
- plot graph from multiple worksheet as embedded chart object on every worksheet
- if then statement with 16 constraints and 1 equation
- need to delete all rows that are gray
- parsename
- fr default color index, need color #
- Data - Group - Hide Details
- I can't find a specific add-in!
- nested while not working any more...
- Routine works on first sheet but not second
- Insert Sheet Code
- Can I build a Find function into my spreadsheet without a button?
- Help with pivot chart calculated field
- Value extraction problem
- Modfiy row of VB to select range of columns
- HELP NEEDED...
- Optional Variant
- Limit characters in an Input Box
- Uploading an XML Doc in Excel
- User Form with CheckBoxes
- Store data JUST entered in Activecell after clicking command button on worksheet
- Retrieving name from command button on Worksheet
- Stepping Through Rows
- how does vba relate to vb.net?
- Print Button Macro
- Update sheet1 with Data sheet in same workbook
- lifelines on multiple people in EXCEL with Timeline output?
- How to hide workbook in background...
- loop does not work correctly
- altering URLs with code
- Code to pull data from webpage
- Group data and pick a particular row based on a condition
- List box error
- How do I get balance forward to work in check register?
- Excel is crashing
- Not enough system resources to display completely
- delete macro and auto save/quit
- COUNTIF formula with date range
- HOW TO: Check if a picture exists?
- Excel 97 not running macro that runs fine in 2000
- Using ActiveCell to specify a column
- Excel Worksheet Protection
- Formula to add cells from external file
- VBA code to move contents from one cell to another
- Macro + Dates formatting issue
- How do I ref OutlookCOM in my Excel2003 PC and run it on Excel2000
- range.offset generates a Run Time error 1004
- Extract file names from folder
- Text-align in buttons userform
- Last Cell on a Worksheet
- To include quote marks in selection.formula
- Select and merge cells with duplicate values
- Replied to post which disappeared?
- Another Auto Fill variable length column
- Delete the contents of columns if the month changes
- Losing Cell Protection When Saving Workbook
- Delete the contents of columns if the month changes
- ReDim=overwrite?
- How can you write a formula that searches for a particular word?
- Syntax for multidimensional array
- sumproduct
- writing excel macros
- Test if Function is Run from worksheet or from VBA
- HOW TO: PivotTable.SourceData
- Last Cell on a Worksheet
- Creating and using an array
- Chinese characters - UTF8 CSV files
- Pop up window prompt for name/address upon opening of file
- Slow RowHeight behavior
- macro for graphing - should be very easy...
- HOW TO: PivotTable.SourceData
- Looping through items in a submenu
- Looping through items in a submenu
- generare a pause in a macro?
- select specific rows
- Find worksheet
- Passing Variables within For loops to other modules
- Progress indicator while saving a file.
- Integrating xls with vba
- worksheet change and DDE
- Goods In Sheet Problem
- Creating "grouped" checkboxes
- Find a specific string in a cell
- Macro help
- Checking Active Sheet is in an approved list
- Simple String Question
- changing Pivot table name via macro
- Delete Excel File
- ReDim string in loop
- Select all duplicate values in a row
- Possible Combination
- find within a named range, then deselect the range
- Why does this mouse menu call a sub from another workbook?
- Identifying a blank cell with existing value
- Adding data to a worksheet from a UserForm
- Shared VBA code between workbooks
- Pivot Table Help
- Excel to load COMMAND and type a Run Command?
- alternative for =0 and =""
- Override
- Excel crashes with long file names
- Avoid counting rows/columns with formula but no values
- Sort table based on array
- Named Ranges
- Two digit week numbers in VB
- What a silly question !
- "Method 'Worksheets' of object '_Global' failed "
- NEED Help - How to capture the Event's progress in Progress Bar
- VBA - Chr(13)
- Excel to load COMMAND and type something...
- Run macro from command line
- Returning newline from a function to a cell
- ReDim Matrix
- email format plain text
- Text-to-columns. Destination:=matrix
- Destination:=matrix
- Consolidating several sheets into one.
- How do I check if a sheetname exists in a file?
- Placing text-to-column data in array
- Excel macro "loop"
- Check if workbook is already open...
- How can I copy grouped data
- find a date using several worksheets
- Inserting and deleting spaces with a macro
- Linked Databases
- Copy row data based on drop down list selection
- Activate Spin Buttons with Keys
- macro for inserting a row
- Adding Time
- vba filter question
- Office Automation - 2000
- Enable Macros - Trust my file on my PC
- Saving a workbook - vba
- calendar/journal
- help with addresses in rows
- Reference Outlook in Excel2003, but not working in Excel2000.
- Linking Embedded Sheets
- Opening Access without declaring a Global Object?
- formula question please
- Looking for solution on Printing multiple sheets
- Time weighted investment returns
- vba - working with autofiltered ranges
- vba - working with autofiltered ranges
- vba - working with autofiltered ranges
- vba - working with autofiltered ranges
- Find and replace in every folder.
- Installing Add-ins
- countif (2) conditions
- Office 2003 vs. Office 2000 performance
- How can I force the file to over write the existing file
- John Walkenbach's Custom Menus
- I want to use the List Box to go to certain areas of the workshee.
- Decimal Places for NOW() in VBA versus formula
- Delete Picture VBA If Then Problem
- SQL
- Trying to execute function after negative if conditional nested in For each loop
- String Contains a Value
- Accessing every option button on a frame
- how to merge cell please help
- Modification to code to consolidate two sheets...
- How do I bypass the message to save when closing a file by macro?
- Limit to field size with .CopyFromRecordset
- VLookUP ARRAY , how can I make it not relative in macro?
- is there worksheet Int function to round decimals up instead of do
- Match function and displaying results
- write WorkBook_close event dynamically
- # of Days in a Year
- Take Action Based Upon # of Rows in Another Worksheet
- UserForm Data to Worksheet
- Exact lookup formulas, VB Instead?
- Go To Next Worksheet in Loop
- Subtotal multiple columns
- formula help
- Comboboxes on userforms
- how to suppress "update links" message for workbook with no links?
- Deleteing a portion of a cell.
- Date to refresh in chart title
- Some ideas
- Macro form
- Reset workbook counter to "0"
- Copying Regions with Filters/Hidden Columns
- Confused - Range and Cells
- AutoFill Using a macro
- conditional statements
- how might I tell a user they did not enable macros for excel?
- Passing a list to an array
- Passing a list to an array
- MsgBox Interactive
- permutation of values in 2 dimensional array
- Reply to outlook email from excel script
- Interop - "Unable to set the Color property of the Interior class"
- MultiPage change CRASH!
- Keeping 0 at beginning
- Count different values in a column
- Need one miracle
- Combo Box / VLOOKUP
- Reviewing a list of defined named ranges
- Copy data in named ranges to a newer version of the same template to identical ranges
- VBA for Cell locked please help
- replacing defined names for ranges
- Help with VBA...
- Displaying all Named Ranges in workbook
- conditional formating
- Convert Binary to Hex
- activate last worksheet in a different workbook
- Separating text and dates.
- Userform with spreadsheet control will not load
- How do I test if the weekday is between Monday and Friday ?
- Macro for comparing Hotel Prices
- Search a string
- Modifying code to Consolidate only 1 column..
- Print ranges based on cell value
- How do i count date cells without duplicate values in excel?
- Conference pictures
- VB Code to Send Workbook to a FTP
- Creating a Macro for refreshing data in a columns
- Creating a Macro for refreshing data in a columns
- Conditional inserting content in new rows in other file/sheets
- Conditional Minimum value
- Sorting list
- search for duplicates
- vbOKCancel box to close
- Building an application on top of Excel
- Macro to sort values in list without 0's (zeros)
- "On Error" help required
- Timing/loading bar
- About Excel Version
- Value on worksheet with fullstop either side
- How do I get User Form to run at start up?
- Get all files from folder
- How do I print hidden pages?
- extracting data from excel
- Provide a check in VBA for backward compatibility of commands
- Reporting several Bugs for Excel 2007 Beta 2
- Commands for cursor moving right, left, up, down.
- Save as .pdf
- Intersect Method
- NumberFormat for date axis is not working
- Unvisible checkbox
- How to add data to separate worksheets?
- Need help with an excel formula
- where to place undo-function in vsto-projects?
- Copy worksheet name into cell A1?
- Array Formula cell via Excel VBA
- Line numbers in VBE
- Find a cell and then insert a formula into adjacent cell
- I am getting Unable to record
- Reset Checkboxes from Control Tool Box
- Command button auto select after pressing Enter
- Excel
- tabstrip name format
- Check User
- Chart Hide/Unhide Series
- Visual Basic - active macro on cell click
- How to find a particular cell using macro?
- Need someone's help with this issue...much apprecaited!!
- Button to print non-active page - How?
- AutoCorrecting in VBE ??
- Referencing Diff Sheet in Formula in VBA
- Label = whole number - How do I set this?
- RE: Formulas or VBA?
- Controlling scroll bars in file dialog
- Vlookup/address question
- Text box caption=Cell Value (without command click)
- Locating Matches & Highlighting Background
- Manpower Schedule
- insert rows in multi sheets
- Lock single Module ONLY in workbook; without locking VBA project?
- Help! I can't get a spreadsheet to open
- How to use send keys to unprotect VBA project
- Clearing row colour & row data
- macro Cell designation
- Identify non-alphanumeric characters within a cell in Excel
- Worksheet_SelectionChange Question
- need help on delimited
- Detect Cell Changes
- Need help from Excel and SAP expert!
- Formula Problem Summing Data in Cells on Previous Worksheets
- dynamic web queries with vba
- FullName vs FullNameURLEncoded
- Range.Text/Value returning the number 3?
- GetOpenFilename FileFilter
- Recording highest value dynamic cells
- VB.Net - retrieve actual formula string
- Creating and Naming a Folder and populating it with files
- Creating and Naming a Folder and populating it with files
- Copy Data
- Macro =sum function not working correctly
- Highlight text (interior color)
- Userform and Goal Seek
- Need workbook w/ VBA to open in new & separate application window
- Such a thing as CurrentCell..? ThisCell?
- Adding shape-type textbox into excel chart sheet
- Printing Multiple Sheets
- Printing Multiple Sheets
- Accessing Image Pixel Data
- Stock Quotes from web
- Remove Holidays as DateSerial using Case
- Excel and launching userforms
- Excel functions and programming
- do i need to macro this function? seems too simple
- How do I create a excel Template to enter data into same workbook
- How to Use Chip Pearson's Text Import Code
- Recovering the ribbon in Excel 2007 after an error
- how to use if command with time in function?
- need help for a golf spread sheet
- Need help with loop code
- how do you create a bell chart for sigma using excell?
- Referencing data from another workbook
- Initializing UserForm which uses MultiPage controls, part 2
- "Renaming Form Buttons From Macro"
- Convert Time Decimal to standard time.
- Conditional Formatting using cell from another worksheet
- My 1st IF-THEN-ELSE Procedure
- Using Built in Functions in VB Code
- Delete Rows With Specific Text
- More RGB Woes
- Command reference manual(s)
- run macro upon clicking a cell?
- Help with VLOOKUP / VBA code, please...
- Autodate worksheet problem
- what is the problem" TOO MANY DIFFERENT CELL FORMATS"?
- Lists in excel
- How to paste HTML code as text into a worksheet?
- AutoFill Macro
- ActiveCell.Row in Range().Select?
- couple userform questions
- Sum after sorting
- If event When a specific cell changes
- How to embed a macro in a flat file?
- Info from User Form to Data sheet and back
- Find text in a cell and select whole row question
- worksheet linkage
- sum function
- Need help setting the worksheet header/Footer margins based on string height?
- Need Help with printing multiple sheets Please
- fonts names in loops
- Upload Workbook to FTP ???
- Setting Funtion Value to Cell
- How to avoid volatile hyperlinks?
- How to arrange that macros are from THIS w/book?
- On Error Resume Next
- The most powerful computer security tool
- Worksheet place in workbook
- prop. scale images - have code, just need slight mod
- Listindex problems in multicolumn listbox
- Parsing a name
- Custom Quoting
- VLookup Error
- Error handling in VBA 6.3 in Excel 2002
- pivotable drill down
- command to do "nothing" in If/Then statement? #2
- Templates and passing functions
- command to do "nothing" in If/Then statement?
- Setting a value is slow
- Macro that AutoFilters based on Cell value
- Pasting from Excel to Powerpoint
- Clear color but not pattern?
- I need to Round Cells up to next .99$
- Delete row data and cell colour
- Combine date and time
- Add/Delete rows based on count
- Macro to insert object into spreadsheet ??
- Sumproduct Error
- Worksheet_Change problem
- Macro that adds records
- delete row of text with 3 macros & [placeholder]
- How can I duplicate conditional formatting
- Excel - User Defined Function Error: This function takes no argume
- Vlookup
- Problem placing embedded charts
- CORRECT SYNTAX FOR RUN...
- CORRECT SYNTAX FOR RUN...
- Embedded Excel Object - Containers Path and Name
- Recording date Excel file is attached to e-mail?
- count of rows
- add prefix to filename - macro to loop down column
- PivotCache
- select one value from drop-down and return multiple corresponding values
- select one value from drop-down and return multiple corresponding values
- select one value from drop-down and return multiple corresponding values
- Excel spreadsheeting
- Lost Basic Excel & Word
- Problem with discussion group
- Challenge of the day: linking VBA code to combo box selections
- Macro to test characters with block of cells and change font
- selecting data in combo box
- If column B not empty, value in column A = L
- selecting data in combo box
- Drawing Program Collaboration
- Finding window handle of data validation listbox
- DEFINED NAMES AND FORMULAS
- Linked Workbooks
- Make field Fixed lenght
- Sumproduct Problem???
- overlapping picture problem
- Incorrect usage of VBA WSfunction
- Open all files in subfolders
- VBScript MS Excel Problem
- inheritance
- NEED HELP - For run time error '1004'
- NEED HELP - For run time error '1004'
- Changing the value of a protected cell
- Excel Macro
- Download with Active X
- copying name box to another sheet
- Formula not evaluating immediately
- "Can't enter break mode at this time"
- Post File Size In Cell
- SaveCopyAs - Timed Capture
- Can this code be modified to delete rows?
- writing to a DB4 file
- Why can't locate the file?
- Application.EnableEvents help
- Auto Jump to Cell
- Workbook close event
- Help in VBA
- Command Button Created from Forms Menu Question
- Dim i,j,k As Integer
- HOW CAN i HAVE A CALENDER POP UP WHEN i CLICK A COMMAND BUTTON
- =NOW() Returning military time
- Deleting cell values
- Application.GetOpenFileName
- Returning reference of frozen cell
- Alt Enter vs. Chr(13)
- Do While True "Select" problem.
- Using XmlImport/Export Fucntions for excel
- Populating form dropdown at run time
- Clearing A Row
- Error handler that does not end macro
- RefreshAll not quick enough
- Read
- Re: VBA counting colors, errors
- Replace all values in a column with values using a mapping from another worksheet
- Compare Columns and Copy Data
- Re: Problems loading and AddIn
- Re: Applying changing cells colour with different two cases of statement
- Re: VBA counting colors, errors
- RE: Detecting "CallingCell" In Function
- Re: Unexpected result copying an array
- Re: Detecting "CallingCell" In Function
- Object error when using Excel in IE
- open file
- MsgBox date
- Hi Trevor :)
- trim and vlookup dun work
- How to make TAB key work in a protected worksheet
- Time Countdown
- How do I name a spreadsheet from the value in a single cell
- VBA code to filter data
- Formating and Precision...I think
- Manipulating Formula
- Data from ASP to Excel
- Excel VBA UserForms in in Mac OS X
- Autofilter for multiple sheets
- Go to current date upon opening Worksheet
- VB Function Round vs Excel function Round not behaving the same Od
- Looking up a value and returning another
- need some help clearing a range
- Code not working NOW ? But it was before???
- Still Looking for help on printing multiple sheets
- Set sem__ = Sheets("template").Copy(before:=Sheets(1))
- combox question
- trouble setting plotarea size
- Type of Drill-Down View
- Help with Code
- Transferring information from one user form to another
- Weird sorting results
- help with a macro
- Here's a quick and easy one..
- VB.NET - Showing a form from a thread
- unzip
- OFFSET() function with external references
- Question on Logical IF statement
- What language is Office Suite written in?
- Exclude Sheets from Macro
- Excel IV macro sheet
- ReDim an array AFTER it's loaded into another array
- PASSING MACROS WITH ARGUMENTS FROM OTHER FILES TO BE RUN
- VBA Programming in Excel
- Transfer Cell Value
- cell changed -> worksheet name changes
- Menus in Excel 2007
- RE: cell changed -> worksheet name changes
- Average of range help
- Adding to a Row Range
- Formatting Via a Macro
- Macro to locate/modify text
- Macro Question
- cmbobox shrink to fit
- VB Code is working for row1; how to apply to row2?
- Modify ADD ROWS Code - Excel 2003
- copy on the next available row
- Change a Function
- How to enable javascript in Excel?
- userform text box and a scroll bar
- auto refresh
- Auto Fit in Spreadsheet XML
- if-than statements in excel
- How do I delete some rows while keeping others
- Array Help
- Rounding
- Macro for locking cells after worksheet is protected
- Does Conditional Formatting create macros in my workbook?
- marco help
- bottom border every second cell in range
- border every other cell in range
- border every other cell in range
- Tracking Users
- border every other cell in range
- border every other cell in range
- Insert formula into a cell doesn't work :S
- serial time
- Problems with Excel via IE
- menu ids
- need to access the xldialogprint object parameters
- Discrete random numbers into an array?
- Windows.Activate
- how to reccognize what day is it ?
- Disable Mouse During Macro
- opening files
- Arrays - declaration, adding values to arrays and calculation
- Remove Every Other Friday
- autofilter based upon combo box
- copy to new workbook
- Can you get excel range object off the clipboard?
- Userform Text Box
- Exporting from access into excel
- Re: Sheet name ref in cell B2 and then!
- Command Button Invisible
- Speeding Up Excel Performance-VBA Loops
- Add a text to a line
- Exchange the content of a .NET DataSet with Excel VBA
- updating data location to build a VBA graph
- adding coloured cells together
- finding last cell of data
- Links - Why is this happening
- Golf Challenge Continua... Cert Printing inteferes with UDF
- Yet Another VSTO Publishing Problem
- Clear button adds to combo box lists
- Real Users Name Not Lan ID
- Setting LeftHeader / CenterHeader
- Dataimport to Excel
- Toolbar FaceID
- Passing a .NET DataSet object to Excel to be used with VBA
- date in arabic ?
- nRows range within SUMIF
- Add-ins Referencing
- Print in one page
- Selecting a data range using a variable
- VBA Loop until certain cell!
- Average to be copied into specific cells
- On event macro
- File error some number formats may have been lost
- excel "web query" timeout
- protect sheet
- Excel Add-In for Analysis Services - What-If
- Passing arguments from VBA to DLL
- Load Excel.xlb
- Deleting rows when a certain cell has a certain value
- lock moth for a date column
- sql vba applications
- Plotting more than 32000 points on a chart
- sql that will refer to a cell in excel
- RGB color palette
- Pivot Table type mismatch
- Open a sheet rename and move to another workbook
- Runtime error 1004/ Save As method help
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.