Previous Topic Next Topic

Macro not copying correct data

Closed
Maclearner - 29 Mar 2010 à 10:48
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 31 Mar 2010 à 13:00
hi m trying to copy column D from one tab and pasting it in another tab. When i luk into code it shows copying (D:D) but it selects columns A-D and pastes all the four columns in the another tab... Can you help me in this?
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
29 Mar 2010 à 14:44
Columns("D").select
Selection.copy
Sheets("Sheet2").select
Cells(1, "A").select
activesheet.paste
Maclearner
30 Mar 2010 à 06:11
Thank you for your help....but this code is also working fine for other columns but when I type for column D its taking data from A- D...
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
30 Mar 2010 à 08:12
Because you must have a merged cell A-D in between
Maclearner
31 Mar 2010 à 11:50
I have not merged any data myself . have just copied data from somewhr nd pasted in excel. Is there any solution for this?.how can i proceed further?
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
31 Mar 2010 à 13:00
One thing that you can try is highlight the columns, right click and choose format and then go to alignment tab. At the bottom you would see merge option. If in the selected column there is a merge cells you would notice that the box is highlighted. Click it twice to remove the check box and click ok. That will remove any merge cells

Similar discussions

How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
DVD Rom issues
LeonardPromise -
ac3mark -

2 responses