| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a cell value to be uses within a macro
I am using Excel 2007.
I have macro designed to hide rows which reads:- Range("A2").Select Rows("2:1311").Select Selection.EntireRow.Hidden = True Range("A2"). Select This, as expected, hides row 2 to 1311. I want to replace 1311 with a variable value read from a cell, Z1. How do I get that cell value to be read in the macro. I have tried:- Range("A2").Select Rows("2:=CELL("CONTENTS",Z1") Range("A2").Select but this does not work. I obviously have a syntax problem, can anyone help please. -- Mac Macdonald |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste A Cell Formula Into A Cell With A Macro. | Excel Worksheet Functions | |||
| macro to move part of cell contents to another cell | Excel Discussion (Misc queries) | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| Macro for cell selection starting with Last Cell | Excel Worksheet Functions | |||
Threaded Mode
