how to string together 3 macros with a relative cell...

[sadams1]

This is another "should be simple!" things but I'm missing something. After combining through threads here & elsewhere, I'm unable to figure how to do the following...

1) there are 3 existing macros I'd like to combine into one macro
2) this new macro would be able to be run in any cell specifically in a column but any row, i.e it would run in C3 that same as C1000

Sounded straightforward for my beginner/intermediate coding skills to hack through.
- I started with the most obvious, "record new macro" but RELATIVE cell references selected. NOPE.
- I have several other macros that can run code in any cell but what I want to do isn't working with any of it
- the stuff here & elsewhere for some reason hasn't turned up anything that I can get to work

My guess is that like usual, someone is going say, "here's 2 lines to do this!" & I'll hang my head in shame yet again.

 

[StephenCrump]

No no, there's no shame in learning how to code. ( I found the VBA syntax frustrating at first, and I'd coded before in other languages).

The macro recorder has limitations. It's a good place to start if you want to see the syntax for what you're trying to automate, but the code it produces usually needs a lot of tidying up to be efficient and succinct.

Perhaps you could start by telling us the three things you're trying to do? And, if it would help our understanding, attach the code you're currently using (even if's not quite working to your requirements).

 

[sadams1]

hello & appreciate the reply! The code does the following:

1) from Mark858

"floating" named range...is it possible to name a range or make a macro to select more than one cell anywhere?

hello & thank you for taking time to see if this insane question is even worth asking... I'd like to select 3 contiguous cells in a row (i.e A1:A3). Could use named ranges if it was static but rather would like to land in a cell that isn't A1, like C1 & be able to run a macro or name a...

www.mrexcel.com

***this formats a range based on another range

2) for Jolivanes

how to expand "selection" to a range instead of "active cell" to show comment/note...

hello & I hang my head in shame that I can't figure this out. Have the follow code... ********************************************* Sub cmtShow() With Selection .Comment.Visible = True .Comment.Shape.Select True End With Application.CutCopyMode = False End Sub...

www.mrexcel.com

***hide all cells in a range

3) show all cells in a row
same as #2 (changing "true" to false)


Again, this looks straightforward & I'd like to group these into one macro by referencing those 3...it's the "relative" part that gets me

 

[StephenCrump]

Based on the two threads you refer to, I am guessing (it's far from clear what you're asking):

Sub Test()
    
    Dim rng1 As Range, rng2 As Range, r As Range
    
    Set rng1 = Range("SomeOtherRange")
    
    On Error Resume Next
    Set rng2 = ActiveCell.Resize(rng1.Rows.Count, rng1.Columns.Count).SpecialCells(xlCellTypeComments)
    On Error GoTo 0
    
    If Not rng2 Is Nothing Then
        For Each r In rng2
            r.Comment.Visible = True
        Next r
    End If
    
End Sub

Given a particular ActiveCell, this makes visible any Notes in the cells in the immediate vicinity of the ActiveCell right and down (based on the size of "SomeOtherRange").

(I assume you're talking about Notes - formerly referred to as Comments - rather than the newer style threaded comments?)

Sorry, I have no idea how any of the comments below relate to the question, or the other threads:

***this formats a range based on another range

***hide all cells in a range

3) show all cells in a row
same as #2 (changing "true" to false)

it's the "relative" part that gets me

 

[sadams1]

looks good! Greatly appreciated & apologies for not being clear...sometimes this forum makes it a challenge to explain some stuff & obviously this was not a shining moment for me. Regardless I've already worked in the code & it's going to be very useful to the team!