vba & excel 2003

I am trying to copy from a workbook that has a single sheet called 'Lookup' to my local workbook using vba in excel2003 (for macros issue). When I use the code below, I get the entire sheet data, but not the formula is a couple of columns. Workbooks.Open...

Hello, I want to compare 2 logic in 2 different work sheets at same time if 2 logic is true then output will be shown. I have written vba code for the same using IF logic, it is working but it takes too much time for running. Hence i tried to change IF logic to INDEX MATCH function vba code, but...

Hi! Anyone know what's the code for opening existing publisher document using excel vba :) Thank and I will be appreciate with the help from anyone.

Hi I am currently doing a project and I have trouble figuring out the code for application.filesearch for excel 2010. There is an error to the code and I hope someone can provide me a solution to this code . Thank you in advance:) ExceStatic x As Integer x = x + 1 Range("j17").Value =...

Hi everyone! I made two buttons using VBA on excel 2007 but they don´t work when I click on them when I open the worksheet on Excel 2013. I don´t receive any error message, they just don´t work. These are the codes I used: 1st Button: Worksheets("Input").Range("C9, B15:B113, I15:I113...

Hi, I write a code to copy data from one worksheet to another, however my code is only able to copy one row, but I need it to copy multiple row

I have write this code, however , there is two serious problem One is about I want to change U's value once I change G's Value or H's value However, first time to key in in G or H will result weird value in U Like The U is zero, and I enter 1 into G, and U will become 2 something like this...

I know how to write the code for CellA+CellB=CellB(New) However when it comes to 3 cells I dun know what to do le

I was trying to input the code number and then copy the data from another worksheet with same code number However, after I try this code, it shows type mismatch at I don't understand where is wrong, so anyone willing to help me? And I was try to input the "c", in to one column in another...

I write a program to set when I key in in one cell in a column, and the other two column meet the requirement, so the row of it will become to red color, and when I key in in one cell in another column, and another two column will fail to meet the requirement, so the row will become not fill in...

Hi, I was trying to put selected cell's text in MsgBox Like said , Range A contained all the item's name, and I want it to pop up a msgbox when Range E and Range F meet some requirement(This one I already write). But, I want the MsgBox show:" xxxxx(Range A's value) is low, Please refill ASAP!!"...

I wrote this code, however after apply the code, only the update date function and the code below is working, the others function all cant work

I would write code for few columns that perform that Cell 1 -Cell 2 +Cell 3 = Cell3(new) However I can only write for one cell, cant perform in one column, and if I never clear the value in cell 1 or cell 2, it will still work like the formula I want to perform like if I never change the value...

I think is because this (If Range("U" & i).Value = 0), but I dun know how to edit the codes

Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng = Target.Parent.Range("Moving_Stock_out") If Target.Count > 1 Then Exit Sub If Intersect(Target, rng) Is Nothing Then Exit Sub...

I want to copy selected cells based on the requirement, because I got color fill in and numbers for the cells, so I want copy the selected cells in to another worksheet according to different color. And also I want copy some selected cells into another worksheet, for the cells number is zero. I...

Private Sub Value_Change(ByVal Target As Excel.Range) If Not (Intersect(Target, Range("A1:A100")) Is Nothing) Then Range("B1:B100").Value = Range("A1:A100").Value + Range("B1:B100").Value End If End Sub I write this to trying to achieve that A1 +B1 =B1(New) ,A2+B2=B2(New), and so on However...

Hi I am very new of VBA, which I would like to write a code that when I updated one column's(like said column 1) value, the other column(column 2) will updated to current date, and other rows will not be affected if the column 1's value is not changed. And is it possible that once I forget to...

It said error 13 type mismatch Sub Most_frequently_used_tools() Dim strData As String Dim item As String Dim diameter As String Dim rng As Range Dim maximum As Variant Dim rngCol As Range Dim lngRow As Long Dim rngAdd As Range 'Enter desired range in which to find the maximum value...

Hi, I would like to creat a button that when I click it will automatically add a new worksheet with the template that already in workbook. I know how to copy the entire worksheet but I dun want to copy every words in the template, some cells I dun want it to be copy