cell value

Hi, I would like to know if it is possible to have a formula where the search field of the array is dependent on the number I put into a cell. As an example: <tbody> A B C D E F 1 7 4.5 7 2 9 5 5 3 6 3 10 4 8 0 </tbody> I want to perform a calculation on the above...

Hi guys, i would like to get a help from you. I need a formula, macro whatever for this table: <colgroup><col><col><col span="4"></colgroup><tbody> result S A B C P1 AACCCACAABSA P2 AAACABCBA P3 ASCAAABCABCS P4 BCBSABBA P5 BBCSAACA P6...

Hello all, I am very new to the forum and very new with the use of Macro as well. I wish to be able to move an object to a certain cell (using .top and .left). It is important the location be referenced to the cell versus increment or numerical value. Below is the sample of my code...

Hello all, I am trying to send cell contents to an email, but time values in my cells are converting to decimals. Is there a simple way to make it show the time properly? I thought .value would do it, but it didn't make a difference. Else Gmail "z@gmail.com", "zzz", "", _ "o> " &...

Hello! It's my first time posting here and I don't know if this question has already been asked. If that is the case, I apologize for cramping up the threads and I would be grateful if you'd provide a link to the answer to my question. My situation is this: I have a spreadsheet that consist of...

Hello Everyone, Your help would be greatly appreciated. I am looking for some code that would copy some specific rows and paste them on the same sheet, one below the other, equal to a number put in a separate box. At the same time I would like to rename one of the cells in each copied groups...

I have two columns of data. For each row, I would like to replace the cell in the 2nd column with the product of the two cells in a VBA macro. I've seen examples of accomplishing this with a constant, but not with changing values. I.E. (before macro runs): 234 10.0 54536 0.2 4...

Hello guys, i need a code in VBA that will insert a picture from a folder in my desktop using the cell value that will be entered manually.. EX. Cell I8 = 2016-02-0225 (this is the name of the picture that will be inserted to a cell) when i click the button after i entered the name of the...

Hi, i have been trying for quite some time to auto select the slicers based on data validation list. for example, i have data validation list in the range I7 : I16 and I used INDEX to obtain the respective values based on selection in I7 : I16. I want slicer to select the values automatically...

I have a spreadsheet set up with thousands of worksheets, however I do not need them all depending on the value of a drop down list. Any ideas how I can do this?

Hi all; "Vlookprint" is the cell where the first vlookup formula will fall into. this first cell is necessary to establish because it gets resized to the correct amount of cells to do Vlookups in. I have a cell in sheet one that contains literally, "W36". So, cell T16 = "W36". The value in...

Hi, I'm new on this forum I've got a problem with a macro used for increasing cells by 1 with the right click of the mouse This is the macro: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) If Target.Cells.Count > 1 Then Exit Sub If Not...

I have been attempting for some time to automate compiling weekly reports that I receive. The following is what I have written, and I can't figure out why it doesn't update the value of cell B39 to reflect to the newly received sheet. This macro runs fine through to the range("B39").Value...

I need to erase the entire row based on 2 different cell values. I would like the Macro to all rows and columns on the sheet and delete the entire row if it finds a cell containing these 2 values: 1. WORK OF 2. RUN DATE Thank you - your help is greatly appreciated

Hello, please if somebody can help me. <tbody> I have this problem: in excel file I have two sheets. In first sheet I am entering values, changing values, deleting values...sometimes, in one cell I enter value like this 125+138+458. I need to copy values into next sheet, but only...

Hello experts I have a section of code which goes like this. For i = 3 To 27 Range("co3").Select ActiveCell.FormulaR1C1 = _ "=CORREL(RC[-6]:R[17127]C[-6],RC[-5]:R[17127]C[-5])" Selection.Copy Range("cp" &...

Hi! I am able to open the file I want using this: Workbooks Range("bd1").Value & ".csv" But how do I then close it later on? If I understand how this works correctly, I need the full filepath to open a file (i.e. the value of cell BD1), but only the book name to close it, right? In this...

Hi guys, I've been asked to make several thousand invoices, so i thought i'd use VBA to generate them for me to save me ALOT of time. Each invoice look the same, but has to have a unique name and contain a unique vendornumber in cell B3. I have 2 column (A and B). A is the name of the excel...

Can someone tell me the syntax for writing the following when I have the name of the sheet in a cell value? The following works for me: Dim ws as worksheet Set ws = ThisWorkbook.Worksheets("Systems") I'd like to be able to change the name of the worksheet so I can apply the remaining code...

Hi, I'm new to VBA but did quite a bit of macros last week with the help from this forum. Now I'm stuck with this one and can't figure it out. Any help is much appreciated. I have a schedule something like this on Sheet1:</SPAN> <TBODY> Name</SPAN> Mon</SPAN> Tue</SPAN> Wed</SPAN>...