Thread: VBA: Column Select then Data Select then return to cell A1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James C[_2_] James C[_2_] is offline
external usenet poster
  
Posts: 17
Default VBA: Column Select then Data Select then return to cell A1
How do you write in VBA:-
to select a column then select the range of data held in the column (say B1)
then return to Cell a1. The data in the column can change in the workbook as
it is updated regulary, so the range of data in the column varies constantly.
There are column headings so the range in column B1 must start at B2.

Many thanks
--
James
Reply With QuoteReply With Quote