write

Hello everybody. I've a situation as follows. https://imgur.com/HLpoOUH Then, in sheet "Data" I have two values: cell A2 = 7210210 cell A3 = 7210214 Now, I've to loop in this array and write in B2 = 2958 (corresponding to 7210210) and in B3 = 1020 (corresponding to 7210214). How can I...

Tôi có một mã vbs. Khi tôi chạy nó để cập nhật dữ liệu từ tệp excel sang ứng dụng SAPGUI, tôi nhận được thông báo lỗi "Không thể ghi vào chỉ đọc thuộc tính '" . AI có thể cho tôi biết nguyên nhân và cách khắc phục. cảm ơn bạn mã vbs: Dim objExcel, objWorkbook, objSheet, i Set objExcel =...

Good morning, I am pretty new to VBA. Just wondering is there a shorter way to write multiple or's in VBA. Thanks in advance If (gradelevel = 1 Or gradelevel = 2 Or gradelevel = 3 Or gradelevel = 4 Or gradelevel = 5 Or gradelevel = 6) Then

I am trying to filter through a bunch of data and write information to a csv. it is functioning correctly with one exception, i keep writing over the first line so i never get all the data. I am certain it is a simple fix that I am overlooking to get to a new line in the csv file. here is the...

Do your best to write a formula that will automatically calculate total price for any amount of units placed in C12. Unit Quantity Price per unit below 4 36 5 to 10 34 11 to 30...

I want to use this formula in VBA. Any assistance is appreciated. Thanks =SUMPRODUCT(SUBTOTAL(9,OFFSET(P15,ROW(P15:P427)-ROW(P15),0,1)),--(P15:P427 < 0))

Hello everyone. Is is possible to make macro that can go down list of websites on excel file in Column A and determine if website has a blog and then in Column B script will write Yes or No ?

Hi I have 2000 files where I need to write over one cell in each files. All these file are in same folder. All files are protected with password, and VBA are also Protected with password. In every file have worksheet what are named "environ". On that sheet I need to change one cell value. So my...

Hi! I need help with my excel worksheet. If I write XXXX in column A - YYYY will appear in column b. Is that possible?

Excel VBA is great to read a picture's metadata but it seems tough to have it write any to the file. Ffor a large number of pictures, because it's so much easier to modify the image attributes in Excel than to do it to the pictures individually, I'm looking for a way to take what I write on a...

I have the following code, it some what redundant i think, wandering if there is a shorter way to accomplish this and check to see if the value being copied is numeric if it is not write a 0 otherwise copy the number in the cell I write each row every minute from a rtd script thanks shawn Sub...

Hi, I'm trying to write an excel formula in VBA which gives me a unique count of a certain column. However, I'm getting an #N/A when I write it in VBA. Any thoughts? Here's the part that's giving the #N/A in the code: .Range("B" & NumberofRows + 4).Formula =...

Can someone please help me tidy up this logic? If ConditionA Then If ConditionB Then Call SomeSub Else Runverylongpieceofcode End If Else Runverylongpieceofcode End If I don't to write Runverylongpieceofcode twice. Thanks

Hi all, I'm trying to write an formula for an audit. The questions is, if a patient is on a particular drug 'A', are certain numbers within a certain range - for instance if they are on drug A, and they are over 80, or a serum creatinine of over 133, or a weight of under 60kg, or a creatinine...

Here's a weird one. Due to the sheer laziness of some team members, they want to enter "1730" into a cell and have it convert to "17:30" Likewise, "530" would convert to "05:30" (5:30AM) I'm literally rolling my eyes because they can't be bothered to just physically write "05:30" (and yes...

I am trying to write the formula below to a cell using VBA but I am receiving a 1004 error. Strangely, if I write exactly the same string to the cell as text (i.e. without the "=") and then manually insert the "=" it works perfectly! Cells(x, 4).Formula = "=COUNTIF(Dic!$B$2:$B$2226;B" & x &...

Hello - I want to write a formula to do the following: If F3 has a number in it than tell me if M3 is blank. <colgroup><col width="72"></colgroup><tbody> </tbody> in other words... you have to be doing the criteria we have in one column if you want to sell the product in the other...

Good Day, Thank you in advance for answering this question. I can't combine two fields with an "x" value. For example, I'm combining lumber height & width so I write a calculated column =CONCATENATE(Data[Height],[Width]) and it shows 812 instead of 8x12. So then I read several websites &...

how do i write the file name and path of my active workbook into a text file without putting it inside quotes i.e c:\temp\col.xls instead of "c:\temp\col.xls"

Hello. It is possible to code an Add-in that make possible to write it down, the conditions, loops and with; in other words, you know that when we type sub automatically the IDE write End Sub, so I am wondering if it is possible to write a add-in for the conditions, we just type If and the IDE...