active cell

Hi All, I need to adjust this bit of code (shown below) to select columns G, AO, and AR not just for the title column (row 7) and a single selected cell's row, but for multiple selected rows. With ActiveCell Union(Cells(.Row, "G"), Cells(.Row, "AO"), Cells(.Row, "AR"), Cells(7, "G"), Cells(7...

This is my current Autofilter VBA for activecell.value: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ActiveSheet.Range("$A$2:$X$10000").AutoFilter Field:=1, Criteria1:=ActiveCell.Value End Sub What I'd like to do is be able to select a range of...

I need some urgent help. I need a macro which would filter items within a column based on the entry that is on the active cell (as in the cell which is active). I came up with the following using the Record - but right now it is looking up the specific name "Adam Hill" - - I would like it to...

Guyz please, I need help in tweaking this code Sub Find_CIB() Dim rngRow As Range, rng2Cut As Range Dim what As String what = "CIB-OA" & "Scrubing Account" Do Set rng = ActiveSheet.UsedRange.Find(what) If rng Is Nothing Then Exit Do Else...

I am trying to create a scoring sheet for a game we play at work. There are 4x different types of ways they get points and the only way I know to do this currently is to create 4x buttons for every row that add points to the appropriate column. If I can just get the base code I can make it work...

Hi all, I have a workbook with cells in several background colours. Users have to fill in values in non-protected cells. However to find the cell in the that needs to be filled in it would be very helpfull if it was clearly visible prefferable instead of the thin black surrounding box in a...

Hi all, hoping someone can help me with this problem please. I'll start by saying that I am not familiar with VBA and have mostly cobbled this code together by reading various posts on this forum so apologies if the code is total rubbish! I have added a Date Picker Control to my sheet and...

Posting expenses in two ranges: V5:Y54 and AB5:AB53. For range V5:Y54 - when a value is entered in cell Y5 (the last cell in the row), I need the cursor/active cell to move to V6 (the start of the next row down in the range). Likewise, when a value is entered in Y6 I need the cursor to move...

I previously had my worksheet set up with 80 Radio Buttons. My Radio Buttons are in the same cell as the target data. I knew using 'Offset' in the macro to copy and paste the data (my data is dynamic) in the cell would be better, but I couldn't figure out how to do that so I used a specific cell...

I need a macro that when a button is clicked, after selecting an active cell in A:, the current date will be put into the same row, column AM.This date will be a time stamp so it shouldn't change when the file is opened the following day.

I have a workbook with Multiple worksheets The names are:</SPAN> 10</SPAN> 20</SPAN> Main </SPAN> In 10,20 Is a Column (Column C) which contains Codes. For example</SPAN> RT102422</SPAN> RT104646</SPAN> RT105678 </SPAN> In Main I have a column Called Spent. This is a drop down of the above...

Hello, I am trying to dynamically set the value of the linked cell for a Scroll Bar. I dont mind if the scroll bar is form type or active x type. Basically I have a column with figures in each cell moving down: 15 19 23 56 I have a scroll bar I want the scroll bar to change the value in the...

Sorry new to VBA. I built a UserForm that filters coloumn's A, B, and C down to a single row based on the combobox selection(s). I want to pull the active cell value from Column D, E, and F (excluding the "header" or row 1) to a Text Box's in the User form. What is the best code that will ignore...

Hi, I am new so forgive any mistakes. I have a table from column B to column M and row 8 to row 47. What I would like is to highlight the row in that range if i selected a cell in that row. So for example if I select M8, then cells B8:M8 would be highlighted, but if I was to select N8 or A1...

Hi, I've made a code to copy data from a loader table and move it to the data, but it keeps on coming up with the same error. Was wondering if anybody could fix the error because I have tried but can't see, to fix it. The bug occurs at the text in red. But if there are any other bugs would be...

Hello I'm trying to Copy a Range based off an Active cell. I want to copy the Active Cell and 1 cell to the right of it and paste it into another area...any ideas?? thanks!

hi, I have simply formula in loop: Set WS = WB.Sheets("Sheet2") Dim b as String For j=1 to 6 b = ActiveCell.Formula = "=MID(Right(WS.Cells(j, 2),9),1,6)" next j and my result is always false. Do you know why?

Can you let me know how to change the font color of a individual active cell by using the ctrl key? I used this command before but I believe that it was built into a macro. Thanks.

Hello--I am new to this board and a bit new to Excel VBA. I am trying to write a script that will do the following--when run, test if the active cell in the current sheet (sheet1) is equal to the active cell in a second sheet (I have named it creatively--sheet2). If yes, then I want it to...

Hi There, I am running a macro that is causing my active cell indicator to disappear. In term of clicking around, I can still select cells, highlight cells and type formula's into cells. However, the black border that surrounds an active cell doesn't work. My file is completely macro driven and...