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 |
- Adding timelines to a chart
- Hide rows in visual columns without data
- find and paste - help with code
- Macro to lookup in a workbook and append it to a table
- IF Statement giving a Syntax Error
- Having Trouble Creating an Add-In Application.
- Run macro on columns with a "defined name"
- Long VBA Code - Can it be reduced
- Adding Percentages to a Stacked Chart
- Pivot Table Creation Macro fails with Error #5 "Invalid procedure call or argument"
- Positioning UserForms, Input & Msg Boxes
- help saving trees by excel *free* macro...
- Custom button behaviour (activation and deactivation)
- lookup for bright solution...
- Solver Macro in Excel 2007
- add a .jpg to msg box
- RE: Concatenation prob
- Help with ADO query on MS Excel worksheet ...
- Adding leading zeros
- (previous discussion with Tom - re:Dynamically creating pt from li
- Re: Concatenation prob
- How to count blanks and spaces that look like blanks
- Setting AutoFilter to "Show All" when worksheet is opened
- Macro Reference Cells
- Macro to search every row in sheet2 then display all matching resu
- Macro Saving
- Link Not Embed Images from URL
- Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date?
- Delete rows with data
- left align active column/cell in window
- If Then ?
- Halt Macro Execution
- VBA - Character Removal
- Rename a range of cells with a macro
- sql
- (repost) Dynamically creating pivot tables from page-field list
- IF formula - positioning difference
- Is this code ok?
- Deleting
- Calculating Gaps Between Numbers
- Password recovery help needed due memory loss caused by cerebralinfarction
- Slow Analysis Tool Pack
- Place Value in Cell
- Import XML file from the web in EXcel
- Macro Help
- Simple qu i hope
- Deployed add-in doesn't load
- "Another ScrollBar Question"
- Insert picture
- Workaround for ChDir/CurDir when path has unicode characters
- Using Mutiple Sheets in excel in shell script
- List all the groups a user is in
- Excel Solver Macro: Contraints Get Lost! - Please Help
- cant sum the values in cells
- Insert row on diff sheet IF
- Question on SubTotal function
- Copy schema objects
- Vlookup VBA on dates
- Conditional Formatting Problem with currency.
- Enable/Disable Command Button
- IE Automation - Trouble getting changes recognized/committed
- xlup to find last row
- Calendar Contol with mutiple textboxes
- Why isn't the conditional formatting working?
- Dynamic Cell Reference
- Converting Text to Numbers
- How does VBA interpret Dates?
- Using a variable to add fields to a pivot table
- Name Increment on Open
- Problem with getting numbers in some range values!?
- Excel and Powerpoint
- Disable command bar Excel 2007 and Vista
- Toggle Macro
- Importing a web page into Excel (picture)
- Checkbox Event Macro
- Help Can not Copy Sheet but Can add a New Sheet!!!
- Find text in between to knowns
- Create a list of hyperlinks
- how to monitor worksheet usage - using counter workbook
- Let property changing all values in Class module
- Transfer Writen Notes
- Creating Pivot tables dynamically from page filter values summary
- How do you delet all the defined range names in a excel file
- Add to Chart
- Cannot change Cell value
- Closing a workbook from a macro doesn't close the workbook
- Extract string after specific characters
- Progressbar on userform for waiting querytable retrieving data from web
- Testing for <Incorrect> Dates
- Alphabetic lookup within a pick box
- Help about macros
- Find and replace, or insert in VBA code
- Storing times in an array
- Removing Field Subtotals except for 2 from from PivotTable
- Mail Merge with Macros
- Offset issue
- 2.5 StdDevs
- Trendline Coefficients
- Copy Average Caluclations
- Combo Boxes - What to do first
- Extremely Urgent need to arrange data
- Problems with the OnWorkbookClose() Event
- Issue with For loop
- RunTime Error 1004? _Default Property?
- Relate a Number with an ARRAY
- Powerpoint chart -> Excel
- Sharepoint File Dialog
- How To Automate Copy Certian Cells from Worksheet A to Certian Cells Worksheet B?
- string size limitations for array formulas
- Help with type mismatch error
- Sum all search results?
- Strange RefEdit Problem
- Personal.XLS Prob.
- Code for Calendar control
- please help me program excel to scan for top 10 highest values
- Active Sheet
- Print Routine Error
- Memory Issues with Excel
- A real cut and paste
- Need help creating, manipulating and reading global arrays ...
- Retrieving Data: Speed of beating down rows vs retrieving from array?
- Can Excel "extract" ranges of numbers listed in the A column?
- Swap 2 ranges
- Help needed for old thread Please ??
- Excel / Access User Conference - Oct 24-26, St Loiuis
- Pivot Table Page Field (Repost)
- Delete rows where colums 4 is empty
- best solution for db
- Find a value and delete that row
- number cells within a range
- Sorting and Subtoaling
- Code Protection
- Global Book Protection
- count number of non empty columns
- Use the Excel LogEst-function at server
- Empty row
- Automatically add Conditional formatting on data/subtotals
- Add method of "Sheets" class fails
- make changes to excel workbook
- Newbie Error
- A) 2 Contiguous Popups B) The 'reverse' of .onaction
- "Scrolling with Scrollbar or SpinButton on UserForm"
- Looking for someone who could extract data from web-page to excel- with paying fee!
- macro to identify columns to hide
- Can I type text in one cell and have a value auto-enter in 2nd cel
- Numeric data only in text box on userform
- Custom Cell Format problem
- Health chart
- Print If Column Contains Blanks (No Characters)
- Read Network Groups Belonged To
- Roger Whitehead contact details
- SpellNumber
- VBA to lock & send multiple workbooks into Essbase cube
- Why R1C1 range parameters in VBA Pivot Table setup/
- 3 combobox.values to one cell
- Auto filtering pivot table field
- Do Not Load if Not Using Auto-Execute Macro
- Cells Protection
- Shift cells to the left
- Help!
- Select Variable Number of Columns
- Messing Up on AutoFit
- Biff8 standard encryption(office 97/2000 defalut encryption way)
- Biff8 standard encryption(office 97/2000 defalut encryption way)
- multicolumn listbox
- filling web forms from excel
- NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON
- Unhide roes in a different worksheet - My code is not working
- strange problem with public variable
- Excel fornual to delect rows
- copy range with different ranges.
- Webbrowser control not loading Html string
- New rows overwriting existing problem
- Copy last row from sheet 1 to last row in sheet 2
- Copy and paste file name
- Macro creates formula with $ absolute. I want to drop the $
- Basic Macro Question (Urgent!)
- Excel 2007 VBA/Vista - How do I deselect a selection programmatica
- Create a shortcut to a folder with VBA
- Copy from Sheet 1 to Last available cell in specified column
- find and delete
- Filling In Cells Using Lookups Via VBA?
- PivotTable question about grouping numbers in it
- Shorter Code
- reset ALL checkboxes (created with control toolbar) with the click of ONE BUTTON
- Error Message: ‘Argument Not optional’
- NEED VB FOR PASTING THE CELL REFERENCE
- Heading for Report from UserForm.
- How to us macro for designing a statistic table (i.e soccer score table) auto update after i enter the game result
- VB program for excel sheet
- Adding Validation When Source Validates To Error?
- Join text and 2 dates in A2 column in worksheet
- Macro to Copy certain values from different sheets to TIME Sheet
- Inability to Copy Sheet to Other Workbooks
- Digital Clock
- Help needed with Complicated code (For me !!)
- Error 1004 when setting a Series Collection.Values as Array via VB
- What are the reasons for ""ActiveSheet.Paste Link:=True"" failure
- ODBC MS Query - chinese character issue
- which range staement is preferable?
- Saving images in VBA
- Pivot Table Page Field
- AutoFilter - Lack or Experience
- Change default Save As file type
- If statement question
- Help on editing a function using a macro
- Cannot Reset a Protected List
- Addin vs. Embedded references
- UNIQ EXPEREINCE: PROCEDURE WORKS FINE USING F8 BUT GET ERROR WHEN COMMAND BUTTON IS CLICKED
- Excel 2007 slow
- How to handle Blank Cells?
- Measurements in Excel?
- Import sharepoint data to Excel 2007
- Loosing values when working on different functions and modules..
- Work out years from entered Date
- Need help with slow AutoFilter
- Search from the bottom of a Range up
- Workbooks("Mappe1").Activate trouble
- Copying formulas situation
- Error in vba module
- viewing specific columns
- seeking a smarter lookup function
- combine number and string
- Converting doubles to text ot string
- Using named range intersection in a sum funtion
- How do I extract part of a text in a cell?
- HPageBreaks.Add
- For Next Loop to Make A4 in Each Sheet = Name of Each Tab
- Make a combobox equal to part of a cell value
- Code a button and Macro to Insert data to an Oracle Database
- ShiftJis to UTF-8
- populate cell looking at last valued cell
- Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs
- Excel table in userform
- User prompt for data connection
- Data lookup function in Excel
- comparing strings on seperate worksheets
- Some fields required question
- . and , while working with User Forms
- Data Selection for a Graph
- Assigning custom commandbar buttons FaceID numbers
- excel.h - How To? Add a new worksheet c++
- Coordinates of Cell
- many types of loops
- Ignore Blank Cells on AutoFilter
- SUMIF HELP
- I need to set up a simulation
- Loading/sorting array of Longs (> 65K rows)
- Code equivalent to Alt + Tab
- Match() how to workaround identical Lookup_values
- Date Format in UserForm textbox.
- How can I turn off the OLE warning when merging cells?
- Autofit rows where a cell contains results of formula
- Color Coding Findings
- Embedded Excel Problem with Menus/Commandbars/Toolbars etc
- The Information cannot be pasted Message
- Querytable and pivot table refresh problem
- paper size by name
- Names.Add
- File constantly defaulting to previous version of Word Object Libary
- Printing an existing excel file in C#
- Embedded Excel Problem via c++
- Printing a Dynamic Range
- Printing an existing excel file in C#
- Using DSN-Less Connectino from Excel to SQL
- Named Ranges
- copy and paste question
- Selected cells not updating
- office 2007 and vsto
- right click hide
- SendKeys
- How to select cells in specific Columns?
- count no. of times a text appears in a sheet.
- How to return the address of a cell found via VLOOKUP?
- Resize any selected object
- Change PivotField Properties with Empty Cache?
- how can I fix Broken Links
- Application.Run with variable number of arguments
- Fed value to unhide rows in another sheet
- Option Buttons Off When Program is opened
- adding a self destruct feature
- Expand selection
- numbers (like invoice numbers) in Excel worksheet
- Date range
- Best Way
- Search a column, enable input fields, save to row & columna, reset
- Where is My Data
- ".MatchTextExactly = true" not always the case, please help.
- WorkSheet or AutoFilter Problem
- Operation is not allowed
- Force save with timestamp
- combining two columns into one-Excel 2007
- Trying To Push Code For Worksheet_Change Into VBA-Created Workbook?
- Enter Data
- Macro - Find Next Change In A Column; then insert row
- Newbie: Dimming a variable.
- printer page length
- Returning focus to a user form after getting message box response
- print macro dependent on conditional format
- Pivot table, average, upper/lower control limit
- Shift-JIS to UTF-8
- there's got to be a better way...
- Changes Macro from WorkSheet to All Books
- sort question
- Top of AutoFiltered Range?
- List file name only
- Adding values from two different worksheets from workbook
- Array formula in memory
- VBA REQUIRED TO TAKE VALUE FROM EACH CELL FROM A RANGE AND FIND THE VALUE FROM A DIFFERENT RANGE
- Import Query from Access - Bug
- Popup box help?
- Disabling scrollbars for an excel's built-in form (Autoform)
- Problem with AutoFilter
- What type of loop?
- User entry in a cell unless conditions are met?
- Generating random lognormally distributed numbers
- vlookup not working with defined name
- Runtime error 91 on website login
- Ghost code from User-defined Add-Ins
- Problem saving file as xls
- Edit Closed XLT
- Run Tab Macro
- inserting three rows
- printing number of copies
- .Net via COM Interop in VBA
- Need loop help.
- Searching certain ranges and stopping when finding no match
- IF statement failing
- Opening a Succession
- Bringing upanother WorkBook (Sheet)
- ThisWorkbook.Activate Question
- Before sheet copy
- How do I determine if a workbook is a template?
- stupid me - search across row
- Data from another cell
- Tab Names
- Using excel built-in form, through VBA, script to initialize it
- Bootstrapping in Excel
- "Available Resources"?
- ranges as arrays
- Named Ranges
- Destroying All My Work
- Userform, Excel 2000 & 2003
- Which runs faster
- Code to track changes by row and store
- insert every other column from other excel cells
- Unprotect all sheets
- Close all internet explorer windows
- How can I enter a workbook password automatically
- Move Data From Active Sheet to New WorkBook
- Date problem
- unprotect next sheet
- Can I pgrogramatically access Track Changes?
- How to Prompt a user to select a Folder.
- How to Place a Check Mark Next to an Item in the Submenu of a Custom Menu
- Code to show if a cell has met conditional formatting
- Delete rows containing Vendor Total A,B,C etc
- Editing Text Boxes
- code for text
- .onaction, passing arguments
- run time error 1004 general odbc error excel 2003 vba
- Save Time With Heading Functions in Excel
- Referencing checkboxes on a worksheet from a form
- Copy data from one worksheet to another
- Make macro run on all worksheets except the first
- Using Powerpoint inside Exel program
- Copy Worksheet from Macro
- Sumproduct between and
- Can you pin ribbon tabs in Excel 2007?
- Print one cell to one page
- Implementation Guidance - Onclick or Hyperlinking
- Excel running when user is not logged in to windows
- litter square caused by ALT + Enter
- Folder access rights
- Multiplying non consecutive rows, then adding it.
- Testing for empty sheet
- Attaching a xml schema to a excel worksheet
- Selecting only from index for combobox
- Procedure Name as a property?
- Compare Column to Inbput Box Variable
- Calling Public Variables between diff Modules
- Automatic copying of results from one sheet to another on same fil
- HOW TO: capture the event when a row group is expanded or collapse
- global variable not seen
- Run time error 91
- Date calculation
- Creating delivery notes from a spreadsheet
- Migrating VBA to Excel 2007 - AutoFill & Excel Object Error - ExcelFrom AutoCAD 2004
- Forcing a selection
- Paste text to userform
- "Tutorial for Userform Controls?"
- offset every other row down a column (2 merged rows)
- How to make a data validated field refresh
- Need Recommendation
- Using Subtotal: How to update TotalList:=
- Email notification
- reorder info
- Command Buttons Outside Spreadsheet
- Codepages and displaying euro sign
- Background colours...
- copy the font color
- File exists but cannot open from Excel
- "floating" button
- Absolute reference problem - Excel 2007
- make selection in listbox html with vba
- How to insert rows as value?
- Code to add Formulas with new records
- Pivot Chart - Disassocoation from PivotTable
- Get rid of all displaypagebreaks in whole workbook
- Macro in Excel 2007
- Convert String Representation of Excel Constant to Actual Value
- about worksheet_change
- Newbie sort problem - Please help
- Compare values in a column
- Macro to change cell colour based on words
- Help with conditional formating
- Checking two cells
- UDF to reference the cell with the function in it
- Print multiple worksheets into separate pdfs
- Worksheet_Change fires even when no change?
- Where do I find Visual Studio Solution Explorer
- Counting Consecutive Numbers
- Listbox, fill by format
- Retrieve Data from a pivot table
- Count some of the numbers in a cell
- conditional format question
- how to import an excel table into sql server express?
- Excel crashes on copying macro using VBE.VBproject
- Autofilter and formatting
- Task pane best practices
- Workbooks.Open Filename
- AutoFilter with protected sheets
- How to create "modern" controls on a worksheet
- Pause a Macro
- Searching through text - Speed issue
- Skipping a tab when with this macro
- Excel Chart Add Series with VBA
- Why won't this work? Syntacs?
- Search all directories for .mdb files
- Cell drives combo box change
- Run macro automatically
- Subtotaling a Varied length Spreadsheet
- With Me statement
- How does Collection.Item search
- Need help with text to column code
- ExportAsFixedFormat?
- Totals rows dynamically moving to accommodate amount of informatio
- weird problem with an excel file, asp.net and IIS
- Workbooks.SaveAs - How to have it saved with .xls extension?
- ChangeLink spends a lot of time
- Populate Combo-box from Multiple Sheets
- Can't create macro - Excel 2007
- Code help?
- Is there a way to compare all columns in a Row and flag difference
- ListBox Home Stretch!
- Excel 2007 worksheet visible problem
- Turn Off Sounds in Macro
- Preventing cutting/pasting
- variable dimensions
- An algebra/programming question
- Activate Sheet Best Practice (Y/N?) when xFer data between sheets?
- Last Row In Named Range
- missing functions
- Excel programming - scanning values, populating cells - please hel
- Count series in chart
- copy excel to word
- Find Copy Paste
- I need Help Please
- Textbox in a toolbar
- Excel program 2007 does not allow use the majority of commands....
- Removing "Contains Macros" popup
- errors on linking for *.def file
- Print macro help
- How to test : files are already opened or not
- Worksheet_Activate - conditional use
- color change in a table
- Using MyValue in SaveAs Fname
- Selecting Populate Cells
- Roger Whitehead contact details
- Copy values only
- Hyperlink to folder not opening
- Borders
- Application.WorksheetFunction.VLookup (Plz Help)
- indices in named range
- Passing variable to and from a form
- Different Zip File Size for Excel with and without Workbook Protec
- Move File to new folder - Problem
- Macro - highlight rows
- Login date & time to the VBA application.
- Difference between Userform Activate and Initialize
- Export worksheet in New File by VBA code
- Combobox Help
- running a macro, while programming in vba at the same time
- How can I password protect a single worksheet within a workbook
- To Place Button in Excel
- Jaccard Statistic
- Removing space characters
- Implementation Guidance
- Macro to create a new worksheet that is a copy of an existing one?
- Sendmail with a named cell value as recipient
- Relative path
- how to program in excel
- complicated macro
- Macro program protect
- Add-In UserForm Crash
- Excel newb needs help writing a macro
- Determine If A File Was Specified When Starting Excel
- Stock Quotes
- refer to one userform from another
- Is it possible to open only form when an excel file opens...
- How do I continue a routine while showing a userform?
- unwanted reinitialization of global variables
- Dynamically sorting a range
- Clear rows with no data?
- Auto Populate Combo Box When Opening a Worksheet
- "Which control to use in a UserForm?"
- List Reference
- Work with only objects in a frame...
- For...Next or Select Case Statement
- Creating a folder using Visual Basic HELP!!!
- Animating charts
- Copying columns to new sheets
- Lock cells but allow sorting and filtering
- Programming Formula for Cond. Format yields different formula
- Macro Help
- web site query
- Delete Blank Rows in a pattern
- array question
- Trouble with VBA code for Excel.
- Why this code crash Excel?
- concatenate with vba
- Worksheet vs. Worksheets
- Conditional formatting with decimals
- Loops for copy and paste
- setting range names
- Resize Sumif formula parameters for added data
- Syntax or Something is KILLING Me
- Conditional Formatting
- Worksheet.opentext....???
- How to automatically stock Dynamic data?
- Specifiy Chart Data Range
- References
- Show All Data
- Need Direction
- macro to automatcially delete a worksheet
- Selecting a range defined in a cell
- Save userform values in excel sheet
- Conditional Formatting using VBA in Access
- adding right click menu to textbox
- Excel 2007 statusbar hWnd
- Automatically Update Delimited/Comma Seperated File
- VB: If Solver found no feasible solution
- VBA Codes Protection
- Problems deleting columns
- Getting Summary Data From A large Data of Files in a Directory
- OR statement VB
- Compile Error: Method or Data Member not found
- OpenText method - how to check if file exists
- Easypdf
- Import All Sheets from Closed Workbook
- Fail to open unicode txt file in excel
- Microsoft Charts
- Open password workbook not working
- Right-Click Sheet, Move or Copy, & Class Module
- sum
- UDF Question
- Excel 2007 is asking me to download VBA converters
- Variable in one sub which refers to an input box in another sub.
- Copy Auto-filtered data to new sheets
- printable area size
- Sort Combobox Items in Userform - shahzad
- 5 schifts
- missing something
- def numbers
- Clearing Empty Cells.
- how do you name a range?
- Coping ranges of cells
- Ensuring Autofilter arrows are visible at end of macro
- Transpose and VBA Resize command
- Excel Workbook for Multi User Access
- can't move UserForm with the mouse
- Basic Questions
- Automating Text to Columns -- can I auto-click "OK" on the message
- Initializing Multiple Combo Boxes
- named cells
- separate two strings
- DLL question
- VBA (or Excel) crashes if Count of Visible Rows in Autofilter Range = 1
- MIDI sound playback
- Change the code in another worksheet
- Macros: Moving data into separate worksheets or spreadsheets
- auto-indent in vb editor
- Re: Urgent help on plotting a X,Y graph...
- need formula for stair stepping commissions w/ diff %per step
- how do I...
- Opening Powerpoint from Excel and Word
- Macros: Copying from different document, saving in multiple forms
- reset "on error resume next"
- Need "grep" like function to search multiple workbooks
- Excecl VBA: When a Dialog Appears that requires you to press "OK"
- Problems with .find code
- Select Case Statements
- Menu Restoration
- Prevent macro calculate if text in the range
- When a web query fails.
- export Hyperlinks
- Deleting the empty rows in Excel
- Enter Range value and get report
- UserForm - Disable the 'x' button
- Cannot find file - code error
- VBA code ok in Excel 2003, but crashes Excel 2002 & 2000
- "Using A Variable On Several Sheets"
- Need look up of month to get total for the month
- Error 59 Bad record length
- VBA code for tab exists
- Macro or VBA process varible row data
- Macro to find and replace text in a worksheet
- send mail on value
- How Change Powerpoint Embedded Chart Values?
- Merging Column Data
- array structure
- Changing the From: in an email
- Posting Recordset to SQl Server
- How do I stack columns?
- updation from another workbook
- insert doen"t work: version 2
- My VBA Script
- Drawing a Circle if a different cell has data
- Slow generation of Word Documents
- Excel 2007 slow saving with defined names
- combining subtotal(9,) with an array formula?
- Delete Rows with Autofilter and partial cell.
- Open .xls files listed in .txt file and generate report
- Hiding Pivot Table Wizard
- AVERAGE / STD of groups in a table?
- Sum of 15 random +/- integers always greater than or equal to zero
- Paste formula into macro
- Format "0000"
- insert doesn't work
- Change username for file transfer
- Stop (halt, break) my vba code please...
- For next loop and copy and pasting VBA
- autofill empty cells with a macro in excel
- forecast using Pivot tables
- MultiSelect ListBox Help
- RE: Logical test
- #VALUE when trying to sum numbers
- how can I make a macro prompt for a portion of a file name?
- Compare 2 sheets and copy matching data
- Excel Interop with in-memory document - no file system
- Modified worksheet macro, where if Yes portion works but not else
- copy,switch,paste,erase
- identifying PivotTables
- Error proof way to find first blank Row after Autofilter Range
- Doing a copy-paste offest between 2 workbooks
- adding comments to a cell and not using comment box
- VBA Cut and paste into other workbook
- Using Readpast to skip records
- printer trays
- Code to open Notes database and find a specific doc
- Click Event
- RE: induce sleeping time
- Excel VBA - SQL to .dbf date problem - GETTING DESPERATE
- copy cell to next open line
- Worksheet Speed
- Run program between 2 separate excel sessions
- Conditional formatting
- Slow Macro
- Message boxes
- How do I change a Worksheet_change event to a beforesave event?
- cannot see the error line when error message appear
- Re: Help deleting fields in SQL table
- Absolute beginner
- Delete Rows based on not existing in range
- Run Business Objects Report from Excel using VBA
- My VBA does not work!!
- Unable to set the Display Alerts property of the application class
- Message box & close worksheet
- Messagr
- tom igilvy\gary"s student\mike h....
- Custom Sum Function
- VSTO 2003 and 2007 Add-ins
- batch hyperlink
- Get info from a file that is already open
- Copying ranges to various locations
- Compatibility Checker causing headaches
- cell.find not working
- How to hide toolbar automatically when I switch to other worksheet
- How to stop VBA in a Loop
- Create Outlook event/appt in non-default calendar folder
- Use formula from cell in UserForm?
- copy and paste values
- Rounding Problem
- Imported and Manually Entered Data
- Write/Paste RTF or HTML string into one cell??
- Msgbox preventing workbook save
- Re: Mail one sheet from Excel without using a new workbook
- Update/Refresh Sheet?
- option button and userform question
- Finding cell matches
- How Capture Cell Value Before Change Event Fires?
- Please help with db query
- run an OQY
- tom ogilvy\gary"s student....... pls!!!!
- RTD Real Time Data
- Copying Named Ranges based on ListBox Results
- Comparing dates
- Re: Setting a variable to range of cell values
- Right click Drag and Drop context menu
- Call API from vbscript via excel.
- Call API from vbscript via excel.
- Call API from vbscript via excel.
- Userform comobox equal to first 3 digits in a cell
- Pausing a Macro awaiting user input
- Copying data from a network file - many problems
- Excel Suspend / Resume Layout
- object variable are not set error
- Excel Used Range
- seek next line (more detailed desc)
- Excel Drag and Drop
- Unable to call Command Button's Click() method from a different sheet
- personal.xls
- functions in 'personal.xls'
- ActiveCell.Formula to equal a specific cell
- make a combo box repeat for entire column?
- Match Entry Complete for Data Validation
- Re: Urgent help on plotting a X,Y graph...
- disable toolbars
- seek next line
- Font Information for a cell with multiple color and size
- Formula - Dynamic Range
- Re: Cell colour doesn't delete
- Excel template behavior
- Listbox MatchEntry Property
- Hyperlink Copy
- importing XML files
- Re: Excel 2002 and IE7
- Re: Dates In UserForm Textboxes
- Excel 2003 in a WEB SERVICE - would like some input :)
- Excel 2007 Weird Image problem
- Re: updating formula when a worksheet is added
- Looking for a Macro to erase particular rows in a given pattern
- application.match with multi-dimensional arrays (syntax request)
- Macro that will run from Excel but act on Excel, Word & Access
- Re: _filterdatabase
- SumbyColor Function
- Error Message regarding .TextFilePlatform = 437
- RE: Dates In UserForm Textboxes
- RE: Macro to Check Two numbers and insert a line
- Automatically Answer Prompts
- RE: Mirroring worksheets
- RE: Convert a range t ype to a string type
- Updating Macro File
- RE: Recalculation problem
- Auto Update Formula Rows
- Validate Entry
- Retrive Records in UserForm and Edit - from shahzad
- Sort Excel objects by their creation order
- Printing several worksheets as on page
- CopyFromRecordset method
- pause/re-run macro to enable DDE updating
- Togglebutton to change Checkboxes
- Counting Cells which have Bold & Red Strike Effect Through Conditional Formatting
- Nested if statement and vlookup problem
- Conditional Combo Box Fill
- Excel Convert Multiple Rows into Multiple Columns
- How do I create a computer admin'd multiple choice test in Excel?
- Grouping Date Data in a Pivot Table
- SUM formula for data from one column when another is populated
- How to sort pivot table by Data Items
- copy from sheet 1 to sheet 2 values
- How do I check if a cell has a dropdown
- Help Improving VBA to update Chart Formats
- Scroll bars in a user form
- How to select named range list dependent on another selection
- Load text file into memory for searching?
- .selection.find not working via automation
- vb Command seems simple but...
- How to add data into a text file without overwriting existing data
- How do I remove a UserForm from a workbook?
- Macro loop problem
- How to Construct a Formula Based on Text In Changing Cell
- Hanlde "New Workbook" Task Pane Events
- Screen Flashing
- Complex Copy/Print Macro
- Truncate value of a cell
- Transferring data from one worksheet to another automatically
- Print_Title start in middle
- XLS 2007: Icons or Colors in a dropdown list ?
- Duration problem
- Delete an entire row if a selected row doesn't have a specified value in a cell
- Insert Picture Into Form
- How to Autofill HTML code into Excell spreadsheet
- UserForm
- Find all 6/1/2007 in the Workbook, Sum Corresponding Dollar Figure
- UserForm help
- Excel 2000 Opens, but spreadsheet cannot be seen
- Scroll bar (control) doesn't scroll!! ???
- XLL Internittently Fails to Load
- How to submit data from one sheet to another with a macro and butt
- Splitting Excel file into many workbooks
- Refedit Retaining Focus
- Macro to cycle through worksheets
- Personal marco workbook
- How do I exchange data between worksheets?
- Getting special formatting to apply to all worksheets
- assign formula to a cell
- Relation between hide(orunhide) and protect
- How to generalize sorting range in macro???
- Jagged arrays - Cannot Define with Arr1()() as integer = New integ
- How to select all sheets in front of a particular sheet???
- Creating Excel Documents from Scratch.
- Does excel macro automatically enter data by date?
- How to obtain cell address of a succesful VLookup?
- How would you set this up?
- Removing Hotkey Assignment
- Class modules Custom initialization Line
- vlookup, change aray if
- Hanging Instance of Excel
- Columnheads...
- Macro terminates upon opening text file
- Creating Server Certificate for Excel Macros
- Open Access Macro, then put a value into a parameter field
- Getting a reference when a value is less than 0
- Adding a Button
- Project or Library missing
- Multiple range selection issue
- Form/Module Code Question
- Cell Colour depending on Value in Range
- ODBC Connector Help
- clearing an advanced filter
- Delimit using 2 spaces instead of 1?
- Set Errors
- WorkBook_SheetChange for non-Active worksheet
- Issue Recalculating VB Formulas in Excel 2003
- Date Selection
- Testing for Valid Macro Name
- User form question
- Code for searching & copying Text from 1 text file to another
- Print Preview XL2007 still not working properly
- Return Column of Found Data
- Digitally Signing Excel/Word Macros
- How to count number of Cell have Strike Through Effect & Bold as font style.
- object invoked is disconnected from its clients
- Clear content of textbox in userform
- Using Application.Inputbox with shapes
- VBA that finds the bottom of the sheet
- VBA to find the bottom of a sheet
- Saving a File to a Name That Already Exists
- Web Site Lookup
- Find last row in a column
- To let us choose the file
- Protecting the code using code
- Command button error
- Conditional format : return to default format
- {=max(if(........))} Array Function not working after range length of $A1:$A339
- RE: UDF
- Number format of textbox in userform
- Linked Tables Dilema using Excel 2000
- RE: How to define a range using variables
- How to define a range using variables
- character limit in formula
- Re: UDF
- RE: UDF
- UDF
- select instruction is not able to work with a sheet
- How to streamline this macro
- Start reading text file at line 3
- Fill in formula with dymanic address
- Editing multiline textbox
- Problem with and Excel Add-in installing on customer's machines
- Conditional Formating for Time Sheet
- combine rows of data to one row...tough one
- workbooks.open - another option
- How do I remove the ' from the begining of value in a cell
- Textbox
- Merge csv file from many folders
- Make a Zip file from Excel
- Automatic Population of one Column
- VBA print character on chart
- IF Function testing a range and a cell
- Signing VBA Project Using VB.NET
- Format a Double to have one decimal place number?
- How to stop a msgbox pop up from another workbook
- Monthly Total report based on 2 or 3 criteria. VBA or Formula
- excel programming
- Array in VBA
- Organizing Information Using Excel Macros (or any other solution)
- IF FORMULA....
- Excel Progress Bar while Calculating
- Createobject for FTP
- How to create a function that fills the current date in an adjoining cell
- List AutoFilter Changes to "All"
- Data from Worksheet to Worksheet
- VBA put number on bar chart
- Date Range (Starting & Ending Date) - syed shahzad
- Order of Files Opening
- unhide columns in named range
- Setting up a way to track accountability and where they are going
- List AutoFilter Changes to "All"
- set of numbers ranging from 0 to 240
- access internet through VBA
- Find string in Data
- Design a Form for Excel
- Delete worksheet in collection
- Soap problem
- How do I compare 1 excel file to another and save what is a match
- What is default property of name object
- Deleting Rows based on hierarcy
- Opening a .pdf file with Adobe Reader 8.0
- VBA.convertFromJava("instanceof")=?
- Project Still Open When Workbook is Closed
- Need a program that gets excel file's name and deletes the first row.
- Excel Macro
- VBA to find the bottom of a sheet
- Macro to copy data
- Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet
- data structures
- Excel QueryTable Refresh Causes "Choose Profile" Dialog to Appear
- Grouping Date Data in a Pivot Table
- reference disappear
- Check box in a text box?
- delete spaces
- Importing large text file ERROR
- If statement and exit macro
- insert a row when theres change in a row.
- Automate cut paste
- Querytables refresh gives Subscript out of Range Error
- Importing LargeTextfiles Over 65,563 lines Error
- Reset conditional color VB
- Value or Text
- How to enable macro later
- When first displaying a sheet -List box is not filled in.
- User forms - How do I...?
- find differences between two columns
- Transpose
- fullscreen changes corrupt display of listbox control
- Visual Basic as a Tool for Financial Modeling in Excel
- VBA for deleting duplicate rows
- Unlocking a Locked File
- Chart Legend Names
- 4 conditional formats
- sending emails using thunderbird as email client
- Print sheets in order 'x' times
- Copy text with more than 65,536 lines into Excel
- Excel crashes when VBA window is closed
- Help please!
- Hyperlinks change on publish as webpage
- AutoFilter can't work after the worksheet is being protected!!!
- empty cell
- find format of cell
- PLEASE HELP - query results to multiple rows.
- Webpage Navigation
- Reference to adodb.connection (or objects in general)
- Input Boxes on Web Pages
- Edit within a cell to select parts
- Truncation of string problem
- Warnings on Web Pages
- Chart Auto-Size Behavior
- Test
- Get Parent directory
- dynamic Range in ADO
- Drop down list - most frequently used
- Listbox in a form
- export data to an existing and open workbook without knowing the f
- DTPicker Bug
- Registering UDFs
- Copyingand pasting
- Checkbox - Source types
- Excel manual calculation probs
- Saving emails sent by Lotus Notes through Excel
- Handling dates in VBA
- How to save with a name in a particular cell?
- Same name - multiple data - how to combine
- How do I create a new work book with selected worksheets
- counting repeats of data
- formula and offset
- Collecting data from excel forms into one spread sheet
- ADO while being used
- Range of Days in a month
- scroll a few columns at a time
- How do I unhide the subtotals in a pivot?
- Code to Insert rows and copy formulas
- Pictures in Footers (again!)
- To reset the Interior.ColorIndex function
- COMPARE TODAY WITH DATE IN COLUMN
- VB for Applications
- How to get Leading Zero's passed
- Local formula evaluate
- Toolbar buttons how do show and change the status
- clearing an array
- Multiple External Data Returns
- How to control the page break
- Automating new line items for worksheets that will be added?
- How to terminate an object that's in a collection
- macro security
- Is it possible to remove the Select method in this case?
- Is it possible to remove the Select method in this case?
- How to obtain the Row number of next visible cell Down?
- Security - Setting
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.