1.value

let's say here is my sample workbook ("productmovement") <tbody> Product Out Stock Total apple 5 8 3 banana 4 9 5 orange 3 10 7 </tbody> and here is my samlple workbook ("productinventory") <tbody> Product Stock date grapes 10 apple 8 orange 10...

Hello I would like to convert a string with a decimal value >100.00000, which are in units of µM to a string with an exponential value, > 1.00E-04. For example: <colgroup><col></colgroup><tbody> >100.000000 >100.000000 >100.000000 >100.000000 >100.000000 >100.000000 >100.000000...

Hi What is the code change to change 'DataSheet1' to N where n = activesheet.name Original code: Range(Cells(10, 1), Cells(j, 1)).Value = "=IFERROR(INDEX(List!C[1],MATCH('DataSheet1'!RC[4],List!C[1],0),1),0)" This doesnt work: Range(Cells(10, 1), Cells(j, 1)).Value =...

Hello, I'm trying to make my first array and hitting a snag. I'm making a macro that automatically runs upon opening any Excel file. I'm having a runtime error of 438, Object doesn't support this property or method. I feel it's from incorrectly defining my active sheet. How would I properly do...

I have the following code which starts off by pasting into cells A1 through B6 the following data. All of the data pasted into column "A" is numeric. I ran the macro recorder and then copied and pasted that into the bottom of my code. When it gets to the line...

I have two small 5c x 20r tables separated by a single column. When my macro gets to the last row (numbered 20 in column 2 and column 8) I would like it to go the top row of the next/previous table. The code is listed below. It works just fine on all of the rows except when it gets to the last...

I am trying to merge cells from several rows similar cobbling together code from the response from Michal M to the post of Robert Dino on June 25, 2017. See link to post below: https://www.mrexcel.com/forum/excel-questions/1011345-how-merge-these-cells-quickly.html?highlight=Merge+Cells In...

Hi, I've created a userform to help data entry over multiple sheets. Which sheets are populated are chosen by ticking check boxes. The problem I have is my code copies the information to all sheets, regardless of whether the check box is ticked or not. How do I stop this happening? this is my...

Is it good practice to clear an object variable before using it? For example: Option Explicit Sub ClearingObjects() Dim ws As Worksheet Set ws = Worksheets("Sheet1") ws.Cells(1, 1).Value = 1 Set ws = Nothing Set ws = Worksheets("Sheet2")...

Hi All, I have a column that can contain two values each cell can contain one value at a time Eg. Apple Cherry Apple Cherry The whole column is filled with either values and nothing else. I used a macro of if statements to check the cell data is Apple OR Cherry if it contains something else...

OK so here is the VBA I am using. its supposed to delete the row with the work Multi_Skill if the row below it has a blank cell in column A and a specific text in column H. the dang thing isn't working. What have I done wrong? Sub fixBlankname() Sheets("Data").Activate For My_ROWS = 1 To...

Hello, I am trying to consolidate 4 worksheets into 1. The problem I am running into is that I am trying to add values to cells based on what is ported over from a specific sheet, when I try it the values I am adding just overwrite each other. Sub FN_Upload() Dim wksDst As Worksheet Dim...

Hello, I am writing a macro to build a template that will be uploaded into another program and I am having some problems with this one bit: For i = 1 To LR With FN_Upload Sheets(3).Range("A" & i + 1).Copy Destination:=FN_Upload.Range("D" & i + 1) .Range("A" & i + 1).Value =...

Hello I have this working code that calculates from row 2 to 1000 on column L and skips 4 columns to P then T and so on... skipping 4 columns at a time up to column 176 (PT) but I see it is taking too long to calculate Here is the code that works vertically now Sub CALC2_() Dim rng As...

Hi Team, Below is my vlookup. this code is for single worksheet it works. I want to run this code for sheets {1,2,4,6} only and in column B1. if vlook up result give exact match it should display the result :=> For match "Old trades", else "New trades". Colomn for vlookup is fix. (b:b). plz...

Hello, Is it possible to have macro copy one column and paste the value to the next empty column in the same sheet? Please note the existing "new draw" macro copies all values in the Total columns and paste values to Prior columns and clears contents of Current columns. This addition to the...

I'm trying to change the date in several different workbooks. Right now my code just references the cell that contains the new date, but I want it to hard code that date into the workbooks instead. How can I change this? Here's my current code. Dim Num As Double Num = 8 Dim FilePath As String...

Hello, This is my first post but I do frequent these forums often trying to figure out how to fix my VBA codes, but I am still struggling with my current issue. Here is what I am trying to do: I am comparing 2 worksheets to see if Product A is on Sheet B, and I have about 80,000 lines to go...

I'm new to VBA and writing a code that will go through a list of excel files and update the date to match the current excel file. I want to make it so that we don't have to write the full file path including what drive its on, just match it to the folder that the files are contained in so that...

Please advise why the variable 'lastrow' is storing a value of 0 when there are data up to row 100 in column A Sub usingFind() Dim ms As Worksheet Dim lastrow As Long, i As Long, c Dim myCell As Range Set ms = Sheets("mathew") lastrow = ms.Range("A" & Rows.Count).End(xlUp).Row x = 2 y = 3 c =...