Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Select Using Range
How do I select multiple cells of a particular column using macros and Range.
I dont want to use ctrl key and select as I have many cells of one particular column to be selected(something like 1000) I wanted to copy a formula into these selected cells, once i select the required cells Thanks Vijaya |
#2
|
|||
|
|||
Select Using Range
here's an idea I use in a checkbook
Sub balance() [Set frng = Range("h8:h" & Range("a65536").End(xlUp).Row) With frng .Formula = "=h7+d8" ' .Formula = .Value 'uncomment to leave ONLY the value End With End Sub -- Don Guillett SalesAid Software "vijaya" wrote in message ... How do I select multiple cells of a particular column using macros and Range. I dont want to use ctrl key and select as I have many cells of one particular column to be selected(something like 1000) I wanted to copy a formula into these selected cells, once i select the required cells Thanks Vijaya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Select updated data from a range of columns | Excel Worksheet Functions | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
select a range using "cells()" | Excel Worksheet Functions | |||
How do I select a range if one cells contents is equal to another | Excel Discussion (Misc queries) |