help - macros

  1. S

    VBA - Rewriting a code to avoid pressing "ok" on each loop - extracting data excel files on SharePoint hyperlinks

    Hi All, Every month I have this task of collecting data from about 200 reports, into a main central consolidation file. The Report is an Excel file stored on SharePoint. All the Data i need is on a hidden tab in one Range. Process:- 1. I go to the SharePoint site where the files are stored and...
  2. R

    Error in Code

    i have a code to consolidate the all sheet into one. sheet name is consolidate. but whenever i have running this, data copying twice. :( Private Sub CommandButton1_Click() Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets("One").Range("a1:c1").Copy...
  3. M

    Help: Macro for copying old workbook columns to new workbook

    Hey guys so im struggling with making a macro: To start; i get inventory lists that don't have my data on it and have to go copy columns from multiple tabs. I was creating the macro below but the problem am having is: How can i make this work on any 2 workbooks i have (ex: this one is copying...
  4. S

    Code to generate new tab transferring data in to new fields

    Hi, I am trying to create the option to click a button/ field/ word on a line in an excel spreadsheet table that will generate a new tab which transfers some of the data from the fields on the row in to a new pre-defined template. The template requires the following fields to be populated from...
  5. J

    attempting to delete rows not containing certain text but having issues.

    Basically im trying to filter a large set of data. I have people's names and want to delete all rows not containing these names. I used this macro originally: Sub DeleteRows() Dim Cell As Range, cRange As Range, LastRow As Long, x As Long LastRow = ActiveSheet.Cells(Rows.Count...
  6. T

    Checkbox maddness!

    Hi hoping someone can help me. For some reason I cannot get the following to work. when the checkbox is ticked i.e. TRUE 1. unlock cell named "merchant" 2. clear merchant contents (a formula) 3. message box "Enter Merchant" (I've got this bit to work fine, where it falls apart is the...
  7. B

    Help with formula

    Hi Guys, Thanks in advance for your help!!! I am trying to edit an existing sheet that we have at work. There is a button that clears all previous records and then a 2nd button that resets the formula. (The VBA for resetting the formula is pasted below) When I hit the reset button all cells...
  8. I

    Help with VBA

    I am really new to VBA's. I am trying to make a "create PDF" button to make a PDF out of the active tab. The file name would be using cells on the active tab then the name of the tab and then another cell. I would also like it to prompt the user if a file of the same name exist and I would like...
  9. J

    VBA Code for Resizing Photos/Objects

    HI! Can anyone help me with figuring out the VBA code to unselect "Lock aspect ratio" and unselect "Relative to original picture size" and then resize all images and object in the active worksheet to a specific height and width? Thank you in advance. -Julie!
  10. S

    VBA Newbie Need Help Please!

    Hello everyone, I am pretty new to working with VBA with Excel. I've worked with a bunch of different coding languages but all pretty entry level. Anyways, I have been trying to make an inventory sheet for my place of employment (public library) that can do what we need. I have worked my way...
  11. E

    VBA Help

    Hello amazing people, I was wondering can you help me with the below This is a current macro that I am using that copies everything (format, tab names, add data) and doesn't have formulas, removes the macros from the file also, works wonderfully, but is there a way to save the new excel into...
  12. D

    MACRO for pie chart

    Hey guys keep getting an error msg of object variable or with block variable not set..excel highlighted the string of code that may be giving me the issue I a completely stumped need help! the code is below..any help is appreciated Sub Macro5() ' ' Macro5 Macro ' ' Keyboard Shortcut: Ctrl+e '...
  13. B

    Sorting with Loop

    Hi All, I'm trying to run the Macro below but it crashes every time it get to the highlighted .Apply line. I have no idea why since it did not crash on the first .Apply line. Can someone please point me to the right direction? Thanks Dim arng As Range Dim brng As Range Dim crng As Range...
  14. L

    VBA - Consolidate data and Sum mulitiple ranges

    Hi is there anyone who can help. I'm working on a project and I need a VBA Code to consolidate multiple rows based on a single column entry, then adding together the other columns. At the moment the data looks like this: <colgroup><col width="170" style="width: 128pt; mso-width-source...
  15. B

    Extract rows with value >=1 to another sheet

    Hi, I would like to ask for help. I need to extract rows when it meets the criteria >=1. EX: Complete Product Sheet: <tbody> ProdCode ProdDesc Qty 1001 Prod1 0 1002 Prod2 1 1003 Prod3 2 1004 Prod4 0 1005 Prod5 1 </tbody> Order Product Sheet: <tbody> ProdCode ProdDesc Qty 1002...
  16. T

    Search Bar and HyperLinks with VBA

    Hi all, I'd need some help. I have the following VBA, and everything is working properly except the simplest thing: the automtical hide-unhide part I saw from Mr.Excel: Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) LinkTo = Target.SubAddress WhereBang = InStr(1...
  17. M

    VBA RGB Code LBound to UBound

    Hi All, this is a most excellent forum with a wealth of information and a wonderful user base! I have learned a lot from this forum, and see many thoughtful answers. I have a macro which I need help with, I'm attempting to display a list of RGB codes to the recent colors section within excel...
  18. P

    VBA Help: Save & Rename Attachment with File Name & Yesterday's Date

    Hi all As post title states, I am trying to write some VBA code that will save & rename Outlook attachments with the attachments filename along with yesterday's date. The attachments all have a string of 16 characters (date & time as numbers) at the end of each attachment. I wish to remove...
  19. M

    Error when activating a workbook

    Hi! I am trying to automate a painful process. I have a workbook that has a lot of sumifs for four countries. I will have to save workbook 4 times and value past certain ranges. I am trying to automate this process with following code. Sub Hardcode_v1() Dim z As String Dim i As Integer Dim w...
  20. I

    Another Automatically Hide Rows Question...

    Hello All, I have been searching for threads and while I can find some code for situations similar to mine, I can't seem to re-work the code to fit my specific situation. I just don't have a deep enough understanding of VB to understand how to modify the code. I have fleshed out what I am trying...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top