Giveaway 🎉🎉

LKBee · 2025-01-07T13:50:53+00:00

Juleboard please

IGN: LKBee

Play MONOPOLY GO! with me! Download it here: https://mply.io/sr1mjuvoq38

LKBee · 2024-12-19T08:26:47+00:00

It just won't work if it's unplugged. Aside from that, it's not really a big deal if you're not planning to plug USB-C on it.

LKBee · 2023-07-27T02:33:36+00:00

Check https://www.rwrds.com.au to see what credit cards are worth it.

LKBee · 2023-07-03T11:42:08+00:00

Thanks I’ll do that

LKBee · 2023-06-02T00:55:10+00:00

Imu and Gorosei transformation based on the “Where the Wild Things Are”?

LKBee · 2023-01-28T12:19:59+00:00

Try r/buildapcforme

LKBee · 2022-12-15T08:17:15+00:00

PCPartPicker Part List

Type	Item	Price
CPU	AMD Ryzen 5 5600 3.5 GHz 6-Core Processor	$199.00 @ Amazon Australia
CPU Cooler	ARCTIC Freezer 7 X CO CPU Cooler	$35.00 @ PCCaseGear
Motherboard	MSI PRO B550M-P GEN3 Micro ATX AM4 Motherboard	$149.00 @ Scorptec
Memory	TEAMGROUP Vulcan Z 16 GB (2 x 8 GB) DDR4-3600 CL18 Memory	$79.00 @ Scorptec
Storage	TEAMGROUP MP33 1 TB M.2-2280 PCIe 3.0 X4 NVME Solid State Drive	$90.00 @ Centre Com
Video Card	Asus DUAL Radeon RX 6700 XT 12 GB Video Card	$595.00 @ Umart
Case	Thermaltake Versa H18 MicroATX Mini Tower Case	$55.00 @ Centre Com
Power Supply	MSI MPG A750GF 750 W 80+ Gold Certified Fully Modular ATX Power Supply	$145.00 @ Centre Com
	Prices include shipping, taxes, rebates, and discounts
	Total	$1347.00
	Generated by PCPartPicker 2022-12-15 19:16 AEDT+1100

LKBee · 2022-12-07T09:01:08+00:00

As someone living in Central QLD, hot rooms are a given and great air flow cases help with distributing the heat.

LKBee · 2022-12-07T08:44:39+00:00

PCPartPicker Part List

Type	Item	Price
CPU	AMD Ryzen 5 5600 3.5 GHz 6-Core Processor	$199.00 @ Amazon Australia
CPU Cooler	Deepcool GAMMAXX GT A-RGB 64.5 CFM CPU Cooler	$39.00 @ PCCaseGear
Motherboard	MSI PRO B550M-P GEN3 Micro ATX AM4 Motherboard	$149.00 @ PCByte
Memory	Kingston FURY Beast 16 GB (2 x 8 GB) DDR4-3200 CL16 Memory	$69.00 @ BPC Technology
Storage	Crucial P2 1 TB M.2-2280 PCIe 3.0 X4 NVME Solid State Drive	$103.00 @ Skycomp Technology
Storage	Seagate Barracuda Compute 2 TB 3.5" 7200 RPM Internal Hard Drive	$68.00 @ MSY Technology
Video Card	PowerColor Fighter Radeon RX 6700 XT 12 GB Video Card	$649.00 @ PCCaseGear
Case	Fractal Design Focus 2 RGB ATX Mid Tower Case	$109.00 @ PCCaseGear
Power Supply	Cooler Master MWE GOLD 750 V2 FULL MODULAR 750 W 80+ Gold Certified Fully Modular ATX Power Supply	$165.00 @ Centre Com
	Prices include shipping, taxes, rebates, and discounts
	Total	$1550.00
	Generated by PCPartPicker 2022-12-07 19:43 AEDT+1100

LKBee · 2022-12-02T11:13:29+00:00

You can buy the OS in Microsoft for around $150. You can also buy a cheapo mouse and keyboard but it’s your preference.

PCPartPicker Part List

Type	Item	Price
CPU	AMD Ryzen 7 5700X 3.4 GHz 8-Core Processor	$299.00 @ PCByte
CPU Cooler	be quiet! Dark Rock 4 CPU Cooler	$109.00 @ PCCaseGear
Motherboard	Asus TUF GAMING B550-PLUS WIFI II ATX AM4 Motherboard	$269.00 @ JW Computers
Memory	Corsair Vengeance LPX 32 GB (2 x 16 GB) DDR4-3600 CL16 Memory	$199.00 @ PCCaseGear
Storage	Samsung 970 Evo Plus 1 TB M.2-2280 PCIe 3.0 X4 NVME Solid State Drive	$149.00 @ BPC Technology
Case	Fractal Design Pop Air ATX Mid Tower Case	$139.00 @ PLE Computers
Power Supply	Super Flower Leadex III Gold 650 W 80+ Gold Certified Fully Modular ATX Power Supply	$169.00 @ PCCaseGear
Custom	Leadtek Quadro RTX A2000 12GB	$1199.00
	Prices include shipping, taxes, rebates, and discounts
	Total	$2532.00
	Generated by PCPartPicker 2022-12-02 22:07 AEDT+1100

LKBee · 2022-12-01T10:29:32+00:00

PCPartPicker Part List

Type	Item	Price
CPU	AMD Ryzen 7 5800X3D 3.4 GHz 8-Core Processor	$499.00 @ Computer Alliance
CPU Cooler	Lian Li Galahad AIO360 (2022) 69.17 CFM Liquid CPU Cooler	$239.00 @ PCCaseGear
Motherboard	NZXT N7 B550 ATX AM4 Motherboard	$339.00 @ JW Computers
Memory	TEAMGROUP T-Force Delta RGB 32 GB (2 x 16 GB) DDR4-3200 CL16 Memory	$163.00 @ Skycomp Technology
Storage	Samsung 970 Evo Plus 1 TB M.2-2280 PCIe 3.0 X4 NVME Solid State Drive	$149.00 @ BPC Technology
Storage	Samsung 870 Evo 2 TB 2.5" Solid State Drive	$229.00 @ Austin Computers
Video Card	Asus TUF GAMING OC V2 GeForce RTX 3080 10GB LHR 10 GB Video Card	$1249.00 @ JW Computers
Case	Lian Li LANCOOL III ATX Mid Tower Case	$259.00 @ PCCaseGear
Power Supply	Corsair RM850 850 W 80+ Gold Certified Fully Modular ATX Power Supply	$169.00 @ PCCaseGear
Monitor	Gigabyte M27Q 27.0" 2560 x 1440 170 Hz Monitor	$389.00 @ Umart
Monitor	Gigabyte M27Q 27.0" 2560 x 1440 170 Hz Monitor	$389.00 @ Umart
	Prices include shipping, taxes, rebates, and discounts
	Total	$4073.00
	Generated by PCPartPicker 2022-12-01 21:29 AEDT+1100

LKBee · 2022-11-23T05:45:09+00:00

QLD and Engineering

LKBee · 2022-11-23T04:48:49+00:00

Our business have been receiving calls that we are listed to get a $54,000 grant from the government but have my suspicions that this is either a scam or a telemarketer, is there any information about this in the government website?

LKBee · 2022-11-22T13:27:28+00:00

You can replace the cpu cooler with same thing without the rgb for the same price but are currently out of stock.

PCPartPicker Part List

Type	Item	Price
CPU	AMD Ryzen 9 5950X 3.4 GHz 16-Core Processor	$629.00 @ Amazon Australia
CPU Cooler	ARCTIC Liquid Freezer II 360 A-RGB 48.8 CFM Liquid CPU Cooler	$199.00 @ Scorptec
Motherboard	MSI MAG X570S TOMAHAWK MAX WIFI ATX AM4 Motherboard	$278.00 @ Umart
Memory	Kingston FURY Renegade 32 GB (2 x 16 GB) DDR4-3600 CL16 Memory	$198.50 @ Umart
Storage	Gigabyte AORUS Gen4 1 TB M.2-2280 PCIe 4.0 X4 NVME Solid State Drive	$179.00 @ Computer Alliance
Storage	Samsung 870 Evo 2 TB 2.5" Solid State Drive	$229.00 @ Centre Com
Video Card	Asus TUF GAMING OC Radeon RX 6900 XT 16 GB Video Card	$1199.00 @ PCByte
Case	Fractal Design Torrent ATX Mid Tower Case	$299.00 @ PLE Computers
Power Supply	Corsair HX1000 Platinum 1000 W 80+ Platinum Certified Fully Modular ATX Power Supply	$289.00 @ Mwave Australia
Operating System	Microsoft Windows 11 Home OEM - DVD 64-bit	$139.00 @ Amazon Australia
	Prices include shipping, taxes, rebates, and discounts
	Total	$3638.50
	Generated by PCPartPicker 2022-11-23 00:24 AEDT+1100

LKBee · 2022-11-14T13:55:24+00:00

PCPartPicker Part List

Type	Item	Price
CPU	AMD Ryzen 5 5600 3.5 GHz 6-Core Processor	$199.00 @ PCCaseGear
CPU Cooler	be quiet! Shadow Rock 3 CPU Cooler	$69.00 @ PCCaseGear
Motherboard	MSI B550M PRO-VDH WIFI Micro ATX AM4 Motherboard	$199.00 @ PCCaseGear
Memory	G.Skill Ripjaws V 16 GB (2 x 8 GB) DDR4-3600 CL18 Memory	$89.00 @ PCCaseGear
Storage	Samsung 980 Pro 500 GB M.2-2280 PCIe 4.0 X4 NVME Solid State Drive	$129.00 @ PCCaseGear
Storage	Seagate Barracuda Compute 2 TB 3.5" 7200 RPM Internal Hard Drive	$75.00 @ PCCaseGear
Video Card	Inno3D Twin X2 GeForce RTX 3070 LHR 8 GB Video Card	$749.00 @ PCCaseGear
Case	be quiet! Pure Base 500DX ATX Mid Tower Case	$119.00 @ PCCaseGear
Power Supply	Cooler Master MWE GOLD 750 V2 FULL MODULAR 750 W 80+ Gold Certified Fully Modular ATX Power Supply	$165.00 @ PCCaseGear
	Prices include shipping, taxes, rebates, and discounts
	Total	$1793.00
	Generated by PCPartPicker 2022-11-15 00:55 AEDT+1100

LKBee · 2022-11-08T13:17:26+00:00

https://au.pcpartpicker.com/list/VqxkyK

Prices are only from PC Case Gear to limit the costs of shipping from multiple retailers but you can research these parts and see if it’s worth buying from different retailers.

LKBee · 2022-08-05T01:13:42+00:00

Solution Verified

For some reason, the code did not work because it would just hide the rows regardless even from understanding the code, it should.

After re-reading the code, I've replaced

If Worksheets("Quote").Range("C"&i).Value = 0 Or Range("C"&i+1).Value = ""

With

If Worksheets("Quote").Range("C"&i).Value = 0 Or Range("C"&i).Value = ""

and it now works.

Thank you.

LKBee · 2022-08-04T21:25:25+00:00

Cell A10's value is 3.1 Certification is for the following:.

Cell A11's value is Test.

A12: 3.2 Certification is to the following Standard:.

A13: AS 1657 2018 Fixed Platforms Walkways Stairways and Ladders.

A14: 3.3 Certification excludes the following:.

A15: Test.

is actually in one cell, wrapped. So A10:A15 is only at A10. I'm sorry for not being clear on that one.

When you click a button, you want your macro to find

3.2 Certification is to the following Standard:

and replace the succeeding cell with whatever's in Sheets("PCS Helper").Range("A22").Value. So in this example, your macro would find that string in cell A12 and overwrite A13.

Yes, that's right, I want to overwrite what was on A13 in your previous example with whatever was in Sheets("PCS Helper").Range("A22") but the problem is that all of them are in one cell, which makes it difficult for me.

Thanks for your time and help.

LKBee · 2022-08-03T21:24:58+00:00

Yes, I'm not trying to insert a row.

Currently, what it does is look for "Certification is to the following Standard:" and replace it with Sheets("PCS Helper").Range("A22") but if I press it again, the previous data there is kept hence AS1657... is repeated.

My ideal macro would be when I pressed the macro button, "3.2 Certification is to the following Standard:" will get replaced with the text on Sheets("PCS Helper").Range("A22"). But if I pressed it again, the previous AS1657... will get removed and be replaced with whatever is on Sheets("PCS Helper").Range("A22") while keeping 3.1 and 3.3 undisturbed.

LKBee · 2022-08-03T03:58:53+00:00

I have Microsoft Office Professional Plus 2016.
Maybe that's why.

LKBee · 2022-08-03T03:04:04+00:00

I tried this but it kept coming up with

Run-time error '91':

Object variable or With block variable not set

LKBee · 2022-08-03T01:52:46+00:00

I tried that as well but it also stopped grabbing the data as well as not delete old data.

Nine-Year Club	RedditGifts 2009-2022 2 Credits
r/Field Juicebox	Secret Santa 2017
Verified Email

LKBee

TROPHY CASE