Forum Discussion

nicholasajl's avatar
nicholasajl
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's avatar
    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's avatar
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

Resources