ExcelBanter - get cell value and use it in vba

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - get cell value and use it in vba (https://www.excelbanter.com/excel-programming/426297-get-cell-value-use-vba.html)

MP999

get cell value and use it in vba

I need to get value of cell A1 on sheet 1 which will be between 0 an 69. I
then need to copy detail from another worksheet (A1:J40) and change formula
in several cells to reflect the selection (one of 10 worksheets and seven
columns on each)

All times are GMT +1. The time now is 12:38 PM.