View Full Version : Excel Help
- How to combine hidden sheets using VBA
- VBA Do While Loop Question
- [SLEEPER:] Dynamic Hyperlink VBA
- [SOLVED:] Need to show and hide named ranges based on cell value
- [SOLVED:] VBA - Pivot table and charts - Automation
- Match worksheet function in VBA searching on multiple criteria
- Looking for a VBA code/Macro to Export Pivot Data into a CSV File on click of button
- VBA Excel : Boolean loop to check last full column
- [SOLVED:] VBA Excel: Ranges
- Excel VBA upload via SFTP
- Multi selection list
- How do I search a spread sheet for a time
- Excel Camera Tool
- COUNTIFS in VBA with data on multiple sheets
- Loop through slicers in PivotTable/PivotChart and export to PowerPoint?
- Formatting question
- [SLEEPER:] VBA Hierarchy
- How do i add a string in a column like "1 week" or "12 months" into cell with a date
- VBA in excel : making a Stock list
- Delete Image
- [SOLVED:] Help on Moving file to another folder, using partial filename
- Looping through worksheets to sort
- Auto save workbook when locked cell is modified
- Need help (If Statement)
- Azure Connection via VB error
- fixing summing and subtracting among sheets in the same range
- programatically added controls do not show up
- Help me please! Basic Excel macro!
- SetFocus with Frames not Working
- vba, how to code to select cell after certain filter field
- [SOLVED:] Excel VBA Userform Comboboxes not populating with external data range
- Copy Rows data to column
- [SOLVED:] Replace table with Userform
- Getting script Error 9 Run time error while declaring variable of Sheet
- HELP! Cant figure out how to modify code based on new requirement
- Create an array removing duplicates from list but keeping last occurence
- [SOLVED:] Calendar Times Not in Order
- [SOLVED:] VBA entering a nested formula with text
- Replace non-contiguous column range with Offset column range in Chart SeriesCollectio
- Advice on 'OnTime'
- [SOLVED:] Conditional Format Calendar Events
- VBA - Macro to open a file based on part of text in cell
- [SOLVED:] Named Ranges Error - Please help!
- [SOLVED:] Update Schedule Sheet with Jobs
- Cell back color
- [SOLVED:] Copy Workbook Name
- [SOLVED:] Error 13 - Mismatch in UserForm update Application.Match with mixed Data
- Sleeper: Keep a timestamped log when any worksheet is unprotected?
- Parse text to array
- Stop save if table has empty cells
- On time assistance required
- [SOLVED:] Use the same Variable in the module
- Cell equal value new value of active cell which is a drop down
- Query
- Run macros on whole workbook
- VBA Code to highlight Odd and Even numbers
- populate combo box with conditions
- Creating a Search Concat for Sharepoint files
- Copy files from one Location to another
- VBA to move JPGs from sub-folders to destination folder using a list
- Consolidate Pivot Table Cache - VBA
- [SOLVED:] Formatting issues
- Help automatically refreshing a year using VBA
- [SOLVED:] Create new column
- Having troubles with XlFillDefault
- [SOLVED:] Conditional expression
- from mastersheet to other sheets (find the last blank raw)
- Early vs. Late Binding
- VBA for inserting Rows with conditions
- [SOLVED:] Advance filtering unique records
- [SOLVED:] insert data for open positions
- VBA for New Format
- Customer Statement of Account
- [SOLVED:] notification by vba
- [SOLVED:] Need help copying cells from one sheet to another..
- [SOLVED:] Combine countifs & Subtotal
- When changing the active worksheet - need VBA that will make it's chart display?
- [SOLVED:] Moving data between two sheets VBA
- How to copy and insert shapes with increase in series of text inside of shape ie 1,2,
- copy and paste question
- How to get dates of all mondays between 2 dates?
- Copy & Paste to the next empy cell. (Vba Code not Working)
- [Beginner] Select and Cut with conditions
- [SOLVED:] Macro Copy & Paste: Numeric to Alphanumeric
- Vba code on looping
- [SOLVED:] VBA to select cell in active row
- vba find the latest date and a corresponding value
- Looping Through Two Columns
- [SOLVED:] First Login Last Logout - Formula
- Coming to the dark Side
- For Each Then Next
- Run time error '1004' Cannot access 'Macroed-Upload_Temp.xlsx'
- Creating dynamic List on Workbook Startup
- VBA MACRO Button click using a class instead of ID
- Set Last Modified date & time to preset value on Save or Save As
- Macro to autofilter data from several sheets in workbook and copy to new worksheet
- VBA to add numbers in columns from various workbooks
- Copy to new workbook and remove blank rows
- code running on more than 1 sheet
- [SOLVED:] Copy files by name from a folder to another
- [SOLVED:] Creating a single Table with different formulas Excel VBA
- [SOLVED:] Excel keeps calculating
- [SOLVED:] Split Cell into multiple column via VBA
- Basic VBA Function to calculate the volume of a cone
- sumifs filtered data
- [SOLVED:] Excel Formula to compare between actual values and target values
- Only the string
- [SOLVED:] Formula to fill down used range
- [SOLVED:] Part of a string
- [SOLVED:] Putting a time limit on QueryTable.Refresh
- [SOLVED:] Write part of 2D Array to Sheet
- [SOLVED:] Data Validation based on Condition(s) in Excel VBA
- [SOLVED:] Change font size of rows in a range with bold letters
- [SOLVED:] index/match based on variable range
- Cut Data Once It Has Been Selected
- [SOLVED:] How to pull XML data into another excel sheet using VBA?
- Conditional Formatting using formula as condition
- Trim rows in multiple sheets
- Add Table to Data Model (Pivot Table)
- VBA script to search a text in google maps
- [SOLVED:] Insert Picture from Directory on Cell Value Changed by Formula
- Split comma to rows
- After clicking the linked cell to move back linked cell without using F5+Enter
- Writing array to sheet
- [SOLVED:] How to set currency with different starting values
- Text in textbox only updates once
- [SOLVED:] Complete data of a master table without overwriting given data
- Hyperlink warning message
- 3 Reference Formulas Not Returning a Result
- [SOLVED:] Hide textbox with selected item in combobox
- [SOLVED:] concatenate variable values
- Building up sentence variable within cells
- VBA Pasting from table to different sheets without using sheets("x").Select HELP!!!
- Duplicate Values in Data Validation
- [SOLVED:] Hide specific rows in various worksheets depending on Summary worksheet cell value
- [SOLVED:] Find Last Value (not first)
- [SOLVED:] select next emtpy column
- [SOLVED:] Excel - Make user opened file the active workbook
- [SOLVED:] Excel - Edit contents of a string
- VBA Help using value in sheet 1 to hide unhide row in sheet 2
- [SOLVED:] Autofit last column in a table
- [SOLVED:] Issue creating pivot table from table data
- PDF to excel
- [SOLVED:] update listbox
- [SOLVED:] sum digits
- [SOLVED:] find listbox column Average
- VBA Newbie looking for linear or polynomial fit to missing dats
- Sleeper: Importing multiple files to excel
- [SOLVED:] PIVOT TABLE TROUBLES - Code runs on one workbook but not the other
- I need help on scrolling down web pages through vba query tables
- [SOLVED:] Loop through listbox to insert to sheet
- [SOLVED:] Get All Most Recent Dates per Month in a Single Column VBA
- Rename the add-in caption on menu bar
- User Form
- VBA to make formula for parent child
- [SOLVED:] Ordering worksheet tabs in a specific order
- [SOLVED:] Delete rows when copying table
- [SOLVED:] VBA - Disable/ activate command button depending on Text box value
- [SOLVED:] Conditional Formatting on a table based on a different table VBA
- Sorting Help
- Calendar with userform input stores irrelevant data to its table
- Graphical hiearchy
- Problem comparing dates in VBA
- [SOLVED:] Delete worksheet activex listbox
- Using userforms
- VBA - Search For Value Across Multiple Worksheets
- Importing files will format data
- [SOLVED:] simple password protection with User Form, with possibility user can change Passwort.
- [SOLVED:] Progress Bar VBA
- Getting selected items in embedded listbox
- Macro works via step through but does not on button click
- Vba, How can code the excel file to save as only and disable to save directly file
- PDF Merger Sequence
- [SOLVED:] Searchable listbox - Multi column - additem to second column only works first time
- [SOLVED:] Changing Data Layout Excel VBA
- [SOLVED:] loop and sum
- Return specific cell in that row using row number
- Creating a Pivot Table Based on Two Tables
- [SOLVED:] error on Password User form by workbook Entry
- Workbook.SaveAs function, appends number to similar named files
- Simple If Statement: Comparing function argument
- Worksheet Change event not working unless cell is manually changed
- Save As function randomly replaces my file path, Error 1004
- Header/Footer sticking to other ranges
- Computing Monthly Weighted Average
- Applying VBA code written in module to all sheets in workbook
- [SOLVED:] vba code for an interface
- Command button to go to another sheet with drop button click
- get Sunday's date between 2 dates
- export and print multipe specific sheets as pdf
- Making new EXCEL file with value only by copy from other excel
- How to Copy-Paste from a dynamic range to fixed one based on cell value using VBA?
- Sleeper: Gantt...mouse over
- Decipher Macro
- Excel chart links in office 2007
- HELP with Conditional VLOOKUP
- RC FORMULA HELP
- [SOLVED:] Automatic Timestamp Insertion Application.Undo
- Save multiple ListBoxes to PDF
- [SOLVED:] Change Excel's own user forms, is it possible?
- Improve Efficiency of VBA Code
- [SLEEPER:] VBA Macro to add values by date
- Reading text files and assigning values
- [SOLVED:] Invalid picture
- Generate Condition CSV File
- Revising A VBA Code
- [SOLVED:] Master file detail list
- Filter Specific data
- Import .txt File with normal Space Delimiters
- Replace kill command with save command and be able to format date
- Click Login button using VBA
- Chart legend entries delete reappear
- Macro Undo Command
- [SOLVED:] COPY/PASTE SPECIFIC DATA INTO GROUPS ON NEW SHEET
- [SOLVED:] Excel filter not working due to blank values in the column
- Data separation
- VBA multiple SQL queries
- copy and rename a folder and its contents based on a cell value.
- [SOLVED:] VBA 2007: How to get object name when inserted in order to delete later
- Help with vba chart
- copy and paste value with condition
- [SOLVED:] Excel 2007: Trying to change images' rotation after loading without selecting first
- [SOLVED:] Clear all items in listbox column
- inputbox vs excel shift + space shortcut
- [SOLVED:] Formulas: If(AND( , OR(NOT(COUNTIF now working correctly
- [SOLVED:] Check if Value Exists in Another Sheet
- refreshing sheet "under" modally shown useform
- Use VBA code in a locked worksheet
- Copy specific data from a row based on value in column A
- Deleting Duplicates based on Active condition
- Getting Key value from last occurrence of another table
- Using Find function in VBA
- split counting
- Select last empty row with header
- AutoFill Only Specific Cells
- Need help with Objective Type questions (Quiz)
- Cant get VBA Code to work. Would appreciate help.
- copy paste the data if condition matches
- Set statement
- [SOLVED:] VBA progress bar help
- VBA Code will not update as target cell is updated using a formula
- Excel 2007 VBA: Having trouble ungrouping a newly loaded object
- [SOLVED:] Display count of months in year which has 31 days in Message Box
- Move files from different folders to single folder and delete the original files
- vba help - to make sumifs formula dynamic
- [SOLVED:] Loop through UserForm Controls and perform Different actions depending on ...
- Link organs in an array to shapes as they are created
- Target cell vs specific cell
- [SOLVED:] ComboBox Function Lost
- [SOLVED:] Userform textbox skipped in tab order after re-enabling - unwanted behaviour
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.