Hi guys,
i need a VBA code to lookup for Saturday and Sunday rows, and values from that rows add to Friday values. After that, replace Saturday and Sunday values with zeroes. But if Saturday or Sunday are first days in a month, add those values to Monday. Is that possible?
File included...
Hi guys,
i need to break all links in worksheet, but problem is that some of the sheets contains charts, so normal codes to break links dont work. Is it posibble to break all links both on standard sheets and chart sheets by one code?
Thanks.
Every week i get database, and i need to delete every record that is not 2016 in clolumn A and from 1 to 15 in column B. But only columns Axxx:Exxx bacause in further columns i have formulas.
Q1: I want to delete cells and data from below move up.
Q2: I need to do that as many times as both...
Hello,
i need to delete first five cells (A:E) in a row in case that cell in column A contains value higher than 2016 and cell in column B contains value higher than 15. Both conditions must be true to delete part of that row. Is that possible?
Thanks.
Hello,
i need VBA to recognise wether selection is grouped and in that case ungroup it, or recognise wheter selection is ungrouped and in that case group it. In one VBA code. With group i mean Data>Group/Ungroup function. Is that possible?
Thanks.
Hello,
i need a vba code that will delete all rows above the cell that contains specific string, is that possible? I got this one, but it will only delete two rows above.
Dim x
For x = Cells(Rows.Count, ActiveCell.Column).End(xlUp).Row To ActiveCell.Row Step -1
If Cells(x, 1) = "Slovakia"...
Hi,
i need to modificate the VBA code below to just clear content in colums A:D, not to delete entire row. Is that possible?
Dim i As Long
For i = Range("C" & Rows.Count).End(xlUp).Row To 1 Step -1
If (Range("C" & i).Value <= 2016) Then
Range("C" & i).EntireRow.delete
End If
Next i...
Hi guys,
i wanted to ask whether is it possible to select used range just in one specific column? I am alerady using code below to select whole used range, but i need to do that just in one column.
ActiveSheet.UsedRange.Copy
Thanks.
I tried to run that macro at my work, and it says "Compile error: User-defined type not defined" with marked first line of the code. Do you know why is that?
To my second question - I am getting emails with attachmens every day, and i want to save attachments only from emails received today. Is...
Hi,
is it possible to open Excel workbook which is attached to recieved email in Outlook, copy data from that workbook and paste them into another workbook by VBA?
Thanks for any advice.
T.
Hi guys,
i need to sum every eight column in variable row number. For example i need to sum every eight column in row 29. The number of row must be used in the formula. Could somebody help me with this formula?
Thanks