-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
selection.cells
-
P
Conditional Formatting - (Range)
Hi Have a conditional formatting code <Code> Sub FormatTotalRow() 'Worksheets(1).Range("K1:K500").Select 'For Each c In Selection.Cells 'If c.Value = "CHECK" Then c.Resize(1).Interior.ColorIndex = 50 'Next c Worksheets(1).Range("K1:K500").Select For Each c In Selection.Cells If c.Value >= 350...- parttime_guy
- Thread
- c.value columns conditional formatting selection.cells
- Replies: 1
- Forum: Excel Questions
-
M
Hyperlink Function in VBA which works with FollowHyperlink --> "https://www.google.hu/search?q=" & "apple"
Hi! I have a button with an assigned macro to it, which follows every hyperlink in the selected cells. But I can't create a customized URL in VBA (using a new FUNCTION), because it shows an error message every time I try to follow the new url using the macro. However, if I type the same URL...- makiwara
- Thread
- dim hyperlink range selection.cells url
- Replies: 1
- Forum: Excel Questions
-
R
Counting the number of blanks removed by trim
Hi Forum Hope all is well, would like a bit of help with a macro that trims spaces from cells. I found this snippet and works great, however I would like to count the number of blanks the macro removes. Sub NoSpaces() Dim c As Range For Each c In Selection.Cells c = Trim(c) Next End Sub...- rob737
- Thread
- blanks macro number range selection.cells
- Replies: 4
- Forum: Excel Questions
