Forum Discussion

A2Z CF's avatar
A2Z CF
Brass Contributor
Dec 01, 2022
Solved

Cell format

Hello all, I have the formula driven date values in column C. The cells of the column are formatted to show the different forms of dates which begin with “=” and ends with “,” signs. I want to past...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 02, 2022

    A2Z CF 

    Change the line

        For r = 1 To m

    to

        For r = 3 To 16
A2Z CF's avatar
A2Z CF
Brass Contributor
Dec 02, 2022
Perfect! thank you so much, this works great. The only thing is that it does the whole column. My column A range is from 3 to 16 as well as column C. If that part is fixed, I'll be g2g. Thank you so much!!
HansVogelaar's avatar
HansVogelaar
MVP
Dec 02, 2022

A2Z CF 

Change the line

    For r = 1 To m

to

    For r = 3 To 16
  • A2Z CF's avatar
    A2Z CF
    Brass Contributor
    Dec 02, 2022
    That's it! Thank you very much. My sincere appreciation for your time and great help.
    May the power be with you!

Resources