Merged cell problem

popinz

New Member
Joined
Dec 29, 2011
Messages
23
I have two forms in excel and they are very similar.

I want some cells on the second form to auto-populate when the information is entered in the first form.

Ex: Date

It does not work because my first form as cells that are merged.

Is there a way I can do this without unmerging my cells?

Thanks in advance for the help .
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

mgm05267

Well-known Member
Joined
Nov 11, 2011
Messages
615
Hi...

Welcome to the board....

Cells are identified as address in the form of range...

eg: if A1:A5 is merged, in VBA, A1 means the value in A1 only. This might change when A2 is given in VBA

Unless cells are unmerged, the values from the form can not be transferred to the sheet.

Regards,

MGM
 

popinz

New Member
Joined
Dec 29, 2011
Messages
23
I actually found answer to my own question but thought I would post in case it can help someone :)

If you do
= then clik on the mergecells you wish to reproduce it will not work because the formula will automatically count all the cells.

ex: ='TAB1 '!B30:C31

To make it work just delete the last part keeping only the first cell of the merged range

ex: ='TAB1 '!B30

It works

Have a great day people :)
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
13,179
Office Version
  1. 365
Platform
  1. Windows
I think mgm has misunderstood your problem from the way you phrased it.

When you need to reference a range of merged cells, you need to use the address of the top left cell in the merged area.
 

Forum statistics

Threads
1,136,633
Messages
5,676,896
Members
419,657
Latest member
ExcelAl1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top