| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select blank cell
Im a newbee in VBA, and I have a simple problem.
How can I select a blank cell in a given range and relpace it with a value from another cell. Any quick VBA programmers out there? --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select blank cell
Dim rng as Range
On Error Resume Next set rng = Range("A1:A10").specialCells(xlBlanks) On Error goto 0 if not rng is nothing then rng(1).Value = "rng(1).offset(-1,0) End if -- Regards, Tom Ogilvy "Hodar " wrote in message ... Im a newbee in VBA, and I have a simple problem. How can I select a blank cell in a given range and relpace it with a value from another cell. Any quick VBA programmers out there? --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select blank cell
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select blank cell
I am trying to do something very similar. Is it possible to modify th
coding here and allow every blank cell within a column to copy th value of the cell immediately before it. For instance, a blank in cel B10 copies B9, blank cell B37 copies B36, etc. Thanks for the help. Gi -- Message posted from http://www.ExcelForum.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select blank cell
Debra Dalgleish has some code (as well as manual instructions) at:
"gfinch <" wrote: I am trying to do something very similar. Is it possible to modify the coding here and allow every blank cell within a column to copy the value of the cell immediately before it. For instance, a blank in cell B10 copies B9, blank cell B37 copies B36, etc. Thanks for the help. Gib --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select blank cell
Debra Dalgleish has some code (as well as manual instructions) at:
http://www.contextures.com/xlDataEntry02.html "gfinch <" wrote: I am trying to do something very similar. Is it possible to modify the coding here and allow every blank cell within a column to copy the value of the cell immediately before it. For instance, a blank in cell B10 copies B9, blank cell B37 copies B36, etc. Thanks for the help. Gib --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select blank cell
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I select the first blank cell | Excel Worksheet Functions | |||
| Select until blank row | Excel Discussion (Misc queries) | |||
| Is there a formula to select the last non-blank cell in a list | Excel Discussion (Misc queries) | |||
| How do I select & use contents of first non-blank cell in row? | Excel Worksheet Functions | |||
| I want to select the first blank cell in column A | Excel Worksheet Functions | |||
Linear Mode
