Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting with command
Dear all
Is it possible to write an if statement which is a "starting with command". For example if cell (r,1) begins "SAM" then range(A1:d1").select with selction Font.bold end slection I would want it to pick up a range of data for example SAM 1 SAM 2 But Not FAM 1 MAny thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting with command
Hi
try something like ..... dim r dim rng as range r=1 with activesheet if left(.cells(r,1).value,3)="SAM" then ..range("A1:D1").font.bold=True end if end with ..... -----Original Message----- Dear all Is it possible to write an if statement which is a "starting with command". For example if cell (r,1) begins "SAM" then range(A1:d1").select with selction Font.bold end slection I would want it to pick up a range of data for example SAM 1 SAM 2 But Not FAM 1 MAny thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Starting and Stopping excel from command line. | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
starting an external program with a command line | Excel Programming | |||
starting an external program with a command line | Excel Programming | |||
Starting a userform upon starting the file | Excel Programming |