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 |
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 . |
All times are GMT +1. The time now is 10:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com