View Single Post
 
Old 03-24-2016, 07:11 PM
carlandtina02 carlandtina02 is offline Windows XP Office 2010 64bit
Novice
 
Join Date: Mar 2016
Posts: 11
carlandtina02 is on a distinguished road
Default BeforeDoubleClick send row to sheet2

Hi Guys,

I have some code that i'm having bother with and could really do with some help please, this is what it does:

In sheet 1 I double click on the row of column B and that then sends that row to B33 on sheet 2, or if you click on the row of column C it will send the same row to B61 on sheet 2.

The rows on sheet2 are hidden and unhide one by one when the row/s above get populated.

The problem is, i have merged columns B,C & D and the code has stopped working, also i don't understand how the code references where the "copy row" starts at?

Any help would be much appreciated



Thanks
Attached Files
File Type: xlsm BDC SAMPLE.xlsm (209.0 KB, 12 views)
Reply With Quote