chazzerman01
Board Regular
- Joined
- Nov 18, 2019
- Messages
- 65
is it possible for a macro to run if the active cell value is different to the value above it
Sure. A script can run when ever you activate it.is it possible for a macro to run if the active cell value is different to the value above it
Sub Resize_Me()
'Modified 1/8/2020 8:49:39 AM EST
Dim rng As Range
Dim ans As Long
ans = InputBox("How Many Rows")
Dim tbl As ListObject
Set tbl = ActiveSheet.ListObjects("Table1")
Set rng = Range("Table1[#All]").Resize(tbl.Range.Rows.Count + ans, tbl.Range.Columns.Count)
tbl.Resize rng
Range("Table1[#All]").Select
End Sub