Forum Discussion

Copper Contributor

May 31, 2020

Solved

Can anyone see the error in this VBA code?

Hello All, I am very new to vba code. I am learning mainly by adapting existing macros. On the screenshot here, you can see a line of code that isn't working. This code, as a whole,...

Macros and VBA

Jos_Woolley
May 31, 2020
nicholasajl

Hi,

Currently you are supplying a row reference to only the CW column of MasterSheet!BK:CW, but the BK column also requires a row reference:

"MasterSheet!BK" & Rng.Row & ":CW" & Rng.Row

Regards

Jos_Woolley

Iron Contributor

May 31, 2020

nicholasajl

Hi,

Currently you are supplying a row reference to only the CW column of MasterSheet!BK:CW, but the BK column also requires a row reference:

"MasterSheet!BK" & Rng.Row & ":CW" & Rng.Row

Regards

nicholasajl
Copper Contributor
May 31, 2020
Jos_Woolley

In minutes, you've fixed what I've spent many hours trying to sort.

I'm so grateful!

Many thanks,

Nick 🙂
- Jos_Woolley
  Iron Contributor
  May 31, 2020
  nicholasajl
  
  You're very welcome! You're doing the right thing by trying to adapt code yourself in order to develop your understanding of VBA. Best way to learn, in my opinion.
  
  Regards