activecell

  1. M

    Sum with Indirect

    Good morning! I would like to modify this formula in a macro so that it always looks at a specific column reference (column K) ActiveCell = "=SUM('Review Tab'!K:K)" I've changed it to this: ActiveCell = "=SUM(INDIRECT(" 'Review Tab'!K:K"))" However, VBA now thinks that everything after...
  2. D

    vba to copy one cell value to another cell value

    Hi, I have this value (95551092 - ) in the activecell and I would like to add whatever value is in cell A50. I do have the following code which adds the value but it deletes the spaces and then moves the hyphen in front of the numbers. Sub test() Dim d As Double d = ActiveCell.Value...
  3. B

    how to use offset range and or resize

    I have a sheet that represents a score card for a sporting event. Row 3 contains the dates of the game, row 4 contains the day of the week and row 5 contains a ‘points’ heading. The remaining rows contain the scores of the games and the team name For example. Row 3 contains 01/01/19...
  4. J

    Trying to Avoid Select, Selection, ActiveCell

    Hello: I'm trying to avoid using the Select method, so I'm trying ActiveCell. But I've heard I should try to avoid using ActiveCell as well. :confused: Any ideas on firming up this code? Here's what I have: Using Select Range(Selection.End(xlToRight), Selection.Offset(0, 7)).Select...
  5. I

    Select Rows With Value

    Hello to everyone I have this situation In Range(A1:A6) i put some values. My activecell is A7. I want to know which is vba code to select Cells from the top rows of activecell(including activecell) until i find a blank row. As result Range(A3:A7) will be selected. Thank's a lot <tbody>...
  6. P

    Difference between If, Then ActiveCell vs If, Or, Then ActiveCell

    Hello, Beginner at VBA here. Was wondering if someone could simply explain to me what the differnece is between: If ActiveCell = " " Then ActiveCell = 0 Else ActiveCell.Offset(1,0).Select V.S. If ActiveCell = '' Or ActiveCell = " " Then ActiveCell = 0 Else ActiveCell.Offset(1,0).Select...
  7. B

    copy activecell value to next cell to the right

    This code copies the value of combobox1 and puts it in the active cell when the command button is clicked. Private Sub CommandButton1_Click() Dim str As String str = ComboBox1.Value ActiveCell.Value = str End Sub If I have checkbox1 checked on the userform containing this code, I want the...
  8. T

    Duplicating the ActiveCell

    I want to duplicate the active cell to specific cells on a calendar and everything seems to be right but my code as is does absolutely nothing. I added in a msgbox just to make sure that it is picking up the value of the active cell and it is however it cant seem to print it in the other cells...
  9. CatLadee

    VBA Will Not Accept Vlookup Formula that Works in Sheet

    Any ideas why this formula won't work in VBA but will in the worksheet? The responses tab exists. How should it be updated? THANK YOU! ActiveCell = "=IF(VLOOKUP(E2,Responses!E:R,8,FALSE)=0,"",(VLOOKUP(E2,Responses!E:R,6,FALSE)))" Range("J2").Select
  10. R

    Sum in VBA not defined correctly

    Hi All I have tried the following code which does not complile and would be glad of some guidance. ActiveCell = Application.WorksheetFunction = Sum(Range("F" & N + 2, "F" & R)) Thanks Rob
  11. B

    Using Cells property to represent the active range

    I have the following VBA Code Snippet and I've trying to learn how to use the Cells object. How would I replace the Activecell object with the Cells object in the Do Loop? In this instance, the Active cell would be Cells(2,2). What confuses me is how to replace the activecell object with...
  12. C

    displaying activecell comments in the same userform textbox or Listbox, updated as the activecell changes...

    ...Is there any way to do this other than creating many separate Sheet locations to store unique comments? Each time the user returns or moves to ANY cell with pre-entered comments, the Userform listbox or textbox would reflect those Comments for that particular cell, displayed in a list ? The...
  13. O

    select non-adjacent cells using vba

    Hey, The following code from one of the recent posts perform the task of selecting the cells starting from column A up until actively selected column. These will select all cells in between. However I would like it to select column A and active column only, hence leaving the adjacent cells in...
  14. L

    ?ActiveCell

    Hi I copied the code below from a website and it works fine and I got an idea what it does. But I tried to understand what "ActiveCell" returns. So I did the following in the immediate window ?ActiveCell and I got the "Hi" which is the content of the cell A1 that is selected? if that is the...
  15. J

    Transfer Data to Specific Rows on another spreadsheet From User Form Inputs

    Hi, there, I'm still quite new in this and struggling with a macro for staff data input. I have an input box on the first page and I want to save the first few inputs on the first page and next few on second page, but to match the record for the same person. I hope I was clear. Can you give a...
  16. F

    Macro - return to original cell

    Hi all, Happy Holidays and thank you in advance for you help. I have a macro I use to identify a unique count for patient names. The goal of this macro is to apply a number to each unique name/dob combination. I have another macro I use to choose a randomized list of numbers within the range of...
  17. D

    Macro to group rows after end of data, down to row 858

    Hi Can anyone help with the following code, I am trying to get the macro to group the rows from the end of a list of data in column A (the end will be different each time the macro is ran), down to row 858, which will stay the same each time. What do I replace A135 with to make the macro...
  18. F

    Exporting data to a new xls workbook

    Hi, I am trying to export data from an xlsm to a new xls. But the problem is that it only copies the first row and I need a table to be copied. My macro is this one: Sub ExportarTXT() Worksheets("Import").Activate If Sheets("Import").Activate Then Range("A1").Select If...
  19. B

    Referencing to a cell

    Hi, I have the formula below. How do I reference selection.name to a cell. Thanks! Sub Shoot() Dim r As Range Window_Capture_VBA Selection.Name = ActiveCell ExportPicture ActiveCell End Sub
  20. A

    Range Selecting With Activecell

    Hi folks, Thank you for my previous problem. I have small problem for selecting total column form Active cell I writ blow Code but it working I get this error "Run time error '1004' My Code Range("ActiveCell", Range("ActiveCell" & Rows.Count)).End(xlDown).Copy Please help me

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top