View Full Version : Excel Help
- How to pass combobox/textbox selected member into sql string in main module (2 replies)
- Solved: Clear Specific InteriorColor Index (4 replies)
- Solved: Macro to change text to date in a set range of cells. (18 replies)
- Two Quick Questions: Using Count Method + Using Offset Property (1 replies)
- PDFCreator automation in VBA Excel (10 replies)
- Solved: Strange behaviour of =cell("filename",A1) formula (4 replies)
- Solved: (How to) Transpose one long list of numbers in CSV file to a number of rows (4 replies)
- Solved: Using a loop with Select Case (2 replies)
- Help Referencing Other Spreadsheets (1 replies)
- Tooltip on Labels (3 replies)
- Buggy Pivot Tables? (3 replies)
- Solved: Workbook_SheetChange and If Not Intersect error (1 replies)
- Solved: Cancel a Loop if .Find Parameters Do Not Exist (8 replies)
- Excel VBA Get Internet Explorer Data (7 replies)
- Specify paper tray (4 replies)
- Solved: copij formula in protected sheet (4 replies)
- VBA to Concatenate Variable Range (3 replies)
- Solved: Combobox: Enter, Tab and Backspace Keys Not Triggering Keypress Events (2 replies)
- Extract Text from Word Document and Put in TextBox (4 replies)
- Number Format Short_Cut (1 replies)
- Data editing/moving/arrange. (2 replies)
- Populate a useform textbox with text from Control Box form (8 replies)
- Solved: VBA average and standard deviation homework help (11 replies)
- Solved: VBA function procedure homework help (5 replies)
- Empty vs Zero (6 replies)
- VBA Vlookup (3 replies)
- Solved: Detecting when a different sheet is made active without using Worksheet_Activate (5 replies)
- Solved: VBA -- IF Statement (6 replies)
- Solved: Inconsistent updating of spreadsheet formula when changing file name (8 replies)
- Computing average over columns with VBA (7 replies)
- VBA – Array Filter (4 replies)
- Create Search Form (0 replies)
- Solved: Macro to Re-arrange Data (4 replies)
- Solved: Operate with data from txt file (3 replies)
- 430 Error when Macro Run (1 replies)
- Solved: Track Cell Value Change (5 replies)
- Choose range (17 replies)
- Application defined or Object defined error (7 replies)
- Run HLOOKUP macro on outcome of Data Validation (2 replies)
- vba workbook_sheetchange event for xlam thisworkbook (5 replies)
- Solved: Copy formula automatically & Paste valuse :VBA code error Rectification (2 replies)
- Generating Custom Report thru VBA (2 replies)
- Add value, as seconds, to LongDate (4 replies)
- Solved: Vba code to clear data cells only not those with formula (1 replies)
- Solved: Dynamic array in VBA of newly added worksheets (4 replies)
- Scroll to a named macro in the VBE (10 replies)
- Solved: Inserting data into the column and maintain it locked (8 replies)
- Copying Excel range to Word doesn't copy the image (1 replies)
- Selecting 2 Cells to the right of the ActiveCell (3 replies)
- VBA merge from some open and some closed workbooks (0 replies)
- Code doesn't send in email (0 replies)
- excel pivot table problem (2 replies)
- Filter : date after 15 /10/2012 (2 replies)
- Solved: Copy and Paste Row if Cell Has Value (22 replies)
- Solved: Copy B4 value of each guide based on column A of worksheet "Plan2" (4 replies)
- Searching multiple workbooks for hidden content (1 replies)
- If Statement checking (5 replies)
- Madness - Excel Crashing (1 replies)
- Private Sub : copy formula (3 replies)
- Highlight the selected cell (2 replies)
- Read/Write Userform to variable range of cells (4 replies)
- Excel 2007 (7 replies)
- combine all file in a one workbook (2 replies)
- Solved: Advice and Help which database to use (6 replies)
- Need help on MultiPage control (1 replies)
- Application.MacroOptions: StatusBar property not working (7 replies)
- Solved: count, insert, copy, paste rows from one worksheet to another (2 replies)
- Help please want to write string sorting function (4 replies)
- Nested IF Function not working when the first condition is False (6 replies)
- Solved: Locking a Row Question (2 replies)
- Problem with keeping the year end dates of downloaded financial data (2 replies)
- Solved: Pivot Date Filter between variable number of days (2 replies)
- Sine Wave Audio Sound Generator (10 replies)
- Solved: Change in Path to Server - Query Macros Affected (2 replies)
- [SOLVED:] File Renaming Tool - Working in Subfolders (18 replies)
- Sort Values In Array (24 replies)
- Plotting to PDF (0 replies)
- Solved: Workbook Slowdown (1 replies)
- Highlighting particular cells (1 replies)
- Play Sound in Excel (23 replies)
- Count members of AD group from Excel (0 replies)
- Same number of trades (1 replies)
- Excel VBA Error 445 in 2007/10 but 2003 is fine (1 replies)
- Send Excel Body by Outlook (0 replies)
- editing text in a cell (2 replies)
- Data transfer based on certain findings (4 replies)
- auto Email (0 replies)
- Compare two worksheet current code modification (6 replies)
- Merging two or more files, column by column (1 replies)
- Nested loops and populating a new ws with the items (2 replies)
- Solved: vary column (5 replies)
- Help VBA code for calculating time difference (1 replies)
- Solved: automatic FormulaCalculation Option using VBA (5 replies)
- Disable File Save And Highlight Empty Cells (5 replies)
- Formatting excel sheet (5 replies)
- Solved: Runtime error '13', Type Mismatch (9 replies)
- Copying range to variant (12 replies)
- Question on ActiveWorkbook.Calculate (4 replies)
- Populating IP Address & Username of the user in Excel (9 replies)
- Solved: SumProduct RowsandColumns (2 replies)
- Getting data from Word Controls into Excel (2 replies)
- Loop filter and copy (0 replies)
- auto save and close workbook after 15 minutes of inactivity (0 replies)
- Passing an Object to a Function (16 replies)
- Open Notepad and write something onto it (4 replies)
- Solved: VBA Formatting mess of text (4 replies)
- Solved: Do something every 14 minutes (3 replies)
- How to solve excel compatibility? (1 replies)
- Solved: Select the shape as shape variable (4 replies)
- Sum amounts based on another column (5 replies)
- Calculation On/OFF Basis On Selection (2 replies)
- use date stamp to trigger Shift:=xlDown? (2 replies)
- VBA functionality for String manipulation (3 replies)
- Solved: Problem in creating status bar (5 replies)
- Highlight the last selected cell (2 replies)
- Solved: Copy Range If Cell Value Equals (7 replies)
- A Combo Box for Certain Types of Information from another worksheet?? (4 replies)
- Solved: cut and pasted into Sheet2 (2 replies)
- Printing issue (9 replies)
- Help with concatrelated vba excel (2 replies)
- Modify Cut Paste (6 replies)
- Printing Unique Values (From a column) in a Combobox (9 replies)
- Loop through rows and delete/keep (1 replies)
- Run time error 1004 Applicatin-defined or object-defined error (Copy from src to dest (2 replies)
- show username if file is open (10 replies)
- Thematic Map (8 replies)
- Solved: Change color figures, with discretion (3 replies)
- Storing Variable From One Cell And Printing It Repetitively In Another Column (3 replies)
- Need to increase the percentage in a cell containing the original value (2 replies)
- Source workbook keeps opening when Destination workbook is protected? (1 replies)
- Excel code to open Access! (0 replies)
- Compare data between two workbooks (1 replies)
- Search Worksheet for Name if found copy to new workbook (12 replies)
- Syntax for Set_Cursor_Pos() (3 replies)
- Concatenate (Nest) "IF" Commands ?? (5 replies)
- Solved: Hide Rows...help in code (8 replies)
- Search Functionality that moves cursor (1 replies)
- [SOLVED:] Find Question (3 replies)
- Loop? Copy/Paste from to Summary from Workbooks on Server (0 replies)
- Code running amazing slow when file is shared (1 replies)
- Create Workbooks based on Unique Values from a Column (6 replies)
- Login and Password for user form (3 replies)
- MACRO help to delete some files in a particular folder (3 replies)
- Solved: Populating Textbox 2 on the basis of Textbox 1 (2 replies)
- Solved: insert row if match is missing in column above (12 replies)
- Formula to pull formula from another cell (18 replies)
- Solved: creating multiple xltx templates (3 replies)
- get data from word form into excel using macro (0 replies)
- "method range of object _worksheet failed" Error (2 replies)
- FileName (5 replies)
- Solved: Locate Date in cell formatted as DD-MMM (6 replies)
- XML Integration (8 replies)
- How to control an Excel file without opening it? (1 replies)
- xmlHttp get requst - cannot get past login (4 replies)
- Remove last few characters from a string (1 replies)
- Filtered Cells Problem (2 replies)
- Conditional Format On Specific Range (10 replies)
- Windows Explorer Shortcut Link Generator (1 replies)
- 'Partial' Julian Date Issue (4 replies)
- Populate Two Text Box using input value (2 replies)
- Solved: VBA table summarize (6 replies)
- Excel using Loop (12 replies)
- Solved: Add Hairline Border Via Vb (4 replies)
- Solved: Copy, Open, Paste (6 replies)
- Solved: Identifying Duplicates Prior to Data Entry. (5 replies)
- GOBACK subroutine for Excel 2007 (2 replies)
- Solved: Email active worksheet using Outlook (2 replies)
- Solved: Copy From Multiple Files To One (6 replies)
- Solved: Error found in codes given in KB (13 replies)
- Excel WB painfully slow (4 replies)
- How to enumerate a variant array? (9 replies)
- Solved: error with mouse_down (2 replies)
- Sumdata based on a table of possible criteria (2 replies)
- MyCheck Fuction (4 replies)
- Solved: Automatically Update date in cell value if workbook is saved under a different name. (8 replies)
- Sleeper: Passing transformed arguments to UDF (10 replies)
- Troubleshoot an Overflow Error (17 replies)
- What is the code to open access file (2 replies)
- Solved: Creating a dynamic concatenation from a list (2 replies)
- Moving Files Based on Last Modified Date (9 replies)
- modify macro with hyperlink (2 replies)
- Solved: VBA Interaction with IE (4 replies)
- Paste onto filtered cells (1 replies)
- Conditional Formatting - Change font (2 replies)
- shade header row (2 replies)
- Solved: Fill an array with vlookup vba (5 replies)
- date range and return value (1 replies)
- Filter a sheet and copy results to another sheet (0 replies)
- Solved: Creating a dynamic user defined function (7 replies)
- Solved: Delete Duplicate Values only... Not rows (9 replies)
- [SLEEPER:] vba program (3 replies)
- Solved: Populate hyphen for continuous three or more zero in a row (4 replies)
- Solved: How to suppress replacing cells when using PasteSpecial? (6 replies)
- [SOLVED:] Index/Match VBA equivalent to append data (3 replies)
- Simple Merge of two lists/tables (2 replies)
- Macro to import entire text file into single cell (4 replies)
- alphanumerics only (7 replies)
- Real Time Clock in a Textbox on a Userform (2 replies)
- Solved: update pivot tables based on the value of cell 'C2' (2 replies)
- [SOLVED:] Determining the 2nd highest number in a list (3 replies)
- VB disable conditional formatting code (1 replies)
- How to create a sequence of dates? (1 replies)
- Copying sheets into new workbook (4 replies)
- simple auto macro :) (4 replies)
- getting the row numbers of visible rows in an filtered selection (3 replies)
- Using conditional formatting (5 replies)
- How to copy an active Excel worksheet to another excel file? (1 replies)
- Solved: Command Button (Save as PDF) (5 replies)
- Can somebody help to achieve following tasks? (1 replies)
- Worksheet on change code a bit slow (3 replies)
- Reference across sheets (1 replies)
- Insert and Delete Rows in Entire Workbook (8 replies)
- Solved: Stop watch in excel which just displays minutes (5 replies)
- FileSystemObject create file containing text copied from IE (2 replies)
- Getting Application defined error 1004 for vba (1 replies)
- Save as xlsm function (2 replies)
- Solved: Calculate Distribution (8 replies)
- find closest date (4 replies)
- Solved: Opening and writing to multiple ASCII text files (6 replies)
- Solved: Detecting Last Time File Was Opened (6 replies)
- Sleeper: Macro loop issues (2 replies)
- Macro Triggers Unreadable Content Error on Restart (2 replies)
- Macro is getting Runtime error 91 - why? (3 replies)
- Excel 2 XML using Macro (1 replies)
- Project locked for viewing - SendKeys? (32 replies)
- Solved: Loop through multiple sheets and delete rows based on a cell reference (4 replies)
- Accessing files in order of Date Last modified (1 replies)
- Solved: Dynamically populate combobox in userform (10 replies)
- Solved: function to find the number of iterations/loops Do...Loop (7 replies)
- Synchronizing Multiple Worksheets (1 replies)
- Solved: CAGR formula using only range as input (7 replies)
- VBA from Excel to Outlook 2010 help (2 replies)
- Master Directory Search (Needs A Tweak) (6 replies)
- Find all hard coded references (14 replies)
- Change Dropdown Macro (1 replies)
- Solved: code running too fast? (9 replies)
- Solved: run macro from one workbok to affect other workbook (3 replies)
- How to post sample excel data (1 replies)
- VBA Help - Desk sharing solution - thanks in advance (1 replies)
- Drop Down List to Copy Contents of Another Column into a Certain Column (4 replies)
- VBA pivot with no range (3 replies)
- VBA HELP! - Need slight change to my code (9 replies)
- Total values associated with unique value in adjacent column (5 replies)
- Solved: Converting the VB code to VBA. (6 replies)
- [SOLVED:] 3 cells USERFORM to enroll in one cell in excel (2 replies)
- Something odd has happened with an "Always on Top" window. (8 replies)
- Solved: VBA Copy a template sheet and paste it into multiple sheets (2 replies)
- Combine multiple rows into one and then seprate specific columns (1 replies)
- Adding MMM-YY to filename (1 replies)
- To paste in Word the selected text in webpage by an Excel macro (1 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.