1.value

  1. A

    problem on transferring data to another workbook

    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...
  2. H

    convert string with a decimal to a string with a exponential

    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...
  3. A

    N= activesheet.name

    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 =...
  4. C

    How to properly address an ActiveSheet (error 438)

    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...
  5. S

    Another Sorting Question

    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...
  6. rjplante

    Run-Time error 1004 issues

    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...
  7. D

    Merge Cells/Rows (Revisited)

    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...
  8. C

    Userform code

    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...
  9. T

    Clearing object variables

    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")...
  10. A

    Check cell for two sets of data

    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...
  11. C

    Stumped and looking for solution tonight,

    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...
  12. T

    Worksheet consolidation VBA

    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...
  13. T

    HELP: Inserting an HTML code as text into VBA

    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 =...
  14. R

    change from calculating vertically (each cell in Column) to horizontally (row)

    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...
  15. M

    For each vlook up help.........

    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...
  16. D

    VBA help: Copy column and paste values into empty column to the right

    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...
  17. M

    Copy/paste value from one workbook to another VBA

    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...
  18. T

    Replacing a long integer with text in VBA

    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...
  19. M

    VBA file path

    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...
  20. R

    lastrow value is nil

    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 =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top