G
gordom
Hi everyone.
I’m sorry but I’m totally illiterate in VBA and have very little
experience in macro (hours only . I recorded a macro containing the
following code:
Sub Macro4()
ActiveSheet.PageSetup.PrintArea = "$A$1:$E$34"
End Sub
What I would like to accomplish is to change "$E$34" into a regular
Excel function:
="$E$" & (MATCH ("abc";A1:A40))
(the function looks for "abc" text in A column and returns the address
of the cell in E column in the same row)
Could someone tell me how it can be done? I was looking in Google for a
while but without success. Thanks in advance,
gordom
I’m sorry but I’m totally illiterate in VBA and have very little
experience in macro (hours only . I recorded a macro containing the
following code:
Sub Macro4()
ActiveSheet.PageSetup.PrintArea = "$A$1:$E$34"
End Sub
What I would like to accomplish is to change "$E$34" into a regular
Excel function:
="$E$" & (MATCH ("abc";A1:A40))
(the function looks for "abc" text in A column and returns the address
of the cell in E column in the same row)
Could someone tell me how it can be done? I was looking in Google for a
while but without success. Thanks in advance,
gordom