activecell

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

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

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

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

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

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

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

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()...

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

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

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

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

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

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

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

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

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.

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

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

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