macro 2007

I am working on a excel sheet, where I have a 4 cells that i enter information into. I am trying to make a button inside this sheet that has a macro assigned to it. The button needs to copy the cells (E3:E6) in the column (E) once it has copied the data from these cells paste them to another...

Hi Folks, Here is a macro for word to word translation. Sub macc() Dim d() As String Dim myValue As Variant myValue = InputBox("Input Cell ID") d = Split(Worksheets("Titles").Range(myValue).Value, " ") For Each i In d a = Application.WorksheetFunction.VLookup(i...

I need to create a few boxes in my sheet (excel 2007) and then assign a macro to them, however, the macro will not be in the workbook as I am building a macro to my personal that I will use to format different reports from different sheets that are run daily. I have the below code which is...

Hey yall, I am looking to create a pop-up message box that will appear when a certain value entered into a cell is bigger than the value of another cell, letting the operator know that the value entered will not work. Please help! Thanks.

Hi, I need to create a Macro to protect a particular worksheet with a password in a workbook. For example:- my workbook has a filename "Vignesh.xlxs". i have many sheets in that such as "Jan", "Feb", "Mar", Apr", "May"..... "Dec". Here i need to protect only "Jan" to "Dec" sheets with same...

How do I have VBA understand that my content is text, not numbers? I keep getting an error when I try to run my code because my words have dashes in them. Here is the part of my code that is giving me issues: Word = "I-BUTANE"

Hi. I'm new to this forum AND macros in general (other than a c++ class in high school many years ago), so please bear with me. I have a feeling this is very simple, but massive amounts of googling has not helped me. I have a worksheet with values in column A (names of cities) and numbers in...

Hi, I have the below Macro to route through my Spreadsheet and only print the sheets with data in a certain cell: Sub CHECKSHEET() Dim Sh As Worksheet Dim Arr() As String Dim N As Integer N = 0 For Each Sh In ActiveWorkbook.Worksheets If Sh.Visible = xlSheetVisible...

Hi, can you pl help me with a macro code for the below task in excel 2007.I am new to macros. 1.In Sheet1 I have 100's of Rectangular shapes each containing one text box containing Text(Single sentence with many words).each Rectangular shape is one below the other in order and each...

Hi all, I am new to Excel world. I know basic functionality and many of the functions of EXCEL. This is what i am looking for. a. In 'Sheet 2' - In cell 'A1' i have a concept 'Assets', In cell 'B1' i have formula how to my concept is calculated '= Current Assets with 2010 of India + Non...

This may be a difficult question to answer, because I can't supply the exact macros I'm using but I will try to give a good description. Essentially the original workbook has data for multiple sales branches across different categories. The macro essentially makes a new workbook for each...

Hi All, write down macro or combination of formulas to find out the following- I need to find the difference between certain column in 2 rows based on other columns. For example- Find 'A10' minus 'A16' based on certain values in B column. 'B1' or 'B2' or 'B10' or 'B?' ('B' can be anything)...

Hi, I have a spreadsheet containing Employee names, the project they've worked on, and the days. Basically, each day in a week, the employee spends a certain amount of time working on that project, say 5 (hrs). The data that I have contains this detail for all the individual days, the only...

Hello Everyone, I have a question regarding Macro's. I have seen a similar question posted here before but I'm afraid my knowledge was not as advanced as the person who asked the question, so i didn't really understand the response! I have a Macro saved in my Personal.xls workbook that converts...

Hi, I need some help with a simple macro I'm using. I've recorded a macro which selects a few cells in a row, copies them and pastes them again over the same cells (special paste - only values), and I've attached this macro to a button. I would like the macro to repeat the same action on the...

Friends, Is it possible to send SMS from a XLSM sheet using macro? I have an XLSM sheet for Employees attendance marking and everyday My HR team used to copy the details from that sheet and sending SMS to me. The system is connected with internet and is it possible to send SMS automatically to...

Friends, I am using the following code to find a NAME in my work sheet and to enter their status. But this macro is not compatible if a duplicate or Similar name exist. Friends can you help me to sort out this. What I need is I need this macro to activate the search NAME Cell and then a VB box...

I'm currently working on a macro for a client and it involves the use of looping. Essentially what I want to do is find every instance where "EERT OUPUT" header is mentioned in the spreadsheet then rearrange the stacked data below the EERT OUTPUT header into one line or row then proceed to the...

i am looking for Macro for Xl 2007 to send emails which are listed in column A automatically, when the numeric data in column D changes to "4". I am looking for this as i have to mail each one of the people listed in column A, each time the cell value gets to "4". and i need the macro to have...

Hi, I'm new to this forum, and equally new to using macros in Excel 2007. I basically need to merge three tables into one. The first two tables contains rates based on an issue age, and a fixed period of time. The only difference between them is the first table is for a "Band" class 1, the...