Excel 2013 Paste trouble Help me

[hwrgs]

I've made some functions with VBA in a Excel file(2013 version) and using it.
There was no any problem for the first time.

However, after I've added more newly functions and modified them, I've found out there is a big trouble.

Here is a situation.

1. A new sheet called 'B' is generated through macro.

2. When I copy 'C1' range value in visible 'B' sheet and try to paste it in 'A1' range of the same sheet,
The value is pasted in 'A1' of 'A' sheet not 'B' sheet.

- If I select another sheet and return to 'B' sheet again before copy&paste,
The problem above does not happen.

This trouble only happens when I try to copy&paste right after a new sheet is created through macro.

Please help me and share your experienced knowledge.
thanks

 

[Michael M]

Is the copy / paste done by macro ??
If so, you need to post your code !

 

[hwrgs]

Is the copy / paste done by macro ??
If so, you need to post your code !

Only Ctrl + C , V is used.
thanks

 

[Michael M]

Are you copying / pasting ranges that overlap ??
You say C1 range...is it just C1 or a range of cells starting at C1 ??

 

[hwrgs]

Are you copying / pasting ranges that overlap ??
You say C1 range...is it just C1 or a range of cells starting at C1 ??

Suppose value is '1' in 'C1' cell

1. Click 'C1' cell in 'B' sheet
2. Copy value using Ctri+C.
3. Click 'A1' cell in 'B' sheet.
4. Paste value using Ctrl+V.

Normally, 'A1' cell should be '1' in 'B' sheet.

However, in this trouble, 'A1' cell is '1' in 'A' sheet not in 'B' sheet.
in 'B' sheet, 'A1' cell is blank.

 

[Michael M]

Do you have the sheets grouped ?

 

[hwrgs]

No sheets are grouped.