Marking cells in Excel

From: FTL (frankgtl_at_online.no)
Date: 05/24/04 

Date: Mon, 24 May 2004 15:47:05 +0200

Hi
In Excel, I am trying to "mark" some cells in the row that is active.
I have written this code:

vRad = ActiveCell.Row
vRef = "Range" & "(""G" & vRad & """)" & ".Select"

...but what can I do to "execute"...?
...Waht I want is to have Range("G5").Select if the active row is
5....

FTL

Relevant Pages

  • Re: Text disappears when word wrap is used
    ... Make sure that there is not Conditional Formatting in Effect ... I trying to specifically look for Excel 2003. ... > are no merged cells on the sheet. ... >> Hi Mark, ...
    (microsoft.public.excel.misc)
  • Re: Can I Link Merged Cells to a Single Cell?
    ... > Hi Mark! ... > Better than using merged cells is use: ... > Excel and Word Function Lists ...
    (microsoft.public.excel.worksheet.functions)
  • Re: calculations in excel
    ... Todaywill always be greater than the dates held in your cells, hence it should come second in the list ... Now, mark A1:F1, Data>Filter>Autofilter and use the dropdown on the Age column to select 18 ... What i am trying to do i get excel to alert me as to when a member reaches 18 years of age so i can remove them from the sheet. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Is Excel reliable
    ... add a check mark to 'Enable background error checking' Add a check mark to 'Numbers stored as text' ... I know how to fix it this time, but I'm afraid that every time I will use excel, it will be required to verify that no "Non Numbers" infected my spreadsheets. ... you spreadsheet have been a victim of slippery fingers, perhaps before enough cups of coffee in the morning? ... So I assume that sometimes excel ignores cells and sometimes considers them. ...
    (microsoft.public.excel.misc)
  • Re: Best practice to store/manipulate Excel spreadsheet cells
    ... and would adapt well to an irregular floor plan. ... is likely to be a better way of getting a "live" floor plan than Excel. ... part of an event managment database. ... 72 cells at top and 91 cells at the bottom with a height of 44 cells. ...
    (microsoft.public.access.formscoding)