Search results

Thankyou Very much @SirJB7 and @Luke M for the help. I really appreciate it.

Thankyou SirJB7. Was late to respond as was unaware of your reply. It is exactly what i want but i want the code to paste only value using paste special function. Now the code is pasting formula at the location. Can you help me in this.

Thankyou Bobhc for you help. I have 70 to 80 ranges for which i need macro. Now i am using same Ctrl copy. But it is taking time i want same to be automated. And we cant select all the ranges at a time unable to do so as excel limitation. We have to select ranges one by one such as first...

I have some ranges below which i want to copy from one file and paste to another file. as you can see the ranges are not continuos but it wil be ok if the output will be in continous range. Range("C2021:G2027,C2518:G2531,C2617:G2629,C2655:G2659")...

Thank you Kaushik for the solution. Was not able to reply as was out for some work.

I am so sorry if you felt that i used harsh words or they seem to be have anger in it no such intention. Apologies for same.I am not able to tell u exactly what word i should have used to (view) hence used necked eyes thought if will use view then excel has view option in it and would have...

Yes Kaushik, Even i can notice that the font size remains same on the sheet and also height and width of rows and column does not get change but what i can see through necked eyes is that the space taken by same data needs bigger space and area in terms of original data and cells size get...

Hi i have pasted the link using the dropbox feature i dont know will it work or not as never used before. I have removed all the information from the file but kept the table format as it is. You can copy using the copy button after protecting the file and then try to paste it to next sheet or...

Sure, will definitely require help in future. Thanks for the support and help.

Thanks for the help Hui.

Ya i am sure the size get increased.The second worksheet is not at a different Viewing Scale to the first. How can i upload the file, would have uploaded the file.

ya i manually paste to other worksheet. i use copy button which is assigned to macro and then paste it to other worksheet which paste the data but it increases the size while pasting the data.

Hi Kaushik, Thanks for the help, really appreciate the effort. Even I would like to welcome you in this forum. It was great help and can use macro for same so got the right solution. Will try using macro. Thank you. Have a great day ahead.

Sub Macro1() If Range("C5") = "NOT OUT OF BOX" Then Range("B9:C32").Select Selection.Copy Else Range("B9:F24").Select Selection.Copy End If End Sub

Hi Luke/Narayan, Thanks for your help. I am sorry i cant upload the file as will lead to discrepancy. But i can upload the file without text where u can see the table size and column width how it look like before and after i paste them using the paste function. as i am new to the group is not...

hi Luke, Thanks for the help. There is no portion of macro which is affecting the font size.

The sheet is password protected and hence cant copy normally hence has used VBA code to copy the cells and when i try to paste special does not receive the paste special table, but receive other table in which say's can paste file with unicode, text, csv file and etc...so when i paste the copied...

When i copy some value from one sheet and paste to other sheet the format of the sheets get changed. That is cell size and font size get increased. I cant use paste special function so is there any other way to keep the size same. I am not worried about Column width.

I am facing a issue regarding Data Validation list. After selecting any item from the list can we reset the value of the cell of the list to blank after some time or after certain process by any formula because after item selection the value in cell remains as it is till we change the value from...

I want to define range name but have huge data with unique records count is 190 and these unique records have 2/3 sub records. Now i defined a range to these unique records and also define a link range for the sub records so that if i select unique record then in another cell i see drop down...

Thanks for help all of you. Will like to explain why i need the list with so much items in it. I will be not scrolling down for finding the value as will be entering the value by typing in the cell. As Narayan explained want to try same i have the items in text formats and would like to have...

My problem is that users are not able to see all the choices in the list. There are currently 76221 choices in the source list, but it's cutting off many of the items from the bottom of the list. > Does anyone have any ideas on how to get the whole list visible? Is there a limit of rows in...

Thankyou Luke and Montrey.

I have two workbooks. Workbook1 contains validated list which is defined by a Range name and is pulled from workbook2. Now when i lock the cells in workbook1 and protect the sheet where i have validation list i am unable to change the value of the list when i close workbook2. But if i open the...

Hi, SirJB7, Thank you. I guess it is really very difficult to make others know what we want and need to do for the required output until and unless one upload the sample file, if the required output is complex. I was looking out for the code which accept only the path of text file from the...