PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 [104] 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166

  1. Solved: Excel VBA changing case
  2. Equalities
  3. Get Data from Closed Wrokbook based on Criteria
  4. Conditional format an indentation based upon a formula from separate cell
  5. Solved: create html code from parsed xml data on worksheet
  6. Send email when changes made
  7. hyperlink
  8. Solved: Cdate in range form number => date
  9. Compare 2 VBA Projects (code)
  10. Get details button from a data.
  11. How to speed up this macro? How to use an array?
  12. Split sheet to different files - variable number of rows
  13. Solved: sort data on cell by value order
  14. Solved: Find and Replace not working
  15. click and move
  16. Applying code to entire column
  17. Simple multiplication
  18. Loop until found / user cancels
  19. Solved: Adding another code the original VBA code (Excel 2003)
  20. Export to text file
  21. Macro to combine output of two sheet into one
  22. Speed up a slow code
  23. serial search
  24. Foreign language
  25. Solved: Trying to create a text box in word from excel
  26. Reading/writing MP3 properties with Excel VBA
  27. Excel Calender
  28. Add the file name in the header of the PDF
  29. CrePivot Table To Show All Value/Field Columns
  30. Solved: Updating Data Multipage 2 to Page 1 Combo box
  31. Sort By Value In Cell
  32. Solved: Average if
  33. Shortening VB Code
  34. Merging Cell EntireRow.Insert Excel 2003
  35. Merge all data in 1 cell with format
  36. VBA email - MERGE addresses
  37. VB Code help on Worksheets
  38. Import specific cells from a website table
  39. how to write a vba code to perform complex calculations
  40. Solved: where to put end if
  41. compile error
  42. Paste the file names in a excel sheet
  43. Sumif for text + concatenation
  44. VBA pulling data from a table
  45. Solved: Condtional format but if Cell next displays "Y" condtionalColour should White
  46. Solved: Conditional Formatting Help excel 2003
  47. Solved: Run a macro by refernce to a cell
  48. PasteSpecial
  49. Search in every column for a value in a specific row, then insert a column before IF
  50. FindNext
  51. Solved: Run code when workbook opens
  52. Filling Arrays
  53. Find all possible paths in a Flowchart
  54. Comparison
  55. Solved: Referencing objects
  56. Solved: Select the last used row in a column using VBA
  57. Dates
  58. Excel 2010 VBA Insert new row changes formula
  59. Need Macro to create a Format
  60. Solved: locked method of range failed
  61. How to save webpage as html to drive
  62. Solved: UserForm Radio Buttons
  63. Create blank lines between all current
  64. VBA AND XML
  65. Copy data to Master file from Different Sheets
  66. VBA for Dynamic source data for charts
  67. 3 pairs of If and end if
  68. add message to macro
  69. auto populate with cell change event?
  70. Excel Phonebook
  71. Hiding multiple non-contiguous rows simultaneously and quickly
  72. Solved: Fine Tuning an Application Event
  73. Formula In Entire COlumn
  74. Understanding brettdj multiple goal seek code
  75. Solved: Cell Name as a variable to feed
  76. Solved: Highlight row based on cell value
  77. run Time error '76 -looking for files within Sharepoint
  78. Solved: using array and column data to creat new sheets
  79. Converting Access SQL to EXCEL SQL
  80. NOVICE QUESTION: Referencing Integer Arrays
  81. Solved: Excel Functions VBA
  82. search and count values
  83. auto select
  84. Hide and Unhide rows based on the condition set
  85. backup of file with date
  86. Solved: Borders on a Range of Cells
  87. Multiplying cells in a range only if they have content
  88. Macro - transpose - audit
  89. formula copy
  90. Solved: worksheet event does nothing
  91. Solved: vbs creates .xml from folders - how to run excel macro at end
  92. Solved: Avoid Screen flickering and selection
  93. cell blinking
  94. Solved: Inserting a formula with VBA
  95. Hidden ActiveX Controls Disappearing
  96. Arrange Images relative to each other
  97. Question about Slicers
  98. Solved: Make text in a cell bold
  99. Solved: VBA Code help.
  100. Find and Replace of Formula Result
  101. pivot table automation
  102. extract data from multiples excel files
  103. unable to set focus
  104. userform combobox requirement
  105. Solved: Delete Unused rows in a table
  106. VB ClearContents if add-on (Excel 2003)
  107. Solved: Save as and File Directory
  108. Solved: Create Monthly Calendar using Userform
  109. Converting conditional format to permanent and reference to shapes
  110. Solved: Writing data from workbook to text file
  111. Array function
  112. Real challenge from my professor
  113. VBA drop down and he internet
  114. Excel 2010 fuzzy vlookup add in
  115. Assign Keyboard Shortcut to Ribbon Item Excel 2007
  116. Next and Prev. command
  117. need help with a code
  118. improving class modules with syntax sugar
  119. Solved: Delete Empty cells with condition
  120. match or vlookup help
  121. Dont Change Folder/Zip File after Zipping & Unzipping
  122. Transpose Range on Key
  123. ListBox Index Select
  124. expired workbook
  125. Solved: Producing multiple spreadsheets by running data from excel database
  126. Solved: copy data to another spreadsheet
  127. Solved: Interchanging data on different sheets
  128. Assigning macro to print button code help
  129. Solved: whats the difference
  130. Calculate Correlations Based on Changing Parameters
  131. Plotting an arrow in excel using VBA
  132. Frequently bought together
  133. Cell copy the data to another cell with offset
  134. Solved: UF Count Tally
  135. Error using .Find across worksheets
  136. insert row above button (retrieve position of button)
  137. How to analyze and sort data using VBA
  138. pause and continue
  139. Help with Excel & Office Web Component!!
  140. Solved: Open Txt File and Copy data
  141. Write Hebrew characters to file in VBA
  142. Problem with OnAction
  143. The active cell in a sheet other than the active sheet (VBA Excel)
  144. Pesky users, causing issues with userform
  145. Solved: Help with Pivot Tables
  146. Solved: Extend Range selection Down
  147. Look up values through hierarchies
  148. Solved: Find Last Used Cell In a Table
  149. sumproduct help ..
  150. Solved: Find a string and align left
  151. Data Validation List
  152. Workbook Parameters compare
  153. OnTime Problem ..?
  154. Solved: Looking for a more 'flexible' Match()
  155. Error when set value to an worksheet object
  156. Date Tranformation
  157. sum of mismatch records
  158. Problem in adding record using macro
  159. Solved: merge blank record in first column
  160. Shade Weekends in Calendar
  161. Solved: Find final Row In Mearge TOP Cell
  162. Unselect missing line in "References VBAProject"
  163. How to stop a specific VBA loop??
  164. Solved: Option Buttons in Multipage Form
  165. VB+Excel help
  166. Solved: Choose a folder in a directory if found.
  167. Adding Data Rows into excel using user inputs.
  168. Add value in empty cell always same line column after column
  169. Count of distributors based on criteria
  170. Worksheet_BeforeDoubleClick is not invoked
  171. Solved: Modify Copy to spreadsheet
  172. Autoupdate Dropbox Values
  173. I feel Computer Illeterate
  174. Select column and row(s) and change format
  175. Check Box Issue
  176. Recall data to my userform
  177. populate combobox when workbook is open
  178. Date and time calculation
  179. VBA to logon to Webpage (JSP)?
  180. Import data from website
  181. Combine Data that obviously the same
  182. Solved: Quintiles and Conditional Formatting
  183. Solved: Trim extra characters from Column F
  184. Solved: SumProduct Help
  185. Error of Advanced filter, copy & paste from different worksheets using 1 cmd button
  186. Solved: Using ElseIF
  187. Force user to enable macros
  188. Solved: Blank cells
  189. Solved: More on SumProduct
  190. Solved: Expression not running all the way through
  191. Solved: Paste block of data into certain cells
  192. Allow Group/Ungroup on protected sheet
  193. change the (Worksheet_Change) event for a module (Sub).
  194. Solved: Need help with adding yes/no msgbox to Find Procedure
  195. edit values of a cell through textbox in a user form
  196. Solved: color
  197. replace text/integer within a formula
  198. Solved: Excel VBA Code for higlighting Pass Or Fail profile
  199. Locking Cells
  200. Solved: Macro embedded in workbook
  201. Formatting not alligning properly on macro run
  202. Solved: Delete Duplicate Colums
  203. How to go through a list on two different worksheets comparing values using VBA
  204. Delete all rows under a group
  205. COUNTIF formula with text color
  206. Solved: excel can't calculate formula
  207. VBA Print Range
  208. Obtaining the standard deviation of a range in vba code
  209. Updating Linked Data
  210. Solved: Sheet Protection and Clipboard
  211. Edit macro to pull from column instead of line in macro
  212. Close messages
  213. Extract missing digits
  214. Lookup and Match data
  215. Comparing spreadsheet - VBA almost working..
  216. [SOLVED] Deploying Add-in
  217. Show / Hide part of Tabstrip or Multipage
  218. ActiveCell.Offset in a Data filtered sheet
  219. More Robust Directory List Generator?
  220. need help with simple macros
  221. copy cells to one page from others
  222. Same ComboBox Value to show in 3 other ComboBoxes in Seperate Userforms
  223. How to disable Paste Special->Keep Source Formatting - Excel 2010
  224. Collecting Data
  225. Solved: Close and re-open
  226. userform combobox error
  227. Use PlaySound and control left/right volume independently
  228. VBA Code to copy required data into Separate Sheet
  229. Sum x number of rows
  230. Minimise use of SELECT in macro copying data from one sheet to another
  231. Extract substring
  232. Solved: if-else query
  233. Solved: problem with sum product formula
  234. Auto Email
  235. Solved: How to perform code on all pages except first one
  236. Multiple columns into multiple rows
  237. read write format text files
  238. sort by upcoming date 60 days from today
  239. Solved: combine data from spreadsheet help
  240. find number of work days in month
  241. Remove Duplicates by Date Range
  242. Store Value in A temporary Variable
  243. Solved: Search Through Subfolders of a Selected Folder
  244. Solved: Creating folder with drive selection.
  245. split workbook into 2 by criteria
  246. Find Function - ONLY find what is specified
  247. Solved: Using Dir()
  248. Solved: Formula to extract string help
  249. Solved: Convert formula to Macro; find closest value and return adjacent values
  250. Error in Picking the specific excel file