vba-excel

Hi everyone. Hope you all are doing well. I've been struggling with a macro update for a while now. I'm trying to count cell values ONLY when the column name is like Math, Science, or History. The issue is that the code is somewhat static. If a Math, History, or Science column is deleted, it...

Hi Team, I created a userform that would look for the next blank cell starting from Column "B" and return with the value in textbox1. I assigned the sub in commandbutton1 so that whenever I click it, the value of texbox1 will be placed in the next blank cell in column "B". I tried searching in...

hello, I have a little problem. here is my sample excel data. its fairly large. <tbody> A B C D E AAA AA 1 AAA BB 2 null null 3 BBB CC 4 BBB DD 5 </tbody> So i want to change the values in column A and B. so i want to input a number (1-5) in column B and values...

Hello, I have two columns column a and column b. column a has alot of dates in it also some empty cells What i want to do is add 30 days to those dates and publish the result on column b. and when the cells are blank then it will be blank. This is my code, but showing an error, type mismatch...

I'm using Application.Match to get the row number of a value, and to fill a form with all data of the row. It works perfect when sought value is alphanumeric, but error 13 is returned if sought value is numeric. Why? Error occurs on line ultimafila = Application.Match(Me.textoCodigo.Value...

I have two workbooks, one is WB1 and second is WB2.With VBA I want to copy specific cells based on a IF condition from WB2 and double paste to WB1. Also I want to add some defined numbers into WB1. It should look like this: WB2...

I have macro file and i saved it as .vbs file. Lets called it macro.vbs, and here is the location on my local C:Dekstop\macro.vbs. here is the code inside: <code>Sub Macro3() Sheets("vlookup").Select Range("B5").Select Selection.EntireColumn.Insert , CopyOrigin:=xlFormatFromLeftOrAbove...

Hello, I am using below code to export Salary Payslip as PDF but i am getting below error while exporting. after export few Page, i am getting "Run-Time error 1004" (Document not Saved. The Document may be open, or error may have been encountered when saving). Code is below Option Explicit...

I am trying to write a vba function, sub or to call a sub / function that would pull unique values in a column's range to another, larger column on the same or different worksheet. I want to pull the unique values as they appear because they may disappear. Imagine for example people enter a...

Hi everyone, I am now about 600 lines deep into my code... yeah.. it's a lot... The 'challenge' now is to make the code not only work for different sheets, but in different files? Is this possible? To have a code.xls that looks for sheets or something? So I just have to press a button? So when...

Title says a nice brief summary. I'm using a VBA Macro It's for a party this Friday and some people entered their name in the wrong place. I have two sheets, let's call them SourceSheet and DestinationSheet. SourceSheet has 2 columns with the same information, I want to make them into one and...

Hi I have a 2 Column excel file. 1st column is just the Serial Number in increments of 1. Every cell in 2nd column has Text ending with a square bracket, e.g. ] Sometimes a sentence ends with a number enclosed between two closing square brackets e.g. ]12] I am looking for help for a VBA Macro...