excel vba

Hi all, hope that someone will be able to help.. I am trying to find out if it is possible to apply a digital signature to an Excel file programmatically via VBA. At the moment, I am going around in circles trying to find an answer and getting nowhere fast. Little bit of background for...

Hi all, this is my first time to post here! :) I am helpless now, I cannot display the value of the first and last index of selected items on a list box thru MsgBox. It only displays me boolean values. Here is the code: x = lb2.ListIndex = 0 'get first index of listbox MsgBox x I'm thinking...

in a sheet I have column A with merged rows in groups of 7 rows Using VBA I want to find either: - if the ID is already present a row: return the row number where the value is found - if the ID doesn't exist: return the row number of the first free cell I was using this code in another sheet...

I manage to import CSV or text files to this macro. I combine it with Module 1(please refer file attachment). The arrangement column is a little different. I have difficulty doing this: The data file that I want to import is below screenshot (please refer to TEST_DATA attachment) The data...

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...

All, I have a tricky VBA Code Scenario. I'm trying to define a table range then loop through all columns in said table range and change the formula in the total row of the table. The Tricky Part is my Table Self Updates so the number of columns and the label of the columns change depending...

I'm trying to use the SEQUENCE formula in the code below but getting a run-time error. Am I missing something in my code? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Application.ScreenUpdating = False If Not Intersect(Target, Range("startDate")) Is...

Hello everyone, I am trying to download a document from a website using vba. So far I can click the print icon on website (using vba) but I am stuck when it shows Open/Save dialog box. Please help on how I can access or click the "Save" button and save file to a given location. Any help is...

Hey All, I'm getting the error that no cells have been found when running the following code. Although it is correct and no cells have been found under the criteria I've put, I want the code to just move on and continue with the code. Could anyone help me to do this? I am a beginner when it...

Dear All, I have to randomly select six clusters/ villages using PPS method (Probability proportional to size) for a geographic unit for surveys. I already have an excel file that does it for me using macro (Module1: RUN_CLUSTER) and generates PDF files using the macro (Module2) I have a fixed...

I am trying to send an SQL query string from Excel VBA to an access database. I have a standard module for this and it works fine except when I am trying to get this query to run. sSQL = SELECT SV_CgRefset.Name FROM SV_CgRefset WHERE ((SV_CgRefset.Name) = "CKD_15"); In short this gets to the...

Hi, I came across a similar thread VBA to copy range data with all visible and invisible cells to another sheet on MrExcel.com and was hoping to get some assistance on my scenario which is as follows: What I have on a tab (name: origin) Station People Cars A 12 29 B 6 10 C 4 2 TBC...

Hello, I'm currently learning excel and vba. I was tasked to create a program and a part of it is to allow users to log in. In a separate userform, the user registers their account together with their other information. The next step is to enter the new user form to login and see their...

I'm running into a unique situation dealing with duplicates. I have the following sheets: Sheet1: Sheet2: Sheet3: My current macro included in the workbook will compare any two columns within individual sheets and delete them. Sub delete() Dim x As Range Dim lstrw As Long Dim sh As...

pincode vendor rating pending cases 1 xyz 2 0 2 xyz 2 41 3 xyz 2 45 1 xyz 1 4 2 xyz 3 17 4 xyz 2 0 5 xyz 2 45 6 xyz 3 17 This is my excel data i want to copy all the unique data of pincode to another excel sheet.. For eg. here there are pincode "1" which has 2count then all...

I have a report that I need to update from the data in another report. Both reports are large, over 50,000 rows, so I read them into arrays so the process would run faster. I need to split the Source array into separate arrays based on certain conditions in the HR array. I'm getting an object...

Hello Everyone, can you please help me with a code that will sum up values based on condition, Here are the details, If sheet "Control Panel" Range(A2)=sheet "BOOK1" Range(B) (search in all rows from B2 to B down) If sheet "Control Panel" Range(B2)=sheet "BOOK1" Range(L) (search in all rows in...

HI i have set of data rows which i need export to word file with images Data in row from A7 need to export to word one by one after image In column O:O contains image path with name after export data values image need to upload followed by text, please find the excel file and expected result

I want to save activated worksheet at given folder path and want to save in tab with specific worksheet name using VBA macro and want to delete activated worksheet again.as i am doing this for number of files and also i want to add wrap text =true and row height set 12.75 Tried below code Code...

Hi I have an excel book that is a template and gets populated through Power Automate and only the headings of the table exist. The data in the table can vary in amount of rows The data is pulled from a database where it has different levels and the Name needs to be indented according to the...