Whole Row Of Active Cell Should Be Bold
The text of the active cell's row should be displayed BOLD. In other words, My cursor is on row 8, then this whole row should be bold. Is this possible ?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Merging Cols Changes Bold To Non-bold Or Non-bold To Bold
I am merging columns. Col B has all text in bold. Col C has all text in regular font. When I use ASAP to merge, the merged column comes out all bold. When I use a formula to merge the merged column comes out all regular. What I want is for the merged column to contain the bold text from Col B in bold, and the regular text from Col C in regular. What I want is... This is for service plan B: Take all data and transer to new server. What I am getting is... This is for service plan B:Take all data and transer to new server. OR This is for service plan B:Take all data and transer to new server.
View Replies!
View Related
Insert Row On Sheet & Move Active Cell Row To It
I would like to create a macro that could archive entries from one sheet and insert them in another. I created one but the problem is that the entry has to be the same row each time. Example: Sheet 1 – is current jobs and sheet 2 is old jobs. My macro moves an entry from Row A-5 of Sheet 1 and moves it to the top of Sheet 2. I would like to be able to scroll through each entry select it and have it moved to the top of the Old Jobs sheet.
View Replies!
View Related
Highlighting Active Cell's Row, Along With Any Row That Shares Same Value In That Column
Is it possible to click on a cell in column C, and have the wishlist below happen: That active cell's row is hightlighted. Any cell in that column that has the same value as active cell is also highlighted. Plus, any cell in another sheet that has that value it's row is highlighted too. Example: I click on C5 in Sheet 2 its value is 45000789 it row is highlighted, this value also appears in C3 in the same sheet, so it's row is highlighted as well. Plus, in sheet 1 in C10 this value appears and it's row is highlighted as well. When any of the values are clicked again the highlight is removed from all parties.
View Replies!
View Related
Insert Row At Active Cell With Formula From Fixed Row
I want to insert a new row that contains the formulas of a fixed row (1:1). The inserted row is changeable and is determined by whichever is the current active cell. Eg: Active cell is something random like E16 I want to add a new row but don't want a blank row - rather want a row that contains the properties of 1:1
View Replies!
View Related
Use Value Of Active Cell To Name Row
I'm trying to take the value of a cell and use the value as a name for the row. If cell a1 has value = June. I want to change the name of row 1 to June. I'm not sure what I'm doing wrong with the following code. Sub Name_a_row() ' ' Dim TheName As String Dim RowNum As Integer TheName = ActiveCell.Value RowNum = ActiveCell.Row ActiveWorkbook.Names.Add Name:="TheName", RefersToR1C1:="=Data!R&RowNum"
View Replies!
View Related
Use Active Cell For Row Number
There is a chart encompasing column A, B and C. The column D has certain numbers stored in its cells. All I wont is to build a code which would check the value of the cell in column D which is in the same row as the active cell, and then paste certain date into the active cell - basing on the value of the cell in column D. Here an example: Sub pasteif() first one) column D has 'if the value is i.e 2 then it should paste into the active cell whatever there is in Range F1:G1 'if other value is present in this case in cell D1 (it is always the D column) then other range would copied into the active cell Range("F1:G1").Copy ActiveCell.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub
View Replies!
View Related
Highlight Row Of Active Cell
Is it possible to have a specified shading (say 50%) applied to all rows except the currently picked row and the header rows to allow a user to focus on inputting across the row? I'd use this in conjunction with " Move Selection After Enter" to "Right" so the user would stay on the same row. I've tried the Help function, but can't find anything.
View Replies!
View Related
Delete Row Of Active Cell
I have a macro for deleting a row. I want iit to delete the row that I have selected, that is i if I mark cell B22 I want it to delete row 22. But it deletes the row under it, that is 23. Sub Tabortrad() Dim intRadnr As Integer Dim intStartrad As Integer Dim intSlutrad As Integer intRadnr = ActiveCell.Row intStartrad = ActiveSheet.Range("Första").Row + 1 intSlutrad = ActiveSheet.Range("Sista").Row - 2 If intRadnr < intStartrad Or intRadnr >= intSlutrad Then MsgBox "Kan inte radera denna rad. Placera markören på en av bokföringsraderna mellan rad " & intStartrad & " och rad " & intSlutrad - 1 & "." & Chr(13) & "En ny rad kommer att infogas under den rad där markören står.", vbOKOnly, "Felaktig rad markerad".......................
View Replies!
View Related
Range In Same Row As Active Cell
I'm looking for a piece of code, which would activate a certain Range i.e. the start of which would be in column A and the End in Column G. My problem is that the activated range of cells shuld be exactly in the same row as the currently active cell i.e. active cell B3 -> activated range A3:G3 .
View Replies!
View Related
Return Active Cell's Location/row
I'm having trouble identifing a way to return a location for the position of the active cell. I've searched Excel help with "Position, location, return, activecell, etc." and I can't seem to figure this out. I know that it's possible, so that's why I'm on here! ... Ok, say the active cell is currently "F1", and I need the location "F1" to identify the ROW to be used in a formula later, how would I go about that? The current contents of cell "F1"' will be "REPLACE", but I need to change the words "REPLACE" in "F1" and other cells labeled "REPLACE" in column F to the following formula (where the "1" in "A1" is is the current row):
View Replies!
View Related
Merge Range Based On Active Cell Row
I am working on a macros that creates a new row for every data entry. Below is the macros that I have. In the new row, I want for the cells in columns F through O to merge right after creating the row. How do I go about this? If Sigma = 0 Then Selection.EntireRow.Insert ' New row for new entries ActiveCell.Value = "NONE" ActiveCell.Offset(1, 0).Select End If
View Replies!
View Related
Set Variable To Row & Active Cell Column
I have a sort procedure I have been working on. Sort By Active Cell Column Now I would like to make sure the row of the activecell.column is row 7. I tried Private Sub comp_myMonthlyReport_SortAscend() Dim rng As Range With ActiveWindow rng = .ActiveCell(7, .ActiveCell.Column) End With Selection.Sort Key1:=rng, _ Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub But I receive this error: Run-time error '91': Object variable or With block variable not set
View Replies!
View Related
Pick Data From A Specific Row/column (eg 10/B) Related To Active Cell
I have a spreadsheet with my Periods along row 10. e.g. C10: "1", D10: "2", E10 "3", F10: "4", G10: "5" etc. (green on the attached sheet). I have my departments along column B, e.g. B11: "Baked" B12: "Fresh" B13: "Frozen" (yellow on the attached sheet) what I need and cannot work out is some VBA code that will populate two variables (lets call them Period & Department) when I click on one of the figures. For example if I click on cell: if I click E14: Period would have the contents of cell E10, and Department the contents of cell B14. if i click G14: Period would have the contents of G10, and Department the contents of cell B14 again. I know how to get the click on the cell to work properly etc, and I have code to slot these variables into that works very nicely, I just can't get this bit to work!!!!
View Replies!
View Related
Find A String And Bold The Row
I am using ctrl+f to find a string that may or may not be in a worksheet. If it is found, i need to bold the row. If it is not found, i need to go on to the next instruction in the macro. I just don't know quite how to combine the If/Then with Find.
View Replies!
View Related
VBA Code To Bold Row Which Contains SUM
I'm new to VBA and needed help with: I need to 'bold' the row which contains sum, the problem is that the location of the row varies depending on how long/short the report is.... Here is the code I used to bold a particular row: Range("A14").EntireRow.Font.Bold = True But instead of A14, i need it to be a row of no more than 5 columns, one of which contains the word 'SUM'.
View Replies!
View Related
ACtiveCell.row: Active Row Is Empty
I am trying to write a statement that sees if the the row below the active row is empty. I have written the following but it is wrong. Please can someone correct it for me? Thanks! If IsEmpty(ActiveCell.Row.Offset(1, 0)) = False Then MsgBox "Not Empty" End If
View Replies!
View Related
Determine If A Cell Is Bold Or Not
I'm trying to create a VBA module that will update data. However, I need it to skip any updates to data that has been set by the user. For simplicity, the user changes will be bold. I've found the info on the site for a function for counting cells in a range that are bold. But really just need to know how to get format of the cell.
View Replies!
View Related
Copy Values If Cell Is Bold
I'm looking for VBA function in excel that will look up for bold cells in K column and copy values at the and of worksheet. Lets say that cells K23, K56, K123 is bold. Macro will copy that cells to the end of worksheet with formula: =+K23 =+K56 =+K123
View Replies!
View Related
Format Particular Value Of Each Cell In To Bold And Colored
I have a question regarding the formatting of cell values. Is it possible to format particular value of each cell in to Bold and Colored? For example in the below example for cells A1 to A5 contains some values. I want the value BBBBB to be bold and with red color font. Title AAAAA BBBBB CCCCC DDDDD BBBBB EEEEE BBBBB GGGGG HHHHH LLLLL AAAAA BBBBB
View Replies!
View Related
Formula Only For Bold Text Cell
i have a worksheet which has a price list for parts, about 2500 rows. in the Column C i have a retail price and in Column D have -5% of the C. i need to add Column E -10% of CERTAIN items, the ones in BOLD Only, of Column D. and change the color of that cell, is there a easy way to do this. i have attached screen shot what i mean.
View Replies!
View Related
To Bold A Part Of The Cell Text
I am creating a sheet with the cell information coming from different cells. I want to bold and/or underline a part of the cell to add clarity. For e.g. Cell A1 = "Trans X" (Name of the transaction); Cell B1 = "System Y" (System where the transaction exists) Cell C1 = "Type Z" (Type of transaction) I want to create a cell which has Newsheet.Cell (x,y) = "Name: Trans X System: System Y Type: Type Z" I created the String by reading and concatenating the values, but I am not sure how to add the formatting to a part of the string.
View Replies!
View Related
Cell Bold And Font Size 12 And Highlight In Red
I am using this formula (Below) and it is working great. Only problem is that I want the client name to be be bold and font size 12, then I want it to highlight in Red. I also want the rows in colunm L to highlight in bright green. Sub InputData() Dim varUserInput As Variant Dim LastRow As Integer LastRow = Cells(Rows.Count, "G").End(xlUp).Row + 1 varUserInput = InputBox("Enter client name:", _ "Client Name", "") If varUserInput = "" Then Exit Sub Range("G" & LastRow).Value = varUserInput Range("G" & LastRow + 20).Value = "Total".......................
View Replies!
View Related
Highlight The Active Row
if you click on a row, it highlights every cell in it, I want to do the exact same thing but then also when you click on a cell only. Preferable (probably impossible though) without the use of VBA, because in my company I think some are "carefull" with enabling macro
View Replies!
View Related
Use Active Row In A Formula
I am wanting to use the row number of the current active cell in another formula on a spreadsheet. I have only been able to find info in putting the active row number in a dialog box. Is there a method of returning the active row number and using in a number of formulas.
View Replies!
View Related
Highlight Active Row
I spend a lot of time in spread sheets working with part numbers and sales figures. With a part # in column B and sales per month in adjacent columns, stretching back years. Is there any way to highlight an entire row automatically? ie. I use Ctrl F to search for a number and it goes to B24. I now want the entire row 24 highlighted as the active row. When I move to another cell I want the entire row highlighted automatically. Can it be done.
View Replies!
View Related
Reference To Active Row
I want to arrange a dataset in blocks of 8 lines and for this I need to refer to the actual row of the active cell. Below code does not work - the "Row" does not change as the active cell moves down through the rows
View Replies!
View Related
To Highlight Active Row And Column
I found this code to highlight the active row. I tried to make it highlight the row and column, but I was not successful. What I really need is to highlight the active row and column above and to the left of the active cell, not the entire row and column. For example, if G10 is active, the highlighted cells would be G1:G10 and A10:G10. Private Sub Worksheet_SelectionChange(ByVal Target As Excel. Range) Dim i As Long Cells.Interior.ColorIndex = xlColorIndexNone If Application. CountA(Target.EntireRow) 0 Then i = Target.Row Else For i = Me.UsedRange.Rows.Count To 1 Step -1 If Application.CountA(Me.Rows(i)) 0 Then i = i + 1 Exit For End If Next i End If Rows(i).Interior.ColorIndex = 6 End Sub Also, I have fill colors on the sheet and I just noticed that the code removes those fill colors. I need it to not remove my fill colors. The only fill colors it should remove are ones it previously colored.
View Replies!
View Related
Identifying The Active Row Number
I'm using a cells.find command to locate a value in a file. How do I return the current row number that I'm on following the command? I'm guessing it is something along the lines of: MyCurrentRow = ActiveCell.RowNumber but I know that that is an invalid statement.
View Replies!
View Related
Find Last Row In Non-active Workbook
I have a number of files which I am opening, manipulating and copying the result to a master workbook I am attempting to use code like this Selection.EntireRegion.Copy Destination:= Workbooks(Master). Range("A" & LastRow) Is it posible to define the value of LastRow without making Master the active workbook?
View Replies!
View Related
Change Color Of Active Row
I found Change Color Of Row When Cell Is Selected ("search" is my friend). StephenR's example is just the sort of thing I want, except I'd like it to ignore Cells that already have an Interior colour, or revert the Cells to their original Interior colour when you move on. The other issue I see would be how could you change/edit a Cells fill properties, without this routine changing it back to white when you move on?
View Replies!
View Related
|
TRACKER
