excel vba 2013

Hi, I am using Excel 2013, I apply 2 way the Large Formula VBA, but not working, what i am wrong, i don't know Sub Macro1() '1st Table Dim statement ---> Declares variables Dim lRow As Long, lCol As Long lRow = Range("D5").End(xlDown).Row lCol = Range("C5").End(xlToRight).Column 'Column Count...

So, i have a 'Summary' workbook that consists of zone, state, city, and total income. Inside one zone, there are a states. And inside the states, there are a cities. What i'm trying to do is to find the total income of each city in column D and summarize the total income of each state. To get...

I have a VBA code to open the reflection workspace. I want to place a cursor in a particular position of the screen(24th row and 15th column) and then pass the string value "START TSO". However, I am unable to place the cursor in that position. I tried PutText1, PutText2, MoveCursorTo1 but it...

Learning Excel VBA on the go to automate a few processes at work and web search didn't provide an answer for this. I have a worksheet with about 15 columns that acts as a log for the work performed daily (Dates in column 1). These tasks are categorized for data analysis purposes (Categories in...

Hello Everyone, Good Day ! I'm learning about excel vba coding and i have an excel file which is something like small invoices sheets and i have added one more sheet like summery/report. Only i want to make copy and paste some specific cells from invoices to summery sheet, attached small...

I have a protected worksheet and need to have specific cells locked after data is entered. I would also like to keep the filter option working after locking the cell( protect the sheet). I currently have a working code that does what I'm looking for but it covers ALL the unlocked cells on the...

Hey, so I will make this fast. I am looking for a way to select a range of cells, starting with A17, down column A, to where a bottom double line border is. There are no other bottom borders in the range. The range can vary, i.e. A17:A46; A17:A2345837, etc etc. All of the range's cells may...

Good day guys. I'm trying to create a Data Entry using VBA code. I successfully created the User Form but I am having problem about the code in Submit / Clear button. So, basically I just want to fill up my excel sheet what ever I enter in my user form specifically in COLUMN C, I, J, and K. I...

The below code checks to ensure a certain cell has a value before changing the color back to the sheet's original color. By changing the color from yellow to the sheet's original color, the user is able to print. The issue is that once a value is entered, the message box keeps appearing when...

I have a worksheet with a Worksheet_Change sub in it. I have two sets of code in it. Each set, individually, works as planned (tested). But when together, for some reason only the first set is catching correctly. Here is the code: Private Sub Worksheet_Change(ByVal Target As Excel.Range)...

So I have 3 worksheets that each have a number of pivot charts on them. The pivot data is on a different sheet than the pivot charts. Charts and Data are on separate sheets. I have a number of slicers (4) on each sheet too .... all three sheets have the same slicers so that if I make a change...

This is my code for checking the system clock and comparing it with the dates of the tax year Sub dateesystem() 'decclare all variable to differnt type '------------------------------------------------- Dim StartDateMonth01 As Date Dim StartDateMonth02 As Date Dim StartDateMonth03 As Date Dim...

Hi everyone I am trying to make a excel file with vba codes. Plan is that file save datas, choose information daily, open an existed word object (.dotm) change bookmarks I create and save it. All is fine till save as a .pdf and send e-mail via outlook app. I already do this in excel with active...

Hello, trying to do the title task (in Phase 1 & 3 of code below), but getting the type mismatch error when running. Please help, thanks in advance! Sub PhaseOne() Application.ScreenUpdating = False Call PhaseOneStepOne Call PhaseOneStepTwo Call PhaseOneStepThree...

I am working on a project, where I am automating IE. Where IE is accessing "www.google.com", and typing "population" and clicking on "google search" button. Desire: I don't want to show what I am entering to the search box. Or I want the text, "population", to be blur or hidden, so that while...

Hello everybody out there, I do believe that VBA code is needed for my problem. So please, be kind and help me. I have table with many dates (all dates are in one specific column). Cells with dates are filled without some special order. Filtering is not applicable, because of other data...

I am pretty solid in my excel skills but am still learning about VBA. I am trying to figure out the script for performing an automated currency calulation (currency converter) when the cell in the first column is selected and a value is entered. The adjacent cell next to it should perform the...

I have a small program that is trying to find a cell containing a certain string and return the Row in the table where it is found. Here is my program: Private Sub test() 'Routine to move data to table from Molding Table 'Check to not overwrite current records but add new ones...

I have a workbook, Book-A, that I have defined a UDF. When I open a second workbook, it breaks the UDF on the first workbook. How do I stop this? Rich

I am using Excel 2013. I have a listobject excel table called Assembly I need to find the cell that contains "asmb1" in column "Item Name" Here is what I have that does work: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit...