visual basic

I ran a macro against a number of Excel workbooks to correct and error that I had found with some forms we use for recording time. The problem is that I put the incorrect syntax into the macro, strangely it still ran ? Syntax I should have used - ActiveSheet.Protect Password:="password" Here...

I'm trying to figure out code that will print out specific worksheets from an xlsx file from an xlsm file. Let's say the file I want to print sheets off of is Print.xlsx and I want to print tabs Sheet1 and Sheet2. I created an xlsm file and have this code: Sub PrintPages() Dim wb As Workbook...

I have code provided by a fellow user that works when printing a list of tabs in cells. For example, the tab called "PrintPage" has a list of tabs from G12:G15. The following code works to print those tabs: Sub printShtsTEST() Dim Ary As Variant Application.Dialogs(xlDialogPrinterSetup).Show...

<tbody> Level Name Industry ID Company Sector ID Sector Applicability ID Link Link Name Solution Name Prod 1 Prod 1 Rev Prod 2 Prod 2 Rev Prod 3 Prod 3 Rev Prod 4 Prod 4 Rev Prod 5 Prod 5 Rev Total Revenue by Row Revenue Split 1 Dairy Farms 43523 D43523 Dairy D43523Dairy (blank) 01-Dairy...

I have code in visual basic that applies a formula all the way down to where the data ends for column D. When I use a vlookup formula, the code works. Below is the code that works: Sub FillFormula() Sheets("On Order").Range("Z4:Z" & Sheets("On Order").Range("D" &...

Hi all. I'm back with hat in hand . . . I'm importing four worksheets then I need to cycle through them, apply the same filter and delete rows. I have the filter working, but I'm not succeeding in moving on to the remaining worksheets. Once it's woking then I know the next step is an error...

0down votefavorite I am exporting a file from Excel to PDF through a Macro. The file consists of a table of contents and several worksheets. The table of contents is hyperlinked to all the separate sheets in the document while on Excel format. When exporting to PDF however I lose the...

Hi, I am trying to run something that will remove the entire row if a series of letters are present. I am using the below code. It works, but I need to add in around another 25 letter combinations (i.e at the moment it removes EZY, but I also need to remove EX, EFT etc etc.) Can anyone...

I have a excel worksheet that has 6 rows of 12 at the top of the page as a reference table. There are then 3 columns going down the left in which numbers are inserted by the user. These inputs are then run through the various formulas in the columns to the right. The problem is only about half...

Below code works perfectly: Sub ExportToPowerPoint() 'early binding Dim ppApp As PowerPoint.Application Dim ppPres As PowerPoint.Presentation Dim ppSlide As PowerPoint.Slide Dim SlideCount As Long ' Reference instance of PowerPoint On Error Resume Next ' Check whether PowerPoint is running...

I'm trying to validate a list in a combo-box from a name range from a seperate worksheet. MY Combo box = Team MY name range = Workstream the code I am trying to work with is 'fill Team With Team .List = Range("Workstream").Value End With but is not working, can someone please tell me where...

Hello, I do IT for a health screening company. Basically a data review person will download a list of people who participated in a health screening event. This file lists all the people that attended and their personal information. This...

Hi There In one of my worksheets, the undo function has stopped working, it has been suggested that the problem I am having is due to the VB applied to this worksheet: Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) 'Update 20140318 Static xRow Static xColumn If xColumn <> ""...

I have a large dataset with product related data in different columns for each data. <tbody> Date Product A Product A Product B Product B Qty Value Qty Value 01-09-2017 50 1000 40 800 02-09-2017 60 1200 20 400 </tbody> I want to make it columner base dataset...

Hi everyone, I am looking to produce a macro that will enable me to do the following: Copy a selection of cells, for instance [A6:D6] Insert the same row; in terms of formatting and row height into [A7:D7] However, cell A6, contains the following data "a.1" and when the macro is run, cell A7...

Hello all, I'm wondering if anyone can help me please. I run a small company and I've had a customer data base created in Excel. I collect the data from telephone enquiries and then the data base is supposed to generate a pop up after 308 days to remind me to eMail the client asking if they wish...

Hello, I'm currently working on a database/master-log work book and I am needing to add a VB code or such to allow my workbook with the repairs to look at the master data workbook (which contains many tabs) To highlight the duplicated values in column B in the repair workbook, While it looks...

Hi, I currently have a simple macro (see below) that requires users to input values in specific cells, otherwise it will not print or save. However, I need to be able to leave the values blank before saving and sending to the user. Any suggestions? I want to be able to save with blank cells...

I was passed down this macro that joins a list of entries in column A, into one continuous string separated by a comma and makes it 10 digits longs. If it is shorter than 10 it adds zeroes to the front. I don't really see what this macro is doing enough to tweak it, but essentially what I want...

I'm having some trouble in writing a routine for Excel to replace text in a word document. I have a list of the replacement text strings, and the dummy text strings they're going to replace contained in the excel document. I have a word document with the dummy text in the correct places. I'm...