sunoffice - Search Results - Excel Help Forum

[SOLVED] Date error: 29/2/2023 shows Wed 01/03/2023

Started by SunOffice‎, 05-23-2023 03:12 AM

5

384

Last Post By:: Last Post: 05-26-2023 08:38 AM; by TMS

Forum:
Excel Programming / VBA / Macros

Transform data from horizontal rows to vertically (for listbox on UserFrom)

Started by SunOffice‎, 05-05-2023 05:35 AM

3

445

Last Post By:: Last Post: 05-06-2023 10:54 AM; by beyond Excel

Forum:
Excel Programming / VBA / Macros

Logic to calculate accurate Ageing (Aging) by Excel formula

Started by SunOffice‎, 09-28-2018 10:04 AM

5

585

Last Post By:: Last Post: 09-28-2018 12:42 PM; by joeu2004

Forum:
Excel Formulas & Functions

[SOLVED] Extract all the special characters from each cell

Started by SunOffice‎, 08-08-2018 03:30 PM

5

595

Last Post By:: Last Post: 08-08-2018 04:24 PM; by jindon

Forum:
Excel Programming / VBA / Macros

[SOLVED] Populate list from the master list (No Vlookup, where you already provide the 1st column)

Started by SunOffice‎, 06-22-2018 02:49 AM

10

923

Last Post By:: Last Post: 08-01-2018 01:15 PM; by FlameRetired

Forum:
Excel General

[SOLVED] Activate button upon checkbox selection in custom ribbon

Started by SunOffice‎, 04-08-2015 08:57 AM

4

2,334

Last Post By:: Last Post: 04-17-2015 09:26 PM; by CaptMac

Forum:
Excel Programming / VBA / Macros

Calculate Years and Months difference - DateDiff and MOD issue

Started by SunOffice‎, 12-08-2013 12:39 AM

9

2,503

Last Post By:: Last Post: 12-08-2013 05:51 AM; by nilem

Forum:
Excel Programming / VBA / Macros

[SOLVED] ComboBox - "Error: Invalid Property Used" while restricting the dropdown values

Started by SunOffice‎, 12-03-2013 07:01 PM

10

2,524

Last Post By:: Last Post: 12-05-2013 04:26 AM; by SunOffice

Forum:
Excel Programming / VBA / Macros

a Dynamic Vlookup (Column Reference)

Started by SunOffice‎, 11-27-2013 04:02 PM

4

1,256

Last Post By:: Last Post: 11-27-2013 04:27 PM; by Tony Valko

Forum:
Excel Formulas & Functions

Completely remove/delete all the external links (Break Links)

Started by SunOffice‎, 11-27-2013 12:25 AM

2

8,074

Last Post By:: Last Post: 01-23-2014 05:31 AM; by jennyc_83

Forum:
Excel Programming / VBA / Macros

[SOLVED] How to get correct values without applying filters

Started by SunOffice‎, 11-24-2013 03:43 PM

8

993

Last Post By:: Last Post: 11-24-2013 06:30 PM; by SunOffice

Forum:
Excel Formulas & Functions

How to keep hyphen in a string and remove all specific characters

Started by SunOffice‎, 11-20-2013 03:43 AM

3

947

Last Post By:: Last Post: 11-27-2013 12:32 AM; by jindon

Forum:
Excel Programming / VBA / Macros

How to sort values in a row by using Array method

Started by SunOffice‎, 11-19-2013 12:58 AM

7

742

Last Post By:: Last Post: 11-19-2013 02:12 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

[SOLVED] How to get data from ComboBox Multiple Columns to excel sheet

Started by SunOffice‎, 09-11-2013 06:57 AM

17

4,085

Last Post By:: Last Post: 09-14-2013 01:19 AM; by SunOffice

Forum:
Excel Programming / VBA / Macros

[SOLVED] Load/Populate TreeView data from sheet to Userfrom

Started by SunOffice‎, 07-18-2013 03:50 PM

3

5,157

Last Post By:: Last Post: 06-10-2015 08:51 PM; by mbproductions

Forum:
Excel Programming / VBA / Macros

Based on Years calcuate Min() and Max() values from another column

Started by SunOffice‎, 04-30-2013 09:10 AM

4

1,004

Last Post By:: Last Post: 04-30-2013 11:14 AM; by Kevin UK

Forum:
Excel Formulas & Functions

[SOLVED] Calculate Time on AM/PM basis

Started by SunOffice‎, 04-30-2013 05:35 AM

2

789

Last Post By:: Last Post: 05-02-2013 11:08 PM; by SunOffice

Forum:
Excel Formulas & Functions

Identify all the smtp E-mail Addresses of a GAL Exchange User? except PrimarySmtpAddress

Started by SunOffice‎, 02-28-2013 03:23 PM

0

1,403

Last Post By:: Last Post: 02-28-2013 03:23 PM; by SunOffice

Forum:
Outlook Formatting & Functions

How to identify the correct 'GAL' & its '.AddressLists.Item(number)' of a particular email

Started by SunOffice‎, 02-22-2013 01:51 AM

0

1,588

Last Post By:: Last Post: 02-22-2013 01:51 AM; by SunOffice

Forum:
Outlook Formatting & Functions

Fetch/Get Outlook GAL email Id details of a particular 'email account domain' (by Exchange

Started by SunOffice‎, 02-21-2013 01:33 AM

2

4,938

Last Post By:: Last Post: 02-25-2013 10:40 AM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Assign fixed values to array / For...Next loop

Started by SunOffice‎, 12-18-2011 04:25 PM

4

1,497

Last Post By:: Last Post: 12-18-2011 05:43 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Excel to find in Notepad and pull data lines

Started by SunOffice‎, 11-05-2011 05:44 PM

13

4,468

Last Post By:: Last Post: 11-30-2011 07:23 AM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Pass values from UserForm ListBox/ TextBox to run the codes of a Module

Started by SunOffice‎, 09-04-2011 08:32 AM

6

2,127

Last Post By:: Last Post: 09-05-2011 08:59 AM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Find out the Row and Column address number of the searched cell (separately)

Started by SunOffice‎, 09-03-2011 12:31 PM

7

1,027

Last Post By:: Last Post: 09-05-2011 09:32 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Hide blank columns via loop

Started by SunOffice‎, 06-09-2011 02:24 AM

2

904

Last Post By:: Last Post: 06-09-2011 10:17 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Cut & Paste - AutoFilter SpecialCells(xlCellTypeVisible)

Started by SunOffice‎, 06-06-2011 09:39 PM

7

6,502

Last Post By:: Last Post: 06-19-2011 05:28 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Auto Filter on the next business date

Started by SunOffice‎, 05-14-2011 06:29 AM

6

1,923

Last Post By:: Last Post: 05-23-2011 04:06 AM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Unprotect workbooks ›—› Encrypting and Decrypting workbook security when opens

Started by SunOffice‎, 05-06-2011 10:44 PM

6

3,823

Last Post By:: Last Post: 05-07-2011 03:25 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

If condition not working in the loop

Started by SunOffice‎, 05-05-2011 09:54 PM

2

762

Last Post By:: Last Post: 05-15-2011 07:22 AM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Autofilter Copy Paste

Started by SunOffice‎, 05-05-2011 06:03 AM

1

1,320

Last Post By:: Last Post: 05-05-2011 09:07 AM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Auto update or refresh workbook in every 15 seconds

Started by SunOffice‎, 04-15-2011 09:58 PM

8

6,880

Last Post By:: Last Post: 04-18-2011 07:10 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Send worksheet as an attachment to specified recipients via outlook

Started by SunOffice‎, 04-10-2011 07:48 AM

14

3,593

Last Post By:: Last Post: 06-19-2011 05:38 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Automatically Protect a single cell in the column

Started by SunOffice‎, 04-09-2011 10:47 PM

0

910

Last Post By:: Last Post: 04-09-2011 10:47 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Adding VBA Hyperlink to each worksheet

Started by SunOffice‎, 03-22-2011 07:16 PM

6

2,803

Last Post By:: Last Post: 03-23-2011 08:53 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Sheet Selection and Data Filling

Started by SunOffice‎, 03-15-2011 06:46 AM

6

1,006

Last Post By:: Last Post: 03-16-2011 10:03 PM; by SunOffice

Forum:
Excel Programming / VBA / Macros

Search:

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Date error: 29/2/2023 shows Wed 01/03/2023

Transform data from horizontal rows to vertically (for listbox on UserFrom)

Logic to calculate accurate Ageing (Aging) by Excel formula

[SOLVED] Extract all the special characters from each cell

[SOLVED] Populate list from the master list (No Vlookup, where you already provide the 1st column)

[SOLVED] Activate button upon checkbox selection in custom ribbon

Calculate Years and Months difference - DateDiff and MOD issue

[SOLVED] ComboBox - "Error: Invalid Property Used" while restricting the dropdown values

a Dynamic Vlookup (Column Reference)

Completely remove/delete all the external links (Break Links)

[SOLVED] How to get correct values without applying filters

How to keep hyphen in a string and remove all specific characters

How to sort values in a row by using Array method

[SOLVED] How to get data from ComboBox Multiple Columns to excel sheet

[SOLVED] Load/Populate TreeView data from sheet to Userfrom

Based on Years calcuate Min() and Max() values from another column

[SOLVED] Calculate Time on AM/PM basis

Identify all the smtp E-mail Addresses of a GAL Exchange User? except PrimarySmtpAddress

How to identify the correct 'GAL' & its '.AddressLists.Item(number)' of a particular email

Fetch/Get Outlook GAL email Id details of a particular 'email account domain' (by Exchange

Assign fixed values to array / For...Next loop

Excel to find in Notepad and pull data lines

Pass values from UserForm ListBox/ TextBox to run the codes of a Module

Find out the Row and Column address number of the searched cell (separately)

Hide blank columns via loop

Cut & Paste - AutoFilter SpecialCells(xlCellTypeVisible)

Auto Filter on the next business date

Unprotect workbooks ›—› Encrypting and Decrypting workbook security when opens

If condition not working in the loop

Autofilter Copy Paste

Auto update or refresh workbook in every 15 seconds

Send worksheet as an attachment to specified recipients via outlook

Automatically Protect a single cell in the column

Adding VBA Hyperlink to each worksheet

Sheet Selection and Data Filling