suggest

Hi All, I am getting publish error (.Publish (True))in below code in Clinet enviornment, However it working fine on my system. Even if i am trying to creating a HTML page manually, it is showing as "Page can't be displayed". Can anyone suggest here what setting needs to change for fix this...

Hi Everyone, I am trying to scan the barcode and that barcode value should display/print in excel column 'C' , can this be done using excel Can anyone suggest me, how this can be done. Regards, Dhruva.

Column A B W1 W1_1 W1 W1_2 W171 W171_3 Formula B1 is: A1&"_"&ROW()-ROW($C$9). How to get W171 not jump to _3 but to _1 again? What formula would you suggest? Thanks!

Can anyone suggest a good source for icons? I'm wanting to add some macros to the a tab as a customization to the Excel ribbon. Thanks.

Hi, is it possible to create a database in excel? What I mean is, can I save details from a worksheet to a different worksheet then I can query it up when needed? If not, can you suggest alternatives? Thanks

Hi everyone, can anyone suggest me that can we convert 8 digits or 7 digits numbers to date format Like example: 12022018 to 12/02/2018 7022018 to 07/02/2018 can this be done using vba, if yes please suggest me how. Thanks in advance

Hi, hoping you clever people can help please. I have a long formula in a report that looks at values in a particular column that is specific to months. On the 1stof the following month I have to roll the formula forward so that each column value increases by 1 i.e. AD becomes AE, AE becomes AF...

I am wiorking with a sheet that is foramted as a table. I have tried five separate codes to get the last row in column ag. None work. Can anyone suggest a solution? https://www.thespreadsheetguru.com/blog/2014/7/7/5-different-ways-to-find-the-last-row-or-last-column-using-vba

Hi, Unfortunately I have deleted table called "Rik" from access table 2010. Now I am looking for suggestion to recover table from the access 2010. Please suggest. Thank You, Mohan

1 box=600 pecs 1 box=15 pkt 1 box=4 strip my total qty 1274 how to get qty in box/pkt/strip/pcs=2box,1pkt.3strip,4pcs please suggest excel formula for this. Thanks, regards, kalpesh

Hi, Following is the list of students & marks they've got in exam. This is sample. We are having groups like A&B, C&D, E&F. We can allow only one from each group who is having more marks for next test. Kindly suggest, how the formula should be using vlookup? Thanks in advance <colgroup><col...

Hi I understand the code below what what I do not really understand is End(xlUp). I read that it is a Property of Range and it is of type of Range itself. It is used to change the direction of a cell. But what I do not understand, why xlUp passed between 2 () to me that suggest it is a...

Can someone suggest the code for find and find next

I am trying to make cell count fro 1-100 automatically Can anyone suggest vba code to do this thanks

Range("C5:C" & Rows.Count).End(xlDown).Clear In the above line of code, data after C5 not getting clear. I used this too Range("C5:C" & Rows.Count).End(xlDown).ClearContents Can any one quickly suggest on this

Hello I have a two lists of numbers. The numbers are from 0.0001 up to 1,999,999,999. I want to find the pairs of numbers that are quite similar, i.e.within +/-5%. How can I do that? I was thinking to round them up and find exact matches, but they have large difference. What do you suggest?

Hello All, I was trying to Log off my colleague system using vba. Can any one suggest me with code or ideas. Thanks, Sasidharan

Which is the best place to enhance the financial modelling skills? If anybody know please suggest me.

Hi Everyone, I have this macro that is quite long as you can see and does a number of different things, however, although it works it is very slow and I was woundering if anyone could suggest parts that could be edited to improve its speed? any help and suggestions will be appreciated and I...

https://imgur.com/a2wvVav I'm trying to create an equipment log to monitor our facility's equipment and their various conditions. The imgur link is what I have so far. If anyone can suggest a cleaner layout, I'd be open to it. Number of Repairs-I'd like to color code each cell in this column...