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

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top