activecell

  1. L

    Cannot jump to "ActiveCell' because it is hidden error

    I am really hoping that someone can help with me my problem. I am not excel savvy with macro, but I can record a macro and get it to do what I need to do. I keep getting this message when I run my macro, click debug and then right click on the yellow highlighted error. A pivot table has been...
  2. M

    Macro filter by contains activecell

    Hi Guys, macro novice struggling to adapt a macro in an excel doc I inherited. It filters one sheet based on the activecell in another. I'd like to change to filter by whether it CONTAINS the activecell, but when I put ** around activecell in the formula, it just looks for whether it contains...
  3. Z

    Help with Macro, want to chage to run on active cell instead of whole page

    Hi, I am still kind of new to using VBA code and my editing skills are very novice at the moment. How would I change this Code to run on only the active cell selected and that is all, instead of the whole page? Sub AddIFERROR() Application.ScreenUpdating = False...
  4. O

    Selecting multiple cells in an active row and copying to the next sheet

    Help! Im using Excel 2010 and want to create a macro that allows me to cut the cells A:S and U in the current active row and paste in the same locations on the next page, at the bottom of a growing list. I would like formulas to be copied also. Alternatively, cut and paste the entire row, but...
  5. F

    Problem with Range selection macro

    Hello, I am running the following piece of code in my macro. Sub SelectData1() Set mySelection = Range(ActiveCell, ActiveCell.End(xlDown)) mySelection.Select End Sub When I run the above code as a stand alone macro it always works as it should; ie. it selects all the data in the column...
  6. R

    Please help me with selecting the cell containing my search result in vba

    Hello, I'm pretty new at this, in fact I rely on recording various actions to get the code I need then piece them all together, but that's not helping me in this case. I'm looking for a way to search for a word in column E. Once it is found, moving it to column A on the same row, then...
  7. W

    Returning focus to last used cell in VBA function

    I've got a function as follows: Function VerificarInfinito(a As Double) Set c = ActiveCell ActiveSheet.ChartObjects("Planta").Activate If (a >= 3) Then ActiveChart.SeriesCollection(2).Format.Line.Transparency = 0 ActiveChart.SeriesCollection(13).Format.Line.Transparency = 0...
  8. K

    Store Userform textbox value

    I am new to using userforms and struggling.. so if anybody has a tip: I want the user to input a (week)number in a userform and then find this number in my worksheet. I can't seem to match the userform value with the sheet value. Code is as follows: Private Sub OK_Click()...
  9. S

    Value of first column in active row in ListObject

    I want the value of the first column in the active row in a ListObject. I've tried MsgBox ActiveCell.ListObject.ListRows(ActiveCell.Row).Range.Address, but don't know how to refer to the first column in this row. I've also tried MsgBox...
  10. D

    VBA how to manipulate multiple range selection

    Windows 7, xl2010 I am working on a day to day schedule worksheet for work but can not seem to pass this hurdle. Structure: This worksheet is meant to be a visual scheduler (like a Gaunt Chart). I have the employees on column A and the dates starting on column B and on. There are control...
  11. D

    Prompt for new Active Cell

    Is there a way for VBA to prompt the user for a new selection?. For exmaple, Sub BlankRow() The reason I need this is because I am already in a macro and can not change selection on screen and I don't want to exit routine to make new selection (last line of code). 'I need to be able to...
  12. J

    Hyperlink Question

    Say I have a value in a cell which is the hyperlink address, what VBA script would I need to run the hyperlink, based on whatever value is in the activecell at the time, either to a cell location or web address. I.e I run a macro and it creates and follows the hyperlink. cell value =...
  13. J

    VBA - Selecting multiple cells using ActiveCell.Offset?

    Hi. ActiveCell.Offset(0,2).Select would be used to move the active cell 2 cells to the right. Instead of moving it 2 cells to the right, how do I make it so that it highlights/selects the original active cell as well as the 2 cells to the right (so I will then have 3 cells selected). How do I...
  14. C

    String input into active cell

    Hey all, This should be a quickie compared to some of the problems you're all dealing with. I am trying to input a text string disguised as a formula into an active cell. I have code: Dim n As String, a As String, r As Integer, b As Inte n = "Test_STEEL 5in" a = "C" r = ActiveCell.Row b...
  15. S

    Populate a sheet based on selected cell

    Hi, I am trying to populate a spreadsheet based on what cell is selected in a different worksheet. Ie, I have a worksheet1 with all information (names in column A) and I want to select a name in column A (say cell A2) and have an additional worksheet2 generate with info from cells a2,b2, c2...
  16. MarkCBB

    VBA to Highligt row of Active Cell

    Hi there VBA Pros, I am need to some code to highligh (or BOLD, Incease size) of the active cell that is selected. I.e. when a user is busy looking at the database and they select cell G7, the whole row 7 is highlighted, making it easier for the user to see what data is related? Can this be...
  17. J

    Activecell.offset next visible row

    Hi, I use the following script for activecell offset activecell.offset(1,0).select Can someone please provide a script that will work for a filtered list, as at the moment when I use the script it is offsetting to invisble rows.
  18. T

    Find and Make Active

    Hi, i have found this code here which i am trying to adjust to my needs Sub finddate() Dim cl As Range Dim lastrow As Long lastrow = Worksheets("Filter_CSM").Range("A65536").End(xlUp).Row for each cl in Range("h2:H" & lastrow).Find(What:=DateValue(<>"")) If Not cl Is Nothing Then cl.Select...
  19. A

    Dynamic Cell Row and choose certain columns to Paste into a diff. ws or wb

    I am searching for data which I just entered via INPUTBOX. Searches for Data within Range(G7 and CA10000) If the data is found then it copies that cellrow and range of Columns H thru K and Column S and Columns AC thru BZ into a diff. Worksheet or Workbook (Haven't Decided). If this data...
  20. J

    if activecell not in range

    Hi, can someone please help. I am after a script that for instance, if the activecell is not within range A1:B500 then it will color the cell yellow. If the activecell is within the range then it will color the cell red. I do not want to use the worksheet selection change event as I want...

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