Search results

Dear Belleke , Kindly advise is it possible to make a below row to display ONLY the date without MONTH and YEAR as 01 02 03 ......31 Regards Govind

Your reply is Exactly matching with my need thanks a lot

Dears, Say for example in Cell A1, after entering the 1st day of the month as 01-05-2021, I need to get A2 to A31 full month date of the particular month. i.e auto calculating the date for the date in the cell A1 Instead of dragging/ autofill, need to get the automated date. Kindly advise...

@Chihiro Thank you it is working =WORKDAY.INTL(Date - 1,10, 7)

Dear All, Total working days in a week 5 days (Friday and Sat weekly off) Task1 starts at 06 09 2020---(1) Task1 needs 10 days of work Task1 ends at 17 09 2020---(2) How to get (1) + 10 = (2) excluding the dates 11 and 12 How to automate this to find the next date excluding Frid and Saturday...

Hi Thank you for your reply Presently I have Excel 2013 I need to run the below code Isn't below same as in (Your) #1 Reply? except ... then You used code - tags >>> use code - tags <<< Dim objClipBoard As Object Dim texttobecopied As String MSForms.DataObject Set objClipBoard =...

Thank you for your reply I need to upgrade my excel version to make it happen regards Govind narayan

Kindly do the needful The code is not working and it is showing red Is it possible to embed the first thread of the code into this and share the excel sheet to run the code Please Govind narayan

Dears, Kindly advise how to fill the chart as attached The shape varies as square or rectangle as per the input data Regards Govind

Dear Hui, Got it THANKS, closed Sub RangeSelectionPrompt() Dim rng As Range c = 0 nc = InputBox("Please enter the number of cells to Sum", "Sum Range") For i = 1 To nc Set rng = Application.InputBox("Select a range", "Obtain Range Object", Type:=8) c = c + rng Next...

Dear Hui, Thank you for your inputs, Code: Sub RangeSelectionPrompt() Dim rng As Range Set rng = Application.InputBox("Select a range", "Obtain Range Object", Type:=8) MsgBox "The cells selected were " & rng.Address End Sub Actually I'm looking for the code as above, once we...

Dear All, Is there is any way to add the selected cell from user form and display the result as a pop-up window itself Say A1 A2 A3 cells have data After clicking a shortcut say ctr+shft+a, window has to popup ask for number of variables to add once it is given as 3 (say, n) it has to allow to...

Thank you very much

Dear p45cal Kindly find attached the file regards

Really sorry I will send the workbook Sorry once again

Hi p45cal Thanks for the code and the conditional formatting formula It works perfect Could you please advise the code or conditional formatting even if the cell is formatted as text Thank you

Kindly advise a code to bold the cell value after selecting the cell and after running a macro with a certain condition as below: Say the cells from A1 to A10 has the values as listed as below if I select the cells from A1 to A10, then after running a macro, the result shall be, the cell that...

@vletm Is this the one? For Each i In ActiveSheet.ChartObjects i.Chart.ProtectSelection = False i.Chart.ProtectData = True i.Chart.ProtectFormatting = True Next i

@vletm I understood. Thanks for your help. I got the concept from your code Thanks once again

@vletm This I have used in my code Thanks a lot Sub Inb() RCNUM = InputBox("Address: ", "RCNUM", "") If RCNUM <> Empty Then MsgBox "R: " & Range(RCNUM).Row & Chr(13) & "C: " & Range(RCNUM & 1).Column, vbInformation, "Given Cell Address: " & RCNUM End If End Sub

vletm Sorry, Initially I didn't understand the code. Got it now Really great Thanks a lot

Dear vletm Thank you for the code. Actually, we need to supply the random cell address to the code not the current location of the cell So need the code that will provide the Row and column if I give the input as L134 = Which row and which column? not the selected cell row column instead the...

vletm Could you please share the working code I need the VBA code that returns the Column and Rownumber of a given cell address Thank you

Dear Marc L Actually, I don't know how to do I can able to get ONLY the cell address of LEFT TOP CORNER CELL With the cell address how to get the row and column number of the cell address. Once I get the row and column number of the cell address through VBA I can resolve it Thank you

I have a XY scatter chart Properties Locked = Unticked Worksheet protected with a password While running the VBA if we try to change the chart properties through VBA, we need to unprotect sheet by supplying password inside the VBA to do the changes in the Chart then after again protecting the...