vba code

Hi masters, I would like to ask a help regarding vba code that can auto hide a certain column in each tab..for example Column C1 = I want to hide all that is under C1.. so basically i have a certain name in row1 that i want to auto hide in each tab

Hi guys, Just wanted to ask for a help related to scraping of data from the URL. I have previously used the following script (function) to extract Article/website title from the URL. Now, however, I need to extract the date of issue; e.g. when the article was published. Could you please help...

Hi Guys, Need help here on adding new name + existing name in tabs/sheets. I am looking for a piece of code that can help me with my work. I want to add new set of numbers on the existing tabs. for example project ID is 2214 : (this are may tab names) 143 188 122 11 901 After the code runs i...

Hi there, I have a set of data which can change via formulas. To reduce the amount information the user is looking at, I wanted to hide the rows with a zero balance. I went to test the below VBA code but it was taking so long, I had to stop it. As you can see, there's over 4,000 rows. Since...

Hi, I'm not sure how to go about writing this VBA code. Can someone help me please? I would like cell M10 to change from True to False and False to True when the VBA Code is run. So if M10 = True return False, if M10 = False return True Thank you!!

So I am using a pivot table and one of my rows contains quite a lot of wording. After I select from the filter which option I want, I go to the row that contains the long wording and edit the wording at the top. Then, when I'm done typing it out, it shortens it to so many charaters (I'm assuming...

I have read through several posts and cannot find a code that will work correctly. I have a spreadsheet that has 700+ rows and 100+ columns. Column A contains a value of Y or N. I need a code , using a Toggle Button, that will print ONLY the rows that have a Y in column A. I know this can be...

Hi there, I am trying to sort my data which is located under headings A52:K52 by the account number order, as stipulated in cells K21:K35. This is my attempt but it is possible I'm way off the mark. Can anyone see how I can get this working please? I don't want to refer to a particular sheet...

Hi all, We are using the following VBA code Sub Search_and_Match() Dim sh1 As Worksheet, sh2 As Worksheet Dim lr As Long, lc As Long, col As Long, lr2 As Long Dim c As Range, f As Range, r As Range ' Set sh1 = Sheets("Sheet1") Set sh2 = Sheets("Sheet2") lr = sh1.Range("A" &...

Hi, I am looking for a vba code for my module which will undo my works. thank you

Hi, I looking for a new vba code for these. In my workbook. I need to make B6 cell as mandatory or need to fill first before you can do other work in workbook. Also a message popup if they not fill the B6 FIRST. Meant after save and open if B6 are filled you can continue your work. Thank you

In a sheet some 6000 rows are there. Id's are repetitive with different dates. I just want that macro will check the no. of repetition of each id and if the repetition is more than 12 times then it should delete the oldest date. (It means 12 times repetition is fine. If an id is repeated 13...

Need VBA code to copy and paste as values from a specific range A1:AE36 in a worksheet named "Matrix DSR" and workbook named ""Daily Sales Report Master Update File - CQ_v2" to a specific range A1:AE36 in a worksheet named "Matrix" and workbook named "BMH Daily Sales Report thru 08-21-19 run...

Hi all thanks a lot in advance to the people that will help me with this. I have to create a line chart which should automatically updates according to the variable length of the columns of data that I want to display in my line chart. Any help/code that can help me? my line chart shows the...

I current have macro set up to log in CMS and pull the need reports. This works fine for me however my co-worker gets the following error when he attempts. He had upgrade to Excel to 64bit but since has revert back to he 32 bit. Before the upgrade it worked just fine. Error Run-time error...

Hi there, Can anyone help me amend this VBA code to include more than one reference (if possible)? It currently refers only to D12 but I want to add another nine references - D68, D124, D180, D236, D292, D348, D404, D460 and D516. Thank you! Private Sub Worksheet_Change(ByVal Target As...

Hi, I have the below code which works fine if the target "No._Partners" is on the same sheet. However, in this case, "No._Partners" is based on another sheet. Can someone please help me change the first part of the code to refer to another sheet? I'm not quite sure how to do that.. Thanks...

Hello, I requested help a few month ago with this code, I was able to find a solution and customized like the following: Sub Externalabelshn() ' Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.EnableEvents = False...