exce-vba

Hi All, I am wondering if someone would be able to help. I have been looking online for a similar code for the below but I cannot find anything close. I am looking for a VBA that does the following: I have data in sheet 4 column “I” if column “H” is blank I need to search in sheet 3 for the...

I'm trying to run a macro but now it keeps freezing excel. It runs with 10 cells, but when the macro is applied to almost two hundred, it freezes and crashes. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch...

Hi, I have question regarding How to jump to the cell with current date when open an Excel file. below are the links to my file. https://drive.google.com/open?id=1_5H6x6pA53OcbOyvtpRfXm6oLVnT1vVa I have tried using below VBA macro but it didn;t work. Private Sub Workbook_Open()...

<tbody> I need to split data, i am having 24 hours data. the time interval also included in that columns. for example, input output Client Trans time csk sub 1:05 1am to 2am intervel rr red 2:07 2am to 3am intervel dd red 5:45 5am to 6am intervel rcb sub 5:47 5am to...

Hi In a table: I am trying to fill an offset of multiple checkboxes, only if their state is True. I came up with this code which most of the time fills ALL the adjacent cells, even the one which state is False. The strange thing is that sometimes the code seams to work. Any idea? Private Sub...

In a workbook I have, I would like ALL sheets, except the sheet being used, to be hidden at all times. In the 'ThisWorkbook' Object I have applied this code: Option Explicit Private Sub Workbook_SheetActivate(ByVal Sh As Object) Dim MySh As Worksheet For Each MySh In...

hi all,i am so sorry if i ask repetitious question but i can not find any related by my problem,however I have one Excel sheet, one userform and a listbox is in userform. Now when i filter my sheet and update listbox by click on button that is on my user form i see all rows in list box. I mean...

I've created a macro in PowerPoint that opens up an Excel workbook, loops through the sheets in the workbook, creates PowerPoint charts and populates them with the data from the Excel sheets. Just to make it clear, the macro is run from PowerPoint. I now have the need to make the data...

Dear all, I am very new to VBA. I have a requirement where I need to hide the columns based on the cell values. For Example, Consider J19, if this is empty then the columns from J to CC should be hidden. Then if K19 is empty, it should hide the columns from K to cc. Likewise, it should check...

Hi All, Sub SavePDF() ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:="D:\Users\51441884\Desktop\Tracking tool\CAPA Form.pdf", _ OpenAfterPublish:=True End Sub Sub Copier() Dim x As Integer x = InputBox("Enter number of times to copy Sheet1") For numtimes = 1 To...

Okay first post in need of some help. I'm currently making a top down shooter in VBA but don't know how to make the player (An image) to rotate in accordance with the mouse like most top down shooters. Any help would be much appreciated .Thanks :)

I have column with containing Below data. 9 Nov 9 Nov 9 Nov 9 Nov 16 Nov 16 Nov 16 Nov 16 Nov 16 Nov 21 Nov 21 Nov 21 Nov 21 Nov 21 Nov 26 Nov 26 Nov 26 Nov 26 Nov 26 Nov 26 Nov these dates are Monday of every week. I want to filter latest Monday (which is 26 Nov)

Hi I am new to this forum and need help for pasting some data from sheet 1 to sheet 2 in the form of transpose. Let me explain in clear. I have a excel sheet as given below image From the above image I need to copy the Image 1, 2,3 as a Transpose into other excel file. Th file is given as...

I have an excel file which has around 373 NamedRanges and their values. Some ranges are singlecell others are around multicelled value. Now I am trying to first export the Names of the NamedRanges all of them which are present in the workbook and their values in csv format. Then I am using...

Hi all This question is related to VBA macro.. How to send automatic outlook mail every day (except sat and sun) at 10:30 am IST using VBA macro Example: To = abc@.com Sub = Reminder Body msg = hi xyz Trade review has been completed for today. what will be vba code for above Scenario ?

Hi all This question is related to VBA macro.. How to send automatic outlook mail every day (except sat and sun) at 10:30 am IST using VBA macro Example: To = abc@.com Sub = Reminder Body msg = hi xyz Trade review has been completed for today. what will be vba code for above Scenario

I have created an excel spreadsheet to use as a template for documentation. I have locked the workbook from being changed, with the exception of the cells that need info entered. I then added a macro the counts up every time the file in opened, with the password protection being unlock then...

hello, I am working on my research and I have to generate more than 91 charts for each sheet and I would like to use macro to do that. I am still new with macros but I tried to write this one, but it is not working. I would greatly appreciate your help on this issue! The set of data that I have...

Hi, calling all Master Coders. I have a document that requires two buttons. The first button needs to search a cell value on sheet "SUB CON PAYMENT FORM" cell "L9" (the value is manually changed each month by the user). It then needs to search all other workbooks for that payment number (the...

I am using VBA . I am having worksheet with different columns and one column i ma having customer names and in G column i am having value for each customer. My requirement is I am having 10 rows with customer name as "Abc" and 5 rows with customer name as "Xyz". When I set Customer name as...