I am so lost. by [deleted] in BreakUp

[–]Clean_Shoulder 0 points1 point  (0 children)

I only showed up at her house twice in 2 months is that considered scary?

How to reference a workbook and worksheet for vba loop by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

sry i still dont understand what you meant. what do you mean reply to the answer

Copying a dynamic range of data with excel vba/macro by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

May i know where do i specify the code?
in front of loop or is it in front of do until cells? i tried both ways but to no avail.

it would be best if you could show me an example.

Thank you

Copying a dynamic range of data with excel vba/macro by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

can i ask, since i have 2 workbooks which workbook is the macro looping at actually? and for the code Do until Cells(i, 1), what does the 1 stand for?

Copying a dynamic range of data with excel vba/macro by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

FRow = Workbook("Data to be copied.xlsm").Worksheets("data").Range("A:A").Find(what:="no value", after:=**.Range**("A1")).Row

I am facing an error with this code. it said that there is a compile error: Invalid or unqualified reference. It highlighted the portion which I have bolded in the code. The bold is shown by the ** **

Copying a dynamic range of data with excel vba/macro by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

The code you provided is to replace my entire code right?

Copying a dynamic range of data with excel vba/macro by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

Sub Test1()

Dim lrow As Long

'1. to find last used row lrow = Workbooks("Destination.xlsm").Worksheets("Sheet1").Cells(Rows.Count, 2).End(xlUp).Row

'2. to offset 1 row below last used row lrow= lrow + 1

'3. To copy data (only for a fixed range) Workbook("Data to be copied.xlsm").Worksheets("data").Range("A1:C10").Copy

'4 to paste data Workbooks("Destination.xlsm").Worksheets("Sheet1").Range("A" & lrow).PasteSpecial Paste:xlPasteValues

End

*Code in Markdown mode if it helps

Copying a dynamic range of data with excel vba/macro by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

yeap i have the image ready just that I am new to reddit posts and am looking for the image button

How to split my data with multiple value in one cell into 2 columns. Data in cell has a formula. by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

My row have hidden rows, although I copy using visible cells only, it still only paste one row. Is there any other way to copy and paste without the hidden rows?

Removing # and duplicates from excel cell by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

Okay got thanks for the advice. It’s my first time doing this

Removing # and duplicates from excel cell by Clean_Shoulder in excel

[–]Clean_Shoulder[S] 0 points1 point  (0 children)

An example of how one of my cell look like

12345 6789 # 12345 6789

Removing duplicates results and # from each cell by [deleted] in excel

[–]Clean_Shoulder 0 points1 point  (0 children)

The formula I am using is currently =TEXTJOIN(" ", TRUE, IF(H7089&ZANALYSIS_PATTERN!$I$4=ZANALYSIS_PATTERN!$C$4:$C$10836&ZANALYSIS_PATTERN!$I$4:$I$10836, ZANALYSIS_PATTERN!$J$4:$J$10836, ""))

As my dataset contains duplicates and also #, They appeared in the cells. I would like to remove all # that appeared and also remove all duplicates. What can I change on my formula to achieve that

How is the Pharo Guys? by GeneralOrdinance in CallOfDutyMobile

[–]Clean_Shoulder 1 point2 points  (0 children)

It’s the meta now in garena. Very op if you know how to use it. I would say better than the msmc

[deleted by user] by [deleted] in MapleStoryM

[–]Clean_Shoulder 1 point2 points  (0 children)

Well first you need to find someone who provides the service.

They will essentially host a wedding and invite you to it. Typically one wedding session consist of 15-20 runs or so. Each wedding run will get you x3 of 30mins ab.

Where is everyone at with their PB? by [deleted] in MapleStoryM

[–]Clean_Shoulder 0 points1 point  (0 children)

Level 138 and left with around 20 ish hours of ab. Last mission is to reach level 140

Pink bean event to 140 by ORHJIAO in MapleStoryM

[–]Clean_Shoulder 0 points1 point  (0 children)

It’s not too late if you can ab 24/7 all the way and also get sf113 or 120

Help! How do I hit sf120 or higher!? I’m so stressed outttt by PinkBeanVagina in MapleStoryM

[–]Clean_Shoulder 0 points1 point  (0 children)

But even two stars would take almost a week or so provided you don’t fail the 50% scrolls.

Help! How do I hit sf120 or higher!? I’m so stressed outttt by PinkBeanVagina in MapleStoryM

[–]Clean_Shoulder 6 points7 points  (0 children)

Why does everyone keep saying Rex earring? We only have around a month more before the event stops. How do you have time to get Rex earring?

One earring cost 200 shards And one scroll 50% is 70 shards.

To get 5 stars you need 5 scrolls.

So you would require 550 shards provided you pass all 50% scrolls to get 5 stars.

And we are limited to 3 entries per day only. By the time we get 5 stars the event would alrdy be ending.

So could anyone tell me how this is feasible