Commonmark migration

Source Link

edited Jun 17, 2020 at 9:04

1

Excel VBA, _{48 47 46 22} 21 Bytes

Immediates Window Function

Anonymous VBE Immediates Windows Function that takes input of the expected type Variant\Integer and from cell [A1] outputs to the VBE immediates window

For I=1To[A1]:?I:Next

Old Subroutine Version

Code:

Sub F(N):For I=1To N:Cells(I, 1)=I:Next:End Sub

Usage:

Sub Test(): F 100: End Sub

Changes:

-24 Bytes for converting to Immediates Window Function

-1 Byte for condensing I=1 To to I=1To

-1 Byte thanks to Engineer Toast for Changing Cells(I,1) to Debug.?

-1 Byte for removing whitespace

##Output to ActiveSheet, ₃₀ 28 Bytes

Output to ActiveSheet, ₃₀ 28 Bytes

Anonymous VBE immediate window function that takes input from range [A1] and outputs to the range [1:1]

[A1].Resize([A1],1)="=Row()"

-2 Bytes for removing A1 from Row(A1)

Excel VBA, _{48 47 46 22} 21 Bytes

Immediates Window Function

Anonymous VBE Immediates Windows Function that takes input of the expected type Variant\Integer and from cell [A1] outputs to the VBE immediates window

For I=1To[A1]:?I:Next

Old Subroutine Version

Code:

Sub F(N):For I=1To N:Cells(I, 1)=I:Next:End Sub

Usage:

Sub Test(): F 100: End Sub

Changes:

-24 Bytes for converting to Immediates Window Function

-1 Byte for condensing I=1 To to I=1To

-1 Byte thanks to Engineer Toast for Changing Cells(I,1) to Debug.?

-1 Byte for removing whitespace

##Output to ActiveSheet, ₃₀ 28 Bytes

Anonymous VBE immediate window function that takes input from range [A1] and outputs to the range [1:1]

[A1].Resize([A1],1)="=Row()"

-2 Bytes for removing A1 from Row(A1)

Excel VBA, _{48 47 46 22} 21 Bytes

Immediates Window Function

Anonymous VBE Immediates Windows Function that takes input of the expected type Variant\Integer and from cell [A1] outputs to the VBE immediates window

For I=1To[A1]:?I:Next

Old Subroutine Version

Code:

Sub F(N):For I=1To N:Cells(I, 1)=I:Next:End Sub

Usage:

Sub Test(): F 100: End Sub

Changes:

-24 Bytes for converting to Immediates Window Function

-1 Byte for condensing I=1 To to I=1To

-1 Byte thanks to Engineer Toast for Changing Cells(I,1) to Debug.?

-1 Byte for removing whitespace

Output to ActiveSheet, ₃₀ 28 Bytes

Anonymous VBE immediate window function that takes input from range [A1] and outputs to the range [1:1]

[A1].Resize([A1],1)="=Row()"

-2 Bytes for removing A1 from Row(A1)

added 64 characters in body

Source Link

edited Sep 4, 2017 at 17:44

Taylor Raine

8.7k
2
27
51

Excel VBA, _{48 47 46 22} 21 Bytes

Immediates Window Function

Anonymous VBE Immediates Windows Function that takes input of the expected type Variant\Integer and from cell [A1] outputs to the VBE immediates window

For I=1To[A1]:?I:Next

Old Subroutine Version

Code:

Sub F(N):For I=1To N:Cells(I, 1)=I:Next:End Sub

Usage:

Sub Test(): F 100: End Sub

Changes:

-24 Bytes for converting to Immediates Window Function

-1 Byte for condensing I=1 To to I=1To

-1 Byte thanks to Engineer Toast for Changing Cells(I,1) to Debug.?

-1 Byte for removing whitespace

##Output to ActiveSheet, 30₃₀ 28 Bytes

Anonymous VBE immediate window function that takes input from range [A1] and outputs to the range [1:1]

[A1].Resize([A1],1)="=Row(A1)"

-2 Bytes for removing A1 from Row(A1)

Excel VBA, _{48 47 46 22} 21 Bytes

Immediates Window Function

Anonymous VBE Immediates Windows Function that takes input of the expected type Variant\Integer and from cell [A1] outputs to the VBE immediates window

For I=1To[A1]:?I:Next

Old Subroutine Version

Code:

Sub F(N):For I=1To N:Cells(I, 1)=I:Next:End Sub

Usage:

Sub Test(): F 100: End Sub

Changes:

-24 Bytes for converting to Immediates Window Function

-1 Byte for condensing I=1 To to I=1To

-1 Byte thanks to Engineer Toast for Changing Cells(I,1) to Debug.?

-1 Byte for removing whitespace

##Output to ActiveSheet, 30 Bytes

Anonymous VBE immediate window function that takes input from range [A1] and outputs to the range [1:1]

[A1].Resize([A1],1)="=Row(A1)"

Excel VBA, _{48 47 46 22} 21 Bytes

Immediates Window Function

Anonymous VBE Immediates Windows Function that takes input of the expected type Variant\Integer and from cell [A1] outputs to the VBE immediates window

For I=1To[A1]:?I:Next

Old Subroutine Version

Code:

Sub F(N):For I=1To N:Cells(I, 1)=I:Next:End Sub

Usage:

Sub Test(): F 100: End Sub

Changes:

-24 Bytes for converting to Immediates Window Function

-1 Byte for condensing I=1 To to I=1To

-1 Byte thanks to Engineer Toast for Changing Cells(I,1) to Debug.?

-1 Byte for removing whitespace

##Output to ActiveSheet, ₃₀ 28 Bytes

Anonymous VBE immediate window function that takes input from range [A1] and outputs to the range [1:1]

[A1].Resize([A1],1)="=Row()"

-2 Bytes for removing A1 from Row(A1)

added 192 characters in body

Source Link

edited Aug 6, 2017 at 18:20

Taylor Raine

8.7k
2
27
51

Excel VBA, _{48 47 46 22} 21 Bytes

Immediates Window Function

Anonymous VBE Immediates Windows Function that takes input of the expected type Variant\Integer and from cell [A1] outputs to the VBE immediates window

For I=1To[A1]:?I:Next

Old Subroutine Version

Code:

Sub F(N):For I=1To N:Cells(I, 1)=I:Next:End Sub

Usage:

Sub Test(): F 100: End Sub

Changes:

-24 Bytes for converting to Immediates Window Function

-1 Byte for condensing I=1 To to I=1To

-1 Byte thanks to Engineer Toast for Changing Cells(I,1) to Debug.?

-1 Byte for removing whitespace

##Output to ActiveSheet, 30 Bytes

Anonymous VBE immediate window function that takes input from range [A1] and outputs to the range [1:1]

[A1].Resize([A1],1)="=Row(A1)"

Excel VBA, _{48 47 46 22} 21 Bytes

Immediates Window Function

Anonymous VBE Immediates Windows Function that takes input of the expected type Variant\Integer and from cell [A1] outputs to the VBE immediates window

For I=1To[A1]:?I:Next

Old Subroutine Version

Code:

Sub F(N):For I=1To N:Cells(I, 1)=I:Next:End Sub

Usage:

Sub Test(): F 100: End Sub

Changes:

-24 Bytes for converting to Immediates Window Function

-1 Byte for condensing I=1 To to I=1To

-1 Byte thanks to Engineer Toast for Changing Cells(I,1) to Debug.?

-1 Byte for removing whitespace

Excel VBA, _{48 47 46 22} 21 Bytes

Immediates Window Function

Anonymous VBE Immediates Windows Function that takes input of the expected type Variant\Integer and from cell [A1] outputs to the VBE immediates window

For I=1To[A1]:?I:Next

Old Subroutine Version

Code:

Sub F(N):For I=1To N:Cells(I, 1)=I:Next:End Sub

Usage:

Sub Test(): F 100: End Sub

Changes:

-24 Bytes for converting to Immediates Window Function

-1 Byte for condensing I=1 To to I=1To

-1 Byte thanks to Engineer Toast for Changing Cells(I,1) to Debug.?

-1 Byte for removing whitespace

##Output to ActiveSheet, 30 Bytes

Anonymous VBE immediate window function that takes input from range [A1] and outputs to the range [1:1]

[A1].Resize([A1],1)="=Row(A1)"

added 58 characters in body

Source Link

edited Aug 6, 2017 at 14:41

Taylor Raine

8.7k
2
27
51

Loading

Converted to VBE Immediates Window Function

Source Link

edited Mar 30, 2017 at 2:56

Taylor Raine

8.7k
2
27
51

Loading

added 34 characters in body

Source Link

edited Mar 28, 2017 at 3:36

Taylor Raine

8.7k
2
27
51

Loading

Removed whitespace for -1 Bytes

Source Link

edited Mar 25, 2017 at 19:49

Taylor Raine

8.7k
2
27
51

Loading

Source Link

created Nov 10, 2016 at 12:24

Taylor Raine

8.7k
2
27
51

Loading

Stack Exchange Network

Return to Answer

Excel VBA, _{48 47 46 22} 21 Bytes

Output to ActiveSheet, ₃₀ 28 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Output to ActiveSheet, ₃₀ 28 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Return to Answer

Excel VBA, 48 47 46 22 21 Bytes

Output to ActiveSheet, 30 28 Bytes

Excel VBA, 48 47 46 22 21 Bytes

Excel VBA, 48 47 46 22 21 Bytes

Output to ActiveSheet, 30 28 Bytes

Excel VBA, 48 47 46 22 21 Bytes

Excel VBA, 48 47 46 22 21 Bytes

Excel VBA, 48 47 46 22 21 Bytes

Excel VBA, 48 47 46 22 21 Bytes

Excel VBA, 48 47 46 22 21 Bytes

Excel VBA, 48 47 46 22 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Output to ActiveSheet, ₃₀ 28 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Output to ActiveSheet, ₃₀ 28 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes

Excel VBA, _{48 47 46 22} 21 Bytes