View Full Version : Excel Help
- Problems with FileCopy and Wb(name).close (11 replies)
- Solved: insert code to show progress (3 replies)
- add extra step to macro (4 replies)
- Appends the contents to the respective columns (6 replies)
- auto print (2 replies)
- Dynamic Range over extending issue (10 replies)
- How to write a VBA-Excel code to find geometric mean? (4 replies)
- Solved: I want to go to "File Save As" as soon as openned (7 replies)
- Solved: Days Difference between text box (6 replies)
- Row & Column Indicators (4 replies)
- Solved: sort ascending leaves blanks at the top (5 replies)
- Extracting information after B/C (1 replies)
- Multi Tracker Entry Help (13 replies)
- Checkboxes and Sheet Protection (4 replies)
- [SOLVED:] What is escape character for quotation marks? (4 replies)
- Solved: Extracting only part which is within brackats (4 replies)
- Solved: PLEASE: Chart Help (2 replies)
- Solved: Sub to Open workbooks, and update named ranges (5 replies)
- Solved: VBA hide columns or rows based on certain criteria (13 replies)
- Solved: UDF to convert long date to "mmmyy" String (7 replies)
- Solved: Creating A Shortcut Key (3 replies)
- Number of Objects Limitation in Sheet (2 replies)
- UserForm: Initialize a ListBox (3 replies)
- Excel VBA:ZeroPadding Mixed Number, Text, Number Content in Cell (4 replies)
- Shared Workbook Woes (5 replies)
- A reminder please, copying range from one ws to another (2 replies)
- Solved: sumif feature needed for multiple criteria using wildcards (4 replies)
- Running a User Defined Function in VBA (8 replies)
- Solved: Copy and Paste - File to File (All files are Password Protected) (7 replies)
- Solved: Check cells in an AutoFiltered Range (2 replies)
- Solved: Insert blank row, NOT "insert copied cells" (2 replies)
- Conditional Formatting with command button (5 replies)
- Solved: 2D Arrays (10 replies)
- Fix data position (1 replies)
- Solved: Writing to a word file from within excel (10 replies)
- Help! Excel User prompt for data input (8 replies)
- Solved: SUBTOTAL COUNT (10 replies)
- Solved: copy contents of one workbook into another (7 replies)
- Date format (3 replies)
- Dynamic Form CheckBoxes Controlls (3 replies)
- Solved: Returning data based on multiple criteria (8 replies)
- Convert to PDF on Legal Size Paper (2 replies)
- Adding multiple entries to Time Sheet (4 replies)
- Excel 2007 template - issue with vba macros (emailing) (0 replies)
- Use text from embedded object (0 replies)
- Solved: Run-time error '53': File Not Found (3 replies)
- Solved: Combine H and V lookup or better idea? (2 replies)
- Copying values (5 replies)
- getting a Macro not to call another macro ?? (1 replies)
- Excel File Sharing Communication Tool (4 replies)
- Solved: Returning an array from a function (6 replies)
- Using VBA to copy and paste the content of multiple worksheets to a new files (14 replies)
- Solved: vlookup non-contiguous ranges (7 replies)
- Solved: Preventing N/A# in Vlookup? (2 replies)
- Linked Picture; Add to Comment (14 replies)
- vlookup in Vba + preventing tabulations in a form field (2 replies)
- Enable paste (6 replies)
- [SOLVED:] Help Alter Code (1 replies)
- Solved: Excel Charts again (1 replies)
- Solved: pb: if condition = true then go to next iteration (2 replies)
- problem with combobox (4 replies)
- ERROr while running a macro (5 replies)
- vba if statement (14 replies)
- Solved: swicthing between formulas (5 replies)
- Putting variable values in a second sheet (3 replies)
- [SLEEPER:] How to automatically trigger a VBA code to respond to expected msgbox (9 replies)
- Solved: Worksheet freezes up (3 replies)
- Solved: Multiple 'On Error' commands in function doesn't work? (2 replies)
- Alpha Testers Wanted (5 replies)
- Why is this chunk of code freezing (5 replies)
- Copy Paste toggle not working (1 replies)
- Solved: Image to Excel (1 replies)
- auto filter (4 replies)
- BO reports (rep files) need to be refreshed from Excel Module (3 replies)
- Excel Chart Lists (0 replies)
- Solved: sort without worksheet? (2 replies)
- Solved: Using IsInPlace (1 replies)
- Why my program gets slow down after running for a while (6 replies)
- Why does .address put $ in value (1 replies)
- Charting an array as a series (3 replies)
- Autofill not working (3 replies)
- VBA Code for mail merger & Printing (3 replies)
- Copy row from workbook if... (2 replies)
- How to write a formula with a bunch of 'IF' statements (7 replies)
- Macros Paste Special to another Workbook (2 replies)
- Print ranges on worksheet (2 replies)
- User Forms behaving strangely (7 replies)
- Need help to get rid of unwanted " in text output file from an excel macro (2 replies)
- [SOLVED:] How to find the first and last row of merge Cells??? (3 replies)
- Solved: Save specific cells in Excel with a Macro (15 replies)
- Refreshing data from multiple large workbooks (11 replies)
- Solved: sum values based upon 2 or 3 conditions (4 replies)
- Image as Multipage Caption (3 replies)
- Excel - Email Groupwise HTML (1 replies)
- Create a consecutive character array? (3 replies)
- Update Checkbox across workbooks (2 replies)
- Solved: Trying to uninstall addin when closing file (3 replies)
- Solved: Form-Filling GUI: ComboBox problem (8 replies)
- Solved: Copy rows selectively (7 replies)
- VBA if..then comparison not working ??? (2 replies)
- Select or msgbox last cell edited by code? (3 replies)
- Solved: Compressing files (4 replies)
- Solved: Need Macro to pull data from Web (3 replies)
- Solved: Validating Excel data entry (5 replies)
- Solved: Creating Dynamic Validation Lists Based on A Selection from Another List (2 replies)
- Sending mails (0 replies)
- Solved: pivot table: sum column is incorrect (4 replies)
- pivot table and MS Queries (0 replies)
- Dropdowns and Zoom?? (1 replies)
- Environmental variables to get to ?My Docs? or "My Documents" location. (3 replies)
- Macro code to generate Email..help (2 replies)
- Excel 2007 Buttons in Print Preview Disabled (0 replies)
- Combo box (4 replies)
- Search a range of columns for values? (1 replies)
- Numbers Directory (2 replies)
- A Loop in a Loop (7 replies)
- Solved: Return DAY of Week based on Date (2 replies)
- Automatically Insert Hyperlink When Text Is Typed In Column (0 replies)
- Solved: Sort multi-dim array by one value? (4 replies)
- Solved: Backing Up in a Macro (6 replies)
- Button to unhide sheets (1 replies)
- Solved: Userform Commandbuttons query (3 replies)
- How to copy contents of text file to tab sheet of another excelsheet (2 replies)
- Solved: To check if to versions are identical (2 replies)
- Solved: Copy Paste in arranged manner (3 replies)
- Generate file name with date from cell (not current date) (3 replies)
- Using form to editing (10 replies)
- Solved: Compile error in hidden module: distMon (2 replies)
- Folder referance ? (6 replies)
- Solved: Conditional formatting not working unless I step into a cell (14 replies)
- For...Each Loop Backwards? (1 replies)
- Solved: Run macro in another workbook without its name (3 replies)
- Disable comments on mouse hover (2 replies)
- How to Retrieve the Last Search Term from Find() (0 replies)
- advanced find and replace loop (4 replies)
- Ftp Folder (0 replies)
- Solved: Update buggy workbook links with .Activate (1 replies)
- Using Excel type formulae in VBA Forms (1 replies)
- Solved: VB code for greater than 1 or less than -1 (8 replies)
- Solved: Choose data for use in control limits (5 replies)
- Solved: Insert blank row below set value (6 replies)
- VBA help (0 replies)
- Creating fields (11 replies)
- [SLEEPER:] Even or odd week? (4 replies)
- Display DownTimer in the UserForm & at the same time User should work with UserForm ? (4 replies)
- Solved: Match function in Vba (10 replies)
- Solved: Delete if matching colour (2 replies)
- ComboBox can't typing the value ? (1 replies)
- Solved: Redim Preserve (3 replies)
- UserForm help, assigning variable from option button selection (4 replies)
- Solved: Chose last of identical data from a column (4 replies)
- Use Find Across multiple workbooks/ multiple worksheet (4 replies)
- Solved: Counting different values (4 replies)
- Solved: Uhh... Corresponding number detection and copying (6 replies)
- Need Help (12 replies)
- Split range of cells into individual numbers? (1 replies)
- Receiving variables from a batch file (3 replies)
- Solved: Function/Sub with Parameters assigned to a Button (3 replies)
- Solved: Change font characteristics depending on value (2 replies)
- import large CSV file(more then 80k records) to MS Access table (1 replies)
- Delete Rows if Value in Column A (5 replies)
- Delete Sheets (1 replies)
- Solved: function match : error in vba (4 replies)
- Increment upper bound of loop (2 replies)
- Solved: x dimensions array, combobox and loop... (2 replies)
- making a "Formula like" userform (5 replies)
- Getting Error Message in Excel 2007 (2 replies)
- Solved: Referencing UDF from another workbook; Evaluate? (7 replies)
- Produce charts with range containing formula (1 replies)
- A Userform to enter data on a new line (25 replies)
- Please help me to write the code for this Excel-VBA problem? (5 replies)
- UDF Returns circular reference...? (1 replies)
- beforeclose, saving the workbook (1 replies)
- Solved: hiding columns (2 replies)
- Enter Formula in Cell Based on Heading in Another Cell (3 replies)
- VBA: If Date (range) Then (do this) (4 replies)
- Applying Template to Power Slides via Excel (0 replies)
- How can I create a Vlookup to certain columns in a closed workbook? (5 replies)
- How to replace Access data from EXCEL instead of adding to it? (2 replies)
- delay between codes (2 replies)
- Solved: Updating Excel Chart (2 replies)
- Solved: Check if data exists, then copy (11 replies)
- Solved: LOOKUP function not Functioning! (2 replies)
- Compare, Copy and Paste using VBA (20 replies)
- Broken macro - can't transfer from excel to access! (5 replies)
- how to optimise sumproduct function (13 replies)
- Solved: Excel Add-IN (4 replies)
- UserFrom if can edit (0 replies)
- Creating Addin that will work regardles saved folder location (15 replies)
- Creating buttons is very slow (1 replies)
- Send email notification when conditions are met (1 replies)
- Create a Letter and Label from Excel (2 replies)
- Active button coding (3 replies)
- Solved: beginning with userforms (4 replies)
- Copying from cells on same row selected by user (5 replies)
- chart base on category (0 replies)
- converting .ps to .pdf (0 replies)
- Solved: Numeric calculus for Matrices (11 replies)
- Solved: Excel macro to loop through rows, while looping format rows if meet criteria (11 replies)
- [SOLVED:] Split listbox text (5 replies)
- Problem with Range and Worksheets (1 replies)
- Solved: Function in add-in - How to reference workbook? (16 replies)
- Macro that automatically imports excel data into access database? (4 replies)
- Solved: [RESOLVED] Import a text file and keep the spaces (8 replies)
- Solved: Merge cells into one if value is smaller than... (2 replies)
- Javascript:_doPostback (11 replies)
- Search, copy, and paste (9 replies)
- Solved: Automatically Add Zeros in a cell (7 replies)
- Getting a line in a graph to change colors (3 replies)
- Fill data validation cell (4 replies)
- Solved: Regex Query (8 replies)
- ActiveCell.Text (2 replies)
- Solved: Print sheet in a loop procedure (5 replies)
- adding access levels (1 replies)
- getting string to resolve to variable (4 replies)
- Solved: Conditional Formatting for Numbers Only (3 replies)
- Copy multiple individual cells (24 replies)
- Random Combination (2 replies)
- flips left-to-right sequence of selected columns (8 replies)
- Disable macros on opening via Hyperlink (6 replies)
- Help Needed with Page Breaks (2 replies)
- Function does not output on Cells (7 replies)
- Solved: Headers & Footers - Multiple Sheets (6 replies)
- Solved: Creating Folders or Directories (6 replies)
- adding code in runtime (1 replies)
- Match 2 columns (1 replies)
- Image rendering in forms (5 replies)
- Solved: create chart in seperated worksheet (6 replies)
- VBA Page Breaks in Excel (1 replies)
- Solved: macro to hide/unhide select cells (9 replies)
- Passing listbox values to cells (0 replies)
- Call Excel Solver from VBA (6 replies)
- Solved: Find and select a cell based on user input (6 replies)
- Solved: Copy information to an Activecell that Moves (8 replies)
- what does ^ mean in the formula (3 replies)
- Solved: Macro:To Many End With's (5 replies)
- Optimizing loop for find&delete shift column (8 replies)
- Creating Add-ins (7 replies)
- add function on print (3 replies)
- Solved: Select range by used rows and named range (10 replies)
- Excel - 2003 VBA Code Error - Run time error '380':Invalid Property (2 replies)
- Solved: Set variable to a cell address (6 replies)
- Solved: Multiline Textbox to Populate Multiple Cells (7 replies)
- Help with code for data entry (26 replies)
- Solved: Help on changing the year (6 replies)
- Macro to open workbook from another workbook (2 replies)
- Send cell contents in email message body (2 replies)
- Solved: Select All Pictures, And Move And Size with cells (4 replies)
- Solved: Ideas to make this code faster (3 replies)
- Solved: Moving from 2003 to 2007 (8 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.