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 167 168 169 170 171 172 173 174

  1. Solved: launching a shell command silently from within VBA
  2. Add user edit range
  3. Solved: My code start to be slow.
  4. Need help to insert column in Pivot
  5. Function, compile error.
  6. Solved: Need help regarding formatting sting using VBA
  7. Solved: Importing data from other Excel spreadsheets
  8. Solved: Cant get the value of a control in a multipage
  9. HELP to show formula
  10. Solved: Running Module from Other Workbook
  11. VBA Code to Hide Blanks in Pivot Table
  12. Solved: Time Stamp in cells using VBA
  13. Copy function
  14. VBA HELP
  15. VBA lookup and delte
  16. Delteing
  17. How to insert Japanese character to SAP from Excel?
  18. Using VBA to disable Save and Save As
  19. Dynamic Range Transpose Loop
  20. Solved: Excel 2003 Saveas Issue
  21. microsoft ado control & datagrid6
  22. VLOOKUP Between workbooks
  23. Need help with select case structure
  24. Help to a code - Save as - Debug
  25. Solved: Date, Month, and Time Stamp using VBA
  26. How to sort files before inserting to worksheet
  27. Solved: long function from excel to vba
  28. How to call\use DLL via vba macro?
  29. Solved: Find Text
  30. Formatting strings in cells
  31. RunTimeerror 2147417848 (80010108) Object invoked disconnected from its clients
  32. Refernce formula and formatting
  33. Linking macros to hyperlinks in VB
  34. Solved: Multiple IF statement (??)
  35. Save dialog in ppt
  36. Asking about VBA in Excel
  37. I need a Worksheet_Change macro moving cell to cell
  38. Code to Compare Cell Contents
  39. Solved: Is there a way of shortening my ever increasing vba
  40. If any column in active worksheet is hidden, then the value of cell A1 is “hide”.
  41. Solved: Range.Find returning Nothing
  42. Help with a macro
  43. Help with multiple criteria functions or VBA code.
  44. Remove Last Row Value From Sort
  45. Solved: Copy and Paste On Formula Result
  46. Solved: Copy a Range then Transpose Paste into every other Cell
  47. Export worksheet problem with path
  48. for loop returning 2 numbers
  49. Solved: Help uderstanding this loop
  50. [SOLVED:] Hex to Binary conversion, not using HEX2BIN
  51. Solved: separate specific symbols in order of priority
  52. Solved: Create chart on new sheet using VBA
  53. Is querying beyond 255 columns dead?
  54. Solved: placing formula in the same cell (D7) of all tabs
  55. Re arrange columns from selected rows
  56. Auto Start/Stop Macro at specific times
  57. Solved: Macro to remove entire if null value encounter in column
  58. VBA CODE ADD TO CODE MANDATORY CELL
  59. Worksheet_SelectionChange(ByVal Target As Range)
  60. Simulate mouse movements
  61. dynamic x axis "find last cell" vba code
  62. Extract Values of SN tags and save to Excel
  63. Solved: .FormulaR1C1 VBA
  64. Display tiff image on vba form
  65. Double click can edition in ListView
  66. CostCenter and Product combinations
  67. [SLEEPER:] Context Menu on UserForm
  68. mail from excel
  69. Solved: VBA Code : Help required
  70. VBA FORCE CELL NOT WORKING
  71. Excel DLL CUDA
  72. Link UserForm with worksheet data
  73. Solved: Used Range Selective ClearFormat
  74. Resize Chart as Picture
  75. [SLEEPER:] New Workbook for each worksheet
  76. Test if variable or object exists
  77. reload job nos fron jobs at J status
  78. Date Time copy paste not including time
  79. [SOLVED:] Need help for conversion
  80. Extract Web Page Data
  81. Solved: Copy data with values & paste in another worksheet
  82. Solved: Loop Until Help
  83. using excel to fill online form
  84. Copy worksheet cells from sub folders to new workbook
  85. Excel macro/VBA to sort a column, upload to sharepoint and save as draft on outlook
  86. Summarising of info from many w/sheets with a Macro
  87. Removing Spaces
  88. Solved: Repeat cells N Times
  89. [SLEEPER:] An MSForms Treeview
  90. Solved: VBA to delete a row in another worksheet
  91. Solved: Subfolders's names in array
  92. Solved: If cell is cleared or blank the conditional formating color is removed
  93. Solved: Draw without repeating words until the entire list has been drawn
  94. Solved: Help with Find/Delete Entire Row
  95. Solved: Incorrect VBA Sort on Workbook Close
  96. Problem Using Kill File
  97. How to get records in excel ADO
  98. Solved: Add date to Userform
  99. Solved: Help with automatically fill in cells by VBA loops
  100. Solved: Excel- align rows by column. Works but too slow!
  101. Solved: Worksheet Change Function: Created WS?
  102. Solved: Return a value from another sheet
  103. Solved: Remove Freeze Panes From Inactive Window
  104. [SOLVED:] Byref argument type mismatch array
  105. Excel Automation of IE - help click this button
  106. Solved: Double Click Event for Shapes
  107. Use a list from Excel to move files on computer
  108. Can not get rid of "Do you want to Save changes"
  109. Multiple currency format from UserForm
  110. VBA - CELL VALUES EXCEED 12 (MONTHS)
  111. Solved: Add third column to listbox
  112. Solved: sort columns dynamic
  113. vba to find and replace exact matches of cell value in a sheet
  114. Solved: user name
  115. Solved: Type mismatch error on If Not Range...
  116. Multiple Criteria Lookup
  117. group and hide blank space
  118. Special Sort needed - Sorting labels contained in one column
  119. [SLEEPER:] Disappearing calc field in pivot table
  120. Solved: change name tab office
  121. Solved: Function that's not working as should
  122. Attachment to gmail
  123. Solved: cell checking
  124. VBA - Macro to create/update documents in Lotus Notes database
  125. Export Selected Sheets to New workbook
  126. Running Macro Automatically if a cell value is True.
  127. Runtime err 1004
  128. OFFSET of result from vlookup
  129. datestamp on cell CHANGE
  130. Excel vba script to insert data into Outlook
  131. Multiple conditional values from Excel in VBA listbox
  132. Opening a new file of a different format
  133. [SOLVED:] Excel chart - identify the selected data point through macro.
  134. VBA Excel HTML e-mail?
  135. pivot vba
  136. data send to zohosheet
  137. Capture window help
  138. Solved: Sort All sheets in a workbook
  139. VBA Show All Data
  140. CONDITIONAL FORMULA with Percentage
  141. execute macro if change to range
  142. Text Box, text formatting
  143. conditional formatting text conditions
  144. Line list box
  145. RunTime error 462 - The remote Server machine does not exist.
  146. Muti Solver VBA
  147. Remove gaps in a combobox list
  148. Solved: Use a spreadsheet specifies interval even if another is active
  149. Embedded gif in userform
  150. Solved: EASY VBA ISSUE TO FINALIZE THE IMPLEMENTATION OF THE MERSEENE TWISTER RNG
  151. Merseene Twister VBA app easy issue to solve (with zip file)
  152. Compile error: Expected line number or label or statement or end of statement?
  153. [SOLVED:] Getwindowstext and settext
  154. Help with code to copy to another worksheet
  155. Consolidate data from different excel files (VBA)
  156. Solved: Make folder path and file name with VBA code
  157. Solved: Refresh my pivot table
  158. [SOLVED:] search folder structure and return paths only
  159. Solved: Application or object based error
  160. Paste special data till last updated row
  161. Solved: Smallest 3 numbers in range
  162. Class Modules in AddIn .xlam
  163. Save As Query
  164. VBA Form that uses data from a worksheet
  165. Solved: copy from excel to word unmerged table
  166. Solved: Empty Cells Will Not Delete
  167. Solved: VBA Pogress Bar
  168. code created text box not firing change event
  169. ContextMenu example errors
  170. repeated user input
  171. how to get profit as per fifo method
  172. Simple VBA Statement
  173. Macro to fill values of row numbers in a 10x20 grid
  174. Using HLookup
  175. Solved: New procedure at end of code?
  176. Solved: Insert header rows
  177. Help with Sorting by first name
  178. Get HTML Code into String from Newly clicked webpage (i.e. URL doesn't change)
  179. [SOLVED:] Countif? within a loop
  180. PIVOT table - Change sub column label
  181. HELP, user-defined type not defined
  182. Solved: Getting average of a range within a loop
  183. Get last row of a page
  184. Unexpected "Subscription out of range" error
  185. Creating Summary/ VBA code
  186. Solved: Fetching data from excel
  187. Passing Array Issues
  188. Solved: If statement
  189. Solved: worksheet tab options unintentionally disabled
  190. Excel 2003 User Defined Function
  191. Solved: need help with finding the minimum in a 1D array
  192. Solved: Array Formula Question
  193. Select an item from a website tree
  194. Solved: Macro Equation
  195. Solved: Remove certain charachters from a cell
  196. adAsyncExecute apparently gets cut off
  197. Protecting Cells With A Password In different Work Sheets With Code?
  198. Treeview in 2010 64Bit
  199. Solved: copy entire row to new sheet along with header
  200. [SLEEPER:] Run Time Error '76' - Path Not Found
  201. Solved: Show All Data From Two Columns Matching Todays Date In A Msgbox
  202. Solved: Status Bar Message With Extract Macro
  203. Solved: Making a macro compatible among multiple users
  204. Solved: Show the working days without holidays
  205. Add signature to email
  206. Copying and Paste files
  207. Solved: Error while printing pdf from excel
  208. Solved: Change the place of alphabets to numeric
  209. [SOLVED:] VBA code for pivot filtering
  210. VBA Prevent File From Saving
  211. [SOLVED:] Working with String in VBA
  212. Solved: Popularize Listbox using Textbox
  213. Programming for the null case
  214. Find the Max Value when a cell contain Text and Number
  215. Solved: VBA to remove duplicates as per the date
  216. [SOLVED:] Matrix Multiplication of Arrays
  217. Displaying Search Results
  218. [SOLVED:] Solved: Change selected cells to common range
  219. Solved: Sorting data problem...need to sort at midpoint of data table
  220. Read Excel using SQL Statements
  221. Generate HTML email with file attached - please help
  222. Clearing Auto-Filter with Password Protection on
  223. Solved: Macro not working properly
  224. Solved: OLEObject Vlookup help
  225. Userforms, Listboxes, Virtual space.
  226. Add-in file path Excel 2000?
  227. Help with crating a tab based on cell value
  228. Solved: Setting Pivot Table Filter with VBA
  229. Solved: How to use VBA to test if a number is a prime or not?
  230. help with Payroll employees
  231. Solved: file name via function
  232. Saving the return value of oracle function in a string
  233. Count unique values based on another column
  234. Putting Values of 3 columns into one column using If ElseIf statements
  235. VBA to delete multiple rows based on multiple criteria?
  236. VBA Or Macro: To format data in a column and delete columns and create new column
  237. Compare one column with one cel and input result on a second column
  238. Solved: Obtain Pivot Table Cell properties with VBA
  239. set color saturation of image with vba
  240. Solved: Worksheet change copy to next cell
  241. Turn an image into a toggle button
  242. Z Axis of 3D Graph
  243. Solved: Formatting Data Imported From Web
  244. Question on Formula
  245. Solved: open with filedialog and copy to my workbook
  246. Google Maps, inputting destinations
  247. Copy cell range to anther sheet containing;..
  248. Help with Copy and paste
  249. error in displaying value on a cover page
  250. Copy data in a Filter table then email it